Difference between revisions of "Documentation/How Tos/Calc: ADDRESS function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(→See also:) |
(→Issues:) |
||
| Line 68: | Line 68: | ||
=== Issues: === | === Issues: === | ||
| − | The proposed ODFF standard says that the default <tt>'''mode'''</tt> (if <tt>'''mode'''</tt> is omitted) should be <tt>'''4'''</tt>. Calc | + | *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. | ||
Revision as of 20:35, 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:
- 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.
