Re: [libreoffice-users] avoiding recalculate on loading of Calc files

make sure this is not checked  (before saving):
Data/Calculate/AutoCalculate

When re-opening, there should not be an automatic  recalclulation....

On 07-02-18 13:26, Philip Jackson wrote:
> Using Calc 5.1.6.2
>
> 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
> Calc.
>
> 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.
>
> Philip


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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