7. Editable calculated cells

Changing calculate cell and modifying its source

• It is possible to edit calculated cell value. Set

  CanEdit

  to the column or, for Calculated row, to the cell. And define

  OnChange

  XML event or

  OnAfterValueChanged

  API event to modify the source of the cell formula.
• Optionally define OnGetInputValue for editable cell to edit different value than shown calculated by Formula.
• The edited value must not be stored in the cell value itself, because the cell value is overwritten by the formula result.
• Compare with 06-Calculated_Attributes.html example.