FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : AutoFilterMode Enumeration |
'Declaration Public Enum AutoFilterMode Inherits System.Enum
'Usage Dim instance As AutoFilterMode
public enum AutoFilterMode : System.Enum
Member | Description |
---|---|
Enhanced | Displays a menu to work with the automatic filter |
FilterBar | Displays a filter bar to work with the automatic filter |
FilterGadget | Displays a filter gadget to work with the automatic filter |
protected void Page_Load(object sender, System.EventArgs e) { if (this.IsPostBack) return; FpSpread1.Sheets[0].Cells[0, 0, 2, 2].Value = 3; FarPoint.Web.Spread.DynamicFilterItem dy = new FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage); FarPoint.Web.Spread.IRowFilter 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); rowFilter.ColumnDefinitions.Add(fd); FpSpread1.ActiveSheetView.RowFilter = rowFilter; FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName); FpSpread1.ActiveSheetView.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).Cells(0, 0, 2, 2).Value = 3 Dim dy As New FarPoint.Web.Spread.DynamicFilterItem(FarPoint.Web.Spread.DynamicFilterType.AboveAverage) 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) rowFilter.ColumnDefinitions.Add(fd) FpSpread1.ActiveSheetView.RowFilter = rowFilter FpSpread1.ActiveSheetView.AutoFilterColumn(1, dy.DisplayName) FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.Enhanced End Sub
System.Object
System.ValueType
System.Enum
FarPoint.Web.Spread.AutoFilterMode
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6