Back to Devexpress

FormulaEngine Interface

officefileapi-devexpress-dot-spreadsheet-dot-formulas.md

latest1.9 KB
Original Source

FormulaEngine Interface

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

Namespace : DevExpress.Spreadsheet.Formulas

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
public interface FormulaEngine
vb
Public Interface FormulaEngine

The following members return FormulaEngine objects:

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.

See Also

FormulaEngine Members

Formula Engine

DevExpress.Spreadsheet.Formulas Namespace