DevExpress.Spreadsheet.Formulas Namespace
Contains classes, interfaces and enumerations required to use the SpreadsheetControl’s formula engine.
Assembly: DevExpress.Spreadsheet.v20.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.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. |