ig.excel.AverageConditionalFormat

Exposes properties which control the visual attributes of a WorksheetCell based on whether a cell's value is above or below the average or standard deviation for the associated range.

Dependencies

jquery-1.4.4.js
infragistics.util.js
infragistics.ext_collections.js
infragistics.ext_collectionsExtended.js
infragistics.ext_io.js
infragistics.ext_text.js
infragistics.ext_core.js
infragistics.documents.core_core.js
infragistics.ext_ui.js
The current widget has no options.
The current widget has no events.
  • aboveBelow

    .aboveBelow( );
    Return Type:
    ig.excel.FormatConditionAboveBelow
    Return Type Description:
    Returns a FormatConditionAboveBelow.

    Returns a value which determines the manner in which cell values are compared against the average or standard deviation for the associated range.

  • aboveBelow

    .aboveBelow( value:ig.excel.FormatConditionAboveBelow );
    Return Type:
    ig.excel.FormatConditionAboveBelow
    Return Type Description:
    Returns a FormatConditionAboveBelow.

    Sets a value which determines the manner in which cell values are compared against the average or standard deviation for the associated range.

    • value
    • Type:ig.excel.FormatConditionAboveBelow
  • numericStandardDeviation

    .numericStandardDeviation( );

    Returns the numeric standard deviation for this condition. Applicable only when the AverageConditionalFormat.aboveBelow property is set to 'AboveStandardDeviation' or 'BelowStandardDeviation'.

  • numericStandardDeviation

    .numericStandardDeviation( value:number );

    Sets the numeric standard deviation for this condition. Applicable only when the AverageConditionalFormat.aboveBelow property is set to 'AboveStandardDeviation' or 'BelowStandardDeviation'.

    • value
    • Type:number

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