Bug 157468 - A specific XLSX imports ignoring the "optimal row height" property, rows keep single-line
Summary: A specific XLSX imports ignoring the "optimal row height" property, rows keep...
Status: RESOLVED DUPLICATE of bug 123026
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/excel-c...
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2023-09-27 07:18 UTC by Mike Kaganski
Modified: 2024-01-14 15:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
A sample file from the Ask question (7.99 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2023-09-27 07:18 UTC, Mike Kaganski 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2023-09-27 07:18:09 UTC 
Created attachment 189844 [details]
A sample file from the Ask question

Opening the attachment has all the rows single-line, unlike in Excel.
Also in LO 3.5 and earlier, the import made row heights fit the content.
In current versions, deleting columns (e.g., column A) suddenly re-calculates the row heights; undoing the column removal does not restore the incorrect single-line row heights.
Exporting the document with incorrect row heights to PDF (and printing) makes the invisible (trimmed) content of the cells to become visible above (overlapping other cells).

All of this seems to be related to each other.

Ref: https://ask.libreoffice.org/t/excel-created-have-word-wrap-enabled-but-libre-dont-adjust-the-row-height-correctly/96314/
Comment 1 m_a_riosv 2023-09-29 18:52:04 UTC 
For seems it works fine with master:
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5e9c8d21874eea8cb5adf2ecab1905295af2308f
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded Jumbo


Reproducible with
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 2 m_a_riosv 2023-09-29 18:54:55 UTC 
Maybe in relation with 147620
Comment 3 Mike Kaganski 2023-09-29 19:02:23 UTC 
(In reply to m.a.riosv from comment #1)

Thank you!

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