Bug 75305 - FORMATTING, FILEOPEN: Automatic row height doesn't work always .xls
Summary: FORMATTING, FILEOPEN: Automatic row height doesn't work always .xls
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: Other All
: low minor
Assignee: Not Assigned
Whiteboard: Confirmed: Confirmed:4.3.0...
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
Reported: 2014-02-21 08:31 UTC by Marco A.
Modified: 2022-09-14 16:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:

Sample document .xls (11.00 KB, application/vnd.ms-excel)
2014-02-21 08:31 UTC, Marco A.
confirmed (156.27 KB, image/png)
2014-02-27 12:38 UTC, retired
Sample.pdf: Page 1 is from LO 3.6 (same as today's 7.5) and Page 2 is from Excel 2003 (38.59 KB, application/pdf)
2022-09-14 02:27 UTC, Justin L
i93609_auto_row_height.xlsb: from OpenOffice.org bug 93609 (8.53 KB, application/vnd.ms-excel.sheet.binary.macroEnabled.12)
2022-09-14 16:24 UTC, Justin L

Note You need to log in before you can comment on or make changes to this bug.
Description Marco A. 2014-02-21 08:31:58 UTC
Created attachment 94484 [details]
Sample document .xls

Spreadsheet that fails to expand row height

Don't always, but happen, rows in files .xls don't expand automatically with the content. 
The file attached have a row visualized correctly in Excel but not in LibO

Build ID: 05dceb5d363845f2cf968344d7adab8dcfb2ba71
Comment 1 Dominique Boutry 2014-02-25 08:51:09 UTC
I confirm a difference between Excel 97 and LibO on Win7 on the attached .xls file. They should be identical so there is a bug. I have no way to say if the bug is in Excel 97 or LibO for this file (status kept to UNCONFIRMED).

If I modify the height of the filled row whichever in Excel 97 or LibO, the other application then opens correctly.
Comment 2 retired 2014-02-27 12:37:40 UTC

Build ID: 2e40ddbd325fb5dc963e2017245e3df2f4f809c8
TinderBox: MacOSX-x86@49-TDF, Branch:master, Time: 2014-02-27_02:42:27

Comment 3 retired 2014-02-27 12:38:05 UTC
Created attachment 94813 [details]
Comment 4 tommy27 2014-07-01 04:58:56 UTC
reproducible under Win7x64 using LibO 3.3.3, 4.2.4 and
Build ID: 95272e7e5b7e38753ab07dbd6503b7cfa2974842
TinderBox: Win-x86@42, Branch:master, Time: 2014-06-26_23:01:43

same issue with OOo 3.3.0 and AOO 4.1

so bug is "inherited from OOo"
Comment 5 QA Administrators 2015-07-18 17:42:39 UTC Comment hidden (obsolete)
Comment 6 tommy27 2015-07-20 08:03:26 UTC
still reproducible with LibO and (x64)
Build ID: 449d272daf5e99f039cdfdd25f020bd798fb9e1d
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-08_08:13:06
Locale: it-IT (it_IT)
Comment 7 QA Administrators 2016-09-20 10:17:51 UTC Comment hidden (obsolete)
Comment 8 Roman Kuznetsov 2019-03-23 14:04:20 UTC
still repro in

Version: (x64)
Build ID: de024e572dd7a588f82b84c68daa2051ec6b20e9
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-03-18_01:13:57
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 9 QA Administrators 2022-08-25 03:43:56 UTC Comment hidden (obsolete, spam)
Comment 10 Justin L 2022-09-08 14:20:17 UTC
repro 7.5+
In Excel 2003 the row is small - shrunk to fit.  In LO, the row is tall - lots of extra space shown.

[My complaint tends to be the opposite. I have the row set to automatic height, but on reload the row will not auto-grow when content is added.]
Comment 11 Justin L 2022-09-13 00:15:09 UTC Comment hidden (obsolete)
Comment 12 Justin L 2022-09-14 02:27:49 UTC
Created attachment 182426 [details]
Sample.pdf: Page 1 is from LO 3.6 (same as today's 7.5) and Page 2 is from Excel 2003

It is hard to understand what the real concern is here. The description talks about expanding automatically with content, but in the comparison it looks like MS Office is SHRINKING to set optimal row height (and yet if I add content, then Excel is not expanding anything).

I wonder if there is a problem with this document. If I round-trip it with Excel 2003, then LO opens it up just fine. If I round-trip it with LO, then Excel opens it up the same way as LO.

LibreOffice reports that a manual height has been set on row 3. In that case it ought to honor the specified height. So unless there is some over-riding setting that we don't know about, it seems to me that LO handles it properly.

The only problem I see is that LO to easily saves "manual height" and thus on a round-trip things are no longer dynamic. (It seems that if the height changes due to content addition that export is marking as custom height. If the file is simply round-tripped, then it is fine.)
Comment 13 Justin L 2022-09-14 16:24:26 UTC
Created attachment 182447 [details]
i93609_auto_row_height.xlsb: from OpenOffice.org bug 93609

(In reply to Justin L from comment #12)
> LibreOffice reports that a manual height has been set on row 3.
Wrong. LO is reading in non-manual height, but it specifically calls SetManualHeight for merged horizontal cells because of https://bz.apache.org/ooo/show_bug.cgi?id=93609

            if( bTextWrap )
                GetOldRoot().pColRowBuff->SetManualRowHeight( rStart.Row() );

Bottom line: There is so much monkey business going on here, it isn't worth fixing this particular bug report.