[libreoffice-users] Re: Slow opening documents

[CVAlkan]

Leonardo:

I first noticed the behavior you describe with:
Version: 5.3.0.0.beta2+
Build ID: 4cbe2e712bab42e95fb55d78da6b1daf326f7f1b

If a document is opened with LO from the file manager, it takes forever for
the resulting window to display the file. If, on the other hand, LO is
started and the document selected from within its own start window (which
appears instantaneously), the document appears pretty much immediately.

For that reason, I reverted back to using an earlier version. The current
ppa version in Ubuntu (Version: 5.3.0.3 - Build ID:
1:5.3.0~rc3-0ubuntu1~xenial1.1) has exactly the same symptoms by the way.

It is not your machine, your memory, your processor or anything else at your
location. It's definitely something that changed between the "normal" 5.2
line and the "5.3" line. I don't think it has anything to do with
pre-loading only because there are no corresponding time differences in
start up of the OS.

I'm using both stock Ubuntu 16.04.1 and Fedora 24 and the behavior is the
same on both; I can't speak for any other OS.

I stopped filing bug reports some time back because of the atmosphere, but
don't let that stop you.

Have a good day: just remember to start LO first, and then pick a file to
load.



--
View this message in context: 
http://nabble.documentfoundation.org/Slow-opening-documents-tp4208616p4208655.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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] Slow opening documents

[Philip Jackson]

On 21/02/17 16:33, Leonardo M. Ramé wrote:
> Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening on
> LO's 5.2.x.
> 
> When I open Writer or Calc documents the LO window is freezed for about
> 15 seconds, then it opens the document.
> 
> Does anyone know why this is happening?.

I see this behavior on UbuntuStudio 16.04 LTS using LO 5.1.4.2 (the
distro's standard issue) under one condition. I have an i5-4400
processor running at 3.1 Ghz with 4 cores, and 31 GiB of RAM. I also saw
this with US 14.04 LTS

Delays which appear as a freeze only happen when I open a second
document in Writer. When I open the first one with around 4 MB and some
70 linked images, the doc opens in about 5 seconds. If I then want to
open a second document of a similar size without closing the first, LO
Writer looks like it's frozen, displaying a blank document for up to 30
seconds before suddenly it all comes good.

I've watched the system during this time and 3 of the cores are running
at around 2 or 3% and the 4th core is at 100%.

I have so much RAM that I don't think that can be 'the' limiting factor.
It is more likely that LO can't take advantage of the other cores in the
cpu and is using an insufficient amount of the available RAM.

I see there is an option to change the amount of memory allocated to LO.
 Tools > Options > LibreOffice > Memory. According to the Help, this is
for caching graphics objects. Mine was originally set at 100 MB (IIRC)
and I have tried increasing it to 400 MB but this makes no discernible
difference to the delay in loading a second document.

I don't believe I have ever seen a delay / freeze when loading a first
document.

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

[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] Slow opening documents

[M Henri Day]

2017-02-21 20:46 GMT+01:00 Leonardo M. Ramé :

>
>
> El 21/02/17 a las 16:23, Leonardo M. Ramé escribió:
>
>> El 21/02/17 a las 14:52, M Henri Day escribió:
>>
>>> 2017-02-21 16:33 GMT+01:00 Leonardo M. Ramé >> >:
>>>
>>> Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening
>>> on LO's 5.2.x.
>>>
>>> When I open Writer or Calc documents the LO window is freezed for
>>> about 15 seconds, then it opens the document.
>>>
>>> Does anyone know why this is happening?.
>>>
>>> Regards,
>>> -- Leonardo M. Ramé
>>> Medical IT - Griensu S.A.
>>> Av. Colón 636 - Piso 8 Of. A
>>> X5000EPT -- Córdoba
>>> Tel.: +54(351)4246924  +54(351)4247788
>>>  +54(351)4247979 int. 19
>>> 
>>> Cel.: +54 9 (011) 40871877
>>>
>>>
>>> ​Leonardo, could this be a hardware problem ? Perhaps you'd like to
>>> tell us a bit more about the hardware on which you're running XUbuntu
>>> and LO 5.3 ?...
>>>
>>> Henri
>>>
>>
>> No, I'm sure it's not a HW problem, this was working perfectly before
>> 5.2. My machine is an i5 with 8gb RAM.
>>
>> What I found is, while the freeze is happening the CPU works at +90%
>> (soffice.bin process).
>>
>>
> More info, this only happens if I open the file from command line like
> "libreoffice myfile.odt" or by double clicking on the file browser.
>
> If I first start libreoffice, then go to file->open it opens instantly.
>
> Regards,
> --
> Leonardo M. Ramé
> Medical IT - Griensu S.A.
> Av. Colón 636 - Piso 8 Of. A
> X5000EPT -- Córdoba
> Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
> Cel.: +54 9 (011) 40871877


​Interesting ! On the machine I described above, on which I'm running
64-bit Linux Mint​
​ 18.1, I see no difference in the speed of opening if I open the file in
question in my Documents directory, or if I first open LO and then access
the file. In my case, (the Swedish language version of) 5.3.0​
​.3 was downloaded directly from the LO website

Running «dpkg -s libreoffice» in a terminal gives the following :

Package: libreoffice
Status: install ok installed
Priority: optional
Section: metapackages
Installed-Size: 13
Maintainer: Ubuntu Developers 
Architecture: amd64
Version: 1:5.3.0~rc3-0ubuntu1~xenial1.1
(and very much more)

i e, precisely what you see, Leonardo

Henri​

-- 
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] Slow opening documents

