OpenOffice calc forgets my font size settings

Discuss the spreadsheet application

OpenOffice calc forgets my font size settings

Postby TheMotorcycleBoy » Mon Jul 22, 2019 9:09 am

Hi people,

I'm using the OpenOffice Calc program which I'm very impressed it. One thing however which is a little annoying is that it seems get my Default Style font size wrong.

When creating financial spreadsheets I like to work with Arial at size 8. It just works best on my screen and with my work flow. I have set my Styles->Manage Styles->Default setting to use this family and size. However, whenever I create a new page, Calc resets my size to 10. I frequently find myself then having to "Select all" the page, and go to the Font button on the toolbar in order to reset back to 8. I also find that sometimes whilst I'm adding new rows, columns that they too will be created using size 10, not size 8 which I've defaulted to.

Is this a known bug, which can be fixed?

Many thanks,
Matt
OpenOffice 6.0.7.3 on Ubuntu 18.04
TheMotorcycleBoy
 
Posts: 2
Joined: Mon Jul 22, 2019 8:55 am

Re: OpenOffice calc forgets my font size settings

Postby RoryOF » Mon Jul 22, 2019 9:25 am

In which format do you Save? If not using .ods, try that.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29294
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice calc forgets my font size settings

Postby TheMotorcycleBoy » Mon Jul 22, 2019 9:41 am

Hi,

I'm using .xlsx - which I'd like to remain using, since it offers me maximum flexibility to reopen my sheets (after uploading them to DropBox) on any device.

Being a software engineer myself, this issue seems orthogonal to that of the file format in which the work is saved.

thanks Matt
OpenOffice 6.0.7.3 on Ubuntu 18.04
TheMotorcycleBoy
 
Posts: 2
Joined: Mon Jul 22, 2019 8:55 am

Re: OpenOffice calc forgets my font size settings

Postby Zizi64 » Mon Jul 22, 2019 9:47 am

I'm using the OpenOffice Calc program which I'm very impressed it.

I'm using .xlsx

Your software is not Apache OpenOffice, but that is LibreOffice.

Always work in the native, international standard ODF file formats (.ods for the spreadsheets). It was developed for the long time compatibility.
Last edited by Zizi64 on Mon Jul 22, 2019 9:51 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8151
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: OpenOffice calc forgets my font size settings

Postby RoryOF » Mon Jul 22, 2019 9:49 am

Try altering your default template.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29294
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice calc forgets my font size settings

Postby Zizi64 » Mon Jul 22, 2019 9:53 am

I have set my Styles->Manage Styles->Default setting to use this family and size. However, whenever I create a new page, Calc resets my size to 10.

Adjusting a style will modify the style of the actual document only.
You must adjust the properties of the Default Template, as RoryOF suggested it.
File - Templates...
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8151
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 21 guests