Cell area being calculated together when calculate cell value of Calculated Column of cached.
It is used as CalculatedColumn.calcRange property. The range of limiting calculation area is specified through CalculatedColumn.calcBounds property.
| ROWS | "rows" | Recalculate changed rows only. |
| FIRST | "first" | Calculate all grid rows in order. You can refer the value of previous row in formula. |
| LAST | "last" | Calculate all grid rows in reverse order. You can refer the value of next row in formula. |
| LOWER | "lower" | Calculate all changed rows of grid in order. You can refer the value of previous row in formula. |
| UPPER | "upper" | Calculate all changed rows of grid in reverse order. You can refer the value of next row in formula. |
grid.setColumns([{
name: "colQuantity",
type: "calced",
cached: true,
calcBounds: DataLudi.ColumnCalcBounds.GRID,
calcRange: DataLudi.ColumnCalcRange.FIRST,
valueExpression: "quantity + prevval",
...
},
...
];