CalculationOptions.CalculationId Property
Allows you to specify the version of the calculation engine used to calculate values in the workbook.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| Int32 | An integer that identifies the version of the calculation engine. |
Property Paths
You can access this nested property as listed below:
| Object Type | Path to CalculationId |
|---|---|
| DocumentSettings |
|
Remarks
The OpenXML specification defines the CalculationId property. This property specifies the version of the calculation engine used to calculate values in the workbook. Microsoft Excel initializes this property according to the application version, for instance, the CalculationId property value for Microsoft Excel 2010 is 145621. The SpreadsheetControl resets this property to 0 after calculating formulas in a document.
The OpenXML specification states that “when you open a workbook created in the current version, the application recalculates only the formulas that depend on cells that have changed. When you open a workbook that was created in an earlier version of the application, all the formulas in the workbook— those that depend on cells that have changed and those that do not— are recalculated.”
Example
// To calculate all formulas in the document created in Excel 2010 and earlier Excel versions, use the following code:
const int Excel2010CalcId = 145621;
spreadsheetControl1.DocumentLoaded += spreadsheetControl1_DocumentLoaded;
private void spreadsheetControl1_DocumentLoaded(object sender, EventArgs e) {
if (spreadsheetControl1.Document.DocumentSettings.Calculation.CalculationId < Excel2010CalcId) {
spreadsheetControl1.Document.CalculateFull();
}
// To not calculate formulas in .XLS/XLSX document when the document is opened in Excel 2010, save the document using the following code:
const int Excel2010CalcId = 145621;
spreadsheetControl1.BeforeExport += spreadsheetControl1_BeforeExport;
private void spreadsheetControl1_BeforeExport(object sender, SpreadsheetBeforeExportEventArgs e) {
spreadsheetControl1.Document.DocumentSettings.Calculation.CalculationId = Excel2010CalcId;
}