Documentation/Calc Functions/ISREF

    From The Document Foundation Wiki
    Other languages:


    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

    Related (or similar) Excel functions:

    ISREF