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

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