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

Using Calc

I would like a Calc file to load without recalculating so that I can
recalculate manually at a moment of my choosing.

While trying to find how to do this, I came across mention of
AutoCalculate in the on-board help files (F1) - it refers to "Tools -
Cell Contents - Autocalculate"  but this does not exist on my version of

I found Tools > Options > LibreOffice Calc > Formula which provides an
option for 'never recaculate' for ODF spreadsheets (Not saved by
LibreOffice). The corresponding entry in the F1 Help says as a tip -

 "LibreOffice saved ODF spreadsheets will honor Never recalculate and
Always recalculate options".

I have that set to Never recalculate but it is not honoured by Calc.

Any suggestions for preventing recalc on load will be much appreciated.


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.