We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

suspending recalcuation

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


5 Replies

JJ Jisha Joy Syncfusion Team September 24, 2010 06:03 AM UTC

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



AD Administrator Syncfusion Team September 24, 2010 01:04 PM UTC

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



RC Rajadurai C Syncfusion Team September 24, 2010 06:40 PM UTC

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



AD Administrator Syncfusion Team September 24, 2010 07:35 PM UTC

Thank you.



RC Rajadurai C Syncfusion Team September 27, 2010 05:58 PM UTC

Hi Jan,

Thank you for using Syncfusion Products.

Regards,
Rajadurai


Loader.
Live Chat Icon For mobile
Up arrow icon