com.aspose.cells
Class FormatConditionType

java.lang.Object
    extended by com.aspose.cells.FormatConditionType

public class FormatConditionType 
extends java.lang.Object

Utility class containing constants. Conditional format rule type.

Field Summary
static final intCELL_VALUE
           This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
static final intEXPRESSION
           This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
static final intCOLOR_SCALE
           This conditional formatting rule creates a gradated color scale on the cells.
static final intDATA_BAR
           This conditional formatting rule displays a gradated data bar in the range of cells.
static final intICON_SET
           This conditional formatting rule applies icons to cells according to their values.
static final intTOP_10
           This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
static final intUNIQUE_VALUES
           This conditional formatting rule highlights unique values in the range.
static final intDUPLICATE_VALUES
           This conditional formatting rule highlights duplicated values.
static final intCONTAINS_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.
static final intNOT_CONTAINS_TEXT
           This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
static final intBEGINS_WITH
           This conditional formatting rule highlights cells in the range that begin with the given text. Equivalent to using the LEFT() sheet function and comparing values.
static final intENDS_WITH
           This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
static final intCONTAINS_BLANKS
           This conditional formatting rule highlights cells that are completely blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
static final intNOT_CONTAINS_BLANKS
           This conditional formatting rule highlights cells that are not blank. Equivalent of using LEN(TRIM()). This means that if the cell contains only characters that TRIM() would remove, then it is considered blank. An empty cell is also considered blank.
static final intCONTAINS_ERRORS
           This conditional formatting rule highlights cells with formula errors. Equivalent to using ISERROR() sheet function to determine if there is a formula error.
static final intNOT_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.
static final intTIME_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.
static final intABOVE_AVERAGE
           This conditional formatting rule highlights cells that are above or below the average for all values in the range.
 

Field Detail

CELL_VALUE

public static final int CELL_VALUE
This conditional formatting rule compares a cell value to a formula calculated result, using an operator.

EXPRESSION

public static final int EXPRESSION
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.

COLOR_SCALE

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

DATA_BAR

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

ICON_SET

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

TOP_10

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

UNIQUE_VALUES

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

DUPLICATE_VALUES

public static final int DUPLICATE_VALUES
This conditional formatting rule highlights duplicated values.

CONTAINS_TEXT

public static final int 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.

NOT_CONTAINS_TEXT

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

BEGINS_WITH

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

ENDS_WITH

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

CONTAINS_BLANKS

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

NOT_CONTAINS_BLANKS

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

CONTAINS_ERRORS

public static final int 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.

NOT_CONTAINS_ERRORS

public static final int 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.

TIME_PERIOD

public static final int 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.

ABOVE_AVERAGE

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

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.