[Leonardo M . Ramé]

El 21/02/17 a las 16:45, Robert Großkopf escribió:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Leonardo,

No, I'm sure it's not a HW problem, this was working perfectly
before 5.2. My machine is an i5 with 8gb RAM.

What I found is, while the freeze is happening the CPU works at
+90% (soffice.bin process).

Where did you get your LO-Version from? Ubuntu-packages or directly
from LO?
Did you try to rename the user-config-path?
Is in your home-directory at .config/libreoffice/4

I won't get any freeze here. HW here is i3-3220 and 4 GB RAM. System
is OpenSUSE 42.1 64bit rpm Linux.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de

LibreOffice Community: http://robert.familiegrosskopf.de/map_3

Hi Robert, I don't really know from which repository I installed LO, but 
when I do "dpkg -s libreoffice" I get this:


dpkg -s libreoffice
Package: libreoffice
Status: install ok installed
Priority: optional
Section: metapackages
Installed-Size: 13
Maintainer: Ubuntu Developers 
Architecture: amd64
Version: 1:5.3.0~rc3-0ubuntu1~xenial1.1

So, I think it was from the Ubuntu tepository?.

Regarding the config path, I already checked by deleting it, but the 
problem still persists.


Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877

--
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] Slow opening documents

[Leonardo M . Ramé]

El 21/02/17 a las 16:23, Leonardo M. Ramé escribió:

El 21/02/17 a las 14:52, M Henri Day escribió:

2017-02-21 16:33 GMT+01:00 Leonardo M. Ramé mailto:l.r...@griensu.com>>:

Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening
on LO's 5.2.x.

When I open Writer or Calc documents the LO window is freezed for
about 15 seconds, then it opens the document.

Does anyone know why this is happening?.

Regards,
-- Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924  +54(351)4247788
 +54(351)4247979 int. 19

Cel.: +54 9 (011) 40871877


​Leonardo, could this be a hardware problem ? Perhaps you'd like to
tell us a bit more about the hardware on which you're running XUbuntu
and LO 5.3 ?...

Henri


No, I'm sure it's not a HW problem, this was working perfectly before
5.2. My machine is an i5 with 8gb RAM.

What I found is, while the freeze is happening the CPU works at +90%
(soffice.bin process).



More info, this only happens if I open the file from command line like 
"libreoffice myfile.odt" or by double clicking on the file browser.


If I first start libreoffice, then go to file->open it opens instantly.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877

--
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] Slow opening documents

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi Leonardo,
> 
> No, I'm sure it's not a HW problem, this was working perfectly
> before 5.2. My machine is an i5 with 8gb RAM.
> 
> What I found is, while the freeze is happening the CPU works at
> +90% (soffice.bin process).

Where did you get your LO-Version from? Ubuntu-packages or directly
from LO?
Did you try to rename the user-config-path?
Is in your home-directory at .config/libreoffice/4

