ISREF in Collabora Office: References Versus Values and Address Text
Use Collabora ISREF to distinguish an actual cell reference from text or a calculated value, without confusing reference validity with cell content.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: ISREF(value) tests whether its argument is a reference. The Collabora help explicitly states that it does not inspect the value stored at a referenced cell. A reference to an empty, textual or erroneous cell can therefore still be a reference.
Availability and version history
- 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.
Syntax and first controls
=ISREF(A2)
=ISREF("A2")
=ISREF(4)
Expected results are TRUE, FALSE and FALSE. A2 is an actual worksheet reference; the quoted characters A2 are text that looks like an address. The number 4 is a value, not an address.
Examples use English function names and semicolons in multiargument formulas. The controls are documentation-based independent expectations, not native application results.
Example 1: keep reference identity separate from contents
Prepare these cells, then evaluate =ISREF(A2) and fill down alongside them:
| Referenced cell | Content entered | Expected ISREF |
|---|---|---|
| A2 | 4 |
TRUE |
| A3 | ="Ready" |
TRUE |
| A4 | Genuinely empty | TRUE |
| A5 | =NA() |
TRUE |
| A6 | =FALSE() |
TRUE |
The referenced contents differ, but each formula still supplies a valid cell reference. The #N/A in A5 does not turn the address A5 into an ordinary value argument for this particular test.
A TRUE flag is therefore not a certification that the cell holds a usable quantity, contains a formula or has no errors. Those are separate questions.
Example 2: compare the reference with an arithmetic result
With numeric 4 in A2:
=ISREF(A2)
=ISREF(A2+0)
=ISREF(A2*2)
Expected results are TRUE, FALSE and FALSE. The latter two expressions calculate numbers 4 and 8. A calculation that happens to read a cell does not make its numeric result a reference.
This distinction helps diagnose a helper expression passed to a function that specifically needs a reference. Inspect what the expression returns, rather than merely whether a cell address appears somewhere inside it.
Advanced example: explicit address text and INDIRECT
Put the text A2 in D2, with numeric 4 still in A2:
=ISREF(D2)
=ISREF("A2")
=ISREF(INDIRECT("A2"))
Expected results are TRUE, FALSE and TRUE. D2 itself is a reference even though it contains text. The literal text A2 is not a reference. The official ISREF section explicitly identifies INDIRECT as a function that returns a reference, so the final expression supplies one.
This example uses a valid address in the shown notation. It does not certify what every malformed, external, deleted or differently notated address string will do. Converting arbitrary text with INDIRECT needs its own validation.
Advanced example: choose a diagnostic that fits the question
For the five cells A2:A6, the reference flags all remain TRUE. For the single numeric control A2:
=ISREF(A2)asks whether the argument is a reference.=ISNUMBER(A2)asks whether the referenced content is numeric.=ISFORMULA(A2)asks whether the cell contains a formula.
Expected flags for a directly entered numeric 4 are TRUE, TRUE and FALSE. Replace A2 with =2+2: the first two remain TRUE, while the formula-presence flag becomes TRUE.
The displayed result can stay 4 even though the cell’s construction changed. No single predicate answers all three questions.
Advanced check: a total is a value
Enter numeric 4 in H2 and 6 in H3. =SUM(H2:H3) has expected result 10, and =ISREF(SUM(H2:H3)) has expected result FALSE.
Compare =ISREF(H2), which remains TRUE. The range consumed by SUM is a reference, but its ordinary numeric total is a calculated value. This guide does not generalize that rule to every function: some functions, including the documented INDIRECT example, return references instead.
Limits and source cautions
The official section also uses ADDRESS to illustrate address text, but the argument layout in its printed example is ambiguous. The controls here use an explicit quoted address instead, without certifying that particular ADDRESS call.
These examples are valid scalar cell references. Invalid-reference error propagation, every range/array context and all external-link syntax remain unverified. Use ISNUMBER, ISERROR or ISFORMULA when the question concerns content, error state or formula presence rather than reference identity.
References and verification
The complete function section was reviewed. Worked controls are independently checked expectations; native execution, broader client support and unlisted edge cases remain unverified.