Formula stop updating after deserialization

[Administrator]

I have a grid with some formulas. If I serialize the grid model and then deserialize it, formula cells do not seem to update when the value of their dependent cell is changed. Steps to reproduce issue from attached sample: -start sample -press save -press open -change value of B1 and notice that the value in A1 doesn''t recalculate. How can I fix this?

issue2.zip

[Administrator]

Hi Alex,

After deserializing, try reactivating the formula cells by recalculating. Below is a code snippet.

Dim engine As GridFormulaEngine
engine = CType(GridControl1.CellModels("FormulaCell"), GridFormulaCellModel).Engine
engine.RecalculateRange(GridRangeInfo.Table, True)

Regards,
Calvin.

[Administrator]

That worked.

Thank you.