GrapeCity.Documents.Excel.IWorkbook.Dirty

Dirty Method

Dirty()

Marks all formulas in the workbook as dirty so they are recalculated the next time calculation runs.

Use this method to invalidate cached formula results for the entire workbook. After calling this method, invoke Calculate(), or retrieve formula results while calculation is enabled, to trigger recalculation.

Declaration

void Dirty()

Sub Dirty()

Examples

worksheet.Range["A1"].Value = 1;
worksheet.Range["A2"].Formula = "=A1*2";
workbook.Dirty();
workbook.Calculate();