From: jorge <firstname.lastname@example.org>
Sent: Mon, 23 Nov 2015 7:50
Subject: Re: [libreoffice-users] Calc 184.108.40.206 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
Once again, I am experiencing this issue in the Windows version of LO 220.127.116.11 _and_ in the Linux
version of LO 18.104.22.168. -- 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]
El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió:
This same behavior exists in 22.214.171.124 (Windows)
Also in both cases my Conditional formatting gets turned off when I turn off AutoCalculate.
From: "James E. Lang" <email@example.com>
To: LibreOffice Users <firstname.lastname@example.org>
Sent: Sun, 22 Nov 2015 22:26
Subject: [libreoffice-users] Calc 126.96.36.199 AutoCalculate
LO 188.8.131.52 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: email@example.com
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
Impressum (Legal Info)
: 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