Documentation/Calc Functions/ISREF

From The Document Foundation Wiki
Jump to navigation Jump to search
This page contains changes which are not marked for translation.
Other languages:
English • ‎Nederlands



Function name:

ISREF

Category:

Information

Summary:

Determines whether the supplied argument is a reference or reference list.

Syntax:

ISREF(Value)

Returns:

Returns TRUE if the argument is a reference or reference list and FALSE otherwise.

Arguments:

Value is the value to be tested to determine whether it is a reference.

Additional details:

  • ISREF does not examine the contents of any cells that are referenced.

Examples:

Formula Description Returns
=ISREF(C5) Here the function returns TRUE because C5 is a valid cell reference. The current content of cell C5 is not checked. TRUE
=ISREF(aRange~Y1:Z6) where aRange is a valid named range. Here the function returns TRUE because the argument is a valid reference list. TRUE
=ISREF(anotherRange) where anotherRange is NOT a valid named range or database range. Here the function returns FALSE because the argument is not a valid reference list. FALSE
=ISREF(INDIRECT("A6")) Here the function returns TRUE, because the INDIRECT function returns a reference. Note that the behaviour of the INDIRECT function is affected by the setting of the Formula syntax option on the Tools ▸ Options ▸ LibreOffice Calc ▸ Formula (LibreOffice ▸ Preferences ▸ LibreOffice Calc ▸ Formula on macOS) dialog. For this example, A6 is not a valid cell reference if the Formula syntax option is set to Excel R1C1. TRUE
=ISREF(ADDRESS(1; 1; 2; "Sheet2")) Here the function returns FALSE, because the ADDRESS function returns a text string, which is not a reference although it may appear to be. FALSE
=ISREF("The spreadsheet for everyone.") Here the function returns FALSE because the argument is a text string rather than a reference. FALSE
=ISREF(42) Here the function returns FALSE because the argument is a number rather than a reference. FALSE

Related LibreOffice functions:

ISNUMBER

ISTEXT

ODF standard:

Section 6.13.24, part 2

Equivalent Excel functions:

ISREF