Description: The attached Excel file was generated with aspose-cells. It opens as expected in MS Excel and in Google Sheets - see attached screenshot. However it has a wromg row height (14.45 cm), when opened in LibreOffice Calc - see attached screenshot. Steps to Reproduce: 1. Open Excel File 2. Check row height of rows 6, 7, 8, 9 Actual Results: Row height is too big 14.45 cm. Expected Results: Row height should be same as for rows 4 and 5. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Vulkan; VCL: win Locale: en-GB (en_GB); UI: en-GB Calc: CL
Created attachment 184233 [details] Excel File generated by aspose-cells that causes the problem (it contains dummy data)
Created attachment 184234 [details] screenshot LibreOffice Calc - invalid row height
Created attachment 184235 [details] screenshot MS Office - correct row height
Created attachment 184236 [details] screenshot Google Sheets - correct row height
I can confirm that row 6 has excessive height using LO 7.6 as reported by the user. Now a few more test results: 1) Row 6 opens fine with MS Excel desktop 2) However in Excel Online the row has the same height as in LO 3) OnlyOffice and Google Sheets get the correct row height Tested with Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 01c9c971e43782800ebf63acc763a7e7fba096c1 CPU threads: 12; OS: Linux 5.19; UI render: default; VCL: kf5 (cairo+xcb) Locale: pt-BR (pt_BR.UTF-8); UI: en-US Calc: threaded
In the Excel file the height of rows 6-9 is set to 409.5 twips, Excel (2019) does not take this into account unless the customHeight attribute or dyDescent is set. These are not set here, which is why the two displays are different in my opinion. Tested width Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: d53540ffaf68d691061afcbc2ea55b47d5a81b69 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: en-US Calc: CL threaded and Microsoft Excel 2019 MSO (16.0.10394.20022) 32 bits
fixed in 24.2 with commit d15c4caabaa21e0efe3a08ffbe145390e802bab9 Author: Justin Luth on Tue Sep 20 08:14:41 2022 -0400 tdf#123026 xlsx import: recalc optimal row height on import *** This bug has been marked as a duplicate of bug 123026 ***