STYLE in Collabora Office: Apply a Named Cell Style from a Formula
Understand Collabora STYLE’s zero return, optional timed reset, and documented CURRENT pattern while preserving the recommendation to prefer conditional formatting.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =10+STYLE("Good";60;"Neutral") keeps numeric value 10, applies the named Good style, and is documented to change to Neutral after 60 seconds. The named styles must be available in the workbook for a meaningful visual check.
When to use this function
Collabora explicitly discourages STYLE without a compelling reason. Its intended purpose is visual notification for asynchronous add-in results; conditional formatting is preferable in almost all other cases. This guide explains existing formulas and controlled examples rather than recommending STYLE as the default formatting method.
STYLE changes the cell containing the formula. It does not return a color value or edit a different referenced cell’s format.
Syntax and defaults
=STYLE("Style" [; Time [; "Style2"]])
Style is the required cell-style name. Literal names must be quoted, and the vendor says names are not case-sensitive. Time is an optional delay in seconds. After the delay, Style2 is applied; if Style2 is omitted, the documented fallback is Default.
Omit the timing arguments when no timed change is wanted. The page also gives general guidance against leaving an optional middle position empty while supplying a later argument, so the worked timed formula supplies all three positions explicitly.
STYLE always returns numeric 0. Adding that zero to a numeric calculation preserves the calculation’s value while applying a formatting side effect.
Example: a timed style change
Ensure styles Good and Neutral exist and have visibly different formatting, then enter:
=10+STYLE("Good";60;"Neutral")
The documented numeric result is 10. The documented visual sequence is Good, then Neutral after 60 seconds. No native timing or visual test was performed for this guide; these are the source’s expectations.
Use =10+STYLE("Good") for a control without the explicit timed transition. If you want to test your actual installation, record the formula, styles, application version, and observed times rather than substituting a generated illustration for evidence.
Example: style a calculated value with CURRENT
Put 8 in A1 and 15 in A2. The source pattern, using semicolon separators, is:
=A1*A2+STYLE(IF(CURRENT()<100;"Bad";"Good"))
The independent numeric product is 120, so the documented logic selects Good. With inputs 8 and 10, the product is 80 and the Bad branch is selected. At exactly 100, the <100 condition is false, so Good is selected.
CURRENT supplies the value calculated so far; STYLE contributes zero. IF selects a name, not a numeric value to add to the product.
Advanced example: style a text result without appending zero
The vendor supplies:
="Total"&T(STYLE("Result"))
The documented text result is Total, with the Result style applied. T prevents the numeric zero returned by STYLE from being appended to the text.
Without that conversion step, combining text with a numeric return can change the displayed label. T is a related text-type function; keep the zero-returning side effect separate from the intended visible string.
Advanced audit: verify value and appearance independently
For the 8×15 control, place an ordinary =A1*A2 formula in another cell. Both numeric values should independently be 120, even though their appearances may differ. Check the arithmetic first, then the existence and formatting of the style names.
A style can change number formatting, so the same stored value may display with different decimals, currency symbols, or colors. An appearance change is not evidence that the underlying numeric calculation changed.
Do not use color alone as the sole record of a critical status. Keep an explicit status label or data value so a printed, exported, or differently styled workbook remains interpretable.
Errors and compatibility limits
The dedicated section does not enumerate every missing-style, invalid-delay, recalculation-timing, or native error outcome. It does not certify asynchronous add-in availability in a particular deployment. These cases require an actual target-version check.
The vendor identifies STYLE as outside OpenDocument 1.3 OpenFormula, with namespace ORG.OPENOFFICE.STYLE. A workbook round trip through another program may not preserve this side effect, and the documentation does not establish Collabora Online or mobile behavior. The examples remain documentation-based controls, with no fabricated screenshot or application execution.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help, retrieved and reviewed on October 17, 2026. This establishes a documentation scope, not the first release that introduced the function or the last version in which it works; those versions and any retirement date remain unestablished. Collabora Online and mobile support are not inferred from desktop help, nor is behavior in another spreadsheet product.
The examples are documentation-based expectations with independent calculations. They have not been executed in Collabora Office. No application screenshot or native error/coercion certification is implied. Formulas use English function names and semicolon argument separators.
References
- Collabora Office 26.04: STYLE (checked October 17, 2026).
- Editorial testing standards.