Monday 18 November 2019

How to set the default font in LibreOffice Calc?


How do you set the default font used in new documents of LibreOffice Calc? I am using LibreOffice 3.3.2.


Some answers below have been updated for LibreOffice 4 as well.



Answer



If you want to use the customized document as standard template (so it's used if you select menu File -> New -> Spreadsheet), the following steps are required (assuming you've created a fresh spreadsheet document and changed the default font as Kirk has described):



  • Select menu File -> Templates -> Save...; Save File as Template

  • In the Template dialogue, enter a name for your template; make sure that "My Templates" is selected in the "Categories" list, then click OK. Enter name and select Category for new Template

  • Select menu File -> Templates -> Organize...; Open Template Organizer

  • In the template management dialogue, double-click on the "My Templates" entry in the list on the left; below "My Templates", a list of your templates should appear, among them the template you saved in step 2; Set custom template as new default template

  • right-click on our template defined in step 2, select "Set as default template", close the template management dialogue.


That's it - now, if you create a new spreadsheet document, it should be based on your custom template.


EDIT 1:


For updated instructions based on LibreOffice 4, see carnendil's answer


EDIT 2:


Setting a custom default template doesn't affect CSV files opened with LO Calc. There are two workarounds:



Insert Sheet from File


No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...