Spread WPF Documentation
FilterPopupOpening Event (GcSpreadSheet)
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class : FilterPopupOpening Event
Occurs when the filter popup is opening.
Syntax
'Declaration
 
Public Event FilterPopupOpening As System.EventHandler(Of CellCancelEventArgs)
'Usage
 
Dim instance As GcSpreadSheet
Dim handler As System.EventHandler(Of CellCancelEventArgs)
 
AddHandler instance.FilterPopupOpening, handler
public event System.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.

PropertyDescription
(Inherited from System.ComponentModel.CancelEventArgs)
Gets the column index of the cell.  
Gets the row index of the cell.  
Example
This example uses the FilterPopupOpening event.
GrapeCity.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1);
GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;

private void GcSpreadSheet1_FilterPopupOpening(object sender, GrapeCity.Windows.SpreadSheet.UI.CellCancelEventArgs e)
        {
TextBox1.Text = e.Column.ToString();
        }
Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 2, 5, 1)
Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter

Private Sub GcSpreadSheet1_FilterPopupOpening(sender As Object, e As GrapeCity.Windows.SpreadSheet.UI.CellCancelEventArgs) Handles GcSpreadSheet1.FilterPopupOpening
        TextBox1.Text = e.Column.ToString()
    End Sub
See Also