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


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

Context


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.