Oleo
1.2.1 noa0 Mode
In noa0 mode (the default), absolute cell addresses have the
form RrowCcol, where row and col are
the row and column (as integers). Thus, R1C2 is the second cell
from the left on the top row. The cell in the leftmost uppermost corner
is R1C1, and the cell in the rightmost lowermost corner is
R65535C65535.
Relative addresses have the form
R[rowoffset]C[coloffset], as in R[-1]C[+1]
(the cell above and to the right of the current cell). An offset of 0
can be omitted, along with its square brackets: RC[+2] (the cell
two columns to the right). The plus signs of positive offsets can also
be omitted. Absolute and relative addresses can be combined, as in
R4C[-1] (the cell in row four that's one left of the current
cell).
Ranges in noa0 mode are specified as
Rrow1:row2Ccol1:col2, where the row
and column references may be either absolute or relative, and can be
mixed. Thus, R1:4C1:[-2] refers to the cells of rows one through
4, columns one through the second column to the left. If row1 =
row2 or col1 = col2, the colon and second number may
be omitted, as in R1:10C2 (rows one through ten in column two).
