FilterPopupOpening Event (GcSpreadSheet)

Visual Basic
C#

'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

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.

This example uses the FilterPopupOpening event.

C#
VB.NET

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

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members