Issue 93609 - No automatic row heights after xlsx import
Summary: No automatic row heights after xlsx import
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: DEV300m5
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sc
Depends on:
Reported: 2008-09-08 14:58 UTC by niklas.nebel
Modified: 2013-08-07 15:14 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

test file, XLSX format (9.07 KB, application/x-compressed)
2008-09-11 12:19 UTC, daniel.rentz
no flags Details
test file, XLSB format (8.53 KB, application/x-compressed)
2008-09-11 12:20 UTC, daniel.rentz
no flags Details
test file, BIFF8 format (19.50 KB, application/
2008-09-11 12:20 UTC, daniel.rentz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description niklas.nebel 2008-09-08 14:58:48 UTC
Import any xlsx file. All rows have a fixed row height, even if they were
automatic in Excel.
Comment 1 daniel.rentz 2008-09-11 10:38:50 UTC
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.
Comment 2 daniel.rentz 2008-09-11 12:19:46 UTC
Created attachment 56412 [details]
test file, XLSX format
Comment 3 daniel.rentz 2008-09-11 12:20:20 UTC
Created attachment 56413 [details]
test file, XLSB format
Comment 4 daniel.rentz 2008-09-11 12:20:49 UTC
Created attachment 56414 [details]
test file, BIFF8 format
Comment 5 daniel.rentz 2008-09-12 14:12:06 UTC
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)
Comment 6 daniel.rentz 2008-09-18 10:56:10 UTC
back to QA
Comment 7 daniel.rentz 2008-09-18 12:34:42 UTC
see also issue 94028 - drawing objects misplaced if sheet contains automatic row
Comment 8 kla 2008-09-19 15:06:48 UTC
Seen ok in CWS dr63 -> verified
Comment 9 kla 2008-11-04 09:59:33 UTC
Seen ok in current master -> closed