Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetColumnAllowFilter Method
Column index
Example


In This Topic
    GetColumnAllowFilter Method
    In This Topic
    Gets whether this column contains a column filter definition.
    Syntax
    'Declaration
     
    Public Function GetColumnAllowFilter( _
       ByVal column As Integer _
    ) As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim value As Boolean
     
    value = instance.GetColumnAllowFilter(column)
    public bool GetColumnAllowFilter( 
       int column
    )

    Parameters

    column
    Column index

    Return Value

    Boolean: true if the specified column allows filtering; false otherwise
    Remarks
    The default is for a column not to allow filtering. Use this method to allow the user to perform filtering of rows by clicking on the filter indicator in a column header.
    Example
    This example returns the column number.
    fpSpread1.ActiveSheet.Columns[2].AllowAutoFilter = true;
    fpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1);
    
    private void button1_Click(object sender, System.EventArgs e)
    {
    bool b = fpSpread1.ActiveSheet.GetColumnAllowFilter(2);
    MessageBox.Show("The column can be filtered is " + b.ToString()); 
    }
    
    
    FpSpread1.ActiveSheet.Columns(2).AllowAutoFilter = True
    FpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1)
    
    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
    System.EventArgs) Handles Button1.Click
    Dim b As Boolean = FpSpread1.ActiveSheet.GetColumnAllowFilter(2)
    MessageBox.Show("The column can be filtered is " & b.ToString())
    End Sub
    See Also