[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Expand]Spreadsheet Document API
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Collapse]API Reference
  [Expand]DevExpress.BarCodes
  [Expand]DevExpress.Compression
  [Expand]DevExpress.Docs.Text
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Drawing
  [Expand]DevExpress.Office.Export
  [Expand]DevExpress.Office.Export.Html
  [Expand]DevExpress.Office.Import
  [Expand]DevExpress.Office.Localization
  [Expand]DevExpress.Office.Options
  [Expand]DevExpress.Office.Services
  [Expand]DevExpress.Office.Utils
  [Expand]DevExpress.Pdf
  [Expand]DevExpress.Pdf.Localization
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Spreadsheet
  [Expand]DevExpress.Spreadsheet.Charts
  [Expand]DevExpress.Spreadsheet.Drawings
  [Expand]DevExpress.Spreadsheet.Export
  [Collapse]DevExpress.Spreadsheet.Formulas
   [Expand]AdditionExpression Class
   [Expand]ArrayConstantExpression Class
   [Expand]BinaryOperatorExpression Class
   [Expand]CellArea Class
   [Expand]CellCalculationArgs Class
   [Expand]CellErrorReferenceExpression Class
   [Expand]CellReferenceExpression Class
   [Expand]CellReferencePosition Structure
   [Expand]ConcatenateExpression Class
   [Expand]ConstantExpression Class
   [Expand]DefinedNameReferenceExpression Class
   [Expand]DivisionExpression Class
   [Expand]EqualityExpression Class
   [Expand]Expression Class
   [Expand]ExpressionContext Class
    ExpressionStyle Enumeration
   [Expand]ExpressionVisitor Class
   [Collapse]FormulaEngine Interface
     FormulaEngine Members
    [Expand]FormulaEngine Methods
   [Expand]FunctionExpression Class
   [Expand]FunctionExpressionBase Class
   [Expand]FunctionExternalExpression Class
   [Expand]GreaterExpression Class
   [Expand]GreaterOrEqualExpression Class
   [Expand]IExpression Interface
   [Expand]IExpressionContext Interface
   [Expand]InequalityExpression Class
   [Expand]LessExpression Class
   [Expand]LessOrEqualExpression Class
   [Expand]MissingArgumentExpression Class
   [Expand]MultiplicationExpression Class
   [Expand]ParsedExpression Class
   [Expand]PercentExpression Class
    PositionType Enumeration
   [Expand]PowerExpression Class
   [Expand]RangeExpression Class
   [Expand]RangeIntersectionExpression Class
   [Expand]RangeUnionExpression Class
   [Expand]ReferenceExpression Class
   [Expand]SheetReference Class
    SheetReferenceType Enumeration
   [Expand]SubtractionExpression Class
   [Expand]TableReferenceExpression Class
    TableRowsRestriction Enumeration
   [Expand]UnaryMinusExpression Class
   [Expand]UnaryOperatorExpression Class
   [Expand]UnaryPlusExpression Class
   [Expand]UnknownFunctionExpression Class
  [Expand]DevExpress.Spreadsheet.Functions
  [Expand]DevExpress.UnitConversion
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.API.Layout
  [Expand]DevExpress.XtraRichEdit.API.Native
  [Expand]DevExpress.XtraRichEdit.API.Native.Implementation
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Export.Html
  [Expand]DevExpress.XtraRichEdit.Export.Rtf
  [Expand]DevExpress.XtraRichEdit.Forms
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Localization
  [Expand]DevExpress.XtraRichEdit.Services
  [Expand]DevExpress.XtraRichEdit.Utils
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Export
  [Expand]DevExpress.XtraSpreadsheet.Export.Html
  [Expand]DevExpress.XtraSpreadsheet.Import
  [Expand]DevExpress.XtraSpreadsheet.Localization
  [Expand]DevExpress.XtraSpreadsheet.Services
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

FormulaEngine Interface

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

Namespace:DevExpress.Spreadsheet.Formulas
Assembly:DevExpress.Spreadsheet.v18.2.Core.dll

Expanded Syntax

Expanded 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 Evaluate method. You can parse a formula using the 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.

Expanded Inheritance Hierarchy

Expanded See Also

Is this topic helpful?​​​​​​​