GrapeCity.Documents.Excel.IWorkbook.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

void Calculate()

Sub Calculate()

Examples

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