suspending recalcuation

[Administrator]

Is there some way to turn on and off recalculation so that it only occurs when desired (like on a button click or similar)?

[Jisha Joy]

Hi Jan,


If your intension is to suspend the calculation on the XlsIOCalcWorkbook, then this can be achieved by setting the Engine.CalculatingSuspended property. See the code:


this.calcWB.Engine.CalculatingSuspended = true;

Please let me know in details if this does not serve your needs.

Regards,
Jisha

[Administrator]

No, my intention is to suspend calculation of the grid contents itself.

[Rajadurai C]

Hi Jan,

To suspend the calculation of formula cells in grid for a while, you can get the FormulaEngine of the respective grid and set the CalculatingSuspended property to true. Following code does the same.

GridFormulaCellModel model = this.gridControl1.CellModels["FormulaCell"]	as GridFormulaCellModel;
GridFormulaEngine engine = model.Engine; 
engine.CalculatingSuspended = true;

Thank you for using Syncfusion Products.

Regards,
Rajadurai

[Administrator]

Thank you.

[Rajadurai C]

Hi Jan,

Thank you for using Syncfusion Products.

Regards,
Rajadurai