Bug 81397 - FORMATTING: When the Default cell style's font size is modified, new sheets do not use corresponding row height
Summary: FORMATTING: When the Default cell style's font size is modified, new sheets d...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL: https://ask.libreoffice.org/t/newly-a...
Whiteboard: BSA
: 150287 (view as bug list)
Depends on:
Blocks: Calc-Styles Cell-Management
  Show dependency treegraph
Reported: 2014-07-15 20:04 UTC by garbagesafe
Modified: 2023-12-10 07:13 UTC (History)
4 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 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. ***
Comment 15 Stéphane Guillou (stragu) 2023-09-25 16:36:31 UTC
Reproduced in recent master build:

Version: (X86_64) / LibreOffice Community
Build ID: 19e9fe7c8c89399753ac1730e1c76378b18418bc
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

To verify e.g. comment 5, I also also tested with OOo 3.3, which had the same behaviour, so marking as inherited and adapting the summary.