I won't get any freeze here. HW here is i3-3220 and 4 GB RAM. System
is OpenSUSE 42.1 64bit rpm Linux.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYrJi+AAoJELDKYwaoS9AI15sQAIv1a7sgVpsn4MxhDmQB+UKn
d5Sh6+o5umATqqjk0WyoTO1EUDum2x/K+VkejbRYEJVKT6mH24PIxtVeNf4lBGbq
BV1GKQRkNfRQpgSG1WTV4HOrAXBWR2e9Pa9t+0ZXVZTky4EInpmRzlgHCYrkoJBD
v9cah1Z/mzj5z6f4SJKnD987pLRzKnOx4775bzTIbcP0p5IipcUiL61inYrFPTsE
xxaVO3mczKq8azjBwwFc9pNwDVUZrEYmSlwwXAZrF5namgwrqp5VG4igbYDD278g
bbq71Xr3uu/kD78n8N6xS7/w/1shlKQqBIAe1/k/m9NgdkKWWp2GgMW3C9GmzqEf
EQ+l/QDJT/22/9PYNtO6KGdLEP3++vWvyA0c4Kk+7D/BCksKVn9nies9cyA7VVga
z88nVOc6A3czSY+jUmBpXPcaa99SIciRHsMqupaUZhYbRzTy7k1kLHn37eX/hmQM
zgpXVqxS12DBRIha5bhqIu0psGo9FEzBID4GoSKezUI+W9El/i9BzIJBCVQrZMFg
hr4r6KEywMe62uZIiDIaiUGdupbkrDeMViWc6Mx+kxkAi2aiHwR+GpVuagbnbztr
kYdiONRxAWDddPP9J8CRN2Q6x3us0RU+XHV/7lNtndwZODrmG7aHm6td/2ApC5mK
s5w3DyB3k7CEMSMOmJpz
=n4db
-END PGP SIGNATURE-

-- 
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] Slow opening documents

[Leonardo M . Ramé]

El 21/02/17 a las 14:52, M Henri Day escribió:
2017-02-21 16:33 GMT+01:00 Leonardo M. Ramé >:


Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening
on LO's 5.2.x.

When I open Writer or Calc documents the LO window is freezed for
about 15 seconds, then it opens the document.

Does anyone know why this is happening?.

Regards,
-- 
Leonardo M. Ramé

Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924  +54(351)4247788
 +54(351)4247979 int. 19

Cel.: +54 9 (011) 40871877


​Leonardo, could this be a hardware problem ? Perhaps you'd like to 
tell us a bit more about the hardware on which you're running XUbuntu 
and LO 5.3 ?...


Henri


No, I'm sure it's not a HW problem, this was working perfectly before 
5.2. My machine is an i5 with 8gb RAM.


What I found is, while the freeze is happening the CPU works at +90% 
(soffice.bin process).


--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877

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

[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] Slow opening documents

[M Henri Day]

2017-02-21 16:33 GMT+01:00 Leonardo M. Ramé :

> Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening on LO's
> 5.2.x.
>
> When I open Writer or Calc documents the LO window is freezed for about 15
> seconds, then it opens the document.
>
> Does anyone know why this is happening?.
>
> Regards,
> --
> Leonardo M. Ramé
> Medical IT - Griensu S.A.
> Av. Colón 636 - Piso 8 Of. A
> X5000EPT -- Córdoba
> Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
> Cel.: +54 9 (011) 40871877


​Leonardo, could this be a hardware problem ? Perhaps you'd like to tell us
a bit more about the hardware on which you're running XUbuntu and LO 5.3
?...

Henri

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

[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

[libreoffice-users] Slow opening documents

[Leonardo M . Ramé]

Hi, I'm using LO 5.3 on XUbuntu 16.10, but this started happening on 
LO's 5.2.x.


When I open Writer or Calc documents the LO window is freezed for about 
15 seconds, then it opens the document.


Does anyone know why this is happening?.

Regards,
--
Leonardo M. Ramé
Medical IT - Griensu S.A.
Av. Colón 636 - Piso 8 Of. A
X5000EPT -- Córdoba
Tel.: +54(351)4246924 +54(351)4247788 +54(351)4247979 int. 19
Cel.: +54 9 (011) 40871877

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

[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

[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

[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

[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

[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

[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