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

2017-02-21 Thread Philip Jackson
On 21/02/17 19:53, Virgil Arrington wrote: > Since the advanced settings are just text strings in a file, which can > be easily edited, couldn't there be a GUI method of editing them? The > example of Firefox's "about.config" file was mentioned. Some of the > settings in that file can be edited

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

2017-02-21 Thread Virgil Arrington
This whole discussion about Calc's default font has got me thinking. I am one who appreciates LO's templates/style approach and I have learned how to use it. Once learned, templates and styles are easy to use and make the finished result polished and consistent. Yet, I will admit, it has taken

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

2017-02-21 Thread Philip Jackson
On 20/02/17 23:44, Piet van Oostrum wrote: > Philip Jackson wrote: > [...] > > 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,

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

2017-02-21 Thread Tanstaafl
On Mon Feb 20 2017 18:16:45 GMT-0500 (Eastern Standard Time), Ian Whitfield wrote: > Thanks All > > But still no joy!! Why does this have to be so difficult!!?? None of the > ideas about using the Side-Bar do anything that makes any sense. > > So I thought I would try

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

2017-02-21 Thread Tanstaafl
On Mon Feb 20 2017 14:32:17 GMT-0500 (Eastern Standard Time), Philip Jackson wrote: > 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

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

2017-02-21 Thread toki
On 02/21/2017 02:56 AM, Ian Whitfield wrote: > It's no wonder some people leave LO for other programs!! Like all software that offers users options, some learning of how to use the program is required. I understand why software learning is not done --- skill testing either ignores, or actively

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

2017-02-21 Thread Dave Barton
On 21.02.2017 03:56, Ian Whitfield wrote: > *Thanks Everyone* > > I seem to have stirred-up a real Hornets Nest here - but to me it just > shows how badly this part of LO is!!! It's a GREAT program except for > this problem and of course the orphan child Base!! > > Anyway - still no luck here -

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

2017-02-21 Thread Ian Whitfield
*Thank you, Thank you Piet and Brian* That did it - Magic!! Just what I wanted. You have made my frequent use of Calc so much better!! I still think it is a convoluted way of doing things but I'm very happy to have the answer at last. With much appreciation!! Ian Pretoria RSA On

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

2017-02-21 Thread Piet van Oostrum
Ian Whitfield wrote: > > Next I tried starting a new Spreadsheet, changing to the Font and size I > want, (which is what I've been doing for a couple of years or so), and > then saving this as a Template with the name 'Default'. I then close > down the program and re-start it and it comes

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

2017-02-20 Thread Ian Whitfield
*Thanks Everyone* I seem to have stirred-up a real Hornets Nest here - but to me it just shows how badly this part of LO is!!! It's a GREAT program except for this problem and of course the orphan child Base!! Anyway - still no luck here - I tried the Side-Bar method first of all but my

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

2017-02-20 Thread Virgil Arrington
: 2/20/17 6:48 PM (GMT-05:00) To: users@global.libreoffice.org Subject: Re: [libreoffice-users] Default font in LO calc Hi Piet, On 2017-02-21 12:31, Piet van Oostrum wrote: > Ian Whitfield wrote: > > > Thanks All > > > > But still no joy!! Why does this ha

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

2017-02-20 Thread Steve Edmonds
Hi Piet, On 2017-02-21 12:31, Piet van Oostrum wrote: Ian Whitfield wrote: > Thanks All > > But still no joy!! Why does this have to be so difficult!!?? None of the > ideas about using the Side-Bar do anything that makes any sense. > > So I thought I would try Paul's idea and try

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

2017-02-20 Thread Virgil Arrington
Sent from my Verizon, Samsung Galaxy smartphone Original message From: Philip Jackson > 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

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

2017-02-20 Thread Piet van Oostrum
Ian Whitfield wrote: > Thanks All > > But still no joy!! Why does this have to be so difficult!!?? None of the > ideas about using the Side-Bar do anything that makes any sense. > > So I thought I would try Paul's idea and try and edit the Default > Template but I can find no reference

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

2017-02-20 Thread Ian Whitfield
Thanks All But still no joy!! Why does this have to be so difficult!!?? None of the ideas about using the Side-Bar do anything that makes any sense. So I thought I would try Paul's idea and try and edit the Default Template but I can find no reference in the Drop-Down options in the Menu

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

2017-02-20 Thread Piet van Oostrum
Philip Jackson wrote: [...] > 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

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

2017-02-20 Thread Bruce Hohl
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

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

2017-02-20 Thread Philip Jackson
On 20/02/17 21:49, leleu wrote: > Under Ubuntu 16.10 a command with the entry > libreoffice --calc /home/leleu/.config/libreoffice/4/user/template/essai.ots > does open a unnamed sheet conform to the model essai.ots > > Robert Leleu Yes it does under. And if the OP creates his template and

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

2017-02-20 Thread Philip Jackson
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

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

2017-02-20 Thread Philip Jackson
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

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

2017-02-20 Thread leleu
Je la 20/02/2017 20:32, Philip Jackson skribis : 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

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

2017-02-20 Thread Dave
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

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

2017-02-20 Thread Philip Jackson
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

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

2017-02-20 Thread John R. Sowden
I had this problem years ago, and wrote to the list for help. The solution was to create a separate empty spreadsheet, (and a write document?), then convert? it to a template, and label it somehow, in order to set the default font and size. The Elephant in this Room is: These two settings

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

2017-02-20 Thread Dave Howorth
On Mon, 20 Feb 2017 10:30:30 -0500 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.)

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

2017-02-20 Thread Piet van Oostrum
Ian Whitfield wrote: > *Thanks Bruce* > > BUT that does not work!! > > Top Right Icon is 'Properties' not 'Styles and Formatting' and it is > showing the Font and Size I want. > > But when I select 'New Spreadsheet' the "default" Liberation Sans 10 > still comes up!! > > I don't

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

2017-02-20 Thread toki
02/20/2017 02:06 PM, Ian Whitfield wrote: > I just want the Font and size that I selected to be the Default for all new Spreadsheets!! Which is precisely why you both want and need to construct, and use a default template. jonathon -- To unsubscribe e-mail to:

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

2017-02-20 Thread Bruce Hohl
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.) On Mon, Feb 20, 2017 at 9:06 AM, Ian Whitfield wrote: >

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

2017-02-20 Thread Ian Whitfield
*Thanks Bruce* BUT that does not work!! Top Right Icon is 'Properties' not 'Styles and Formatting' and it is showing the Font and Size I want. But when I select 'New Spreadsheet' the "default" Liberation Sans 10 still comes up!! I don't want or need a Template I just want the Font and

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

2017-02-20 Thread Bruce Hohl
View > Sidebar Use top right icon to switch to "Styles and Formatting Right click "Default" and select "Modify" Under the Font tab select your desired font. You might want to save this as a template and use as your default template. On Mon, Feb 20, 2017 at 7:52 AM, Ian Whitfield

[libreoffice-users] Default font in LO calc

2017-02-20 Thread Ian Whitfield
*Hi All* _PLEASE_ can someone tell me how to change the *&%$# Default Font in Calc!! I have tried many times to do this, Googled lots of suggestions but NOTHING WORKS!! And there are many different sets of instruction on how to do this. It is one of the most frustrating things in LO Calc and