Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index


        Excuse me because my words about memory weren't clear. I try to


(I'm not sure but it would be)


Jorge Rodríguez

El lun, 23-11-2015 a las 10:50 -0800, James E. Lang escribió:

-----Original Message-----
From: jorge <>
Sent: Mon, 23 Nov 2015 7:50
Subject: Re: [libreoffice-users] Calc AutoCalculate


I've had this kind of problem before. As I understand it is because
the spreadsheet has a lot of formulas into it. Then when you enter a
new value or formula to be calculate, it recalculate all formulas
again of the spreadsheet that you are using.

I only can solve with uncheck autocalculate 

[Thank you Jorge but that's exactly what I reported trying in my
original message. It still takes the same four minutes after I enter
or revise a single value before it lets me do anything more _and_ the
hiding of conditional formatting when AutoCalculate is unchecked is
another _unexpected_and_undesirable_ behavior. Can anybody else
contribute a solution to my problem? -- jl]

and continue working entering new data and when I have enough new
information, run autocalculate to update and review it.

[Actually I intended to use F9 for this but maybe that's what you
mean. -- jl]

I don't know if increase the memory improve the result of

[I remember recently seeing someone suggesting a memory tweak but I
don't recall what to try in that regard. The Linux version is running
on a laptop computer with a solid state disk drive and without
crowding memory. According to top,

KiB Mem: 3072748 total, 2961416 used, 111332 free, 540732 buffers
KiB Swap: 7817776 total, 321948 used, 7495828 free, 571112 cached Men

and for soffice.bin top reports

VIRT 1599776 RES 385276 SHR 76000 %CPU 99.9 %MEM 12.5

With AutoCalculate unchecked I reentered the value 2.2 in cell AI1289
and top recorded 3 minutes 59 seconds of CPU time consumed by
soffice.bin before that process returned to an idle state.

My point is that AutoCalculate should not even be taking place since I
unchecked it but it obviously is. 

Once again, I am experiencing this issue in the Windows version of LO _and_ in the Linux version of LO -- jl]

I think that I had this problem before with different spreadsheet
package from different office suites.

Regards, and hope this help,

[Again I thank you for trying. Your suggestion obviously worked for
you but it's not working for me. -- jl]

Jorge Rodríguez


El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió:
This same behavior exists in (Windows)

Also in both cases my Conditional formatting gets turned off when I
turn off AutoCalculate. Unexpected behavior.


-----Original Message-----
From: "James E. Lang" <>
To: LibreOffice Users <>
Sent: Sun, 22 Nov 2015 22:26
Subject: [libreoffice-users] Calc AutoCalculate

LO Calc (Linux)

I turned AutoCalculate off (Alt+T, N, C) but LO takes the same four
minutes (plus or minus five seconds) to process a changed value in one
cell as it took with AutoCalculate turned on. Does that make sense? If
so, is there any other way to accelerate the entry or alteration of
raw data?

FWIW the spreadsheet has ~3,000 rows on each of two sheets and a
total of ~300,000 formulas.




Jorge Rodríguez

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.