.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

Workbook.Calculate() Method

Forces recalculation of the workbook.

You need an active license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Docs.v21.2.dll


public void Calculate()


When the Calculate is called, all workbook modifications are applied and all cells are calculated.

Recalculation of the entire workbook can take a significant amount of time and resources. To calculate only a formula contained in a single cell, use the Workbook.Evaluate method.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Calculate() method.


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.


See Also