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)
Version:
(earliest affected)
4.4.5.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xls
Depends on:
Blocks: XLS
  Show dependency tree / graph
 
Reported: 2015-09-08 13:24 UTC by krakken
Modified: 2022-09-08 14:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 
Summary:

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 
Hi,

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

Best regards,
Krakken
Comment 3 m_a_riosv 2015-09-09 15:38:21 UTC 
Reproducible.
Win10x64
Version 3.6.7.2 (Build ID: e183d5b)
Version: 4.3.7.2 Build ID: 8a35821d8636a03b8bf4e15b48f59794652c68ba
Version: 5.0.2.1 (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.

With
LibreOffice 3.3.4 OOO330m19 (Build:401) tag libreoffice-3.3.4.1
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)
Comment 9 QA Administrators 2021-03-24 05:55:42 UTC Comment hidden (spam)