Spread Windows Forms 11.0 Product Documentation
Cancel Property (FilterBarEventArgs)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FilterBarEventArgs Class : Cancel Property
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

Reference

FilterBarEventArgs Class
FilterBarEventArgs Members