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" <[email protected]>
> To: LibreOffice Users <[email protected]>
> 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: [email protected]
> 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: [email protected]
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
