Difference between revisions of "Documentation/How Tos/Calc: R1C1 notation"
From Apache OpenOffice Wiki
< Documentation | How Tos
(initial content) |
|||
| (3 intermediate revisions by one other user not shown) | |||
| Line 8: | Line 8: | ||
| − | An older method is R1C1 notation. This is only implemented in Calc in the [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]] and [[Documentation/How_Tos/Calc: ADDRESS function|ADDRESS]] functions, for compatability. | + | An older method in some other spreadsheets is R1C1 notation. This is only implemented in Calc in the [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]] and [[Documentation/How_Tos/Calc: ADDRESS function|ADDRESS]] functions, for compatability. |
| 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. | ||
| + | {{SeeAlso|EN| | ||
| + | * [[Documentation/How_Tos/Calc: ADDRESS function|ADDRESS]] | ||
| + | * [[Documentation/How_Tos/Calc: INDIRECT function|INDIRECT]] | ||
| + | |||
| + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
| + | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
[[Category: Documentation/Reference/Calc/Spreadsheet functions]] | [[Category: Documentation/Reference/Calc/Spreadsheet functions]] | ||
Latest revision as of 09:52, 17 July 2018
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 in some other spreadsheets 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.
See Also
