Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


That is issue of tdf#124098<https://bugs.documentfoundation.org/show_bug.cgi?id=124098> and caused 
by tdf#62268<https://bugs.documentfoundation.org/show_bug.cgi?id=62268>
 see comments at end of bug 62268.

Simple workaround is to get the sheet open and then remove the optimal row height by selecting all 
cells and setting a row height from Format -> Rows -> Height.

It will tweak the layout of the sheet but will restore reasonable opening speed.

________________________________
From: David Lynch
Sent: Friday, July 30, 2021 4:04 AM

I have a large (100000 by 100) but simple spreadsheet.

When loading and, sometimes, editing it appears to take longer "Adapting
row height" than the rest of the processing put together. I am happy
with the existing row height and do not want it adapted.

Is there anything I can do to eliminate or speed up this part of the
processing?

David Lynch

Version: 7.1.4.2 (x64) / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 4; OS: Windows 10.0 Build 19041; UI render: Skia/Raster;
VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded



-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.