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: [email protected] 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
