RangeFiltered Event (GcSpreadSheet)

Occurs when a column has just been automatically sorted.

Syntax

Visual Basic
C#

'Declaration
 
Public Event RangeFiltered As EventHandler(Of RangeFilteredEventArgs)

'Usage
 
Dim instance As GcSpreadSheet
Dim handler As EventHandler(Of RangeFilteredEventArgs)
 
AddHandler instance.RangeFiltered, handler

public event EventHandler<RangeFilteredEventArgs> RangeFiltered

Event Data

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

Property	Description
Column	Gets the index of the column that was automatically filtered.
FilterValues	Gets the values to filter the column by.

Example

This example uses the RangeFiltered event.

C#
VB.NET

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());
        }

Dim cellrange As New GrapeCity.Xaml.SpreadSheet.Data.CellRange(0, 0, 5, 1)
Dim hideRowFilter As New GrapeCity.Xaml.SpreadSheet.Data.HideRowFilter(cellrange)
GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
 
    Private Sub GcSpreadSheet1_RangeFiltered(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.RangeFilteredEventArgs) Handles GcSpreadSheet1.RangeFiltered
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.FilterValues(0).ToString())
    End Sub

    Private Sub GcSpreadSheet1_RangeFiltering(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.RangeFilteringEventArgs) Handles GcSpreadSheet1.RangeFiltering
        ListBox1.Items.Add(e.Column.ToString())
        ListBox1.Items.Add(e.FilterValues(0).ToString())
    End Sub

    Private Sub GcSpreadSheet1_RangeSorted(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.RangeSortedEventArgs) Handles GcSpreadSheet1.RangeSorted
        ListBox1.Items.Add(e.Ascending.ToString())
        ListBox1.Items.Add(e.Column.ToString())
    End Sub

    Private Sub GcSpreadSheet1_RangeSorting(sender As Object, e As GrapeCity.Xaml.SpreadSheet.UI.RangeSortingEventArgs) Handles GcSpreadSheet1.RangeSorting
        ListBox1.Items.Add(e.Ascending.ToString())
        ListBox1.Items.Add(e.Column.ToString())
    End Sub

Reference

GcSpreadSheet Class
GcSpreadSheet Members

Product Support Forum | Print this page