avoiding recalculate on loading of Calc files

users
#1

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

#2

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

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

#3

Hello,

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

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

I'd add that this setting is document-based: you may have spreadsheets with automatic calculations set and others without.

Best Regards