Calculate Method

Calculates formulas as needed. Volatile formulas and formulas involved in circular references are always calculated.

[Visual Basic]
Overridable Sub Calculate() 

[C#]
virtual void Calculate();

[C++]
virtual void Calculate(); 

[C++/CLI]
virtual void Calculate(); 

Remarks

Calculate will defer actual calculation of the workbook set to the background calculation thread if all of the following are true:

• The current thread has acquired a lock on the workbook set.
• BackgroundCalculation is true.
• Calculation is not set to Calculation.Manual.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IWorkbookSet Interface  | IWorkbookSet Members  | BackgroundCalculation Property  | Calculation Property  | CalculationOnDemand Property  | CalculateFull Method  | CalculateFullRebuild Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.