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/". > Yes, I tend to agree. That's why I suggested that maybe someone on the list has experience here that could help us.
> Not sure what the "/Standard/" button is, but if you mean the > "/Default/" style, you will obviously be "/again in the Liberation Sans > 10 font/", because you did not change it to something else before saving > your custom default template. > I cannot see that you are right here. My new template was prepared especially with Arial font [just for trials not because I like Arial] and wherever I look in the template under cell style in this template the 'Default' style has Arial font specified. So I can always open a new spreadsheet equipped with Arial by selecting File > New > Templates > spreadsheet tab > My Templates > select the template > click Open. That is a lot of clicks and so in practice, it is easier just to do File > New > Spreadsheet and then change the font from Liberation to Arial. Now if I am inside a new spreadsheet created with my Arial template, all checks on Default cell style do show Arial but that does not mean that if I just click File > New > Spreadsheet that I will get another new spreadsheet with Arial font. The new one in this case has Liberation font set and that, I think, is what the OP would like to avoid. > It's not a "/work-around/". The software has to start with some kind of > default settings. If the user has not customized those settings by > providing their own default preferences in the form of a template, the > software has no option but to use it's inbuilt defaults. I agree that the software has to start from some kind of default settings. But creating a new template with the user's default preferences only works if the user is prepared to go through the lengthy number of clicks I outlined above. If his only changes are the font settings, it is quicker just to open a new sheet File > New > Spreadsheet and then change the font from Liberation to whatever. I still think the answer the OP is seeking lies within the Advanced settings, but I am wary of the dragons within. Philip -- To unsubscribe e-mail to: [email protected] 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
