Recalculation of spreadsheets on load

Specifies whether to force a hard recalculation of formula cells after load of non-LibreOffice-generated ODF documents and/or OOXML-based Excel documents (2007 and newer).

Recalculation on file load

Excel 2007 and newer:

0. Always recalculate
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	0

1. Never recalculate
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	1

2. Prompt user
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	2

Final

Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
Value Name	Final
Value Type	REG_SZ
Default Value	0
True Value	1
False Value	0

ODF spreadsheet (not saved by LibreOffice):

0. Always recalculate
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	0

1. Never recalculate
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	1

2. Prompt user
   

   Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
   Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
   Value Name	Value
   Value Type	REG_SZ
   Value	2

Final

Registry Hive	HKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
Registry Path	Software\Policies\LibreOffice\org.openoffice.Office.Common\Formula\Load\ODFRecalcMode
Value Name	Final
Value Type	REG_SZ
Default Value	0
True Value	1
False Value	0