CalculationOptions.FullCalculationOnLoad Property
Indicates whether formulas should be recalculated when the workbook is opened.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
Type | Default | Description |
---|---|---|
Boolean | false | true to recalculate all formulas when the workbook is opened; otherwise, false. |
Property Paths
You can access this nested property as listed below:
Object Type | Path to FullCalculationOnLoad |
---|---|
DocumentSettings |
|
Remarks
The FullCalculationOnLoad
property value is stored in a document file. When the Spreadsheet opens a workbook with this option enabled, it recalculates all formulas. However, if the CalculationOptions.Mode property is set to Manual, the Spreadsheet does not recalculate the workbook even if FullCalculationOnLoad
is true
.
When the Spreadsheet loaded a workbook and successfully recalculated all formulas, the FullCalculationOnLoad
property is reset to its default value (false
).