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

public void Dirty()

Public Sub Dirty()

Implements

IWorkbook.Dirty()

Examples

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