FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : AutoFilterMode Property |
'Declaration Public Property AutoFilterMode As AutoFilterMode
'Usage Dim instance As SheetView Dim value As AutoFilterMode instance.AutoFilterMode = value value = instance.AutoFilterMode
public AutoFilterMode AutoFilterMode {get; set;}
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
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