For a list of all members of this type, see WorksheetFilterSettings members.
| Name | Description | |
|---|---|---|
 | ApplyAverageFilter | Applies an AverageFilter to the column. |
| ApplyCustomFilter | Overloaded. Applies a CustomFilter to the column. |
| ApplyDatePeriodFilter | Applies an DatePeriodFilter to the column. |
| ApplyFillFilter | Applies a FillFilter to the column. |
| ApplyFixedValuesFilter | Overloaded. Applies a FixedValuesFilter to the column. |
| ApplyFontColorFilter | Overloaded. Applies a FontColorFilter to the column. |
| ApplyIconFilter | Applies a IconFilter to the column. |
| ApplyRelativeDateRangeFilter | Applies a RelativeDateRangeFilter to the column. |
| ApplyTopOrBottomFilter | Overloaded. Applies a TopOrBottomFilter to the column which will filter in the top 10 values in the list of sorted values. |
| ApplyYearToDateFilter | Applies a YearToDateFilter to the column. |
| ClearFilter | Clears the filter that is applied to a specific column. |
| ClearFilters | Clears all previously applied filters |
| ClearRegion | Clears the region as well as any existing filters and sort criteria |
| GetFilter | Gets the filter that is applied to a specific column. |
| ReapplyFilters | Re-filters all data cells in the filter region based on the applied filters. |
| ReapplySortConditions | Re-sorts all data cells in the region based on the sort conditions. |
| SetRegion | Overloaded. Sets the region where the filter settings should be applied |
View on GitHub