GrapeCity.Documents.Excel.Workbook.Calculate

Calculate Method

Calculate()

Calculates formulas in the workbook as needed.

This method recalculates workbook formulas that require calculation. If iterative calculation is enabled, all formulas in the workbook are marked for recalculation before the calculation is performed.

Declaration

public void Calculate()

Public Sub Calculate()

Implements

IWorkbook.Calculate()

Examples

worksheet.Range["A1"].Value = 100;
worksheet.Range["B1"].Formula = "=A1*2";
workbook.Calculate();
object value = worksheet.Range["B1"].Value;