FormulaEngine Interface

An object that provides the capability to calculate and parse worksheet formulas.

Namespace: DevExpress.Spreadsheet.Formulas

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public interface FormulaEngine

VB.NET

Public Interface FormulaEngine

Related API Members

The following members return FormulaEngine objects:

• IWorkbook.FormulaEngine
• Workbook.FormulaEngine

Remarks

The FormulaEngine includes a built-in formula parser, as well as the flexibility to evaluate formulas in any range of any worksheet using the FormulaEngine.Evaluate method. You can parse a formula using the FormulaEngine.Parse method, analyze the resulting expression tree, make the required modifications and rebuild the formula string from the modified expression tree using the ParsedExpression.ToString method.