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
|
|
Copyright © 2020, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.