[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
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Collapse]Cross-Platform Core Libraries
 [Expand]DevExpress ORM Tool
 [Expand]DevExpress Data Library
 [Expand]DevExpress Pivot Grid Core Library
 [Expand]Miscellaneous
 [Collapse]API Reference
  [Expand]DevExpress.Data
  [Expand]DevExpress.Data.Browsing
  [Expand]DevExpress.Data.Browsing.Design
  [Expand]DevExpress.Data.Camera
  [Expand]DevExpress.Data.Controls
  [Expand]DevExpress.Data.Controls.ExpressionEditor
  [Expand]DevExpress.Data.Entity
  [Expand]DevExpress.Data.Filtering
  [Expand]DevExpress.Data.Filtering.Exceptions
  [Expand]DevExpress.Data.Filtering.Helpers
  [Expand]DevExpress.Data.Linq
  [Expand]DevExpress.Data.ODataLinq
  [Expand]DevExpress.Data.PivotGrid
  [Expand]DevExpress.Data.PLinq
  [Expand]DevExpress.Data.TreeList
  [Expand]DevExpress.Data.Utils
  [Expand]DevExpress.Data.Utils.ServiceModel
  [Expand]DevExpress.Data.WcfLinq
  [Expand]DevExpress.Data.WizardFramework
  [Expand]DevExpress.Data.XtraReports.DataProviders
  [Expand]DevExpress.Data.XtraReports.Labels
  [Expand]DevExpress.Data.XtraReports.ServiceModel
  [Expand]DevExpress.Data.XtraReports.ServiceModel.DataContracts
  [Expand]DevExpress.Data.XtraReports.Wizard
  [Expand]DevExpress.Data.XtraReports.Wizard.Presenters
  [Expand]DevExpress.Data.XtraReports.Wizard.Views
  [Expand]DevExpress.DataAccess
  [Expand]DevExpress.DataAccess.ConnectionParameters
  [Expand]DevExpress.DataAccess.EntityFramework
  [Expand]DevExpress.DataAccess.Excel
  [Expand]DevExpress.DataAccess.ExpressionEditor
  [Expand]DevExpress.DataAccess.Localization
  [Expand]DevExpress.DataAccess.ObjectBinding
  [Expand]DevExpress.DataAccess.Sql
  [Expand]DevExpress.DataAccess.Sql.DataApi
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.Localization
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DataAccess.Web
  [Expand]DevExpress.DataAccess.Wizard
  [Expand]DevExpress.DataAccess.Wizard.Model
  [Expand]DevExpress.DataAccess.Wizard.Presenters
  [Expand]DevExpress.DataAccess.Wizard.Services
  [Expand]DevExpress.DataAccess.Wizard.Views
  [Expand]DevExpress.Diagram.Core
  [Expand]DevExpress.Diagram.Core.Layout
  [Expand]DevExpress.Diagram.Core.Localization
  [Expand]DevExpress.Diagram.Core.Shapes
  [Expand]DevExpress.Diagram.Core.Themes
  [Expand]DevExpress.DocumentServices.ServiceModel
  [Expand]DevExpress.DocumentServices.ServiceModel.Client
  [Expand]DevExpress.DocumentServices.ServiceModel.DataContracts
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.Entity.Model
  [Expand]DevExpress.Entity.ProjectModel
  [Expand]DevExpress.Export
  [Expand]DevExpress.Export.Xl
  [Expand]DevExpress.Map
  [Expand]DevExpress.Mvvm
  [Expand]DevExpress.Mvvm.DataAnnotations
  [Expand]DevExpress.Mvvm.DataModel
  [Expand]DevExpress.Mvvm.ModuleInjection
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.Utils
  [Expand]DevExpress.Mvvm.ViewModel
  [Expand]DevExpress.Office
  [Expand]DevExpress.Office.Crypto
  [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.PivotGrid.Printing
  [Expand]DevExpress.Printing
  [Expand]DevExpress.Printing.Core
  [Expand]DevExpress.Printing.ExportHelpers
  [Expand]DevExpress.ReportServer.Printing
  [Expand]DevExpress.ReportServer.Printing.Services
  [Expand]DevExpress.ReportServer.ServiceModel.Client
  [Expand]DevExpress.ReportServer.ServiceModel.ConnectionProviders
  [Expand]DevExpress.ReportServer.ServiceModel.DataContracts
  [Expand]DevExpress.Schedule
  [Expand]DevExpress.Services
  [Expand]DevExpress.Sparkline
  [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
   [Expand]FormulaEngine Interface
   [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.TreeMap
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Commands
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.Filtering.Internal
  [Expand]DevExpress.Utils.IoC
  [Expand]DevExpress.Utils.Localization
  [Expand]DevExpress.Utils.Serializing.Helpers
  [Expand]DevExpress.WebUtils
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpo
  [Expand]DevExpress.Xpo.DB
  [Expand]DevExpress.Xpo.DB.Exceptions
  [Expand]DevExpress.Xpo.DB.Helpers
  [Expand]DevExpress.Xpo.Exceptions
  [Expand]DevExpress.Xpo.Helpers
  [Expand]DevExpress.Xpo.Metadata
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Localization
  [Expand]DevExpress.XtraCharts.Printing
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraExport.Csv
  [Expand]DevExpress.XtraGauges.Base
  [Expand]DevExpress.XtraGauges.Core
  [Expand]DevExpress.XtraGauges.Core.Base
  [Expand]DevExpress.XtraGauges.Core.Drawing
  [Expand]DevExpress.XtraGauges.Core.Localization
  [Expand]DevExpress.XtraGauges.Core.Model
  [Expand]DevExpress.XtraGauges.Core.Primitive
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraPivotGrid
  [Expand]DevExpress.XtraPivotGrid.Customization
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPivotGrid.Localization
  [Expand]DevExpress.XtraPivotGrid.Selection
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.BarCode
  [Expand]DevExpress.XtraPrinting.Caching
  [Expand]DevExpress.XtraPrinting.DataNodes
  [Expand]DevExpress.XtraPrinting.Drawing
  [Expand]DevExpress.XtraPrinting.Export
  [Expand]DevExpress.XtraPrinting.Export.Web
  [Expand]DevExpress.XtraPrinting.Localization
  [Expand]DevExpress.XtraPrinting.Native
  [Expand]DevExpress.XtraPrinting.Shape
  [Expand]DevExpress.XtraPrinting.Shape.Native
  [Expand]DevExpress.XtraPrinting.WebClientUIControl.DataContracts
  [Expand]DevExpress.XtraPrinting.XamlExport
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports
  [Expand]DevExpress.XtraReports.Design
  [Expand]DevExpress.XtraReports.Parameters
  [Expand]DevExpress.XtraReports.ReportGeneration
  [Expand]DevExpress.XtraReports.UI
  [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.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Compatibility
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.Exchange
  [Expand]DevExpress.XtraScheduler.iCalendar
  [Expand]DevExpress.XtraScheduler.iCalendar.Components
  [Expand]DevExpress.XtraScheduler.Localization
  [Expand]DevExpress.XtraScheduler.Native
  [Expand]DevExpress.XtraScheduler.Outlook
  [Expand]DevExpress.XtraScheduler.Outlook.Interop
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.Tools
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraScheduler.Xml
  [Expand]DevExpress.XtraSpellChecker
  [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]Tools and Utilities
 End-User Documentation

DevExpress.Spreadsheet.Formulas Namespace

Contains classes, interfaces and enumerations required to use the SpreadsheetControl's formula engine.

Expanded Classes

  Class Description
Public class AdditionExpression An arithmetic addition operation.
Public class ArrayConstantExpression An array constant operand.
Public class BinaryOperatorExpression A base class for binary operator expressions.
Public class CellArea Defines the range of cells in a worksheet. Used in cell reference expressions contained in parsed formulas.
Public class CellCalculationArgs Provides data for the ICustomCalculationService.OnBeginCellCalculation method.
Public class CellErrorReferenceExpression Invalid Cell Reference error (#REF!).
Public class CellReferenceExpression A cell range reference used in parsed formula.
Public class ConcatenateExpression An ampersand operator used to concatenate strings.
Public class ConstantExpression A constant value.
Public class DefinedNameReferenceExpression A defined name.
Public class DivisionExpression A division operator.
Public class EqualityExpression An equality operator.
Public class Expression A base class for an expression.
Public class ExpressionContext Contains formula environment information - the cell or range, the worksheet, the current culture, the reference style, and indicates whether the formula is an array formula.
Public class ExpressionVisitor A base class for implementing a custom visitor to traverse the expression tree.
Public class FunctionExpression A built-in or user-defined worksheet function.
Public class FunctionExpressionBase A base class for the functions in formulas.
Public class FunctionExternalExpression An external function.
Public class GreaterExpression A "Greater than" operator.
Public class GreaterOrEqualExpression A "Greater than or equal" operator.
Public class InequalityExpression A inequality operator.
Public class LessExpression A "Less than" operator.
Public class LessOrEqualExpression A "Less than or equal" operator.
Public class MissingArgumentExpression A "Missing argument" error.
Public class MultiplicationExpression A multiplication operator.
Public class ParsedExpression Contains an expression tree and provides methods to handle it.
Public class PercentExpression A percent operator.
Public class PowerExpression An exponentiation operator.
Public class RangeExpression An operator that produces a reference to all cells located between the cells specified as operands.
Public class RangeIntersectionExpression An operator that produces a reference to cells that are included in both references specified as operands.
Public class RangeUnionExpression An operator that produces a reference to cells that are included in both references specified as operands.
Public class ReferenceExpression A base class for expressions that reference cells.
Public class SheetReference A worksheet reference in a formula.
Public class SubtractionExpression A subtraction operator.
Public class TableReferenceExpression A structured reference used for worksheet tables.
Public class UnaryMinusExpression An unary negation operator.
Public class UnaryOperatorExpression A base class for unary operators.
Public class UnaryPlusExpression An unary positive operation.
Public class UnknownFunctionExpression An unrecognized function.

Expanded Interfaces

  Interface Description
Public interface FormulaEngine An object that provides the capability to calculate and parse worksheet formulas.
Public interface IExpression A base interface for expression node.
Public interface IExpressionContext A base interface for an expression context.

Expanded Structures

  Structure Description
Public structure CellReferencePosition Defines the column, row and the reference type (relative or absolute).

Expanded Enumerations

  Enumeration Description
Public enum ExpressionStyle Lists possible ways to interpret and calculate a formula in a worksheet.
Public enum PositionType Lists types of cell references in formulas.
Public enum SheetReferenceType Lists types of the worksheet reference.
Public enum TableRowsRestriction Lists item specifiers used in structured references.
Is this topic helpful?​​​​​​​