Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FilterBarEventArgs Class / Column Property
Example


In This Topic
    Column Property (FilterBarEventArgs)
    In This Topic
    Gets the column index of the cell in filter bar that is clicked.
    Syntax
    'Declaration
     
    Public ReadOnly Property Column As Integer
    'Usage
     
    Dim instance As FilterBarEventArgs
    Dim value As Integer
     
    value = instance.Column
    public int Column {get;}
    Example
    This example uses the FilterBarClick event.
     fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    
    private void fpSpread1_FilterBarClick(object sender, FarPoint.Win.Spread.FilterBarEventArgs e)
            {
                listBox1.Items.Add(e.Button.ToString());
                listBox1.Items.Add(e.Cancel.ToString());
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.View.ToString());
                listBox1.Items.Add(e.X.ToString());
                listBox1.Items.Add(e.Y.ToString());
            }
    fpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    
    Private Sub fpSpread1_FilterBarClick(ByVal sender As System.Object, ByVal e As FarPoint.Win.Spread.FilterBarEventArgs) Handles fpSpread1.FilterBarClick
            ListBox1.Items.Add(e.Button.ToString())
            ListBox1.Items.Add(e.Cancel.ToString())
            ListBox1.Items.Add(e.Column.ToString())
            ListBox1.Items.Add(e.View.ToString())
            ListBox1.Items.Add(e.X.ToString())
            ListBox1.Items.Add(e.Y.ToString())
        End Sub
    See Also