See Also

IWorkbookSet Interface  | IWorkbookSet Members  | BackgroundCalculation Property  | Calculation Property  | CalculationOnDemand Property  | Calculate Method  | CalculateFull Method  | CalculateFullRebuild Method  | GetLock Method  | ReleaseLock Method

Requirements

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

Language

Visual Basic

C#

C++

C++/CLI

Show All

See Also Languages SpreadsheetGear The Performance Spreadsheet Component Company 

BackgroundCalculation Property

SpreadsheetGear Namespace > IWorkbookSet Interface : BackgroundCalculation Property

Gets or sets the property which specifies whether interruptible background calculation will be initiated as needed when the last lock on a workbook set is released.

[Visual Basic]
Overridable Property BackgroundCalculation As Boolean
[C#]
virtual bool BackgroundCalculation {get; set;}
[C++]
__property virtual bool get_BackgroundCalculation(); __property virtual void set_BackgroundCalculation(    bool value );
[C++/CLI]
virtual property bool BackgroundCalculation {    bool get();    void set (bool value); }

Remarks

This property is thread safe.

Changing BackgroundCalculation from true to false stops background calculation before the property setter returns.

BackgroundCalculation is on by default. However, background calculation will not be initiated if Calculation is set to Calculation.Manual or if a lock is never acquired and subsequently released.

When utilizing background calculation, GetLock must be used to acquire a lock before any access to any object in a workbook set.

All Windows Forms components from SpreadsheetGear use GetLock and ReleaseLock whenever they access anything in a workbook set.

See GetLock and ReleaseLock for more information about acquiring and releasing locks as well as the effect this has on background calculation.

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  | Calculate Method  | CalculateFull Method  | CalculateFullRebuild Method  | GetLock Method  | ReleaseLock 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.