Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FilterBar Class / FilterBarMode Property

In This Topic
    FilterBarMode Property
    In This Topic
    Gets or sets the filter bar mode.
    Public Property FilterBarMode As FilterBarMode
    Dim instance As FilterBar
    Dim value As FilterBarMode
    instance.FilterBarMode = value
    value = instance.FilterBarMode
    public FilterBarMode FilterBarMode {get; set;}

    Property Value

    The filter bar mode.
    This example sets the FilterBarMode property.
    protected void Page_Load(object sender, EventArgs e)
                if (IsPostBack) return;
                for (int i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++)
                    for (int j = 0; j < FpSpread1.ActiveSheetView.ColumnCount; j++)
                        FpSpread1.ActiveSheetView.Cells[i, j].Value = i + j;
                FarPoint.Web.Spread.FilterBarCellType fbc = new FarPoint.Web.Spread.FilterBarCellType();
                fbc.MenuType = FarPoint.Web.Spread.FilterMenuType.Auto;
                FpSpread1.ActiveSheetView.FilterBar.DefaultStyle.CellType = fbc;
                FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar;
                FpSpread1.ActiveSheetView.FilterBar.FilterBarMode = FarPoint.Web.Spread.FilterBarMode.Dynamic;
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
            If (IsPostBack) Then
            End If        
            For i As Integer = 0 To FpSpread1.ActiveSheetView.RowCount - 1
                For j As Integer = 0 To FpSpread1.ActiveSheetView.ColumnCount - 1
                    FpSpread1.ActiveSheetView.Cells(i, j).Value = i + j
            Dim fbc As New FarPoint.Web.Spread.FilterBarCellType()
            fbc.MenuType = FarPoint.Web.Spread.FilterMenuType.Auto
            FpSpread1.ActiveSheetView.FilterBar.DefaultStyle.CellType = fbc
            FpSpread1.ActiveSheetView.AutoFilterMode = FarPoint.Web.Spread.AutoFilterMode.FilterBar
            FpSpread1.ActiveSheetView.FilterBar.FilterBarMode = FarPoint.Web.Spread.FilterBarMode.Dynamic
        End Sub
    See Also