Default fonts for LibreOffice Calc

Discuss the spreadsheet application
Post Reply
IanP
Posts: 34
Joined: Sat Oct 06, 2018 11:01 am

Default fonts for LibreOffice Calc

Post by IanP »

Hi all,

I found the right Customise tab for LibreOffice writer to change the default font but I can't find the equivalent in Calc. Please advise.

Thanks,

Ian
OpenOffice 4.1.5 on Windows 7
John_Ha
Volunteer
Posts: 9606
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Default fonts for LibreOffice Calc

Post by John_Ha »

See Styles > Manage styles. You need to edit the style with your choice of font.

See Chapter 4 Using Styles and Templates in the Calc Guide.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
IanP
Posts: 34
Joined: Sat Oct 06, 2018 11:01 am

Re: Default fonts for LibreOffice Calc

Post by IanP »

Hi John,

Many thanks. "Save as" advice noted as well. I'll have a look.

Ian
OpenOffice 4.1.5 on Windows 7
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Default fonts for LibreOffice Calc

Post by Villeroy »

Create a new file and change the font for cell style "Default". Changing the font of the "Default" cell style, changes the font for the other styles too unless some other style has its own font definition. See hierarchical view of the cell styles. "Default" is the "mother of all styles" passing all its properties to the children unless the children are set up otherwise.

If you save the new file as a template via menu:File>Template>Save... you get a new document from that template via File>New>From Template [Ctrl+Shift+Open] where you pick the template you want.

If you want that every new spreadsheet is derived from that template, call menu:File>Templates>Organize... select your template and make it the default template.

Styles and templates are the core concept of all office software, LibreOffice and OpenOffice in particular.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply