The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
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.v19.1.Core.dll

Declaration

public enum DynamicFilterType
Public Enum DynamicFilterType
public enum DynamicFilterType
Public Enum DynamicFilterType

Members

Name Description
AboveAverage

Shows values which are greater than the average value.

BelowAverage

Shows values which are less than the average value.

LastMonth

Shows dates occurring in the last calendar month.

LastQuarter

Shows dates occurring in the last quarter.

LastWeek

Shows dates occurring in the last week.

LastYear

Shows dates occurring in the last year.

M1

Shows dates occurring in January, 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.

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.

NextMonth

Shows dates occurring in the next calendar month.

NextQuarter

Shows dates occurring in the next quarter.

NextWeek

Shows dates occurring in the next week.

NextYear

Shows dates occurring in the next year.

Null

Does not apply any filter.

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.

ThisMonth

Shows dates in the current month.

ThisQuarter

Shows dates in the current quarter.

ThisWeek

Shows dates in the current week.

ThisYear

Shows dates in the current year.

Today

Shows today's dates.

Tomorrow

Shows tomorrow's dates.

YearToDate

Shows dates occurring between the beginning of the current year and today, inclusive.

Yesterday

Shows yesterday's dates.

See Also