Hello,
I seem to be having an issue with the Grid formula engine. In resolution to an issue of recalculating formulas on deserialization (
http://www.syncfusion.com/Support/Forums/message.aspx?MessageID=40881) we run the following code after we deserialize the GridControl.
gm is the GridModel
Dim model As GridFormulaCellModel = gm.CellModels.Item("FormulaCell")
Dim engine As GridFormulaEngine = model.Engine
engine.FormulaCopyFlags = engine.FormulaCopyFlags Or GridFormulaCopyFlags.InsDelRangeReferencesUpdated Or GridFormulaCopyFlags.ClipBoardReferencesAdjusted
engine.RecalculateRange(GridRangeInfo.Table, True)
In calling ‘engine.RecalculateRange(GridRangeInfo.Table, True)’ our program enters an infinite loop on some grids with more complex formulas and other grids it seems to work fine. If we change the code to engine.RecalculateRange(GridRangeInfo.Table, True, True) the infinite loop seems to not occur. Is there is reason this happening? Can you shed some light on what the on what the force calculations and force parsing parameters are doing to ensure we are using them correctly and for better understanding it would be of great help.
Thank you so much.
Nick