Home  Products  Purchase  Downloads  Demos  Forums  Blogs  Ticket  Wiki  API  Corporate


com.aspose.cells
Interface FormatConditionType


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

CELL_VALUE

static final byte CELL_VALUE
The conditional formatting is based on a cell value.

See Also:
Constant Field Values

EXPRESSION

static final byte EXPRESSION
The conditional formatting is based on an expression.

See Also:
Constant Field Values

COLOR_SCALE

static final byte COLOR_SCALE
This conditional formatting rule creates a gradated color scale on the cells.

See Also:
Constant Field Values

DATA_BAR

static final byte DATA_BAR
This conditional formatting rule displays a gradated data bar in the range of cells.

See Also:
Constant Field Values

ICON_SET

static final byte ICON_SET
This conditional formatting rule applies icons to cells according to their values.

See Also:
Constant Field Values

TOP_10

static final byte TOP_10
This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.

See Also:
Constant Field Values

UNIQUE_VALUES

static final byte UNIQUE_VALUES
This conditional formatting rule highlights unique values in the range.

See Also:
Constant Field Values

DUPLICATE_VALUES

static final byte DUPLICATE_VALUES
This conditional formatting rule highlights duplicated values.

See Also:
Constant Field Values

CONTAINS_TEXT

static final byte CONTAINS_TEXT
This conditional formatting rule highlights cells containing given text. Equivalent to using the SEARCH() sheet function to determine whether the cell contains the text.

See Also:
Constant Field Values

NOT_CONTAINS_TEXT

static final byte NOT_CONTAINS_TEXT
This conditional formatting rule highlights cells that are not blank. Equivalent to using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered as blank. An empty cell is also considered as blank.

See Also:
Constant Field Values

BEGINS_WITH

static final byte BEGINS_WITH
This conditional formatting rule highlights cells in the range that begins with the given text. Equivalent to using the LEFT() sheet function and comparing values.

See Also:
Constant Field Values

ENDS_WITH

static final byte ENDS_WITH
This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.

See Also:
Constant Field Values

CONTAINS_BLANKS

static final byte CONTAINS_BLANKS
This conditional formatting rule highlights cells that are completely blank. Equivalent to using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered as blank. An empty cell is also considered as blank.

See Also:
Constant Field Values

NOT_CONTAINS_BLANKS

static final byte NOT_CONTAINS_BLANKS
This conditional formatting rule highlights cells that are not blank. Equivalent to using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered as blank. An empty cell is also considered as blank.

See Also:
Constant Field Values

CONTAINS_ERRORS

static final byte CONTAINS_ERRORS
This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

See Also:
Constant Field Values

NOT_CONTAINS_ERRORS

static final byte NOT_CONTAINS_ERRORS
This conditional formatting rule highlights cells without formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.

See Also:
Constant Field Values

TIME_PERIOD

static final byte TIME_PERIOD
This conditional formatting rule highlights cells containing dates in the specified time period. The underlying value of the cell is evaluated, therefore the cell does not need to be formatted as a date to be evaluated. For example, with a cell containing the value 38913 the conditional format shall be applied if the rule requires a value of 7/14/2006.

See Also:
Constant Field Values

ABOVE_AVERAGE

static final byte ABOVE_AVERAGE
This conditional formatting rule highlights cells that are above or below the average for all values in the range.

See Also:
Constant Field Values