Version

Infragistics.Documents.Excel.Filtering Namespace

Classes
 ClassDescription
ClassAverageFilter Represents a filter which can filter data based on whether the data is below or above the average of the entire data range.
ClassCustomFilter Represents a filter which can filter data based on one or two custom conditions.
ClassCustomFilterCondition A filter condition used in a CustomFilter.
ClassDatePeriodFilter Represents a filter which can filter dates in a specific period.
ClassDateRangeFilter Abstract base class for filters which filter dates based on whether they are within a specified range of dates or not.
ClassDynamicValuesFilter Abstract base class for all filter types which filter data based on a dynamic condition, such as the data present in the filtered data range, the date when the filter was applied, or the date when the filter is evaluated.
ClassFillFilter Represents a filter which will filter cells based on their background fills.
ClassFilter Abstract base class for all filters which filters cells in a worksheet.
ClassFixedDateGroup Represents a fixed range of dates.
ClassFixedDateGroupCollection A collection of fixed date groups.
ClassFixedValuesFilter Represents a filter which can filter cells based on specific, fixed values, which are allowed to display.
ClassFontColorFilter Represents a filter which will filter cells based on their font colors.
ClassIconFilter Represents a filter which can filter cells based on their conditional formatting icon.
ClassRelativeDateRangeFilter Represents a filter which can filter date cells based on dates relative to the when the filter was applied.
ClassTopOrBottomFilter Represents a filter which can filter in cells in the upper or lower portion of the sorted values.
ClassWorksheetFilterSettings Exposes methods to identify a region in the wroksheet and to apply filters and optionally sort criteria to that region.
ClassYearToDateFilter Represents a filter which can filter in date cells if the dates occur between the start of the current year and the time when the filter is evaluated.
Enumerations
 EnumerationDescription
EnumerationAverageFilterType Represents the various types of the AverageFilter.
EnumerationCalendarType Represents the various calendar types available for the FixedValuesFilter
EnumerationConditionalOperator Represents the various logical operators used to combine the conditions of the CustomFilter.
EnumerationDatePeriodFilterType Represents the various date range types which can be filtered by the DatePeriodFilter.
EnumerationExcelComparisonOperator Represents the various comparisons which can be used in the CustomFilterCondition.
EnumerationFixedDateGroupType Represents the various types, or precisions, of a FixedDateGroup.
EnumerationRelativeDateRangeDuration Represents the various durations which can be filtered by the RelativeDateRangeFilter.
EnumerationRelativeDateRangeOffset Represents the various relative date offsets which can be filtered by the RelativeDateRangeFilter.
EnumerationTopOrBottomFilterType Represents the various filter types available for the TopOrBottomFilter.
See Also