PROPER in Collabora Office: Capitalize Simple Word Labels with a Reviewable Cleanup Policy

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: online and mobile deployments are not inferred from desktop documentation.
• Checked: October 14, 2026. Direct function documentation and independently modeled text controls; no native Collabora test was performed.

=PROPER(text)

The argument is text or a reference to a text cell. Collabora’s direct page demonstrates ordinary words separated by spaces. These examples likewise use lowercase Latin words with ordinary spaces, avoiding unsupported assumptions about apostrophes, hyphens, digit boundaries or locale-specific casing.

The short definition does not give a complete rule for already-uppercase interior letters. This guide therefore does not certify that every mixed-case acronym or brand will survive unchanged, or that a particular punctuation mark always starts a new word.

Enter north region, south warehouse, quality review and support team in A2:A5. In B2 enter and fill down:

=PROPER(A2)

Expected labels: North Region, South Warehouse, Quality Review, Support Team. Keep A2:A5 as the source values. The output column provides a display variant without silently changing the stored source descriptions.

These are text labels, not unique keys. Two records can have the same display label for legitimate reasons, and capitalization does not establish that they refer to the same entity.

For the source north team, expected outputs are:

• =PROPER("north team"): North Team.
• =UPPER("north team"): NORTH TEAM.
• =LOWER("north team"): north team.

Choose the desired presentation before applying a transformation across a workbook. UPPER and LOWER express different policies; a professional title or brand may need a manually maintained display value instead.

Use the following text inputs in D2:E4. Each empty override is an explicit ="" formula, not an unspecified imported blank.

In F2 enter and fill down:

=IF(EXACT(E2;"");PROPER(D2);E2)

Expected outputs: North Region, API Support, Quality Review. Without the override, the all-lowercase second source would produce Api Support. The override preserves the intentional acronym while the simple labels use the automatic rule.

EXACT compares the explicit text values, and IF selects the chosen presentation. This controlled example does not establish a full blank/error-coercion matrix for arbitrary override cells.

For quality review, both the source and expected Quality Review have length 14. The selected ASCII case conversion changes letters without adding characters in this control. This is not a universal promise for all scripts or case mappings.

Use a separate status such as =IF(EXACT(A2;B2);"Unchanged";"Review display") to expose a difference rather than overwriting the source. The lowercase first example is expected to produce Review display.

PROPER cannot know how a person spells a name, whether a short word should remain lowercase in a title, or which organizational abbreviations require capitals. A mechanically consistent output can still be editorially wrong. Keep an override path and check representative real labels before adopting the rule.

The examples do not claim punctuation-boundary, multilingual, maximum-length or native-client testing. Use the ordinary-word controls as a reproducible starting point and maintain authoritative names separately.

• Collabora Office 26.04: PROPER.
• Editorial testing standards.

The dedicated Collabora function page was reviewed. Expected outputs are independently modeled text controls, not captured results from the application. Extended-character, coercion and deployment-specific behavior retain the limits stated above.