Documentation/How Tos/Calc: ADDRESS function
From Apache OpenOffice Wiki
ADDRESS
Returns a cell reference as text, given row and column numbers.
Syntax:
ADDRESS(row; column; mode; sheet)
- row is a number specifying the row.
- column is a number (not a letter) specifying the column.
- mode (an optional number) determines whether the cell address is absolute or relative. If omitted, it is assumed to be 1.
mode row column example 1 absolute absolute $A$1 2 absolute relative A$1 3 relative absolute $A1 4 relative relative A1
- sheet is an optional text string specifying the sheet.
Example:
ADDRESS(4; 3; 2; "Sheet2")
- returns the text Sheet2.C$4.
ADDRESS(4; 3; 4)
- returns the text C4.
ADDRESS(4; 3)
- returns the text $C$4.
See also:
Functions listed alphabetically, Functions listed by category
Issues:
- Excel represents some cell references differently to Calc, so this function is not always portable. For example ADDRESS(1;1;4;"Sheet2")) returns Sheet2.A1 in Calc; the equivalent in Excel returns Sheet2!A1.
- The proposed ODFF standard says that the default mode (if mode is omitted) should be 4. Calc and Excel both default to 1.
- Excel allows an R1C1 reference style.