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 through the graphical Preferences 
> dialogs. Other settings require direct editing of the about.config file. 
> I have to believe that part of LO's GUI Options dialogs could be to make 
> changes to some of these deeper level settings, such as Ian's default 
> Calc font.

There is a GUI method of editing them. Using the normal LO GUI. I
outlined it in a post earlier in this thread.
 4 mouse clicks and you're into the 'Expert Configuration' dialog. 3
double clicks and you're into the default font settings of your own
language. I was wary of the dragons, but it is easy to do and easy to undo.

Philip

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 me a lot of time and effort to learn templates and styles, and 
I have learned that this is time and effort that most users aren't 
willing to expend.

When I consider changing Calc's default, the template method is 
efficient and took me about a minute. But, I believe someone else found 
a way to change it by editing some settings in the Advanced options 
settings. This, of course is unadvised and I understand why. But, for me 
it raises a question.

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 through the graphical Preferences 
dialogs. Other settings require direct editing of the about.config file. 
I have to believe that part of LO's GUI Options dialogs could be to make 
changes to some of these deeper level settings, such as Ian's default 
Calc font.

Virgil

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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, 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.
> 
> If that template is set as default template then all that is not necessary. 
> Just File > New > Spreadsheet will create a new spreadsheet based upon the 
> template.
> 
You are quite right, thanks. There is always something to learn -
fortunately.

Philip

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 Paul's idea and try and edit the Default 
> Template

No, no NO.

If you must use the Libreoffice menu system to create new documents and
want to change the defaults (I prefer just saving my templates in the
filesystem and using them from there), then do as has already been
suggested multiple times.

1. Create a template the way you want it to be.

2. Set that template as the NEW Default.

3. Done.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 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.

I have never, ever, used the menus and/or the application template
directory with my templates.

I create my templates, save them wherever I want with a meaningful name,
then when I'm ready to use one, I just go to MY templates folder (in the
filesystem, not through the Libreoffice menu system), then dbl-click the
template I want to use. Done.

For any that I use a lot, I create a shortcut and put it on my desktop.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 penalizes those who have learned "advanced", more
efficient ways of doing things, than using mouse clicks. Furthermore,
the more efficient way can look scary, and scary is an anathema to PHBs.
Nonetheless, learning how to use one's tools effectively, and
efficiently should remain standard practice, no matter the
discombobulation to both designers of skill rating tests, and PHBs.

> But thank you all for trying - appreciated. (back to the repetitive manual 
> method I guess!)

Why would you rather do the same sequence of actions every time you want
a spreadsheet, than do things once, and be done with it?

jonathon

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 - I tried the Side-Bar method first of all
> but my version has no such option as Cell Styles - so no joy there!!
> 
> 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 up with Liberation Sans 10
> still *GRR!!!*
> 
> This should be one change in the Options Menu - "Set Default Font and
> Size". Why all these hoops to jump through!
> It's no wonder some people leave LO for other programs!!
> 
> But thank you all for trying - appreciated. (back to the repetitive
> manual method I guess!)
> 
> IanW
> Pretoria RSA.

Hi Ian,

I cannot understand why this is not working for you. The simple one time
method of creating a default Calc template described in my previous
email works perfectly for me and 14 others here all using PCLinuxOS and
LO version 5.3.0.3

My guess is the problem is either an issue with your user profile, or
something else in your setup that we are not picking up from your
description.

Try directly opening the attached sample template and you should see a
single sheet with Bold 14pt. Liberation Serif font. If not there is
something "adrift" in your setup.

Regards
Dave



-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 02/21/2017 10:08 AM, Piet van Oostrum wrote:

That's not enough. You also have to designate it as the default template. The name 
doesn't do that. Go to File > Template > Manage Templates, select the template 
and set it as the default template.
See my posting.




--
To unsubscribe e-mail to: users+unsubscr...@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

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 up with Liberation Sans 10 
 > still *GRR!!!*

That's not enough. You also have to designate it as the default template. The 
name doesn't do that. Go to File > Template > Manage Templates, select the 
template and set it as the default template.
See my posting.
 > 
 > This should be one change in the Options Menu - "Set Default Font and 
 > Size". Why all these hoops to jump through!
 > It's no wonder some people leave LO for other programs!!

Next time, somebody wants an option to set the default page size, or the 
default background color, or ... 
Putting it all in a template is much easier than having options for everything

-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 version has no such option as Cell Styles - so no joy there!!


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 up with Liberation Sans 10 
still *GRR!!!*


This should be one change in the Options Menu - "Set Default Font and 
Size". Why all these hoops to jump through!

It's no wonder some people leave LO for other programs!!

But thank you all for trying - appreciated. (back to the repetitive 
manual method I guess!)


IanW
Pretoria RSA.




--
To unsubscribe e-mail to: users+unsubscr...@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

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

2017-02-20 Thread Virgil Arrington 
I hadn't seen Piet's post below until Steve responded to it, but Piet's process 
is what I used to change my default font. Worked just fine.

Virgil



