Documents for Excel, Java Edition Documentation
com.grapecity.documents.excel.expressions Package / OperatorKind Enumeration
In This Topic
    OperatorKind Enumeration
    In This Topic
    Represents formula operators.
    Members
    MemberDescription
    AdditionRepresents the + operator.

    The + operator has the primary purpose of adding two numbers.

    This operator is defined only for @code:double operands, and it always narrows 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 widens its 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 the remainder.

    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:double value.

    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.

    SIZE 
    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

    See Also