Open in the explorer

User interface of Calc

Type
Computer and user
GPO path
Computer Configuration › Policies › Administrative Templates › Collabora Office › Common › User Interface User Configuration › Policies › Administrative Templates › Collabora Office › Common › User Interface
Supported on
Collabora Office 21.06 or higher
ADMX file
Collabora-Office.admx
Internal name
Collabora-Office/ToolbarModeCalc

Explanation

Selects the toolbar layout the application starts with. This is the same setting the user can change in View - User Interface.

The policy supplies the value for users who have not picked a user interface themselves. A user who changes the user interface later keeps that choice, because the setting stored in the user profile takes precedence over the policy.

Only the Standard Toolbar and the notebookbar based layouts can be applied this way. Single Toolbar and Sidebar are not offered, because their toolbar and sidebar arrangement is only built when the user switches to them from within the application.

The notebookbar based layouts only take effect in Collabora Office Classic and LibreOffice. Collabora Office only has the Standard Toolbar.

Registry

HKEY_LOCAL_MACHINE\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\Applications\Calc/#fuse\Active
HKEY_CURRENT_USER\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\Applications\Calc/#fuse\Active
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/ToolbarModeCalc
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\Applications\Calc/#fuse\Active'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# User interface
# Possible options:
#   Standard Toolbar = Default (+ Value=Default)
#   Tabbed = notebookbar.ui (+ Value=notebookbar.ui)
#   Tabbed Compact = notebookbar_compact.ui (+ Value=notebookbar_compact.ui)
#   Groupedbar Compact = notebookbar_groupedbar_compact.ui (+ Value=notebookbar_groupedbar_compact.ui)
Set-ItemProperty -Path $k -Name 'Value' -Value 'Default' -Type String
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'Value' -Value 'Default' -Type String

Disable

# Disable: Collabora-Office/ToolbarModeCalc
# No value is written in the "Disabled" state (nothing defined in the ADMX)

Revert to "Not configured"

# Revert to "Not configured": Collabora-Office/ToolbarModeCalc
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\Applications\Calc/#fuse\Active'
Remove-ItemProperty -Path $k -Name 'Value' -ErrorAction SilentlyContinue
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc'
Remove-ItemProperty -Path $k -Name 'Value' -ErrorAction SilentlyContinue

User (HKCU)

Enable

Disable

Revert to "Not configured"

Options (1)

LabelControlRegistry valueREG typeConstraints / details
User interface:ValueDrop-down listenumValueREG_SZ
Default choice (UI): #0
LabelValue
Standard ToolbarREG_SZ = Default
Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc › Value : REG_SZ = Default
TabbedREG_SZ = notebookbar.ui
Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc › Value : REG_SZ = notebookbar.ui
Tabbed CompactREG_SZ = notebookbar_compact.ui
Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc › Value : REG_SZ = notebookbar_compact.ui
Groupedbar CompactREG_SZ = notebookbar_groupedbar_compact.ui
Software\Policies\LibreOffice\org.openoffice.Office.UI.ToolbarMode\ActiveCalc › Value : REG_SZ = notebookbar_groupedbar_compact.ui

Application

Collabora Office / LibreOffice (Collabora) — November 2026 templates

Official templates downloaded on November 12, 2026.