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).

Supported on: LibreOffice-from-Collabora 4.4 or higher

Recalculation on file load

Excel 2007 and newer:


  1. Always recalculate
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value0
  2. Never recalculate
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value1
  3. Prompt user
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value2

Final
Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode
Value NameFinal
Value TypeREG_DWORD
Default Value0
True Value1
False Value0
ODF spreadsheet (not saved by LibreOffice):


  1. Always recalculate
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value0
  2. Never recalculate
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value1
  3. Prompt user
    Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
    Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode
    Value NameValue
    Value TypeREG_SZ
    Value2

Final
Registry HiveHKEY_LOCAL_MACHINE or HKEY_CURRENT_USER
Registry PathSoftware\Policies\LibreOffice\org.openoffice.Office.Common\Formula\Load\ODFRecalcMode
Value NameFinal
Value TypeREG_DWORD
Default Value0
True Value1
False Value0

libreoffice-from-collabora.admx

Administrative Templates (Computers)

Administrative Templates (Users)