make sure this is not checked (before saving):
When re-opening, there should not be an automatic recalclulation....
On 07-02-18 13:26, Philip Jackson wrote:
Using Calc 22.214.171.124
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: firstname.lastname@example.org
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: 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