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


In This Topic
    Cancel Property (FilterBarEventArgs)
    In This Topic
    Gets or sets whether to cancel default processing.
    Syntax
    'Declaration
     
    Public Property Cancel As Boolean
    'Usage
     
    Dim instance As FilterBarEventArgs
    Dim value As Boolean
     
    instance.Cancel = value
     
    value = instance.Cancel
    public bool Cancel {get; set;}
    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