asposecells.api

Class FormatConditionType

Utility class containing constants. Conditional format rule type.

Field Summary
const  intCELL_VALUE
This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
const  intEXPRESSION
This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
const  intTOP_10
This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
const  intUNIQUE_VALUES
This conditional formatting rule highlights unique values in the range.
const  intDUPLICATE_VALUES
This conditional formatting rule highlights duplicated values.
const  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.
const  intNOT_CONTAINS_TEXT
This conditional formatting rule highlights cells that do not contain given text. Equivalent of using SEARCH() sheet function to determine whether the cell contains the text or not.
const  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.
const  intENDS_WITH
This conditional formatting rule highlights cells ending with given text. Equivalent to using the RIGHT() sheet function and comparing values.
const  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.
const  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.
const  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.
const  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.
const  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.
const  intABOVE_AVERAGE
This conditional formatting rule highlights cells that are above or below the average for all values in the range.
const  intCOLOR_SCALE
This conditional formatting rule creates a gradated color scale on the cells.
const  intDATA_BAR
This conditional formatting rule displays a gradated data bar in the range of cells.
const  intICON_SET
This conditional formatting rule applies icons to cells according to their values.
 

    • Field Detail

      • CELL_VALUE

        const int CELL_VALUE
        This conditional formatting rule compares a cell value to a formula calculated result, using an operator.
      • EXPRESSION

        const int EXPRESSION
        This conditional formatting rule contains a formula to evaluate. When the formula result is true, the cell is highlighted.
      • TOP_10

        const int TOP_10
        This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
      • UNIQUE_VALUES

        const int UNIQUE_VALUES
        This conditional formatting rule highlights unique values in the range.
      • DUPLICATE_VALUES

        const int DUPLICATE_VALUES
        This conditional formatting rule highlights duplicated values.
      • CONTAINS_TEXT

        const 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

        const int NOT_CONTAINS_TEXT
        This conditional formatting rule highlights cells that do not contain given text. Equivalent of using SEARCH() sheet function to determine whether the cell contains the text or not.
      • BEGINS_WITH

        const 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

        const 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

        const 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

        const 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

        const 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

        const 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

        const 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

        const int ABOVE_AVERAGE
        This conditional formatting rule highlights cells that are above or below the average for all values in the range.
      • COLOR_SCALE

        const int COLOR_SCALE
        This conditional formatting rule creates a gradated color scale on the cells.
      • DATA_BAR

        const int DATA_BAR
        This conditional formatting rule displays a gradated data bar in the range of cells.
      • ICON_SET

        const int ICON_SET
        This conditional formatting rule applies icons to cells according to their values.