Sent from my Verizon, Samsung Galaxy smartphone


 Original message 
From: Steve Edmonds <steve.edmo...@ptglobal.com>
Date: 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 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 Bar for Templates or Edit Templates. So where do you find this and
>   > edit it??
>   >
>   > This should be as easy to do as it is in Scribus!!! Why make things so
>   > difficult??
>   >
>
> It had been posted before, but I'll repeat:
> (This is LO 5.3.0.3 on Mac)
> File > New > Spreadsheet
> Side Bar > Styles and Formatting (or Format > Styles > Styles and Formatting)
>> Cell Styles (icon) > Default
> Right Click Modify..
> Set your font and font size > OK
> File > Templates > Save as Template
> Enter a name (e.g. Default), select category "My Templates",
> check "Set as default template" > Save
> In other versions you might have to do
> File > Templates < Manage Templates, Filter Spreadsheets, to set the template 
> as default.
>
  just beat me to it. Quite straight forward but not easily found with
this explanation.
For me in writer I also change the default margins as well as font and
have custom named paragraph styles (to avoid issues copy/pasting between
documents with the same named but different styles).
steve

--
To unsubscribe e-mail to: users+unsubscr...@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


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 and edit the Default
  > Template but I can find no reference in the Drop-Down options in the
  > Menu Bar for Templates or Edit Templates. So where do you find this and
  > edit it??
  >
  > This should be as easy to do as it is in Scribus!!! Why make things so
  > difficult??
  >

It had been posted before, but I'll repeat:
(This is LO 5.3.0.3 on Mac)
File > New > Spreadsheet
Side Bar > Styles and Formatting (or Format > Styles > Styles and Formatting)

Cell Styles (icon) > Default

Right Click Modify..
Set your font and font size > OK
File > Templates > Save as Template
Enter a name (e.g. Default), select category "My Templates",
check "Set as default template" > Save
In other versions you might have to do
File > Templates < Manage Templates, Filter Spreadsheets, to set the template 
as default.
  
 just beat me to it. Quite straight forward but not easily found with 
this explanation.
For me in writer I also change the default margins as well as font and 
have custom named paragraph styles (to avoid issues copy/pasting between 
documents with the same named but different styles).

steve

--
To unsubscribe e-mail to: users+unsubscr...@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

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 through the lengthy
number of clicks I outlined above.



Earlier today, I opened a blank spreadsheet, changed.the font on the default 
style, saved the file as a template, and then designated the template as the 
default for spreadsheets. Yes, it took a more than a few clicks, but I 
accomplished the entire process in about a minute. I have taken the time to 
learn how to use LO's styles and remplates. Since this is how the program 
works, it was time well spent. By spending a minute to create my own template, 
I have saved myself time later by directly changing the font in every 
spreadsheet I create.

Virgil



--
To unsubscribe e-mail to: users+unsubscr...@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

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 in the Drop-Down options in the 
 > Menu Bar for Templates or Edit Templates. So where do you find this and 
 > edit it??
 > 
 > This should be as easy to do as it is in Scribus!!! Why make things so 
 > difficult??
 > 

It had been posted before, but I'll repeat:
(This is LO 5.3.0.3 on Mac)
File > New > Spreadsheet
Side Bar > Styles and Formatting (or Format > Styles > Styles and Formatting)
> Cell Styles (icon) > Default
Right Click Modify..
Set your font and font size > OK
File > Templates > Save as Template
Enter a name (e.g. Default), select category "My Templates",
check "Set as default template" > Save
In other versions you might have to do
File > Templates < Manage Templates, Filter Spreadsheets, to set the template 
as default.
 
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 Bar for Templates or Edit Templates. So where do you find this and 
edit it??


This should be as easy to do as it is in Scribus!!! Why make things so 
difficult??


Thanks all


On 02/20/2017 06:27 PM, Piet van Oostrum wrote:

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 want or need a Template I just want the Font and size that I
  > selected to be the Default for all new Spreadsheets!!
  >
If you want to change the default font, and setting the default template is the 
way to do it, why would you not want that?


--

--
To unsubscribe e-mail to: users+unsubscr...@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

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 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.

If that template is set as default template then all that is not necessary. 
Just File > New > Spreadsheet will create a new spreadsheet based upon the 
template.
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 Arial.

You can use:
Ctrl+Shift+n to open the Templates window.
Then double click the desired template.

On Mon, Feb 20, 2017 at 4:55 PM, Philip Jackson 
wrote:

> 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 modifies the
> command line above accordingly, he will be able to make a small script
> tied to a keyboard shortcut which would make it very simple to create a
> new spreadsheet.
>
> Philip
>
> --
> To unsubscribe e-mail to: users+unsubscr...@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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 modifies the
command line above accordingly, he will be able to make a small script
tied to a keyboard shortcut which would make it very simple to create a
new spreadsheet.

Philip

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 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+unsubscr...@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

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 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: users+unsubscr...@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

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 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


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

--
To unsubscribe e-mail to: users+unsubscr...@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

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 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/".

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.

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.

Don't fight templates, use them.

Dave

