Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

4 Answers

up vote 10 down vote accepted

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.

share|improve this answer
1  
the screenshots are created using openoffice, but it's the same as in libreoffice (and even the same in openoffice / libreoffice writer). –  tohuwawohu Jun 25 '11 at 17:01
add comment

Format menu -> Styles and formatting. You should get a dialog that looks similar to this:

enter image description here

Right click on Default, and choose modify. In the fonts tab you should be able to choose the new default font.

share|improve this answer
1  
... and of course, you can combine this answer with the @tohuwawohu answer to make the style change the default. –  derobert Jul 11 '12 at 15:22
add comment

If you have with other languages (Complex Text Layout (CLT) languages like Persian languages) just do this first:

  1. Click on English/any default language on status bar and then select More.

  2. Select your western and CTL font and default language you want.

  3. For setting these configurations, just do same as Kirk said above to set this template as.

share|improve this answer
add comment

Updated instructions for LibreOffice 4.0.x:

The process is still as per tohuwawohu's answer, yet the specific steps have changed a little:

  1. To save as template, go to menu File > Save as template...

    libreoffice-menu-guardar-como-plantilla-r

  2. Select "My Templates" in the Template Manager, and then click on the button "Save". See image on the next step.

  3. A new window will appear asking for a name for the new template. Give a descriptive name and click on the button "OK".

    libreoffice-plantillas-guardar-mis-plantillas-nombre
    Click on the image to open a full-resolution version.

  4. Now go to menu File > New > Templates

  5. Select the tab titled "Spreadsheets", double click on "My Templates" and select your newly saved template. Of a series of buttons that appear under the tabs, select the one labeled "Predeterminate" in order to set the template as the default for Calc.

    libreoffice-calc-plantillas-predeterminar
    Click on the image to open a full-resolution version.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.