Bug 158734 - Font format applied to selected cells on sheet not used when additional cell entries are made, reverts to <default>
Summary: Font format applied to selected cells on sheet not used when additional cell ...
Status: RESOLVED DUPLICATE of bug 153527
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.8.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-16 14:59 UTC by Meetup
Modified: 2024-01-20 00:36 UTC (History)
3 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 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 ***