Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Overview / Cell References in a Formula / R1C1 Notation
In This Topic
    R1C1 Notation
    In This Topic

    Each cell can be referenced by its row and column number by preceding each by the letter "R" for row and the letter "C" for column. For example R1C3 is the cell in the first row and third column.

    A1 Cell Ref. R1C1 Cell Ref. Description
    B12 R12C2 Cell in the second column (column B) and twelfth row (row 12)
    D14:D48 R14C4:R48C4 The range of cells in the fourth column (column D) and in rows 14 through 48
    E16:H16 R16C5:R16C8 The range of cells in the sixteenth row (row 16) in the fifth through the eighth column (columns E through H)
    A25:E70 R25C1:R70C5 The range of cells in the first five columns (column A through E) and rows 25 through 70