Calculation Property

Gets or sets the property which determines whether this workbook set is automatically calculated as needed.

[Visual Basic]
Overridable Property Calculation As Calculation

[C#]
virtual Calculation Calculation {get; set;}

[C++]
__property virtual Calculation get_Calculation();
__property virtual void set_Calculation( 
   Calculation value
);

[C++/CLI]
virtual property Calculation Calculation {
   Calculation get();
   void set (Calculation value);
}

Remarks

If Calculation is not set to Calculation.Manual, cells containing formulas will always be calculated automatically before values are returned by the SpreadsheetGear for .NET API.

To calculate a workbook set with Calculation set to Calculation.Manual, call Calculate.

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  | CalculationOnDemand Property  | CalculateBeforeSave Property  | NeverRecalc Property  | Calculate Method  | 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.