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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

suspending recalcuation

Thread ID:





96557 Sep 20,2010 01:39 PM UTC Sep 27,2010 05:58 PM UTC WinForms 5
Tags: GridControl
Administrator [Syncfusion]
Asked On September 20, 2010 01:39 PM UTC

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 [Syncfusion]
Replied On 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.


Administrator [Syncfusion]
Replied On September 24, 2010 01:04 PM UTC

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

Rajadurai C [Syncfusion]
Replied On 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.


Administrator [Syncfusion]
Replied On September 24, 2010 07:35 PM UTC

Thank you.

Rajadurai C [Syncfusion]
Replied On September 27, 2010 05:58 PM UTC

Hi Jan,

Thank you for using Syncfusion Products.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon