Spread WPF Documentation
Spread WPF Documentation / Formula Reference / Formula Functions / ADDRESS
In This Topic
    ADDRESS
    In This Topic

    Summary

    This function uses the row and column numbers to create a cell address in text.

    Syntax

    ADDRESS(row,column,absnum,a1style,sheettext)

    Arguments

    This function has these arguments:

    Argument Description
    row Row number in the cell reference
    column8 Column number in the cell reference
    absnum [Optional] Type of reference to return; can be any of:
    Value - Type of Cell Reference Returned
    1 or omitted - Absolute
    2 - Absolute row, relative column
    3 - Relative row, absolute column
    4 - Relative
    a1style [Optional] Logical value that indicates whether the reference style is A1; if TRUE or omitted, the style is A1; if FALSE, then the style is R1C1
    sheettext [Optional] Name of the sheet to use as an external reference; if omitted, no sheet name is used

    Data Types

    Accepts numeric and string data. Returns string data.

    Examples

    ADDRESS(2,4,2,FALSE)

    See Also