ig.excel.FormatConditionAboveBelow

Constants which specify the manner in which cell values are compared when evaluating a AverageConditionalFormat.

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
  • aboveAverage

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    0

    The cell value must be above the average for the associated range in order to meet the associated condition.

  • aboveStandardDeviation

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    4

    The cell value must be above the standard deviation for the associated range in order to meet the associated condition.

  • belowAverage

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    1

    The cell value must be below the average for the associated range in order to meet the associated condition.

  • belowStandardDeviation

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    5

    The cell value must be below the standard deviation for the associated range in order to meet the associated condition.

  • equalAboveAverage

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    2

    The cell value must be equal to or above the average for the associated range in order to meet the associated condition.

  • equalBelowAverage

    Type:
    ig.excel.FormatConditionAboveBelow
    Default:
    3

    The cell value must be equal to or below the average for the associated range in order to meet the associated condition.

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

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