Default font and size

users
#1

I am having a problem setting the default font in calc. This is usually not an issue, as I often start a new sheet from an existing sheet. But if I start from the first menu, I get a font called 'arial' (sounds like a mermaid or m$). Since I am using an oss program, i would prefer to use an oss font, e.g. freesans. per help, I an supposed to open a Write sheet and set the font in the 'tools' section. This works for write, not for calc.

Assistance?

John

#2

Hi.
Select the whole sheet, set the font (freesans).
Click File>Templates>Save
Select Categories = My Templates.
Give a name to the New template (defaultcalc) and click ok
Click File>Templates>Organise.
Double click My Templates, select defaultcalc
Select Commands button drop down menu and select Set as default template.

New calc sheets now open with your font (and other) settings.

Steve

#3

Hi John,

John R. Sowden schrieb:

I am having a problem setting the default font in calc. This is usually
not an issue, as I often start a new sheet from an existing sheet. But
if I start from the first menu, I get a font called 'arial' (sounds like
a mermaid or m$). Since I am using an oss program, i would prefer to
use an oss font, e.g. freesans. per help, I an supposed to open a Write
sheet and set the font in the 'tools' section. This works for write,
not for calc.

Assistance?

The font is set in the document template.

Take an new document.
Open "Styles and Formatting" window. Right click style "Default", then "Modify...".
Goto tab "Font" and choose your favorite font. OK.
Save the document as template.
Set this template as your default template.

How to do this depends on your LibreOffice version, because a new Template Manager has been developed.

Kind regards
Regina

#4

Hi. I think as Regina points out, your version and mine differ, but you seem to be on the right track.
Steve

#5

I had failed to right click on default. But I do not see any dialogue or check box to make this the default template. I looked in 'save', 'save as' and 'save as template'.

John

#6

Hi. It could be under Commands if you see that anywhere. It would certainly be much easier if there was a simple "Save as Default Template".
steve

#7

Hi John,

John R. Sowden schrieb:

Hi John,

John R. Sowden schrieb:

I am having a problem setting the default font in calc. This is usually
not an issue, as I often start a new sheet from an existing sheet. But
if I start from the first menu, I get a font called 'arial' (sounds like
a mermaid or m$). Since I am using an oss program, i would prefer to
use an oss font, e.g. freesans. per help, I an supposed to open a Write
sheet and set the font in the 'tools' section. This works for write,
not for calc.

Assistance?

The font is set in the document template.

Take an new document.
Open "Styles and Formatting" window. Right click style "Default", then
"Modify...".
Goto tab "Font" and choose your favorite font. OK.
Save the document as template.
Set this template as your default template.

How to do this depends on your LibreOffice version, because a new
Template Manager has been developed.

Kind regards
Regina

I had failed to right click on default. But I do not see any dialogue
or check box to make this the default template. I looked in 'save',
'save as' and 'save as template'.

Let's try, hopefully we have the same version.
I assume, that you have already used "Save as template".

Use File > New > Templates or 'Templates' from the start screen. You shout get a dialog with title "Template Manager".

Select the tab "Spreadsheets". There you should see your new template.

Make a single click on your template to select it. Now you get a toolbar at the top. And there you find "Set as default".

Kind regards
Regina

#8

The answers that you have been given - to create a new default template in the required font - are good, of course. But you may like to check what happens if you start a new document using this template and then create new sheets within the document. I fear you may find that the font defaults back to Arial.

I trust this helps.

Brian Barker

#9

Yes I remember. The change to the font only sticks to the first sheet with my explanation.
You need to follow Regina's procedure and it works ok.

Take an new document.
Open "Styles and Formatting" window. Right click style "Default", then
"Modify...".
Goto tab "Font" and choose your favorite font. OK.
Save the document as template.
Set this template as your default template.

Steve

#10

Hi Brian,

Brian Barker schrieb:

I am having a problem setting the default font in calc. This is
usually not an issue, as I often start a new sheet from an existing
sheet. But if I start from the first menu, I get a font called
'arial' (sounds like a mermaid or m$). Since I am using an oss
program, i would prefer to use an oss font, e.g. freesans. per help,
I an supposed to open a Write sheet and set the font in the 'tools'
section. This works for write, not for calc.

The answers that you have been given - to create a new default template
in the required font - are good, of course. But you may like to check
what happens if you start a new document using this template and then
create new sheets within the document. I fear you may find that the
font defaults back to Arial.

If you will follow Steve's description yes, because there the first sheet has got a direct formatting. But that does not change the general setting and the new sheet will have the general setting with Arial.

If you will follow my guide, the new sheet will have the new font, because it is changed in style.

I usually also set my favorite number formats in the style. And I set the language to 'none' and make a new style text_de and text_en with language German and English respectively.

And as I like printed grids I change the page style too.

Unfortunately it is not possible to set column and row width/height in a style.

I trust this helps.

Kind regards
Regina

#11

Indeed. Sorry.

Brian Barker

#12

Aargh! Sorry: I read your solution too quickly; indeed, I misread it.

Apologies - and thanks for the correction.

Brian Barker