Open in the explorer

Recalculation of spreadsheets on load

Type
Computer and user
GPO path
Computer Configuration › Policies › Administrative Templates › Collabora Office › Calc › Formulas User Configuration › Policies › Administrative Templates › Collabora Office › Calc › Formulas
Supported on
LibreOffice-from-Collabora 4.4 or higher
ADMX file
Collabora-Office.admx
Internal name
Collabora-Office/RecalcMode

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\OOXMLRecalcMode
HKEY_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 = unchecked

Disable

# 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 SilentlyContinue

User (HKCU)

Enable

Disable

Revert to "Not configured"

Options (4)

LabelControlRegistry valueREG typeConstraints / details
Excel 2007 and newer:OOXMLValueDrop-down listenumValueREG_SZ
Default choice (UI): #1
LabelValue
Always recalculateREG_SZ = 0
Never recalculateREG_SZ = 1
Prompt userREG_SZ = 2
FinalOOXMLFinalCheck boxbooleanFinalREG_DWORD
Checked: implicit: 1
Unchecked: implicit: 0
ODF spreadsheet (not saved by LibreOffice):ODFValueDrop-down listenumValuein Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcModeREG_SZ
Default choice (UI): #1
LabelValue
Always recalculateREG_SZ = 0
Never recalculateREG_SZ = 1
Prompt userREG_SZ = 2
FinalODFFinalCheck boxbooleanFinalin Software\Policies\LibreOffice\org.openoffice.Office.Calc\Formula\Load\ODFRecalcModeREG_DWORD
Checked: implicit: 1
Unchecked: implicit: 0

Application

Collabora Office / LibreOffice (Collabora) — November 2026 templates

Official templates downloaded on November 12, 2026.