4 Answers
4

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...;

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

Select menu File -> Templates -> Organize...;

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;

the screenshots are created using openoffice, but it's the same as in libreoffice (and even the same in openoffice / libreoffice writer).
–
tohuwawohuJun 25 '11 at 17:01

1

You're instructions* worked for me when I create a new spreadsheet using File -> New. However, when I open a CSV file and it creates a new document using the Text Import feature, it appears to NOT use the default template and still uses the PREVIOUS default font. How do I get it to use the NEW default font, even when opening CSV files? (*with only a few differences in LibreOffice 4.2.6.3)
–
Tyler RickSep 29 '14 at 18:29

I'm having a similar issue to @TylerRick, but when I add a new sheet to my spreadsheet. I open a new document (LibreOffice, by the way) and it comes up with my default style, but adding a new sheet uses the old style. Any ideas?
–
DisgruntledGoatNov 16 '14 at 1:26

@DisgruntledGoat: Sorry, i can't reproduce this using LibreOffice 4.2.7.2. If i create a new Spreadsheet file based on my custom template and add sheets using the (+) sign at the bottom (sheet tabs), ot using the menu (Insert -> Sheet), the new sheet has the same customized defaults as the first sheet. Did you insert existing sheets (Insert -> Sheet from File)?
–
tohuwawohuNov 16 '14 at 10:19

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

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

Click on the image to open a full-resolution version.

Now go to menu File > New > Templates

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.