CURRENT in Collabora Office: Use the Formula’s Intermediate Result

=CURRENT()

There are no arguments. The function’s value comes from its position in the surrounding calculation. The vendor’s main use case is pairing it with STYLE so a cell style can depend on the result already calculated.

In the documented numeric example, 1+2 first gives 3. CURRENT then returns that intermediate 3, which is added to the original 3, producing 6.

This is a specific evaluation-context feature. It should not be treated as a general replacement for a named intermediate expression, a cell reference, or an assumption about every possible nested expression’s evaluation order.

Enter each formula in its own cell:

The text example shows that CURRENT is not restricted to numeric results. When encountered after the text “choo”, it supplies that text again for concatenation.

The second numeric row is an independent extension of the vendor’s simple left-to-right pattern, not a native observation. Keep controls simple when investigating an unfamiliar nested formula.

Put 7 in A2 and 5 in B2. Ensure the cell styles Red and Default exist in the workbook. The source’s pattern is:

=A2+B2+STYLE(IF(CURRENT()>10;"Red";"Default"))

The independently expected numeric result is 12. At the decision point CURRENT represents the sum 12, so the documented style logic selects Red. STYLE returns zero, which leaves the numeric sum unchanged.

With inputs 4 and 5, the independent sum is 9, and the Default branch is selected. These are documentation-based numeric/style expectations, not observed style changes or screenshots.

The first example intentionally adds CURRENT to the earlier total and doubles it. In the STYLE pattern, CURRENT is inspected inside the condition, while STYLE contributes zero to the arithmetic.

Replacing the final STYLE call with +CURRENT() would change the numeric result. Keep the zero-returning style side effect distinct from the intermediate value being tested.

IF chooses the style name. SUM may express a longer numeric subtotal, but do not assume every rearrangement or nesting preserves the same CURRENT context without checking it.

Before applying the style formula, put =A2+B2 in a separate audit cell. For the 7 and 5 control it should be 12 independently. Then compare that value with the formula containing STYLE.

This separates arithmetic errors from style-name or evaluation-context issues. If the numeric values differ, investigate the formula before attributing the problem to formatting. If the numbers agree but the appearance differs, inspect whether the named styles actually exist and have distinguishable formatting.

The companion STYLE documentation recommends conditional formatting for almost all ordinary conditional-formatting needs, reserving STYLE mainly for compelling cases such as asynchronous add-in notifications. CURRENT’s support does not make this pattern the preferred design for every worksheet.

The dedicated section does not specify a full native error matrix, standalone CURRENT behavior, or every nested evaluation-order boundary. This guide limits its expectations to explicit source examples and simple extensions of the same pattern.

CURRENT is not a volatile clock, selected-cell address, or persistent previous value. The function has no memory argument or date argument. The vendor identifies namespace ORG.OPENOFFICE.CURRENT, outside OpenDocument 1.3 OpenFormula. Do not assume another product preserves its evaluation semantics merely because it can open the workbook.

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.

• Collabora Office 26.04: CURRENT (checked October 17, 2026).
• Editorial testing standards.