Bug 152588 - FILEOPEN, FORMATTING Invalid row height when opening Excel file saved with aspose-cells
Summary: FILEOPEN, FORMATTING Invalid row height when opening Excel file saved with as...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2022-12-19 10:52 UTC by Sebastian Sosnik
Modified: 2023-05-19 10:20 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Excel File generated by aspose-cells that causes the problem (it contains dummy data) (53.23 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2022-12-19 10:54 UTC, Sebastian Sosnik 		Details
screenshot LibreOffice Calc - invalid row height (58.48 KB, image/png)
2022-12-19 10:55 UTC, Sebastian Sosnik 		Details
screenshot MS Office - correct row height (53.32 KB, image/png)
2022-12-19 10:56 UTC, Sebastian Sosnik 		Details
screenshot Google Sheets - correct row height (53.99 KB, image/png)
2022-12-19 10:56 UTC, Sebastian Sosnik 		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 Sebastian Sosnik 2022-12-19 10:52:11 UTC 
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
Comment 1 Sebastian Sosnik 2022-12-19 10:54:34 UTC 
Created attachment 184233 [details]
Excel File generated by aspose-cells that causes the problem (it contains dummy data)
Comment 2 Sebastian Sosnik 2022-12-19 10:55:49 UTC 
Created attachment 184234 [details]
screenshot LibreOffice Calc - invalid row height
Comment 3 Sebastian Sosnik 2022-12-19 10:56:23 UTC 
Created attachment 184235 [details]
screenshot MS Office - correct row height
Comment 4 Sebastian Sosnik 2022-12-19 10:56:57 UTC 
Created attachment 184236 [details]
screenshot Google Sheets - correct row height
Comment 5 Rafael Lima 2022-12-20 00:40:27 UTC 
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
Comment 6 Czeber László Ádám (NISZ) 2023-05-19 10:20:54 UTC 
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