GrapeCity.Documents.Excel.XlsxOpenOptions.DoNotRecalculateAfterOpened

DoNotRecalculateAfterOpened Property

DoNotRecalculateAfterOpened

Gets or sets whether to skip marking formulas dirty after opening an XLSX file.

The default value is false.

When this property is true, formulas with cached results are not marked dirty after opening, so the cached formula results are returned when calculation is triggered. Formulas without cached results are still marked dirty and recalculated when calculation is triggered. When this property is false, formulas are marked dirty after opening, so formula results are recalculated when calculation is triggered. Calculation can be triggered by operations such as getting formula values or calling Calculate().

Declaration

public bool DoNotRecalculateAfterOpened { get; set; }

Public Property DoNotRecalculateAfterOpened As Boolean

Examples

XlsxOpenOptions openOptions = new XlsxOpenOptions();
openOptions.DoNotRecalculateAfterOpened = true;
bool doNotRecalculate = openOptions.DoNotRecalculateAfterOpened;
workbook.Open("source.xlsx", openOptions);