'Declaration Public Event FilterPopupOpening As EventHandler(Of CellCancelEventArgs)
'Usage Dim instance As GcSpreadSheet Dim handler As EventHandler(Of CellCancelEventArgs) AddHandler instance.FilterPopupOpening, handler
public event EventHandler<CellCancelEventArgs> FilterPopupOpening
Event Data
The event handler receives an argument of type CellCancelEventArgs containing data related to this event. The following CellCancelEventArgs properties provide information specific to this event.
| Property | Description |
|---|---|
| Cancel | (Inherited from System.ComponentModel.CancelEventArgs) |
| Column | Gets the column index of the cell. |
| Row | Gets the row index of the cell. |
Example
This example uses the FilterPopupOpening event.
GrapeCity.Xaml.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 2, 5, 1); GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter(cellrange); gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter; private void GcSpreadSheet1_FilterPopupOpening(object sender, GrapeCity.Xaml.SpreadSheet.UI.CellCancelEventArgs e) { TextBox1.Text = e.Column.ToString(); }
Private Sub Grid_Loaded_1(sender As Object, e As RoutedEventArgs) Dim cellrange As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 2, 5, 1) Dim hideRowFilter As New GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter(cellrange) GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter End Sub Private Sub GcSpreadSheet1_FilterPopupOpening(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.CellCancelEventArgs) Handles GcSpreadSheet1.FilterPopupOpening TextBox1.Text = e.Column.ToString() End Sub
See Also