Formula Row and Column Syntax
Syntax:
gridname.row\column[x].property| Argument | Description |
|---|---|
| gridname | Name of the grid. Grid names cannot include spaces. When specifying the full gridname notation, you must also indicate the row, column, or cell.
|
| x | Row or column, number, and property. |
Example 1
Add all elements in row 3 of mygrid1.
mygrid1.row[3].sumExample 2
Return the sum of the nth column:
mygrid2.column[C].sumExample 3
Returns the absolute value of the cell located at the intersection of row 5 and column B in the current grid:
ABS([5,B])