Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AutoFilterColumn Method
Column index
Filter
Example


In This Topic
    AutoFilterColumn Method
    In This Topic
    Automatically filters the rows in the specified column according to the specified filter.
    Syntax
    'Declaration
     
    Public Sub AutoFilterColumn( _
       ByVal viewColumn As Integer, _
       ByVal filterString As String _
    ) 
    'Usage
     
    Dim instance As SheetView
    Dim viewColumn As Integer
    Dim filterString As String
     
    instance.AutoFilterColumn(viewColumn, filterString)
    public void AutoFilterColumn( 
       int viewColumn,
       string filterString
    )

    Parameters

    viewColumn
    Column index
    filterString
    Filter
    Example
    This example sets a row filter.
    FpSpread1.Sheets[0].Cells[0, 2].Text = "test";
    FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle();
    FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle();
    instyle.BackColor = Color.Yellow;
    outstyle.BackColor = Color.Aquamarine;
    FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    | FarPoint.Web.Spread.FilterListBehavior.Default);
    FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2);
    FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition();
    FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets[0], instyle, outstyle);
    sf.AddColumn(fcd); 
    sf.AddColumn(fcd1);
    sf.AddColumn(fcd2);
    FpSpread1.Sheets[0].RowFilter = sf;
    FpSpread1.Sheets[0].AutoFilterColumn(2, "test");
    
    FpSpread1.Sheets(0).Cells(0, 2).Text = "test"
    Dim instyle As New FarPoint.Web.Spread.NamedStyle()
    Dim outstyle As New FarPoint.Web.Spread.NamedStyle()
    instyle.BackColor = Color.Yellow
    outstyle.BackColor = Color.Aquamarine
    Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences
    Or FarPoint.Web.Spread.FilterListBehavior.Default)
    Dim fcd1 As New FarPoint.Web.Spread.FilterColumnDefinition(2)
    Dim fcd2 As New FarPoint.Web.Spread.FilterColumnDefinition()
    Dim sf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets(0), instyle, outstyle)
    sf.AddColumn(fcd)
    sf.AddColumn(fcd1) 
    sf.AddColumn(fcd2)
    FpSpread1.Sheets(0).RowFilter = sf
    FpSpread1.Sheets(0).AutoFilterColumn(2, "test")
    
    See Also