DynamicFilterType Enum

Namespace:

GemBox.Spreadsheet

Assembly:

GemBox.Spreadsheet.dll

Represents a dynamic filter type.

• C#
• VB.NET

public enum DynamicFilterType

Public Enum DynamicFilterType

Fields

AboveAverage	Shows values that are above average.
BelowAverage	Shows values that are below average.
LastMonth	Shows last month's dates.
LastQuarter	Shows last quarter's dates.
LastWeek	Shows last week's dates.
LastYear	Shows last year's dates.
Month1	Shows the dates that are in January, regardless of year.
Month10	Shows the dates that are in October, regardless of year.
Month11	Shows the dates that are in November, regardless of year.
Month12	Shows the dates that are in December, regardless of year.
Month2	Shows the dates that are in February, regardless of year.
Month3	Shows the dates that are in March, regardless of year.
Month4	Shows the dates that are in April, regardless of year.
Month5	Shows the dates that are in May, regardless of year.
Month6	Shows the dates that are in June, regardless of year.
Month7	Shows the dates that are in July, regardless of year.
Month8	Shows the dates that are in August, regardless of year.
Month9	Shows the dates that are in September, regardless of year.
NextMonth	Shows next month's dates.
NextQuarter	Shows next quarter's dates.
NextWeek	Shows next week's dates.
NextYear	Shows next year's dates.
Null	Common filter type not available.
Quarter1	Shows the dates that are in the 1st quarter, regardless of year.
Quarter2	Shows the dates that are in the 2nd quarter, regardless of year.
Quarter3	Shows the dates that are in the 3rd quarter, regardless of year.
Quarter4	Shows the dates that are in the 4th quarter, regardless of year.
ThisMonth	Shows this month's dates.
ThisQuarter	Shows this quarter's dates.
ThisWeek	Shows this week's dates.
ThisYear	Shows this year's dates.
Today	Shows today's dates.
Tomorrow	Shows tomorrow's dates.
YearToDate	Shows the dates between the beginning of the year and today, inclusive.
Yesterday	Shows yesterday's dates.