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.
Unfortunately, activation email could not send to your email. Please try again.

suspending recalcuation

Thread ID:

Created:

Updated:

Platform:

Replies:

96557 Sep 20,2010 09:39 AM Sep 27,2010 01:58 PM Windows Forms 5
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On September 20, 2010 09:39 AM

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 02:03 AM

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 [Syncfusion]
Replied On September 24, 2010 09:04 AM

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


Rajadurai C [Syncfusion]
Replied On September 24, 2010 02:40 PM

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 [Syncfusion]
Replied On September 24, 2010 03:35 PM

Thank you.


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

Hi Jan,

Thank you for using Syncfusion Products.

Regards,
Rajadurai


CONFIRMATION

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.

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.

;