ISREF Function (Gnumeric)

ISREF distinguishes an actual cell or range reference from an ordinary evaluated value such as a number or text. A reference remains a reference even when the referenced cell contains a number, text, or nothing. Gnumeric documents this function as Excel-compatible. R1

=ISREF(value)

value (required) is the expression to check for reference-ness. In the checksum-verified Gnumeric 1.12.62 source implementation the callback explicitly requires exactly one argument. There are no optional arguments or defaults in that implementation. The published Gnumeric Information manual shows the synopsis ISREF(value,…), suggesting variadic input; however, the same source’s evaluator returns an invalid-number-of-arguments error when given anything other than one. For this review guide, use a single argument and retain this source-versus-manual discrepancy as an open native-validation item. We have not run the executable to resolve its displayed error message. R1

Validation limits: Examples are independently reasoned expectations from official documentation and checksum-verified release source. Native Gnumeric execution and screenshots were not performed.

Version and locale scope: Written against the official Gnumeric 1.12 Information manual, the public Gnumeric function catalogue and the GNOME-maintained source consulted on 2026-10-12. Gnumeric 1.12.62 is the current series release identified. Actual plugin/build availability and any localization effects must be confirmed in the reader’s installation. These guides use English names and Gnumeric’s manual convention of a leading = and comma-separated arguments. A single-argument function has no delimiter ambiguity; nested IF examples use commas and might need locale-appropriate adjustment. R1R4

1. Put the literal number 34 into A2 and plain text Widget into A3; leave A4 empty.
2. Enter each separate formula exactly as written in B2:B8. B cells are independent tests, not formulas to fill from one master row.
3. The results listed here are expected from the source’s reference-type evaluation, not observed in Gnumeric.

In Gnumeric’s source the function asks the evaluator for a reference (GNM_EXPR_EVAL_WANT_REF) and checks whether the result is a cell range (VALUE_IS_CELLRANGE). Thus the distinction here concerns an expression’s reference type, not the content type of A2. Precise results still require confirmation on a locally installed 1.12.62 build. R6

Label references versus constants while exploring a formula

=IF(ISREF(A2),"Reference","Value")

Expected: Reference even though A2 holds the number 34. Contrast =IF(ISREF(34),"Reference","Value"), expected: Value. This is a compact demonstration of reference identity versus value identity. R1R6

Inspect a range without requiring the cells to be populated

=ISREF(A2:A4) is expected TRUE although A4 is empty. This does not tell you that the range is populated, nor that numeric values are valid. For those questions, use an appropriate content test such as ISBLANK or ISNUMBER on individual cells. R1

Multi-argument trap

=ISREF(A2,A3) is not a supported two-argument example in the inspected GNOME source. The callback checks argc != 1 and constructs an argument-count error. The official manual’s value,… notation is in tension with this implementation. Do not claim a specific localized error string until native evaluation confirms it. R1

• Why does ISREF(A2) return TRUE for 34? The input is the reference A2, not the literal number stored there. R1
• Why does "A2" return FALSE? Quoted text is a string, not a reference. To construct a reference from text, a separate INDIRECT operation may be relevant, but its composed behavior is not native-validated here. R2
• Why is A2+1 FALSE? Arithmetic returns a number, losing the original expression’s reference identity. R6
• Why does a second argument fail? The source’s explicit one-argument count check conflicts with the variadic manual synopsis; treat this as a version-specific verification hold. R1
• Broken/cross-file references: behavior may involve evaluator errors and workbook availability. This draft does not assert outcomes for invalid external references without a native reproducible test.
• Locale: in a direct one-argument ISREF, no separator is needed; nested IF formulas use English manual comma notation. R4

The Gnumeric manual states that ISREF is Excel-compatible, and the catalogue labels its implementation Complete / Basic project testing. The one-argument behavior above is additionally inspected in GNOME source, not executed. Microsoft’s Excel reference separately lists ISREF; that does not confirm exact error outcomes or complex-reference compatibility across versions. R1R6

ISFORMULA · ISBLANK · ISNUMBER · INDIRECT · IF.

Primary source verification: Gnumeric 1.12.62 official archive was checked against GNOME’s SHA-256 checksum; the relevant callback was inspected without compilation or execution.

Checked: 2026-10-12 UTC. These official references support the specific claims above:

• R1 Gnumeric Information functions — official function definitions, signatures, argument descriptions and compatibility notes.
• R2 Gnumeric cells, formulas, references and errors — formula input, Boolean versus text values, cell references and error interpretation.
• R3 Gnumeric public function catalogue — registration, implementation and project test-suite classification; catalogue totals are not the version-pinned 1.12.62 release registry.
• R4 Gnumeric locales — operating-system locale and formatting context.
• R5 Gnumeric 1.12.62 release announcement — current version context; this does not prove execution of these examples on every build.
• R6 Official Gnumeric 1.12.62 source archive — checksum-verified plugins/fn-info/functions.c inspected on 2026-10-13; source-level evidence, not native execution.
• R7 Microsoft’s Excel Information function reference — Excel’s separately documented availability, not a substitute for testing Gnumeric.

Validation: Official manuals and checksum-verified Gnumeric 1.12.62 source inspected; example logic and arithmetic independently checked. No native Gnumeric execution, screenshots, locale regression or workbook round-trip tests were performed.