Skip to main content
Row

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

public enum DynamicFilterType

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:

See Also