6. Calculated attributes

Setting Formula for cell and row attributes

• It is possible to calculate also the most of cell and row attribute values by

  Formula

  attached to cell attribute name, e.g. Col1CanEditFormula="...".
• If the row calculates some of its attributes, the row must have defined

  CalcOrder

  that will list all the formulas in the row.
• The calculated attribute is listed in the CalcOrder without the Formula keyword, e.g. CalcOrder='Col1CanEdit,Col2'
• See also 07 Conditional formatting tutorial for more calculated attributes.
• If some attribute depends on some cell value, sometimes is better to use OnChange event to modify the attribute by API instead of calculating all the attributes by Formula, to speed up the calculations. See 07-Editable_Calculated_Cells.html tutorial.