:: com :: sun :: star :: sheet ::

unpublished constants group ConditionOperator2
Usage Restrictions
not published
Description
is used to specify the type of XSheetCondition2.

Constants
NONE no condition is specified.  
EQUAL value has to be equal to the specified value.  
NOT_EQUAL the value must not be equal to the specified value.  
GREATER the value has to be greater than the specified value.  
GREATER_EQUAL the value has to be greater than or equal to the specified value.  
LESS the value has to be less than the specified value.  
LESS_EQUAL the value has to be less than or equal to the specified value.  
BETWEEN the value has to be between the two specified values.  
NOT_BETWEEN the value has to be outside of the two specified values.  
FORMULA the specified formula has to give a non-zero result.  
DUPLICATE Conditionally format duplicate values  
NOT_DUPLICATE Conditionally format non-duplicate values  
Constants' Details
NONE
const long NONE = 0;
Description
no condition is specified.
EQUAL
const long EQUAL = 1;
Description
value has to be equal to the specified value.
NOT_EQUAL
const long NOT_EQUAL = 2;
Description
the value must not be equal to the specified value.
GREATER
const long GREATER = 3;
Description
the value has to be greater than the specified value.
GREATER_EQUAL
const long GREATER_EQUAL = 4;
Description
the value has to be greater than or equal to the specified value.
LESS
const long LESS = 5;
Description
the value has to be less than the specified value.
LESS_EQUAL
const long LESS_EQUAL = 6;
Description
the value has to be less than or equal to the specified value.
BETWEEN
const long BETWEEN = 7;
Description
the value has to be between the two specified values.
NOT_BETWEEN
const long NOT_BETWEEN = 8;
Description
the value has to be outside of the two specified values.
FORMULA
const long FORMULA = 9;
Description
the specified formula has to give a non-zero result.
DUPLICATE
const long DUPLICATE = 10;
Description
Conditionally format duplicate values
NOT_DUPLICATE
const long NOT_DUPLICATE = 11;
Description
Conditionally format non-duplicate values
Top of Page