Question re: Calc default font

Willy_Williams · February 23, 2012, 12:22am

I must not be holding my mouth right. While I can hit F11 and change the current font in Calc to the desired one, I seem to not be able to make that other font my default. I've found the magic in Writer, but not Calc. Can someone please enlighten me as to how to set a permanent default font in Calc other than Arial? Thanks in advance.

Willy

Brian_Barker · February 23, 2012, 5:27am

o Open a new spreadsheet document.
o Click in the top left corner, where the row and column headers meet, in order to select the entire sheet.
o Go to Format | Cells... | Font (or right-click | Format Cells... | Font) and select your chosen font - or just use the Font Name box in the Formatting toolbar.
o Repeat for Sheet2 and Sheet3 if desired.
o Go to File | Templates > | Save..., give the template a name, and save it somewhere - probably in My Templates.
o Go to File | Templates > | Organize..., browse to and select the template, and then click Commands | Set As Default Template.

This template will now be used when you create a new spreadsheet (Calc) document, with the font set as you require. But I suspect any new sheets you insert may fall back to Arial.

I trust this helps.

Brian Barker

Willy_Williams · February 23, 2012, 7:23am

Thanks, Brian. I've done all that, but Calc continues to revert to Arial every time. I seem to not be able to save a new default font for all new documents. As I recall, I could do that in versions of Calc prior to 3.5.

Willy

Regina · February 23, 2012, 4:43pm

Hi,

Brian Barker schrieb:

While I can hit F11 and change the current font in Calc to the desired
one, I seem to not be able to make that other font my default. I've
found the magic in Writer, but not Calc. Can someone please enlighten
me as to how to set a permanent default font in Calc other than Arial?

o Open a new spreadsheet document.
o Click in the top left corner, where the row and column headers meet,
in order to select the entire sheet.
o Go to Format | Cells... | Font (or right-click | Format Cells... |
Font) and select your chosen font - or just use the Font Name box in the
Formatting toolbar.

A better way is not setting a hard formatting but using the styles. So open Style&Formatting window and set the desired font in the cell style "default".

The important step is indeed to save it as template and afterwards make it your default template. If you want to use document creation from right click in Windows, you need to change the common template as well.

Kind regards
Regina

Tom_Davies · February 23, 2012, 5:15pm

Hi
If it's still not working would it be a good idea to trry renaming the UserProfile to see if Brian's instructions, as modified by Regina, work better with the fresh start?
http://wiki.documentfoundation.org/Documentation/UserProfile
Regards from
Tom

Willy_Williams · February 23, 2012, 5:28pm

That was just the trick, Regina. Thanks for the wisdom. Now, if that capability could be made part of the Options, much as it's part of the Options in Writer, it would be even better.

Willy

Tom_Davies · February 23, 2012, 5:31pm

Hi
Sounds like time to add a feature request
http://wiki.documentfoundation.org/BugReport
Congrats and regards from
Tom

Willy_Williams · February 23, 2012, 8:28pm

Done.

Willy

Tom_Davies · February 24, 2012, 5:43pm

Hi
Nicely done :) You can always give a link to the bug-report/feature-request although doing so seldom results in it getting dealt with faster or getting mor votes or anything. Still it's nice&tidy for future reference if you are up for it.
Congrats, thanks and regards from
Tom

Villeroy · February 25, 2012, 12:09pm

Am 23.02.2012 18:28, Willy Williams wrote:

That was just the trick, Regina. Thanks for the wisdom. Now, if that
capability could be made part of the Options, much as it's part of the
Options in Writer, it would be even better.

Pardon? Which options in Writer? I only know the same methods in Writer, Calc, Draw and Impress. Simply define your own templates and styles. What's wrong with it? Where is the link to your issue?

Brian_Barker · February 27, 2012, 4:05am

At Tools | Options... | LibreOffice Writer | Basic Fonts (Western), you can set default fonts for Writer. But there is no corresponding option for document types other than text or HTML.

I trust this helps.

Brian Barker

Villeroy · February 27, 2012, 9:39am

Am 27.02.2012 05:05, Brian Barker wrote:

Am 23.02.2012 18:28, Willy Williams wrote:

That was just the trick, Regina. Thanks for the wisdom. Now, if that
capability could be made part of the Options, much as it's part of
the Options in Writer, it would be even better.

Pardon? Which options in Writer? I only know the same methods in
Writer, Calc, Draw and Impress. Simply define your own templates and
styles.

At Tools | Options... | LibreOffice Writer | Basic Fonts (Western), you
can set default fonts for Writer. But there is no corresponding option
for document types other than text or HTML.

I trust this helps.

Brian Barker

Thank you. I never noticed this very useful method for mass editing styles. In Calc there is only one root style with a font property. In English it is named "Standard". Edit that one and you are done.