DocumentSettings.Calculation Property

Provides access to options used for calculation of formulas contained in the worksheet cells.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v17.2.Core.dll

Declaration

C#

CalculationOptions Calculation { get; }

VB.NET

ReadOnly Property Calculation As CalculationOptions

Property Value

Type	Description
CalculationOptions	A CalculationOptions object that contains various calculation options.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to Calculation
Cross-Platform Class Library	IWorkbook	.DocumentSettings.Calculation
Office File API	Workbook	.DocumentSettings.Calculation

Remarks

For detailed information on formulas, refer to Spreadsheet Formulas.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Calculation property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

how-to-update-external-references-in-the-loaded-workbook-t177074/CS/ExternalReferencesLoadSample/Form1.cs#L51

spreadsheetControl1.Document.LoadDocument("Workbook2.xlsx");
spreadsheetControl1.Document.DocumentSettings.Calculation.Mode = CalculationMode.Automatic;

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/CS/CustomCalculationServiceExample/Form1.cs#L24

spreadsheetControl1.BeginUpdate();
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = true;
calculationService = new TestCustomCalculationService(loggingControl);

VB.NET

how-to-update-external-references-in-the-loaded-workbook-t177074/VB/ExternalReferencesLoadSample/Form1.vb#L45

spreadsheetControl1.Document.LoadDocument("Workbook2.xlsx")
spreadsheetControl1.Document.DocumentSettings.Calculation.Mode = CalculationMode.Automatic

how-to-implement-a-service-to-manage-the-process-of-worksheet-cell-calculation-t270403/VB/CustomCalculationServiceExample/Form1.vb#L23

spreadsheetControl1.BeginUpdate()
spreadsheetControl1.Document.DocumentSettings.Calculation.Iterative = True
calculationService = New TestCustomCalculationService(loggingControl)