Workbook.Calculate() Method

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.v23.2.dll

NuGet Package: DevExpress.Document.Processor

Declaration

C#

public void Calculate()

VB.NET

Public Sub Calculate

Remarks

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.

Related GitHub Examples

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.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/SearchActions.cs#L13

#region #SimpleSearch
workbook.Calculate();
Worksheet worksheet = workbook.Worksheets["ExpenseReport"];

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/SearchActions.vb#L12

#Region "#SimpleSearch"
            workbook.Calculate()
            Dim worksheet As DevExpress.Spreadsheet.Worksheet = workbook.Worksheets("ExpenseReport")

Implements

Calculate()