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 recalcule all formulas again of the
spredsheet that you are using.

        I only can solve with uncheck autocalculate and continue working
entering new data and when I have enough new information, run
autocalculate to update and review it.

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

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

Regards, and hope this help,

Jorge Rodríguez



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

-- 
Atentamente,

Jorge Rodríguez


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