![]() |
||
Home Products Purchase Downloads Demos Forums Blogs Ticket Wiki API Corporate |
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface FormatConditionType
Represents conditional format type constants.
Field Summary | |
---|---|
static byte |
ABOVE_AVERAGE
This conditional formatting rule highlights cells that are above or below the average for all values in the range. |
static byte |
BEGINS_WITH
This conditional formatting rule highlights cells in the range that begins with the given text. |
static byte |
CELL_VALUE
The conditional formatting is based on a cell value. |
static byte |
COLOR_SCALE
This conditional formatting rule creates a gradated color scale on the cells. |
static byte |
CONTAINS_BLANKS
This conditional formatting rule highlights cells that are completely blank. |
static byte |
CONTAINS_ERRORS
This conditional formatting rule highlights cells with formula errors. |
static byte |
CONTAINS_TEXT
This conditional formatting rule highlights cells containing given text. |
static byte |
DATA_BAR
This conditional formatting rule displays a gradated data bar in the range of cells. |
static byte |
DUPLICATE_VALUES
This conditional formatting rule highlights duplicated values. |
static byte |
ENDS_WITH
This conditional formatting rule highlights cells ending with given text. |
static byte |
EXPRESSION
The conditional formatting is based on an expression. |
static byte |
ICON_SET
This conditional formatting rule applies icons to cells according to their values. |
static byte |
NOT_CONTAINS_BLANKS
This conditional formatting rule highlights cells that are not blank. |
static byte |
NOT_CONTAINS_ERRORS
This conditional formatting rule highlights cells without formula errors. |
static byte |
NOT_CONTAINS_TEXT
This conditional formatting rule highlights cells that are not blank. |
static byte |
TIME_PERIOD
This conditional formatting rule highlights cells containing dates in the specified time period. |
static byte |
TOP_10
This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified. |
static byte |
UNIQUE_VALUES
This conditional formatting rule highlights unique values in the range. |
Field Detail |
---|
static final byte CELL_VALUE
static final byte EXPRESSION
static final byte COLOR_SCALE
static final byte DATA_BAR
static final byte ICON_SET
static final byte TOP_10
static final byte UNIQUE_VALUES
static final byte DUPLICATE_VALUES
static final byte CONTAINS_TEXT
static final byte NOT_CONTAINS_TEXT
static final byte BEGINS_WITH
static final byte ENDS_WITH
static final byte CONTAINS_BLANKS
static final byte NOT_CONTAINS_BLANKS
static final byte CONTAINS_ERRORS
static final byte NOT_CONTAINS_ERRORS
static final byte TIME_PERIOD
static final byte ABOVE_AVERAGE
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |