GrapeCity.Xaml.SpreadSheet.UI
Column Property (RangeFilteringEventArgs)
Example 


Gets the index of the column to be automatically filtered.
Syntax
'Declaration
 
Public ReadOnly Property Column As Integer
'Usage
 
Dim instance As RangeFilteringEventArgs
Dim value As Integer
 
value = instance.Column
public int Column {get;}

Property Value

The index of the column to be automatically filtered.
Example
This example uses the Column property.
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

RangeFilteringEventArgs Class
RangeFilteringEventArgs Members

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options