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

constants group ConditionFormatOperator

Constants
EQUAL  
LESS  
GREATER  
LESS_EQUAL  
GREATER_EQUAL  
NOT_EQUAL  
BETWEEN  
NOT_BETWEEN  
DUPLICATE  
UNIQUE  
TOP_N_ELEMENTS  
BOTTOM_N_ELEMENTS  
TOP_N_PERCENT  
BOTTOM_N_PERCENT  
ABOVE_AVERAGE  
BELOW_AVERAGE  
ABOVE_EQUAL_AVERAGE  
BELOW_EQUAL_AVERAGE  
ERROR  
NO_ERROR  
BEGINS_WITH  
ENDS_WITH  
CONTAINS  
NOT_CONTAINS  
EXPRESSION  
Constants' Details
EQUAL
const long EQUAL = 0;
LESS
const long LESS = 1;
GREATER
const long GREATER = 2;
LESS_EQUAL
const long LESS_EQUAL = 3;
GREATER_EQUAL
const long GREATER_EQUAL = 4;
NOT_EQUAL
const long NOT_EQUAL = 5;
BETWEEN
const long BETWEEN = 6;
NOT_BETWEEN
const long NOT_BETWEEN = 7;
DUPLICATE
const long DUPLICATE = 8;
UNIQUE
const long UNIQUE = 9;
TOP_N_ELEMENTS
const long TOP_N_ELEMENTS = 10;
BOTTOM_N_ELEMENTS
const long BOTTOM_N_ELEMENTS = 11;
TOP_N_PERCENT
const long TOP_N_PERCENT = 12;
BOTTOM_N_PERCENT
const long BOTTOM_N_PERCENT = 13;
ABOVE_AVERAGE
const long ABOVE_AVERAGE = 14;
BELOW_AVERAGE
const long BELOW_AVERAGE = 15;
ABOVE_EQUAL_AVERAGE
const long ABOVE_EQUAL_AVERAGE = 16;
BELOW_EQUAL_AVERAGE
const long BELOW_EQUAL_AVERAGE = 17;
ERROR
const long ERROR = 18;
NO_ERROR
const long NO_ERROR = 19;
BEGINS_WITH
const long BEGINS_WITH = 20;
ENDS_WITH
const long ENDS_WITH = 21;
CONTAINS
const long CONTAINS = 22;
NOT_CONTAINS
const long NOT_CONTAINS = 23;
EXPRESSION
const long EXPRESSION = 24;
Top of Page