Recalculation of spreadsheets on load
Explanation
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).
Registry
HKEY_LOCAL_MACHINE\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcModeHKEY_CURRENT_USER\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode- Value name
- not defined in the ADMX
Enable / disable values: not defined in the ADMX (see the options below).
PowerShell
PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.
Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.
Computer (HKLM)
Enable
# Enable: Collabora-Office/RecalcMode
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Excel 2007 and newer
# Possible options:
# Always recalculate = 0
# Never recalculate = 1
# Prompt user = 2
Set-ItemProperty -Path $k -Name 'Value' -Value '1' -Type String
# Final
# value not defined in the ADMX (the GPO editor usually writes 1/0)
# 1 = checked, 0 = unchecked; default state taken from the ADML
Set-ItemProperty -Path $k -Name 'Final' -Value 1 -Type DWord
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# ODF spreadsheet (not saved by LibreOffice)
# Possible options:
# Always recalculate = 0
# Never recalculate = 1
# Prompt user = 2
Set-ItemProperty -Path $k -Name 'Value' -Value '1' -Type String
# Final
Set-ItemProperty -Path $k -Name 'Final' -Value 1 -Type DWord # value not defined in the ADMX; 1 = checked, 0 = uncheckedDisable
# Disable: Collabora-Office/RecalcMode
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": Collabora-Office/RecalcMode
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\OOXMLRecalcMode'
Remove-ItemProperty -Path $k -Name 'Value' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'Final' -ErrorAction SilentlyContinue
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode'
Remove-ItemProperty -Path $k -Name 'Value' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'Final' -ErrorAction SilentlyContinueUser (HKCU)
Enable
Disable
Revert to "Not configured"
Options (4)
| Label | Control | Registry value | REG type | Constraints / details | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Excel 2007 and newer:OOXMLValue | Drop-down listenum | Value | REG_SZ | Default choice (UI): #1
| ||||||||
| FinalOOXMLFinal | Check boxboolean | Final | REG_DWORD | Checked: implicit: 1Unchecked: implicit: 0 | ||||||||
| ODF spreadsheet (not saved by LibreOffice):ODFValue | Drop-down listenum | Valuein Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode | REG_SZ | Default choice (UI): #1
| ||||||||
| FinalODFFinal | Check boxboolean | Finalin Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcMode | REG_DWORD | Checked: implicit: 1Unchecked: implicit: 0 |
Application
Collabora Office / LibreOffice (Collabora) — November 2026 templates
Official templates downloaded on November 12, 2026.