On this page are the main methods used to reference cells and regions. These are used to select or subset data from tables to use as inputs for formulas.
Me refers to the cell containing the formula. It works in cell formulas, but doesn't work in other places, e.g. in a node's config .
Absolute index is similar to classic spreadsheet cell addressing.
R11C1, AbsoluteRC(11,1) - a cell in the row 11 and column 1(R11 means the row number is 11 which is defined at sheet left side, C1 means the column number is 1 which is defined at sheet top side)R11C1:R13C3 , Colon(R11C1, R13C3)- a table described by top-left R11C and bottom-right R13C3 cellsSetRow(R2C3, 4) returns R4C3SetCol(R2C3, 4) returns R2C4Since cell labels play such an important role in Planarly, there is a diverse set of operators that allow you to use them, or the row and column they are in, to build references to your data.
The most basic reference is the cell label on its own: a - a cell with a label "a".
In the operators below - is shorthand for row and | is shorthand for column.
a -| b, RowCol(a,b) - use a's row(s), b's column(s)a |- b , ColRow(a, b) - use a's column(s), b's row(s)a v- b, DownTill(a, b) - from a, go down till the row of b.a vv- b, DownDownTill(a, b) - from a vv 1, go down till the row of b.a ^- b, UpTill(a, b) - from a, go up till the row of b.a ^^- b, UpUpTill(a, b) - from a ^^ 1, go up till the row of b.