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

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 <brucehohl@gmail.com> 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
> > <whitfield@telkomsa.net> 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
> > > > <whitfield@telkomsa.net> 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+unsubscribe@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+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