TdxSpreadSheetFormulaOperation Enum

Enumerates operations applied to the formula expression‘s arguments.

Declaration

TdxSpreadSheetFormulaOperation = (
    opAdd,
    opSub,
    opMul,
    opDiv,
    opPower,
    opConcat,
    opLT,
    opLE,
    opEQ,
    opGE,
    opGT,
    opNE,
    opIsect,
    opUnion,
    opRange,
    opUplus,
    opUminus,
    opPercent,
    opParen
);

Members

Name
opAdd
opSub
opMul
opDiv
opPower
opConcat
opLT
opLE
opEQ
opGE
opGT
opNE
opIsect
opUnion
opRange
opUplus
opUminus
opPercent
opParen

Remarks

The list of operations between the formula expression’s arguments includes:

Value	Operator	Operation
opAdd	+	The addition operation.
opSub	-	The subtraction operation.
opMul	*	The multiplication operation.
opDiv	/	The division operation.
opPower	^	The exponentiation operation.
opConcat	&	The concatenation operation.
opLT	<	The less than comparison operation. Returns TRUE if the left operand is less than the right operand.
opLE	<=	The less than or equal operator. Returns TRUE if the left operand is less than or equal to the right operand.
opEQ	=	The equality comparison operation. Returns TRUE if two operands are equal.
opGE	>=	The greater than or equal comparison operation returns TRUE if the left operand is greater than or equal to the right operand.
opGT	>	The greater than comparison operation returns TRUE if the left operand is greater than the right operand.
opNE	<>	The inequality comparison operation. Returns TRUE if two operands are not equal.
opIsect		The intersection operation.
opUnion	,	The union operation. Allows you to provide several arguments to a function.
opRange	:	The range operation. The respective operator is used to separate cell references that specify a cell range.
opUplus		The unary plus, or the unary positive operation.
opUminus	-	The unary minus, or the additive inverse operation.
opPercent	%	Allows the Spreadsheet control to interpret the entered number as a percentage.
opParen

Note

All actual operators invoking the formula operations are listed in the Built-in Operators and Functions topic.