Document Solutions for Excel, Java Edition | Document Solutions
com.grapecity.documents.excel.expressions Package / OperatorKind Enumeration
In This Topic
OperatorKind Enumeration
In This Topic
Represents formula operators.
Members
MemberDescription

The + operator has the primary purpose of adding two numbers.
This operator is defined only for @code:double operands, and it alwaysnarrows its operands to @code:double.
Syntax:
@code:expression1 + expression2 or @code:+expression2
Parts:
@code:expression1: Optional. Any numeric or string expression.
@code:expression2: Required. Any numeric or string expression.

ConcatenateRepresents the & operator.

Concatenation operators join multiple strings into a single string. The & operator is defined only for @code:string operands, and it always widensits operands to @code:string.
Syntax:
@code:expression1 & expression2
Parts:
@code:expression1: Required. Any expression with a data type that widens to String.
@code:expression2: Required. Any expression with a data type that widens to String.

DivisionRepresents the / operator.

Divides two numbers and returns a floating-point result, including any remainder.
The @code:QUOTIENT function returns the integer quotient, which drops theremainder.
Syntax:
@code:expression1 / expression2
Parts:
@code:expression1: Required. Any numeric or string expression.
@code:expression2: Required. Any numeric or string expression.

EqualityRepresents the = operator.

The equality operator compares two expressions to determine whether or not they are equal.
Syntax:
@code:expression1 = expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

ExponentRepresents the ^ operator.

Raises a number to the power of another number, always as a @code:doublevalue.
Syntax:
@code:number ^ exponent
Parts:
@code:number: Required. Any numeric or string expression.
@code:exponent: Required. Any numeric or string expression.

GreaterThanRepresents the > operator.

The greater than operator compares two expressions to determine whether the left side is greater than the right side.
Syntax:
@code:expression1 > expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

GreaterThanOrEqualRepresents the >= operator.

The greater than operator compares two expressions to determine whether the left side is greater than or equal to the right side.
Syntax:
@code:expression1 >= expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

InequalityRepresents the <> operator.

The inequality operator compares two expressions to determine whether they are not equal.
Syntax:
@code:expression1 <> expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

IntersectionRepresents the (space) operator.

The intersection operator gives reference to those cells which are common in two range arguments.
Syntax:
@code:range1 range2
Parts:
@code:range1: Required. Must be a range expression.
@code:range2: Required. Must be a range expression.

LessThanRepresents the < operator.

The less than operator compares two expressions to determine whether the left side is less than the right side.
Syntax:
@code:expression1 < expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

LessThanOrEqualRepresents the <= operator.

The less than or equal operator compares two expressions to determine whether the left side is less than or equal to the right side.
Syntax:
@code:expression1 <= expression2
Parts:
@code:expression1: Required. Any expression.
@code:expression2: Required. Any expression.

MultiplyRepresents the * operator.

Multiplies two numbers.
Syntax:
@code:expression1 * expression2
Parts:
@code:expression1: Required. Any numeric or string expression.
@code:expression2: Required. Any numeric or string expression.

PercentageRepresents the % operator.

Divides a number by 100.
Syntax:
@code:expression1%
Parts:
@code:expression1: Required. Any numeric or string expression.

RangeRepresents the : operator.

The range operator gives a range of cells within start point and end point reference cells.
Syntax:
@code:range1:range2
Parts:
@code:range1: Required. Must be a range expression.
@code:range2: Required. Must be a range expression.

SingleRepresents the £À operator.
Aggregates a range of cells spilled by Dynamic Array functions into a single cell.
Syntax:
@code:@expression
Parts:
@code:expression: Required. Any range or function call expression.
SpillRepresents the # operator.

Refers to a range of cells spilled from the specific cell.
Syntax:
@code:expression#
Parts:
@code:expression: Required. Any cell reference expression.

SubtractionRepresents the - operator.

Returns the difference between two numeric expressions or the negative value of a numeric expression.
Syntax:
@code:expression1 - expression2 or @code:-expression2
Parts:
@code:expression1: Optional. Any numeric or string expression.
@code:expression2: Required. Any numeric or string expression.

UnionRepresents the @code:, operator.

The union operator combines two or more than two references into a single reference.
Syntax:
@code:range1,range2
Parts:
@code:range1: Required. Must be a range expression.
@code:range2: Required. Must be a range expression.

Inheritance Hierarchy

java.lang.Object
java.lang.Enum
com.grapecity.documents.excel.expressions.OperatorKind