[Libreoffice-bugs] [Bug 43804] Slow FILEOPEN and EDITING of ODS spreadsheet because of adapt row height processing

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=43804

GoodMovie3 <laugh2 at gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|INVALID                     |---

--- Comment #6 from GoodMovie3 <laugh2 at gmx.net> ---
Still occurs with the following versions:
1. LO Calc 6.2.8.2 and 6.2.8.2 (64bit) on Linux Mint 18.3 (64bit) MATE
2. LO Calc 6.3.3 (64bit) on Linux Mint 19.1 (64bit) MATE
3. LO Calc 6.3.2 (64bit) on Windows Server 2012 R2 (64bit)

Expected Behaviour:
1. Numerical data with no text data using these operations occurs in seconds.
2. Excel (32bit) processes within seconds for both numerical and test data.
3. The user should have choice whether "Adapt row height" is performed by
default.

Observed Behaviour (as previous posts):
1. When using large spreadsheets with many calculations then operations such as
opening files and inserting columns (amongst others) results in processing
times in excess of 5 minutes to over 30 minutes depending on the spreadsheet
and hardware when using LO Calc. (Excel on same hardware may take up to 5
minutes or so.)
2. LO Calc indicates "Adapt row height" or provides no message but is
unresponsive.
3. LO Calc uses just 1 core/threads at 100% - no other cores are used. In
comparison LO Calc uses all cores when performing calculations. (Also Excel
uses all cores/threads when performing operations comparable to "Adapt row
height.)
4. It is not possible to prevent "Adapt row height" from occurring
automatically and by default - hence there is no workaround. Temporary relief
is possible by selecting the entire worksheet then unchecking the 2 tick boxes
for automatic row and height adjustment. This is described for row height at
the link below and needs also to be done similarly for column width. Refer to: 

https://ask.libreoffice.org/en/question/9348/calc-restore-row-heights-to-automatic-to-max-content-height/


Reproducibility:
1. Spreadsheets effected always show this behaviour.

3. I could provide a spreadsheet for a developer to look at for diagnosis
purposes but not for general publication.

Further details:
I have posted hardware and other details at:

https://ask.libreoffice.org/en/question/218518/row-height-disable-automatic-row-height-permanently/

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191210/8cf8bab2/attachment-0001.htm>