Difference between revisions of "Documentation/How Tos/Calc: ADDRESS function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→Issues:) |
(→Issues:) |
||
Line 68: | Line 68: | ||
=== Issues: === | === Issues: === | ||
+ | *Excel represents some cell references differently to Calc, so this function is not always portable. For example <tt>'''ADDRESS(1;1;4;"Sheet2"))'''</tt> returns <tt>'''Sheet2.A1'''</tt> in Calc; the equivalent in Excel returns <tt>'''Sheet2!A1'''</tt>. | ||
*The proposed ODFF standard says that the default <tt>'''mode'''</tt> (if <tt>'''mode'''</tt> is omitted) should be <tt>'''4'''</tt>. Calc and Excel both default to <tt>'''1'''</tt>. | *The proposed ODFF standard says that the default <tt>'''mode'''</tt> (if <tt>'''mode'''</tt> is omitted) should be <tt>'''4'''</tt>. Calc and Excel both default to <tt>'''1'''</tt>. | ||
*Excel allows an R1C1 reference style. | *Excel allows an R1C1 reference style. |
Revision as of 20:41, 15 September 2008
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.