Issue 93609

Summary: No automatic row heights after xlsx import
Product: Calc Reporter: niklas.nebel
Component: open-importAssignee: kla <thomas.klarhoefer>
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues
Version: DEV300m5   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
test file, XLSX format
none
test file, XLSB format
none
test file, BIFF8 format none

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
heights
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