2. Calculated rows
Fixed summary rows
- Calculated row must have set attribute
Calculated
='1'. And for every its cell you can set its Formula
.
- In calculated rows there are used also the formulas defined in columns; set the cell Formula attribute to empty string to ignore the column Formula.
- Calculated rows are usually fixed rows or rows with children, but in fact, calculated can be any row in grid.
- In calculated rows you can use also aggregate functions to iterate all variable rows or row's children.
- Calculated row cells cannot be edited by a user by default. see 07-Editable_Calculated_Cells.html tutorial for editable calculated cells.