Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

-----Original Message-----
From: jorge <jrodriguez17@cpcecr.com>
To: jim@lang.hm
Cc: users@global.libreoffice.org
Sent: Mon, 23 Nov 2015 7:50
Subject: Re: [libreoffice-users] Calc 5.0.3.2 AutoCalculate

Hi:

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 4.4.6.3 _and_ in the Linux 
version of LO 5.0.3.2. -- 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

-- 
Jim

El dom, 22-11-2015 a las 23:32 -0800, James E Lang escribió:
> This same behavior exists in 4.4.6.3 (Windows)
>
> Also in both cases my Conditional formatting gets turned off when I turn off AutoCalculate. 
> Unexpected behavior.
>
> -- 
> Jim
>
> -----Original Message-----
> From: "James E. Lang" <jim+lou@lang.hm>
> To: LibreOffice Users <users@global.libreoffice.org>
> Sent: Sun, 22 Nov 2015 22:26
> Subject: [libreoffice-users] Calc 5.0.3.2 AutoCalculate
>
> LO 5.0.3.2 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.
>
> -- 
> Jim


-- 
Jim
-- 
To unsubscribe e-mail to: users+unsubscribe@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