officefileapi-devexpress-dot-spreadsheet-d0ae8bf9.md
Lists the types of dynamic filter, i.e. a filter whose results may depend on the data to which it is applied or the current date.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public enum DynamicFilterType
Public Enum DynamicFilterType
| Name | Description |
|---|---|
Null |
Does not apply any filter.
|
| AboveAverage |
Shows values which are greater than the average value.
|
| BelowAverage |
Shows values which are less than the average value.
|
| Tomorrow |
Shows tomorrow’s dates.
|
| Today |
Shows today’s dates.
|
| Yesterday |
Shows yesterday’s dates.
|
| NextWeek |
Shows dates occurring in the next week.
|
| ThisWeek |
Shows dates in the current week.
|
| LastWeek |
Shows dates occurring in the last week.
|
| NextMonth |
Shows dates occurring in the next calendar month.
|
| ThisMonth |
Shows dates in the current month.
|
| LastMonth |
Shows dates occurring in the last calendar month.
|
| NextQuarter |
Shows dates occurring in the next quarter.
|
| ThisQuarter |
Shows dates in the current quarter.
|
| LastQuarter |
Shows dates occurring in the last quarter.
|
| NextYear |
Shows dates occurring in the next year.
|
| ThisYear |
Shows dates in the current year.
|
| LastYear |
Shows dates occurring in the last year.
|
| YearToDate |
Shows dates occurring between the beginning of the current year and today, inclusive.
|
| Q1 |
Shows dates occurring in the 1st quarter, regardless of year.
|
| Q2 |
Shows dates occurring in the 2nd quarter, regardless of year.
|
| Q3 |
Shows dates occurring in the 3rd quarter, regardless of year.
|
| Q4 |
Shows dates occurring in the 4th quarter, regardless of year.
|
| M1 |
Shows dates occurring in January, regardless of the year.
|
| M2 |
Shows dates occurring in February, regardless of the year.
|
| M3 |
Shows dates occurring in March, regardless of the year.
|
| M4 |
Shows dates occurring in April, regardless of the year.
|
| M5 |
Shows dates occurring in May, regardless of the year.
|
| M6 |
Shows dates occurring in June, regardless of the year.
|
| M7 |
Shows dates occurring in July, regardless of the year.
|
| M8 |
Shows dates occurring in August, regardless of the year.
|
| M9 |
Shows dates occurring in September, regardless of the year.
|
| M10 |
Shows dates occurring in October, regardless of the year.
|
| M11 |
Shows dates occurring in November, regardless of the year.
|
| M12 |
Shows dates occurring in December, regardless of the year.
|
The following properties accept/return DynamicFilterType values:
See Also