Automatically find column and row labels
Explanation
Specifies whether column and row labels are used to refer to the column area beneath the text cell or to the row area at the right of the text cell while running a search.
Registry
HKEY_LOCAL_MACHINE\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Calculate\Other\FindLabelHKEY_CURRENT_USER\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Calculate\Other\FindLabel- 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/FindLabel
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Calculate\Other\FindLabel'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Automatically find column and row labels
# unchecked: false
Set-ItemProperty -Path $k -Name 'Value' -Value 'true' -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 DWordDisable
# Disable: Collabora-Office/FindLabel
# No value is written in the "Disabled" state (nothing defined in the ADMX)Revert to "Not configured"
# Revert to "Not configured": Collabora-Office/FindLabel
$k = 'HKLM:\Software\Policies\LibreOffice\org.openoffice.Office.Calc\Calculate\Other\FindLabel'
Remove-ItemProperty -Path $k -Name 'Value' -ErrorAction SilentlyContinue
Remove-ItemProperty -Path $k -Name 'Final' -ErrorAction SilentlyContinueUser (HKCU)
Enable
Disable
Revert to "Not configured"
Options (2)
| Label | Control | Registry value | REG type | Constraints / details |
|---|---|---|---|---|
| Automatically find column and row labelsValue | Check boxboolean | Value | REG_SZ | Checked: REG_SZ = trueUnchecked: REG_SZ = false |
| FinalFinal | Check boxboolean | Final | REG_DWORD | Checked: implicit: 1Unchecked: implicit: 0 |
Application
Collabora Office / LibreOffice (Collabora) — November 2026 templates
Official templates downloaded on November 12, 2026.