Working with syncfusion grid and need the formulas to update their reference on row insert. Followed solution suggested on forum in threads 107111, 68861 and 94721. In fact all of them suggest the same solution that appears to be pretty straight forward but unfortunately not working for me. I must be miossing something or doing a mistake.
Here is my sample code:
GridFormulaEngine engine = ((GridFormulaCellModel)grid.CellModels["FormulaCell"]).Engine;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.InsDelRangeReferencesUpdated;
engine.FormulaCopyFlags |= GridFormulaCopyFlags.NamedRangeReferencesUpdated;
grid.BeginUpdate();
grid.Model.Rows.InsertRange(12, 1);
grid.EndUpdate();
Can somebody guide me where is the mistake?