GrapeCity.Xaml.SpreadSheet.UI
RangeFiltered Event (GcSpreadSheet)
Example 


Occurs when a column has just been automatically sorted.
Syntax
'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.

PropertyDescription
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.
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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options