DynamicFilterType Enum
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.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Members
| 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. |
Related API Members
The following properties accept/return DynamicFilterType values: