Syntax
| Visual Basic (Declaration) | |
|---|---|
Event EndCalculate() As EndCalculateEventHandler | |
| C# | |
|---|---|
event EndCalculateEventHandler EndCalculate() | |
Event Data
The event handler receives an argument of type EndCalculateEventArgs containing data related to this event. The following EndCalculateEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| BackgroundCalculation | Returns true if the EndCalculate event is being invoked on the background calculation thread, or false if it is being invoked on any other thread. |
Remarks
This event occurs when calculation of this workbook set has completed.
This event is always invoked on the thread which completes calculation of the workbook set:
- If calculation completes during execution of an API such as Save which may require calculation to be completed, the locked state of the workbook set will be the same as when the API was called.
- If calculation completes during background calculation, the invoking thread is the background calculation thread and the workbook set will be locked before this event is invoked.
This event will not occur until calculation is complete. For example, this event will not occur if a partial calculation is completed in response to getting the value of a cell, and it will not be invoked if background calculation is interrupted.
The WorkbookView.Calculate event is always invoked on the thread which created the WorkbookView control and is generally a better choice when using the WorkbookView control.
Requirements
Platforms: x86 and x64 versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2). SpreadsheetGear 2009 requires the Microsoft .NET Framework 2.0 and supports .NET 3.0 and .NET 3.5.