[]
DEMOS DOCS API BLOG SUPPORT PRICING DOWNLOAD
(Showing Draft Content)

GrapeCity.Spreadsheet.CalculationEngine.Calculate

Calculate Method

Calculate()

Calculates all dirty cells in the whole workbook set.

Declaration
public void Calculate()
Public Sub Calculate()

Calculate(IWorkbook, bool, bool)

Calculates cells in the specified workbook.

Declaration
public void Calculate(IWorkbook workbook, bool fullCalculate = false, bool rebuild = false)
Public Sub Calculate(workbook As IWorkbook, Optional fullCalculate As Boolean = False, Optional rebuild As Boolean = False)
Parameters
Type Name Description
IWorkbook workbook

A GrapeCity.Spreadsheet.Workbook object indicates the workbook to operate.
bool 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.
bool 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.

Calculate(IWorksheet)

Calculates cells in the specified worksheet.

Declaration
public void Calculate(IWorksheet worksheet)
Public Sub Calculate(worksheet As IWorksheet)
Parameters
Type Name Description
IWorksheet worksheet

The worksheet to calculate.