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

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

[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 

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.


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.