ig.excel.FormatConditionType

Constants which determine the criteria for a format condition.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_core.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
  • average

    Type:
    ig.excel.FormatConditionType
    Default:
    11

    Cells with values which are greater than or less than the average value for the associated region are formatted.

  • blanks

    Type:
    ig.excel.FormatConditionType
    Default:
    9

    Cells with no value are formatted. Note that foreground-related properties such as font colors are not applicable.

  • cellValue

    Type:
    ig.excel.FormatConditionType
    Default:
    0

    The format is based on the cell's value, which is evaluated against one or more conditions to determine whether the value meets a particular criteria.

  • colorScale

    Type:
    ig.excel.FormatConditionType
    Default:
    2

    Represents a conditional formatting rule which applies gradations to cell colors to indicate relative differences in the values of cells which belong to the associated range.

  • dataBar

    Type:
    ig.excel.FormatConditionType
    Default:
    3

    Represents a conditional formatting rule which renders a color bar inside the cell to indicate relative differences in the values of cells which belong to the associated range.

  • duplicateValues

    Type:
    ig.excel.FormatConditionType
    Default:
    7

    Cells with values which are duplicated (non-unique) across the associated range are formatted.

  • errors

    Type:
    ig.excel.FormatConditionType
    Default:
    13

    The format is applied to cells which contain an error.

  • expression

    Type:
    ig.excel.FormatConditionType
    Default:
    1

    The format is determined by evaluating a formula.

  • iconSets

    Type:
    ig.excel.FormatConditionType
    Default:
    5

    Represents a conditional formatting rule which displays an icon inside the cell which indicates the cell's value as relative to the highest and lowest value in the associated range.

  • noBlanks

    Type:
    ig.excel.FormatConditionType
    Default:
    12

    Cells with a non-empty value are formatted.

  • noErrors

    Type:
    ig.excel.FormatConditionType
    Default:
    14

    The format is applied to cells which do not contain an error.

  • rank

    Type:
    ig.excel.FormatConditionType
    Default:
    4

    Cells with the top/bottom n values are formatted, where n represents a numeric, percentage, or percentile ranking. For example, this type can be used to to enable a 'top ten' condition.

  • textString

    Type:
    ig.excel.FormatConditionType
    Default:
    8

    The format is determined by whether the cell's value matches a literal string value.

  • timePeriod

    Type:
    ig.excel.FormatConditionType
    Default:
    10

    The format is determined by whether a cell's date value falls within a given period of time.

  • uniqueValues

    Type:
    ig.excel.FormatConditionType
    Default:
    6

    Cells with values which are unique across the associated range are formatted.

The current widget has no events.
The current widget has no public methods.

Copyright © 1996 - 2022 Infragistics, Inc. All rights reserved.