-- 
Please address any reply to the mailing list only. Any messages sent to
this noreply@ address are automatically deleted from the server and will
never be read.

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 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

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 belong in the Tools->Options section.


One might say that there are many options that can be changed on a 
default template, but I, for one, only change 2 (coincidently font and 
size :) ).  I assume this applies to most people in the world.  For 
those that do complicated set-ups, let them create default documents and 
make them templates.


By the way, after much help from the list, I finally gave up.  I allow 
LO to start the document with the _wrong_ font and size, then I go to 
the upper left corner on the sheet to select all cells, then I set the 
_correct_ font and size there.



John

On 02/20/2017 08:55 AM, Dave Howorth wrote:

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.)

I'm using an earlier version of LO (5.2.3.3) so maybe things are
different but...

To the right of Properties (in the Sidebar, which is at the right-hand
side of the window) is the right-hand window border!

but ... (see below ...)


On Mon, Feb 20, 2017 at 9:06 AM, 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.

Above Properties is Sidebar Settings (three short horizontal lines and
a triangle) and Styles and Formatting is in the sub-menu it brings up,
but ...

The Styles and Formatting icon (a piece of paper and a T-bar) is
immediately below the Properties icon (green and blue) anyway, so just
click on it ...

HTH, Dave


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 size that I
selected to be the Default for all new Spreadsheets!!

IanW
Pretoria RSA



On 02/20/2017 03:22 PM, Bruce Hohl wrote:


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
 wrote:

*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
there has
to be a basic simple way to do this - all I need is for someone
to teach me
how!!

I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.

Thanks a lot

IanW
Pretoris RSA



--


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
ubscribe/ 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





--
To unsubscribe e-mail to: users+unsubscr...@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

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.)

I'm using an earlier version of LO (5.2.3.3) so maybe things are
different but...

To the right of Properties (in the Sidebar, which is at the right-hand
side of the window) is the right-hand window border!

but ... (see below ...)

> On Mon, Feb 20, 2017 at 9:06 AM, 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.

Above Properties is Sidebar Settings (three short horizontal lines and
a triangle) and Styles and Formatting is in the sub-menu it brings up,
but ...

The Styles and Formatting icon (a piece of paper and a T-bar) is
immediately below the Properties icon (green and blue) anyway, so just
click on it ...

HTH, Dave

> > 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 size that I
> > selected to be the Default for all new Spreadsheets!!
> >
> > IanW
> > Pretoria RSA
> >
> >
> >
> > On 02/20/2017 03:22 PM, Bruce Hohl wrote:
> >
> >> 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
> >>  wrote:
> >>
> >> *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
> >>> there has
> >>> to be a basic simple way to do this - all I need is for someone
> >>> to teach me
> >>> how!!
> >>>
> >>> I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.
> >>>
> >>> Thanks a lot
> >>>
> >>> IanW
> >>> Pretoris RSA
> >>>
> >>>
> >>>
> >>> --
> >>>
> >>
> >
> > --
> > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> > ubscribe/ 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
> >
> 


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 want or need a Template I just want the Font and size that I 
 > selected to be the Default for all new Spreadsheets!!
 > 
If you want to change the default font, and setting the default template is the 
way to do it, why would you not want that?
-- 
Piet van Oostrum 
WWW: http://pietvanoostrum.com/
PGP key: [8DAE142BE17999C4]


-- 
To unsubscribe e-mail to: users+unsubscr...@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

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: users+unsubscr...@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

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:

> *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 size that I
> selected to be the Default for all new Spreadsheets!!
>
> IanW
> Pretoria RSA
>
>
>
> On 02/20/2017 03:22 PM, Bruce Hohl wrote:
>
>> 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 
>> wrote:
>>
>> *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 there
>>> has
>>> to be a basic simple way to do this - all I need is for someone to teach
>>> me
>>> how!!
>>>
>>> I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.
>>>
>>> Thanks a lot
>>>
>>> IanW
>>> Pretoris RSA
>>>
>>>
>>>
>>> --
>>>
>>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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

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 size that I 
selected to be the Default for all new Spreadsheets!!


IanW
Pretoria RSA


On 02/20/2017 03:22 PM, Bruce Hohl wrote:

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 
wrote:


*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 there has
to be a basic simple way to do this - all I need is for someone to teach me
how!!

I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.

Thanks a lot

IanW
Pretoris RSA



--



--
To unsubscribe e-mail to: users+unsubscr...@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

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 
wrote:

> *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 there has
> to be a basic simple way to do this - all I need is for someone to teach me
> how!!
>
> I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.
>
> Thanks a lot
>
> IanW
> Pretoris RSA
>
>
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns
> ubscribe/
> 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
>

-- 
To unsubscribe e-mail to: users+unsubscr...@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

[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 
there has to be a basic simple way to do this - all I need is for 
someone to teach me how!!


I'm currently using LO ver 5.3.0.3 on PClinusOS 64-bit.

Thanks a lot

IanW
Pretoris RSA



--
To unsubscribe e-mail to: users+unsubscr...@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