BackgroundCalculation Property (IWorkbookSet)

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.

Syntax

System.bool BackgroundCalculation {get; set;}

read-write property BackgroundCalculation: System.Boolean;

function get,set BackgroundCalculation : System.boolean

__property System.bool get_BackgroundCalculation();
__property void set_BackgroundCalculation( 
   System.bool value
);

property System.bool BackgroundCalculation {
   System.bool get();
   void set (    System.bool value);
}

'Declaration
 
Property BackgroundCalculation As System.Boolean

'Usage
 
Dim instance As IWorkbookSet
Dim value As System.Boolean
 
instance.BackgroundCalculation = value
 
value = instance.BackgroundCalculation

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

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

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

See our live ASP.NET Excel Reporting, Excel Charting, Dashboards from Charts and Ranges, Excel Calculation and Excel to DataGrid Samples.

Copyright © 2003-2020 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Send Feedback