+ session of Calc: everything scares frightfully.

users
#1

users@global.libreoffice.org

I have the following problem.
When launching more Libreoffice scales at the same time, everything
scares frightfully.

I use linux and then paste my software versions.

Greetings
Paolo

#2

Paolo, Regarding your problem, please provide more information.

#3

Try to explain me better. If I open two or three sheets of calc at the
same time, everything slows down

#4

Try to explain me better.

If I open two or three sheets of calc at the same time, everything slows down

Paolo

#5

Just a few general comments:

LibreOffice is a relative large desktop application so if you have a low
resource computer (old or very low cost) performance will be slower with
more open worksheets.

Performance is affected by the "size" of each worksheet. "Size" somewhat
difficult to measure but more cells used, more formulas used and more
formatting used affect performance.

I have a few large worksheets for which I uncheck "Menu > Data >
AutoCalculate". I must then press F9 to update the formulas.

Several times on this mailing list people have reported slow performance
related to cell formatting. Some worksheets converted from Excel include
formatting "baggage" which can slow performance. Sometimes I rebuild these
worksheets in LibreOffice to leave this "baggage" behind.

#6

By "rebuild" I mean that the worksheet is manually recreated starting with
a blank worksheet. As much as practical enter again formulas. Data can be
copied from the original worksheet but use "Edit > Paste Special as Text,
Numbers or Date & time". Add needed formatting to the new worksheet (do
not copy formatting from the old worksheet). There is no guarantee this
will solve the problem. Consider this to be a test. Be happy if this
works!

#7

Hi.
What version of Libreoffice do you have, also how much RAM in your PC.
Steve

#8

There are some memory consumption bugs with LO but it might take some time to notice it with 14GB RAM.
I have 32GB and it is usually a few weeks before I start noticing.

There is this older thread similar. http://nabble.documentfoundation.org/Slow-response-time-with-Calc-td4202227.html
You could try updateing to LO 5.2....
steve

#9

Exact. The thread that you have shown shows just a case like mine. So
I think the problem is in Ubuntu Mate
Thank you
Paolo

#10

use to install Linux Mint MATE to my customers.

To install LibreOffice's official PPA follow this link, please.
https://wiki.ubuntu-it.org/Ufficio/LibreOffice

Just below: "Utilizzare versioni più recenti"

Cheers.