Bug 158734

Summary:	Font format applied to selected cells on sheet not used when additional cell entries are made, reverts to <default>
Product:	LibreOffice	Reporter:	Meetup <meetup>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	ilmari.lauhakangas, stephane.guillou, vsfoote
Priority:	medium
Version:	7.5.8.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

Description Meetup 2023-12-16 14:59:35 UTC

Description:
new doc, Ctrl+A, change lettertype and size, save.
after that the text that was there has changed to the new type and size (Comic sans MS 15 pts) BUT a new tekst in a cell starts as it was Arial 10 pts. 

How to solve?

Actual Results:
new text shows up in arial 10 pt font in stead of Comic Sans 15 pt font

Expected Results:
that everything i type in this document will be in Comic Sans 15 pt


Reproducible: Always


User Profile Reset: No

Additional Info:
made ALL fiels as to be written in Comic Sans 15pt

Comment 1 Buovjaga 2023-12-16 15:43:05 UTC

Not reproduced, text is Comic Sans MS 15 pt for me.

Just as a tip, if you want to change the font style globally, use the Style pane of the Sidebar. Right-click Default and select Edit Style...

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded

Comment 2 Buovjaga 2023-12-16 15:43:25 UTC

Please copy and paste here the contents of your Help - About (LibreOffice - About on macOS) by clicking the copy button. This allows us to know more about your system.

Set to NEEDINFO.
Change back to UNCONFIRMED after you have provided the information.

Comment 3 V Stuart Foote 2023-12-16 16:19:46 UTC

Do not attempt direct formatting of empty cells via a select all. Empty cells will not take the formatting.

You need to select a different theme (Format -> "Spreadsheet Theme", or the new "Theme..." dialog) or you can change the selected theme's style ("Default" cell style on the Sidebar Styles deck) for the cell content.

Then Layout, Format, Style changes can be saved as a document template for easy reuse. Just note the difference between a template (.ots) and the actual working spreadsheet document (.ods) and avoid clobbering your template.

See the Calc Guide, or the online-help for your options--there are many.

Comment 4 Meetup 2023-12-16 16:31:20 UTC

Version: 7.5.8.2 (X86_64) / LibreOffice Community
Build ID: f718d63693263970429a68f568db6046aaa9df01
CPU threads: 20; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: nl-NL
Calc: threaded

Comment 5 V Stuart Foote 2023-12-16 20:30:35 UTC

Not clear this is a bug. Cells within current viewport of sheet do take the font direct formatting. But seems to duplicate see also bug 153527 for the <Ctl>+A selection of the entire sheet, and which is considered an issue.

Comment 6 Stéphane Guillou (stragu) 2024-01-20 00:36:42 UTC

Indeed, sounds exactly like bug 153527. Let's close as duplicate.
Meetup, if you still see an issue in 24.2, please describe it in more detail and set back to "unconfirmed".
Thank you!

*** This bug has been marked as a duplicate of bug 153527 ***