FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : DynamicFilterType Enumeration |
'Declaration Public Enum DynamicFilterType Inherits System.Enum
'Usage Dim instance As DynamicFilterType
public enum DynamicFilterType : System.Enum
Member | Description |
---|---|
AboveAverage | Filters cells whose values are greater than the average value; used for number filter. |
BelowAverage | Filters cells whose values are less than the average value; used for number filter. |
LastMonth | Filters cells whose values are in the last month; used for date filter. |
LastQuarter | Filters cells whose values are in the last quarter; used for date filter. |
LastWeek | Filters cells whose values are in the last week; used for date filter. |
LastYear | Filters cells whose values are in the last year; used for date filter. |
M1 | Filters cells whose values are in January, regardless of year; used for date filter. |
M10 | Filters cells whose values are in October, regardless of year; used for date filter. |
M11 | Filters cells whose values are in November, regardless of year; used for date filter. |
M12 | Filters cells whose values are in December, regardless of year; used for date filter. |
M2 | Filters cells whose values are in February, regardless of year; used for date filter. |
M3 | Filters cells whose values are in March, regardless of year; used for date filter. |
M4 | Filters cells whose values are in April, regardless of year; used for date filter. |
M5 | Filters cells whose values are in May, regardless of year; used for date filter. |
M6 | Filters cells whose values are in June, regardless of year; used for date filter. |
M7 | Filters cells whose values are in July, regardless of year; used for date filter. |
M8 | Filters cells whose values are in August, regardless of year; used for date filter. |
M9 | Filters cells whose values are in September, regardless of year; used for date filter. |
NextMonth | Filters cells whose values are next month; used for date filter. |
NextQuarter | Filters cells whose values are in the next quarter; used for date filter. |
NextWeek | Filters cells whose values are in the next week; used for date filter. |
NextYear | Filters cells whose values are in the next year; used for date filter. |
Q1 | Filters cells whose values are in the first quarter, regardless of year; used for date filter. |
Q2 | Filters cells whose values are in the second quarter, regardless of year; used for date filter. |
Q3 | Filters cells whose values are in the third quarter, regardless of year; used for date filter. |
Q4 | Filters cells whose values are in the fourth quarter, regardless of year; used for date filter. |
ThisMonth | Filters cells whose values are in this month; used for date filter. |
ThisQuarter | Filters cells whose values are in this quarter; used for date filter. |
ThisWeek | Filters cells whose values are in this week; used for date filter. |
ThisYear | Filters cells whose values are in this year; used for date filter. |
Today | Filters cells whose values are equal to today; used for date filter. |
Tomorrow | Filters cells whose values are equal to tomorrow; used for date filter. |
YearToDate | Fitlers cells whose values are between the beginning of the year and today, inclusive; used for date filter. |
Yesterday | Filters cells whose values are equal to yesterday; used for date filter. |
protected void Page_Load(object sender, System.EventArgs e) { if (this.IsPostBack) return; FpSpread1.Sheets[0].RowCount = 5; FpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3; FpSpread1.Sheets[0].Cells[0, 0, 2, 2].BackColor = Color.Red; FpSpread1.Sheets[0].Cells[4, 1].Text = System.DateTime.Now.ToString(); FarPoint.Web.Spread.DynamicFilterItem dy = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage); FarPoint.Web.Spread.ColorFilterItem colorfilter = new FarPoint.Web.Spread.ColorFilterItem(false, Color.Red); FarPoint.Web.Spread.DynamicFilterItem datefilter = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.LastMonth); FarPoint.Web.Spread.HideRowFilter rowFilter = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView); FarPoint.Web.Spread.FilterColumnDefinition fd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom); fd.Filters.Add(dy); fd.Filters.Add(colorfilter); fd.Filters.Add(datefilter); rowFilter.ColumnDefinitions.Add(fd); FpSpread1.ActiveSheetView.RowFilter = rowFilter; FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName); FpSpread1.Sheets[0].AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced;
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If (IsPostBack) Then Return End If FpSpread1.Sheets(0).RowCount = 5 FpSpread1.Sheets(0).Cells(0, 0, 2, 2).Value = 3 FpSpread1.Sheets(0).Cells(0, 0, 2, 2).BackColor = Drawing.Color.Red FpSpread1.Sheets(0).Cells(4, 1).Text = DateTime.Now Dim dy As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage) Dim colorfilter As New FarPoint.Web.Spread.ColorFilterItem(False, Drawing.Color.Red) Dim datefilter As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.LastMonth) Dim rowFilter As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.ActiveSheetView) Dim fd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.Custom) fd.Filters.Add(dy) fd.Filters.Add(colorfilter) fd.Filters.Add(datefilter) rowFilter.ColumnDefinitions.Add(fd) FpSpread1.ActiveSheetView.RowFilter = rowFilter FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName) FpSpread1.Sheets(0).AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced End Sub
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.DynamicFilterType
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional