ig.excel.AverageFilter

Represents a filter which can filter data based on whether the data is below or above the average of the entire data 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.
  • average

    .average( );

    Gets the average that was computed the last time the filter was applied or 0 if any errors or all non-numeric values were found when applying the filter.

  • type

    .type( );
    Return Type:
    ig.excel.AverageFilterType
    Return Type Description:
    AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average.

    Gets the value indicating whether to filter in values below or above the average of the data range.

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the AverageFilterType enumeration.
  • type

    .type( value:ig.excel.AverageFilterType );
    Return Type:
    ig.excel.AverageFilterType
    Return Type Description:
    AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average.

    Sets the value indicating whether to filter in values below or above the average of the data range.

    • value
    • Type:ig.excel.AverageFilterType

    Exceptions

    Exception Description
    ig.excel.InvalidEnumArgumentException The value assigned is not defined in the AverageFilterType enumeration.

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