RangeFiltering Event (GcSpreadSheet)

Visual Basic
C#

'Declaration
 
Public Event RangeFiltering As EventHandler(Of RangeFilteringEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of RangeFilteringEventArgs)
 
AddHandler instance.RangeFiltering, handler

public event EventHandler<RangeFilteringEventArgs> RangeFiltering

The event handler receives an argument of type RangeFilteringEventArgs containing data related to this event. The following RangeFilteringEventArgs properties provide information specific to this event.

Property	Description
Cancel	(Inherited from System.ComponentModel.CancelEventArgs)
Column	Gets the index of the column to be automatically filtered.
FilterValues	Gets the values to filter the column by.

This example uses the RangeFiltering event.

C#

GrapeCity.Xaml.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1);
GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter(cellrange);
gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;

private void gcSpreadSheet1_RangeFiltered(object sender, GrapeCity.Xaml.SpreadSheet.UI.RangeFilteredEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.FilterValues[0].ToString());
        }

private void gcSpreadSheet1_RangeFiltering(object sender, GrapeCity.Xaml.SpreadSheet.UI.RangeFilteringEventArgs e)
        {
            listBox1.Items.Add(e.Column.ToString());
            listBox1.Items.Add(e.FilterValues[0].ToString());
        }

private void gcSpreadSheet1_RangeSorted(object sender, GrapeCity.Xaml.SpreadSheet.UI.RangeSortedEventArgs e)
        {
            listBox1.Items.Add(e.Ascending.ToString());
            listBox1.Items.Add(e.Column.ToString());
        }

private void gcSpreadSheet1_RangeSorting(object sender, GrapeCity.Xaml.SpreadSheet.UI.RangeSortingEventArgs e)
        {
            listBox1.Items.Add(e.Ascending.ToString());
            listBox1.Items.Add(e.Column.ToString());
        }

Target Platforms: Windows Server 2012, Windows RT

Reference

GcSpreadSheet Class
GcSpreadSheet Members