Re: [libreoffice-users] Default font in LO calc

On 20/02/17 21:11, Dave wrote:
> On 20.02.2017 20:32, Philip Jackson wrote:
> > On 20/02/17 16:30, Bruce Hohl wrote:
> > > To the right of 'Properties' there is a drop down icon which if you
> > > mouse-over has the tag 'Side bar setting'.  Click that icon to select
> > > 'Styles and Formatting'.  (If someone knows another way please chime-in.)
> > I'm with Ian on this one. Those changes you suggest work for the current
> > spreadsheet but as soon as you do :
> > File > New > Spreadsheet, the new sheet opens with Liberation Sans 10
> > selected and in place.
> >
> > If you open the Default style by right-click > modify > Font tab, you
> > can set the font to anything else you like but one thing that makes me
> > think the default is set at a deeper level is that on the style modify
> > dialog, there is a fourth button (at RHS) labeled 'Standard'.  Clicking
> > this sets Liberation Sans 10 again.
> >
> > According to the help info, the Standard button "Resets the values
> > visible in the dialog back to the default installation values"
> >
> > If I prepare a new blank spreadsheet with my preferred font and save it
> > as a new template, whenever I open a new spreadsheet by File > New >
> > Templates > Spreadsheets tab > select my new template > click Open, I
> > get a new blank spreadsheet with my fonts I selected. So this is
> > available as a workaround but it involves a lot of clicks just to get
> > what is needed. More clicks than it takes to change the font in the
> > default spreadsheet.
> >
> > Moreover, within the new spreadsheet from the new template, if I open
> > the style modification dialog and click the 'Standard' button, then I'm
> > again in the Liberation Sans 10 font.
> >
> > So where to go to change the 'Standard' setting remains a useful
> > question.  Could the answer be in the Tools > Options > LibreOffice >
> > Advanced and then look at org.openoffice.VCL > DefaultFonts  where I see
> > that the Liberation family gets lots of mentions ?
> >
> > Perhaps someone more used to modifying these Advanced settings could
> > comment ?
> >
> > Philip
>
> I would advise advise anyone against poking around in the "/Advanced/"
> options. It's somewhat like messing with the Windows Registry, or
> Mozilla's about:config, one wrong move and everything can go "/pear
> shaped/".

OK - I couldn't resist it. After my previous response I tried this :

Tools > Options > LibreOffice > Advanced > Expert Configuration.  Within
the Expert Configuration dialog box, I selected
org.openoffice.VCL and double clicked on the little triangle to its
left. This opened up to show three possibilities :
Settings, DefaultFonts, FontSubstitutions.
I double clicked the little triangle to the left of DefaultFonts and
then same for 'en' language. This revealed 22 lines of defaults for
different 'cases'.  Looking down the second column 'Property', I
selected the row 'LATIN_SPREADSHEET' where the 4th column shows the
value : "Liberation Sans;Albany AMT;Albany;Arial;Arimo... ...." [15
different fonts in total]

I clicked on the 'Edit' button and typed Arial in the first place of the
list, deleted it from its existing 4th place, taking care not to upset
the semi-colons, and clicked 'OK'

I tried creating new spreadsheets from File > New > Spreadsheet, from
the LibreOffice starter panel, and from inside Writer. In every case,
the new spreadsheet opened with Arial set as default. I think this is
the effect the OP was seeking although Arial may not be his preference.

It would seem that LO creates a spreadsheet using as default, the first
font listed in the Value string of the LATIN_SPREADSHEET property of the
org.openoffice.VCL:LocalizedDefaultFonts['en']  preference.

Caution must be used when tampering with these configuration settings
and anybody who does so, does it at his own risk.

Philip

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted