Ask Your Question

Change default font in calc

asked 2018-03-16 10:27:50 +0200

MG312 gravatar image

Hi, I know this question has come up before, but nothing works with the version I am using, which is LibreOffice

The current default font is Liberation Sans, which I would like to change. I can change this within the document easily enough, but how do I make this a permanent change so that new documents open with my choice of font?

Any help gratefully appreciated.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-03-16 10:59:17 +0200

David gravatar image

updated 2018-03-16 11:46:25 +0200

You need to create a "default template" for Calc to set your own personal settings as the base for new spreadsheets. There are three steps.

(1) First, open Calc, and simply save its current settings as your own "template", following this menu sequence:

  • File > Templates > Save as template...
  • then give a name, e.g. calc-noto-sans (or whatever, that's just a random example for these instructions, of course) and
  • Assign to the "My Templates" category. Click OK.

(2) Next, you can use that template to save your personal choices:

  • Go to File > Templates > Manage Templates;
  • find your new calc-noto-sans template; right-click on it, and choose Edit.
  • From menu bar, follow Styles > Manage styles...; then from the panel that opens,
  • right-click on Default, select Modify;
  • click on the Font tab, and make your selections (e.g., Noto Sans, point size, etc.)
  • click OK.
  • Now Save the template, and Close it.

(3) Third and last step: (re-)open Calc, then:

  • Go to File > Templates > Manage Templates;
  • find your calc-noto-sans template; right-click on it,
  • but now choose Set as Default.
  • you'll see a "checkmark" appear with that template.

You can now click "Open", and from now on, all new Calc spreadsheets will open with your own personal defaults set.

edit flag offensive delete link more



Great. It's easy when you know where to look. I didn't realise that you could ask Calc to open a template as default. Now I can set up more than one for different purposes. Fantastic! Thank you.

MG312 gravatar imageMG312 ( 2018-03-16 12:50:10 +0200 )edit

@MG312 - Good to know it helped. You can signal that (and your thanks!) most effectively if you "up-vote" the answer, and "tick" the one you believe best solves your issue.

David gravatar imageDavid ( 2018-03-16 12:53:39 +0200 )edit

@MG312: Yes, that's great, and the way templates and named styles are implemented inLibO is one of its most relevant advantages, imo. You will also learn to derive specialised templates from more general ones, by which they will inherit properties. This kind of heritage will even allow to change a general template later-on, and to get the changes in force in all of the inheriting templates. Documents derived from changed templates will next time prompt you if you want to apply the changes. ...

Lupp gravatar imageLupp ( 2018-03-16 14:21:25 +0200 )edit

answered 2018-03-16 10:45:50 +0200

Lupp gravatar image

updated 2018-03-16 10:46:28 +0200

Which suggested solutions don't work? (Try to be precise, please, and give a few links in such a case!)

From my view the only reasonable solution (independent of the version):
-1- Create a Calc document from the most basical template you have (probably built-in default).
-2- Make the changes you want for the default cell style. (There is no font setting for the document.)
-3- Save the document as a template.
-4- Manage templates to import the new one and to make it your 'Standard'.

edit flag offensive delete link more


Thank you.

MG312 gravatar imageMG312 ( 2018-03-16 12:50:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-03-16 10:27:50 +0200

Seen: 3,660 times

Last updated: Mar 16 '18