1. Calculated columns
Horizontal cells calculation in row
- If you want to calculate column's data, you have to set its attribute
Formula
to expression to calculate.
- In this expression you can use any JavaScript syntax, operators, mathematical functions, many TreeGrid API functions and any your custom JavaScript function.
- To reference other cells in actual row, you can use column name as a variable.
- The formula must not use its cell value as its input parameter, because the result of the formula is stored in the cell value.
- Calculated column cells cannot be edited by a user by default. see 07-Editable_Calculated_Cells.html tutorial for editable calculated cells.