Created attachment 179231 [details] Example document to reproduce issue # Version info: Version: 7.3.1.3 / LibreOffice Community Build ID: 30(Build:3) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Ubuntu package version: 1:7.3.1~rc3-0ubuntu0.20.04.1~lo1 Calc: threaded Linux: Linux Mint 20.3 Cinnamon # Steps to reproduce 1. Create/open document that contains cells with multiple lines of text and automatic wrapping of text (Context menu > Format Cells > Alignment tab > Wrap text automatically) enabled (also see attached example file). 2. Ensure that all rows have optimal height, i.e. double-click on cell boundary of index or select rows or use context menu item "Optimal Height..." with Add 0.00cm. 3. Save and close document 4. Reopen same document # Observed behavior Row height of rows with cells that contain text breaking over multiple lines is not optimal (usually height is too small). NOTE 1: This behavior is not observable with any constellation. It seems that it depends on the column width, the amount of text that is wrapped and maybe the font family/size or other properties of the cell. I have successfully tested the described behavior with the attached example document. NOTE 2: In certain cases (unfortunately, I was unable to reproduce using the attached example document), saving and reopening is not necessary to reproduce. E.g. I observed that a filling cells of a different column in a row following the row with wrapping text using drag fill triggered to adjust the line height of the cells with wrapping text. # Expected behavior Row height of lines with cells containing wrapping text is not altered when saving and reopening the document.
The rows crush into wrapped text after sort or as soon as typing completed and entered. If optimal height is executed, that only remains active until document is closed or sorted. Even if all cells are formatted to default, once sheet is broken with row height it cannot be fixed. Copied cells to new sheet behave in same manner. Occasionally a new sheet behaves as expected, but at some point will also become corrupted.
Repro with Version: 7.3.3.2 / LibreOffice Community Build ID: 30(Build:2) CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Ubuntu package version: 1:7.3.3~rc2-0ubuntu0.21.10.1~lo1 Calc: threaded And with Version: 7.5.0.0.alpha0+ / LibreOffice Community Build ID: 61f5c991a97de8990badfed6ef840941b5aa8c7f CPU threads: 16; OS: Linux 5.13; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: threaded Row height is adjusted, but after saving, closing and reopening the file, row height returns to what it was before.
Repro in 6.2.0.3 but not 6.1.0.3, so must be the same regression as bug 146668.
*** This bug has been marked as a duplicate of bug 146668 ***