Bug 132354 - Automatic Row height wrong after FileOpen (workaround: set height manually)
Summary: Automatic Row height wrong after FileOpen (workaround: set height manually)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
6.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: bibisected, bisected
Depends on:
Blocks: Regressions-row-height
  Show dependency treegraph
Reported: 2020-04-23 13:10 UTC by Matthias Hellinghausen
Modified: 2022-03-24 13:46 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Text of cell a:4 (10.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-04-23 13:12 UTC, Matthias Hellinghausen
screenshot shows the failure (142.02 KB, image/png)
2020-04-24 06:27 UTC, Matthias Hellinghausen
same file with older LO version (120.64 KB, image/png)
2020-04-24 06:32 UTC, Matthias Hellinghausen

Note You need to log in before you can comment on or make changes to this bug.
Description Matthias Hellinghausen 2020-04-23 13:10:06 UTC
Libreoffice Calc:

the calculation of the "optimal Row height" fails after opening an ods file. 
When the "optimal Row height" is triggered again from the context menue, the Row Height will fit abain and the full Text of the cell will be displayed.

The calculation nmot fails in all cases, but depends on the width of the column and the length off the Text.

kind regards

Steps to Reproduce:
1. long text that not fit in the cell (width) 
2. wrap text enabled
3. optimal row height enabled
4. save
5. reopen
6. 1-5 with different "column width"/"text length"

Actual Results:
after open the Row heigth calculated wrong

Expected Results:
all text of the cell should be displayed

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Comment 1 Matthias Hellinghausen 2020-04-23 13:12:40 UTC
Created attachment 159851 [details]
Text of cell a:4
Comment 2 m.a.riosv 2020-04-23 20:16:24 UTC
I can't repro.
Version: (x64)
Build ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU threads: 4; OS: Windows 10.0 Build 19613; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Comment 3 Matthias Hellinghausen 2020-04-24 06:27:10 UTC
Created attachment 159882 [details]
screenshot shows the failure

added screenshot
Comment 4 Matthias Hellinghausen 2020-04-24 06:32:34 UTC
Created attachment 159883 [details]
same file with older LO version

added screenshot

btw. with Version the row height is OK after file open. 

Here the problem shows up with version 6.4.3 on different Linux maschines (ubuntu 16.04. and 18.04)
Comment 5 Xavier Van Wijmeersch 2020-04-24 08:55:50 UTC
cannot reproduce with

Build ID: 96f77910e86f88c99621a8b17c09fc69f9f1d8f3
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3; 
Locale: nl-BE (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 6 Adam 2020-05-15 20:48:16 UTC
Repro in 

Version: (x64)
Windows 10.0 Build 18363

Version: (x64)
Windows 10.0 Build 18363

Seems like it might be a dup of a pre-existing issue? 

Comment 7 Xisco Faulí 2020-06-17 11:55:28 UTC
The issue started to happen after https://cgit.freedesktop.org/libreoffice/core/commit/?id=1e55a47e89a9d9d6cf9cb3993484022aaf2c097b. Before this commit the issue can be reproduced if recalculation on File Load for
ODF files is set to Always Recalculate in Tools/Options.../LibreOffice
Comment 8 Gessel 2022-03-24 13:46:37 UTC
I filed #148151 which appears to be a duplicate of this bug and #130383.

I found disabling Options->Calc->Defaults->Enable very large spreadsheets resolved the problem though at the expense of not supporting very large spreadsheets, which is obviously a suboptimal workaround.  If this is the same bug, I'd expect the same results.  I tested with your examples and got the same problems you report and these were resolved with the VLS feature disabled on my system.