Ask Your Question

Calc user created default template only affects Sheet1 [closed]

asked 2014-12-20 17:40:46 +0200

rd21292 gravatar image

updated 2016-03-07 02:52:39 +0200

Alex Kemp gravatar image

In Calc running on a Windows 7 system, the guides for creating a default template allowed me to set Arial 10 as the default font.

This works for Sheet1. But if an additional sheet is added, Sheet2 is still the original Liberation San 10. Also, imported CSVs arrive as Liberation Sans 10, not Arial 10.

How can the default template be made to affect additional sheets and imported data?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-07 02:52:58.007990


We just had another thread about the same topic. As there was no answer there, I'm not so confident you will get one here. From very incomplete knowledge: The template is a template for documents, not for objects (this including sheets, drawings, charts ..) that may or may not be additionally included. These are created from default templates. I don't know how to change them.

Lupp gravatar imageLupp ( 2014-12-20 22:30:47 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-12-20 23:09:43 +0200

Lupp gravatar image

updated 2014-12-20 23:24:06 +0200

Just got it for your case. While there isn't a thing like a sheet style, there are cell styles, of course. Don't change the font by direct formatting but modify the 'Default' cell style for your template to your needs before saving your template. (Use > 'Format' > 'Styles and Formatting' -F11, formerly 'Stylist'. The context menu for the 'Default' cell style will offer a 'Modufy' option.) See also: RottenTemplate.ots

{Ceterum censeo: You might consider not to use that ... font. If you do, you (e.g.) won't be able to distinguish an upper case "I" from a lower case "l" without a microscope (or calling the CODE() function).}

edit flag offensive delete link more


I have the same problem, cannot open new calc spreadsheet and have desired cell alignment on any sheet other than sheet1. Created template with desired alignment and set it as the default. Then opened a new spreadsheet. Sheet1 had the desired alignment, but NOT SHEET 2 (or 3, or 4....). Is it possible to have the "default template" control the format of new spreadsheets with more than one sheet?

raymondvillain gravatar imageraymondvillain ( 2016-06-25 15:10:53 +0200 )edit

@raymondvillain: In what way are your observations conflicting with the above answer?

Lupp gravatar imageLupp ( 2016-06-26 23:06:03 +0200 )edit

Question Tools

1 follower


Asked: 2014-12-20 17:40:46 +0200

Seen: 328 times

Last updated: Dec 20 '14