How To Suspend Calculations While a Series Of Values Are Updated?

18 Nov 20181 minute to read

You can use the property CalcEngine.CalculatingSuspended to control the calculations that will be performed as values change in your ICalcData object.

  • C#
    • // 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 somehow...

// Turn on calculations.

 engine.CalculatingSuspended = false;
  • VBNET
    • ' 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 somehow...

' Turn on calculations.

engine.CalculatingSuspended = False