Apache OpenOffice (AOO) Bugzilla – Issue 93609
No automatic row heights after xlsx import
Last modified: 2013-08-07 15:14:39 UTC
Import any xlsx file. All rows have a fixed row height, even if they were automatic in Excel.
Filter sets all rows to manual height due to the different handling of rows with merged cells: If a row contains horizontally merged cells (one row, several columns), Excel sets this row to the height of a single text line, but Calc sets row height to show all text lines in the merged cell. Fix for this issue will set manual height for rows containing such merged cells, not for all rows.
Created attachment 56412 [details] test file, XLSX format
Created attachment 56413 [details] test file, XLSB format
Created attachment 56414 [details] test file, BIFF8 format
In the attached test documents, the rows 7 to 9 (with red comments) contain merged cells in a single row. They must be imported with manual row height set. All other rows in range 2 to 17 must have automatic row height. All rows in range 20 to 35 must have manual row height. Note a special case in row 4: the cell contains text with hard line breaks, but with cell property "wrap text" set to false. Excel does not show the line breaks in this case, but Calc does. Therefore, the row height is still different in Calc. Fixed in CWS DEV300/dr63 (OOo 3.1)
back to QA
see also issue 94028 - drawing objects misplaced if sheet contains automatic row heights
Seen ok in CWS dr63 -> verified
Seen ok in current master -> closed