Spread WPF 18
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)
    public void Calculate( 
       IWorkbook workbook,
       bool fullCalculate,
       bool 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