Spread WinForms 15
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / CalculationEngine Class / Calculate Method / Calculate(IWorkbook,Boolean,Boolean) Method
A Workbook object indicates the workbook to operate.
if set to true, calculates all formulas; otherwise, calculates all formula as needed. Volatile formulas and formulas involved in circular references are always calculated.
if set to true the internal data in this CalculationEngine will be re-build.


In This Topic
Calculate(IWorkbook,Boolean,Boolean) Method
In This Topic
Calculates cells in the specified workbook.
Syntax
'Declaration
 
Public Overloads Sub Calculate( _
   ByVal workbook As IWorkbook, _
   Optional ByVal fullCalculate As Boolean, _
   Optional ByVal rebuild As Boolean _
) 
 
'Usage
 
Dim instance As CalculationEngine
Dim workbook As IWorkbook
Dim fullCalculate As Boolean
Dim rebuild As Boolean
 
instance.Calculate(workbook, fullCalculate, rebuild)

Parameters

workbook
A Workbook object indicates the workbook to operate.
fullCalculate
if set to true, calculates all formulas; otherwise, calculates all formula as needed. Volatile formulas and formulas involved in circular references are always calculated.
rebuild
if set to true the internal data in this CalculationEngine will be re-build.
Remarks
Rebuild internal data of the CalculationEngine is a very expensive operation.
See Also