Difference between revisions of "Documentation/How Tos/Calc: R1C1 notation"
From Apache OpenOffice Wiki
< Documentation | How Tos
(initial content) |
m (→R1C1 notation) |
||
| Line 15: | Line 15: | ||
:<tt>'''R5C3'''</tt> refers to the cell at the fifth row, third column (<tt>'''C5'''</tt> in usual notation) | :<tt>'''R5C3'''</tt> refers to the cell at the fifth row, third column (<tt>'''C5'''</tt> in usual notation) | ||
| − | :<tt>'''R[2]C[4]'''</tt> is a relative reference, two rows down and | + | :<tt>'''R[2]C[4]'''</tt> is a relative reference, two rows down and four rows across from the current cell. If <tt>'''R[2]C[4]'''</tt> is entered in a formula in cell D3, it refers to cell H5. |
| − | :<tt>'''R[-1]C[4]'''</tt> is a relative reference, one row up and | + | :<tt>'''R[-1]C[4]'''</tt> is a relative reference, one row up and four rows across from the current cell. |
:<tt>'''R'''</tt> is a reference to the current row. | :<tt>'''R'''</tt> is a reference to the current row. | ||
Revision as of 16:06, 31 July 2010
R1C1 notation
The usual way to refer to cells in Calc is by using a column letter and a row number:
- C5 - the cell at the third column across and the fifth row down.
An older method is R1C1 notation. This is only implemented in Calc in the INDIRECT and ADDRESS functions, for compatability.
In R1C1 notation:
- R5C3 refers to the cell at the fifth row, third column (C5 in usual notation)
- R[2]C[4] is a relative reference, two rows down and four rows across from the current cell. If R[2]C[4] is entered in a formula in cell D3, it refers to cell H5.
- R[-1]C[4] is a relative reference, one row up and four rows across from the current cell.
- R is a reference to the current row.
