Calc: Adapting row height is slow

users
#1

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

#2

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.

#3

The other way is to open the ODF archive Zip and directly (e.g. with 7-zip) and edit the 'content.xml' file (gvim works well when set as the Editor for 7-zip).

Find and change the 'use-optimal-row-height="true"' to "false"; there should only be a couple of these style settings. Save the changed contentl.xml file back into the Zip archive.

A little more tricky, to open the archive and edit the XML directly, but less potential to make other changes to ODS Sheet formatting done like this.