Bug 148151 - Row height display issues with multi-line cells
Summary: Row height display issues with multi-line cells
Status: RESOLVED DUPLICATE of bug 134552
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.1.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected
Depends on:
Blocks:
 
Reported: 2022-03-23 18:07 UTC by Gessel
Modified: 2022-04-01 08:10 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
cell grid display problem text as entered (18.98 KB, image/png)
2022-03-23 18:16 UTC, Gessel
Details
cell grid display problem select wrap automatically (42.76 KB, image/png)
2022-03-23 18:17 UTC, Gessel
Details
cell grid display problem result and after reopening (14.40 KB, image/png)
2022-03-23 18:18 UTC, Gessel
Details
example spreadsheet showing problem, at least on my systems (9.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-24 13:26 UTC, Gessel
Details
how the attached .ods file renders on my computer (14.29 KB, image/png)
2022-03-24 13:27 UTC, Gessel
Details
#132354 example rendered on my system - looks like the same bug. (17.70 KB, image/png)
2022-03-24 13:34 UTC, Gessel
Details
#130383 example rendered on my system also looks like the same bug. (34.64 KB, image/png)
2022-03-24 13:35 UTC, Gessel
Details
Problem does not happen if tools->options->Calc->Defaults->Enable very large spreadsheets is disabled. (22.81 KB, image/png)
2022-03-24 13:42 UTC, Gessel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gessel 2022-03-23 18:07:39 UTC
Description:
After making text wrap to multiline, the row height and content displayed in the spreadsheet doesn't match the row index or the select highlight box.  Saving and reopening corrects the display anomaly temporarily.  

Steps to Reproduce:
1.Type text into a cell that exceeds the column width - it extends into the next column as expected
2. reformat the cell to "wrap text automatically"
3. observe

Actual Results:
The spreadsheet grid displays the same but with fill arrows (>) instead of wrapping, the row index bar shows expected row heights as one would expect as a consequences of wrapping to multi-line.  The highlight boxes and cell select index box match the row index bar, but the display doesn't match.

Expected Results:
row lines and content to match the row heights.


Reproducible: Always


User Profile Reset: No



Additional Info:
OpenCL is disabled.
Comment 1 Gessel 2022-03-23 18:16:43 UTC
Created attachment 179054 [details]
cell grid display problem text as entered
Comment 2 Gessel 2022-03-23 18:17:42 UTC
Created attachment 179055 [details]
cell grid display problem select wrap automatically
Comment 3 Gessel 2022-03-23 18:18:26 UTC
Created attachment 179056 [details]
cell grid display problem result and after reopening
Comment 4 Gessel 2022-03-23 18:21:50 UTC
I have two installs, one on Mint 19.3 
Version: 7.3.1.3 / LibreOffice Community
Build ID: 30(Build:3)
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.3.1~rc3-0ubuntu0.18.04.1~lo1
Calc: threaded Jumbo

and one on Ubuntu 21.10 Impish 

Version: 7.2.5.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.5-0ubuntu0.21.10.3
Calc: threaded Jumbo

Both show the same problems.
Comment 5 Timur 2022-03-24 13:12:48 UTC
Seems duplicate of bug 130383 or bug 132354. Please mark.
And also attach your sample ODS.
Comment 6 Gessel 2022-03-24 13:26:15 UTC
Created attachment 179078 [details]
example spreadsheet showing problem, at least on my systems
Comment 7 Gessel 2022-03-24 13:27:10 UTC
Created attachment 179079 [details]
how the attached .ods file renders on my computer
Comment 8 Gessel 2022-03-24 13:33:39 UTC
@Timur as rendered on my system both appear to be the same issue.  Attached is an example spreadsheet which exhibits the problem and a screencap of how it renders on my system. Also attached is #130383 example .ods and #132354 example .ods rendered on my system.  All three seem to have the same artifacts.



Version: 7.2.5.2 / LibreOffice Community
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.2.5-0ubuntu0.21.10.3
Calc: CL Jumbo
Comment 9 Gessel 2022-03-24 13:34:35 UTC
Created attachment 179080 [details]
#132354 example rendered on my system - looks like the same bug.
Comment 10 Gessel 2022-03-24 13:35:12 UTC
Created attachment 179081 [details]
#130383 example rendered on my system also looks like the same bug.
Comment 11 Gessel 2022-03-24 13:41:18 UTC
Disabling or enabling auto-recalculate didn't fix it.
However,  the option enable very large spreadsheets did seem to fix it.  

See attached: image of demo opened with very large disabled.
Comment 12 Gessel 2022-03-24 13:42:37 UTC
Created attachment 179082 [details]
Problem does not happen if tools->options->Calc->Defaults->Enable very large spreadsheets is disabled.
Comment 13 Timur 2022-03-31 11:00:10 UTC
I don't reproduce with attachment 179078 [details]. 
Anyway, let's mark duplicate.

*** This bug has been marked as a duplicate of bug 130383 ***
Comment 14 Timur 2022-04-01 08:10:35 UTC
Hm..this seems Fixed in 7.4. 
 7b4234505420c85a45ad1acd569c433e82cd466b is the first bad commit
Date:   Tue Feb 8 12:48:46 2022 +0100
source cd50d33fc4af3f2d4ab40de98ecf02f0d832d750
author	Luboš Luňák <l.lunak@collabora.com>
MAXCOL/MAXROW -> ScSheetLimits in fillinfo.cxx

*** This bug has been marked as a duplicate of bug 134552 ***