'Declaration Public Event FilterBarClick As FilterBarClickEventHandler
'Usage Dim instance As FpSpread Dim handler As FilterBarClickEventHandler AddHandler instance.FilterBarClick, handler
public event FilterBarClickEventHandler FilterBarClick
Event Data
The event handler receives an argument of type FilterBarEventArgs containing data related to this event. The following FilterBarEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Button | Gets which mouse button has been pressed. |
| Cancel | Gets or sets whether to cancel default processing. |
| Column | Gets the column index of the cell in filter bar that is clicked. |
| View | Gets the view that contains the filter bar cell that is clicked. |
| X | Gets the x-coordinate of the pointer position. |
| Y | Gets the y-coordinate of the pointer position. |
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