Download it now!
Bug 94027 - FILESAVE: Opening new created xls file, initial default row height changes from 0,45 to 0,52
Summary: FILESAVE: Opening new created xls file, initial default row height changes fr...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency treegraph
Reported: 2015-09-08 13:24 UTC by krakken
Modified: 2019-03-24 12:59 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description krakken 2015-09-08 13:24:17 UTC

If you work in Calc with different file types (.xls from Excel 2003 and .xlsx from Excel 2013 for example), especially when you need to save in one of those formats or if you need to continue some formatting work that was started in one of these formats, in order to stay compatible with people working with this Office suite:
Whenever you open the document in Calc and change the background color of one cell and it will resize the height of the whole row, against your will!
This is very annoying, especially if you need to do some precise work!

Easy way to reproduce:

1) In Calc, create a new spreadsheet.

2) Save As... an older .xls format from Excel 97-2003, for example (you do not even need to edit anything or to change the default row height).

3) Close this .xls file.

4) Reopen this .xls file.

5) Now, if you try to change the background color of some cells, it will resize the whole row automatically, against what you expect.
Comment 1 m.a.riosv 2015-09-08 23:03:28 UTC
Hi @krakken, thanks for reporting.

Please, could you test that it's not and effect of the option:
Menu/Tools/LibreOffice calc/View - Visual Aids - Grid lines - "Hide",
and if change it for "Show on colored cells" solve your issue.
Comment 2 krakken 2015-09-09 04:52:17 UTC

I have just tested to toggle this option but this does not solve the issue.

Best regards,
Comment 3 m.a.riosv 2015-09-09 15:38:21 UTC
Version (Build ID: e183d5b)
Version: Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba
Version: (x64) Build ID: 9a18d52abbdfbdc2ac9acebec2b92e7859eb73b7
Doesn't inherited from OOo.

Row sizes changes from 0,45 to 0,52, but I think not for change the background color, it shows the issue.

LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-
opening the xls created with 5.0 open with 0,48 height but default height for new files in this version is 0,48.

Selecting one or several rows, right-click - optimal Row Height does the same.

Seems default's row height is changed after save as xls, doesn't happen with xlsx.
Comment 4 m.a.riosv 2015-09-09 15:53:24 UTC
Not reproducible opening some other xls files, maybe it depends on the program used to create the file.
Comment 5 QA Administrators 2016-09-20 10:28:42 UTC Comment hidden (obsolete)
Comment 6 krakken 2016-09-22 13:42:23 UTC
This bug is still there in the new version 5.1.5 for Win 64.
Comment 7 Xisco Faulí 2017-09-29 08:48:36 UTC Comment hidden (obsolete)
Comment 8 Xisco Faulí 2018-04-23 12:53:56 UTC Comment hidden (obsolete)