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

FormulaEngine Interface

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

Namespace: DevExpress.Spreadsheet.Formulas

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


public interface FormulaEngine
Public Interface FormulaEngine


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