PlanMaker ISREF: Validate references separately from their contents

The PlanMaker 2026 reference, 2024 reference and 2021 reference were retrieved and compared on October 15, 2026. They document this function’s core operation. Documented by 2021 is not an original introduction date; the first introduction and any last-working-version endpoint remain unverified. The 2026/NX manual family does not establish per-build availability in FreeOffice, mobile clients or every operating system.

The examples below are vendor-supported controls and independently modeled expectations. No native PlanMaker execution, screenshot capture or workbook interchange test was performed. Keep the distinction between documentation support and observed application behavior when applying the guide to an installed version.

=ISREF(Value)

There is one required argument and no documented optional default. Value is the candidate reference to test; the vendor explicitly includes ranges and named references in its examples. The formulas use English function names. The one-argument call needs no list separator; nested helper formulas below use commas, which may need adjustment for the installed locale.

SoftMaker explicitly documents ordinary, absolute and range references. On ReferenceControls, put any small numeric value, such as 12, in A1. Enter these formulas in D2:D7:

The first four follow the vendor’s examples directly. The two address-looking strings follow the same distinction: quoting the characters does not turn them into a worksheet reference. This is not an address parser.

The range passed in D4 includes ordinary cells, and its validity does not require every cell to be populated. It also happens to lie outside the result formulas placed in column D, avoiding an unnecessary self-reference complication. The function’s range example is explicit vendor evidence; it should not be generalized to the unrelated range behavior of other IS functions.

Change A1 from 12 to 99 in a copy. D2:D4 remain TRUE; the reference still points to a valid location. The test is not comparing A1’s content with 12.

SoftMaker gives a named-reference example: ISREF(FirstQuarter) is FALSE before that name is assigned to a range and TRUE after it identifies a range. This is a documented expectation, not an observed native name-resolution test. Use a spare workbook with no existing FirstQuarter name so you do not alter an unrelated definition.

Enter 10,20,30 in A2:A4 and 100,200,300 in B2:B4 on NamedReferenceAudit. Use your installed version’s range-naming interface to define FirstQuarter as A2:A4. In D2 enter =ISREF(FirstQuarter) and in D3 enter =SUM(FirstQuarter). Expected results are TRUE and 60.

In a copy, redefine the name to B2:B4. D2 remains TRUE, but D3 becomes 600. Both names are valid references; only one may be the intended source range. ISREF cannot detect a valid but misdirected name. Keep the intended range recorded and inspect the name definition when an aggregate changes unexpectedly.

The guide does not give a universal menu path: name-management controls can vary with version or platform. Do not remove or overwrite existing workbook names merely to recreate this exercise. The spreadsheet data and intended definitions are sufficient to reproduce the check in a clean file.

On another sheet put fixed numeric 25 in A2 and formula =5*5 in A3. Fill B2 =ISREF(A2) and C2 =ISFORMULA(A2) through row 3. Expected B is TRUE in both rows, while C is FALSE,TRUE. Both cells are valid references and display the same number, but only one contains a formula.

Replace A3 with fixed 25 in a copy. ISREF remains TRUE while ISFORMULA becomes FALSE. These distinct checks help separate reference integrity from formula preservation.

A TRUE result does not validate the value, the intended address, the completeness of a range or the meaning of a defined name. Validate those independently. Deleted references, external workbooks, dynamic reference expressions and names bound to constants rather than ranges need their own target-build checks; the examples here do not settle all such cases.

Do not interpret the vendor’s unassigned-name example as a guarantee that every malformed name or syntax error will be caught. A formula still has to be parsed successfully. ISFORMULA inspects formula presence and ISERROR checks resulting error values; their arguments and purposes are not interchangeable with this reference test.

Record the PlanMaker version/build, edition, platform, language and workbook format. Recreate the original dataset, inspect the actual formulas and then apply the specified one-cell changes on a copy. Compare the original and changed outputs, not only a screenshot of the final values. Save/reopen and cross-product import results remain separate tests; neither was performed for this guide.