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.