FORMULA in Collabora Office: Formula Text, Cell Definitions and Inspection Reports

• 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: support in every online or mobile deployment is not inferred from desktop documentation.
• Checked: October 14, 2026. Complete function-specific documentation and independent controls; no native Collabora test was performed.

=FORMULA(A8)

If A8 contains =SUM(1;2;3), the documented expected returned text is =SUM(1;2;3), while A8’s numeric result is 6. Keep the definition and the value in separate columns when inspecting a calculation.

Examples use English function names and semicolon separators. Formula-text display can depend on stored syntax and the client’s language settings; this guide does not promise identical capitalization, spacing or localized names for every imported workbook.

Enter these formulas in A2:A4, then put =FORMULA(A2) in B2 and fill down:

The expected B-column content describes each expression as text. It is not an independent recalculation that turns a text string into a new executable formula.

A report that records only the values 4, 6 and 30 cannot reveal which operations generated them. Formula text supplies another useful inspection layer, while still requiring interpretation.

Enter numeric 4 in D2 and =2+2 in D3. Both display 4, but:

=FORMULA(D2)
=FORMULA(D3)

The documented-model expectations are #N/A for D2 and the formula text =2+2 for D3. A matching numeric result does not establish that a formula exists.

Literal formula-like text is also different. Entering '=2+2 as text does not create the formula that those characters resemble. A reference to that text-only cell is a reference to a cell with no formula.

ISFORMULA identifies whether a valid cell contains a formula. On the D2:D3 controls, its flags are FALSE and TRUE.

A presentation pattern is:

=IF(ISFORMULA(D2);FORMULA(D2);"No formula")

The intended selected label for the constant is No formula; the formula cell supplies its definition. This model follows the documented selection rules without asserting a universal lazy-evaluation guarantee for every possible failing expression.

Keeping the original cells and the presence flag beside the text makes the report easier to interpret than replacing every #N/A with an unexplained blank.

Put numeric 2 in F2 and 10 in G2. With =F2*G2 in H2, the numeric result is 20 and the definition being inspected contains multiplication.

Change H2 to =F2+G2: its result becomes 12, and FORMULA identifies the addition expression instead. ISFORMULA remains TRUE in both cases, so formula presence alone would not explain the change.

If H2 were overwritten with the constant 20, FORMULA would have no formula definition to return even though the old displayed value had been restored. The distinction is useful when checking calculation columns that should retain formulas.

The Collabora reference states that FORMULA is recalculated whenever a recalculation occurs. A cell containing FORMULA is therefore an inspection formula, not an immutable historical snapshot of a workbook’s earlier definition.

If the underlying formula changes and the inspection recalculates, the displayed text can change too. Record a fixed snapshot through the chosen audit workflow when the goal is to preserve what was present at a particular time. This guide does not certify revision history, authorship or event timestamps.

The source explicitly documents #N/A for no-formula and invalid-reference cases. It does not establish an Excel-specific formula-length limit, protected-workbook rule or a complete array/external-reference matrix, so those are not imported here.

A text string containing an equals sign is not automatically executed by FORMULA. The function reads a definition from a referenced formula cell. Use ISREF for the reference question, ISFORMULA for presence and ISERROR for a calculated error result.

Expected definitions and numeric controls here were independently checked. No native Collabora execution or cross-language formula-normalization test was performed.

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

The complete function section was reviewed. Worked controls are independently checked expectations; native execution, broader client support and unlisted edge cases remain unverified.