Bug 81397 - FORMATTING: When Default cell style is modified, new sheets do not show correct row height since LO 4.2 change in row height
Summary: FORMATTING: When Default cell style is modified, new sheets do not show corre...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium major
Assignee: Not Assigned
Whiteboard: BSA
Keywords: bibisectRequest
: 150287 (view as bug list)
Depends on:
Blocks: Calc-Styles
  Show dependency treegraph
Reported: 2014-07-15 20:04 UTC by garbagesafe
Modified: 2022-09-21 14:30 UTC (History)
3 users (show)

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


Note You need to log in before you can comment on or make changes to this bug.
Description garbagesafe 2014-07-15 20:04:21 UTC
Problem description: 

When the Default cell style is modified with a different font size and a new sheet is added to the spreadsheet, the new sheet shows the "original" row height (0.18"), not the row height that is correct for the new font size. 

The new sheet displays the correct font size on the button on the toolbar, and text typed into the new sheet is displayed at the correct size, but the row height remains fixed at the 0.18".

Steps to reproduce:

1) Open the Styles and Formatting window.

2) In the Cell Styles tab, modify the Default cell style to a different font size.

3) Add a new sheet to the speadsheet.

Current behavior:
The new sheet shows the original "as-installed" row height of 0.18".

Expected behavior:
The new sheet should show row heights adjusted to the size of the font saved in the modified Default cell style.

Select all cells in the new sheet and manually apply the modified Default cell style. The correct row heights will display.

Operating System: Linux (Other)
Version: release
Comment 1 garbagesafe 2014-07-15 20:11:14 UTC Comment hidden (obsolete)
Comment 2 Kevin Suo 2014-07-16 04:18:40 UTC
Confirmed with, windows xp sp3.
Set to NEW, platform -> ALL.
Comment 3 Kevin Suo 2014-07-16 04:20:49 UTC
An easy workaround: Select all cells of the new sheet, then double-click between two row labels to auto adjust height.
Comment 4 bugquestcontri 2014-07-16 07:56:53 UTC
There is also a AskLibO entry: http://ask.libreoffice.org/en/question/36979/newly-added-sheets-not-showing-correct-default-cell-style/

I made also a test using a new background color and found the background color to appear correct in newly added sheets.

The combination of background color and new font shows the reported font problem

Test made on on XP/SP3
Comment 5 rlk 2014-10-05 03:39:35 UTC
There are a few other bugs that seem to result in rows getting set to 0.18" height, even if the Default font size is set to something smaller (starting with 4.2): 77592, 80059, 83568
Comment 6 QA Administrators 2015-10-14 19:56:38 UTC Comment hidden (obsolete)
Comment 7 Petra 2015-10-20 13:57:37 UTC
I have LibreOffice on Yosemite 10.10.5

The problems is still there. I've done a new template with Calibri 10 and row height 0.52 on all cells. The template included just one sheet. I did this template to a standard one.
When I opens a new file the first spread sheet (which is included from the beginning) shows correct font and row height. When I add a new sheet the font is right but the row height is back to 0.43.
Comment 8 alan 2016-01-18 13:50:58 UTC Comment hidden (obsolete)
Comment 9 Kevin Suo 2016-01-18 14:48:42 UTC Comment hidden (obsolete)
Comment 10 m.a.riosv 2017-02-17 23:32:44 UTC
Still there
Version: (x64)
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; 
Locale: es-ES (es_ES); Calc: group

Save and reopen doesn't solve the issue.
Only selecting the whole sheet and Menu/Format/Rows - Optimal height.
Comment 11 QA Administrators 2018-07-12 02:43:50 UTC Comment hidden (obsolete)
Comment 12 Timur 2019-05-28 13:37:40 UTC
Repro LO 6.3.
Comment 13 QA Administrators 2021-05-28 04:50:56 UTC Comment hidden (obsolete)
Comment 14 m.a.riosv 2022-08-06 21:35:33 UTC
*** Bug 150287 has been marked as a duplicate of this bug. ***