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+unsubscr...@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