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.