How To Force Calculations To Be Processed After They Have Been Suspended?
9 Dec 2019 / 1 minute to read
The following code illustrates how to force calculations to be processed after Engine.CalculatingSuspended has been flipped back to true.
// Creates some data object that implements ICalcData.
this.data = new ArrayCalcData(a);
// Creates a CalcEngine object using this ICalcData object.
CalcEngine engine = new CalcEngine(this.data);
//Turn off calculations.
engine.CalculatingSuspended = true;
// Makes multiple updates to this.data.
// Turn on calculations.
engine.CalculatingSuspended = false;
// Calls RecalculateRange so any formulas in the data can be computed.
engine.RecalculateRange(RangeInfo.Cells(1, 1, nRows + 1, nCols + 1), data);
' Creates some data object that implements ICalcData.
Me.data = New ArrayCalcData(a)
' Creates a CalcEngine object using this ICalcData object.
Dim engine As New CalcEngine(Me.data)
'...
' Turn off calculations.
engine.CalculatingSuspended = True
' Makes multiple updates to this.data.
' Turn on calculations.
engine.CalculatingSuspended = False
' Calls RecalculateRange so any formulas in the data can be computed.
engine.RecalculateRange(RangeInfo.Cells(1, 1, nRows + 1, nCols + 1), Data)
Was this page helpful?
Yes
No
Thank you for your feedback!
Thank you for your feedback and comments. We will rectify this as soon as possible!
An unknown error has occurred. Please try again.
Help us improve this page