Click or drag to resize

DynamicFilterType Enumeration

Represents a dynamic filter type.

Namespace:  GemBox.Spreadsheet
Assembly:  GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 41.3.30.1132
Syntax
public enum DynamicFilterType
Members
  Member nameValueDescription
Null0 Common filter type not available.
AboveAverage1 Shows values that are above average.
BelowAverage2 Shows values that are below average.
LastWeek3 Shows last week's dates.
LastMonth4 Shows last month's dates.
LastQuarter5 Shows last quarter's dates.
LastYear6 Shows last year's dates.
ThisWeek7 Shows this week's dates.
ThisMonth8 Shows this month's dates.
ThisQuarter9 Shows this quarter's dates.
ThisYear10 Shows this year's dates.
NextWeek11 Shows next week's dates.
NextMonth12 Shows next month's dates.
NextQuarter13 Shows next quarter's dates.
NextYear14 Shows next year's dates.
Yesterday15 Shows yesterday's dates.
Today16 Shows today's dates.
Tomorrow17 Shows tomorrow's dates.
YearToDate18 Shows the dates between the beginning of the year and today, inclusive.
Month119 Shows the dates that are in January, regardless of year.
Month220 Shows the dates that are in February, regardless of year.
Month321 Shows the dates that are in March, regardless of year.
Month422 Shows the dates that are in April, regardless of year.
Month523 Shows the dates that are in May, regardless of year.
Month624 Shows the dates that are in June, regardless of year.
Month725 Shows the dates that are in July, regardless of year.
Month826 Shows the dates that are in August, regardless of year.
Month927 Shows the dates that are in September, regardless of year.
Month1028 Shows the dates that are in October, regardless of year.
Month1129 Shows the dates that are in November, regardless of year.
Month1230 Shows the dates that are in December, regardless of year.
Quarter131 Shows the dates that are in the 1st quarter, regardless of year.
Quarter232 Shows the dates that are in the 2nd quarter, regardless of year.
Quarter333 Shows the dates that are in the 3rd quarter, regardless of year.
Quarter434 Shows the dates that are in the 4th quarter, regardless of year.
See Also