officefileapi-devexpress-dot-spreadsheet-dot-workbook-bc9d9e84.md
Forces recalculation of the workbook.
You need a 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.v25.2.dll
NuGet Package : DevExpress.Document.Processor
public void Calculate()
Public Sub 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.
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.
#region #SimpleSearch
workbook.Calculate();
Worksheet worksheet = workbook.Worksheets["ExpenseReport"];
' #Region "#SimpleSearch"
workbook.Calculate()
Dim worksheet As Worksheet = workbook.Worksheets("ExpenseReport")
See Also