TdxSpreadSheetFormulaOperation Enum
In This Article
Enumerates operations applied to the formula expression‘s arguments.
#Declaration
Delphi
TdxSpreadSheetFormulaOperation = (
opAdd,
opSub,
opMul,
opDiv,
opPower,
opConcat,
opLT,
opLE,
opEQ,
opGE,
opGT,
opNE,
opIsect,
opUnion,
opRange,
opUplus,
opUminus,
opPercent,
opParen
);
#Members
Name |
---|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
op
|
#Remarks
The list of operations between the formula expression’s arguments includes:
Value | Operator | Operation |
---|---|---|
op |
+ | The addition operation. |
op |
- | The subtraction operation. |
op |
* | The multiplication operation. |
op |
/ | The division operation. |
op |
^ | The exponentiation operation. |
op |
& | The concatenation operation. |
op |
< | The less than comparison operation. Returns TRUE if the left operand is less than the right operand. |
op |
<= | The less than or equal operator. Returns TRUE if the left operand is less than or equal to the right operand. |
op |
= | The equality comparison operation. Returns TRUE if two operands are equal. |
op |
>= | The greater than or equal comparison operation returns TRUE if the left operand is greater than or equal to the right operand. |
op |
> | The greater than comparison operation returns TRUE if the left operand is greater than the right operand. |
op |
<> | The inequality comparison operation. Returns TRUE if two operands are not equal. |
op |
The intersection operation. | |
op |
, | The union operation. Allows you to provide several arguments to a function. |
op |
: | The range operation. The respective operator is used to separate cell references that specify a cell range. |
op |
The unary plus, or the unary positive operation. | |
op |
- | The unary minus, or the additive inverse operation. |
op |
% | Allows the Spreadsheet control to interpret the entered number as a percentage. |
op |
Note
All actual operators invoking the formula operations are listed in the Built-in Operators and Functions topic.
See Also