Page 1 of 1

[Solved] Default Fonts

PostPosted: Fri May 17, 2019 2:41 pm
by jonesp57
Hi, I need some help in setting a default font in a spreadsheet.
I wish to use 'Times New Roman' as a default font in my spreadsheets.
I opened up a new spreadsheet, changed the fonts to 'New Times Roman' and saved this as a Template in 'My Templates'
I then set this as my 'Default Template.
Now when I open up a new spreadsheet all the fonts are 'New Times Roman' as I require.

The problem I have, is that if I 'cut' or 'move' some text from a cell, that cell reverts back to having 'Arial' as the default text.

Can someone offer some advice please

Regards Paul

Re: Default Fonts

PostPosted: Fri May 17, 2019 2:49 pm
by RoryOF
Try /Tools /Options /OpenOffice /Fonts. check "Apply replacement table" and enter the desired font substitutions

Re: Default Fonts

PostPosted: Fri May 17, 2019 3:15 pm
by jonesp57
RoryOF wrote:Try /Tools /Options /OpenOffice /Fonts. check "Apply replacement table" and enter the desired font substitutions



Thanks, tried that, Fonts still revert to 'Arial'

Re: Default Fonts

PostPosted: Fri May 17, 2019 7:23 pm
by jonesp57
Managed to resolve the problem myself via choosing

Format > Styles and Formatting, right click on Default and choose Modify > Font

re-saved as default Template

Phew, been driving me mad for the past few days.

Thanks Paul