Skip to main content

DevExpress.Spreadsheet.Formulas Namespace

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

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Classes

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

Interfaces

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

Structs

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

Enums

Name Description
ExpressionStyle Lists possible ways to interpret and calculate a formula in a worksheet.
PositionType Lists types of cell references in formulas.
SheetReferenceType Lists types of the worksheet reference.
TableRowsRestriction Lists item specifiers used in structured references.