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


In This Topic
    FilterBarMode Property
    In This Topic
    Gets or sets the filter bar mode.
    Syntax
    'Declaration
     
    Public Property FilterBarMode As FilterBarMode
    'Usage
     
    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.
    Example
    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
                Return
            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
                Next
            Next
            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