Spread WPF 14
GrapeCity.Windows.SpreadSheet.UI Namespace / RangeFilteringEventArgs Class / Column Property
Example


In This Topic
    Column Property (RangeFilteringEventArgs)
    In This Topic
    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.Windows.SpreadSheet.Data.CellRange cellrange = new GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1);
    GrapeCity.Windows.SpreadSheet.Data.HideRowFilter hideRowFilter = new GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange);
    gcSpreadSheet1.Sheets[0].RowFilter = hideRowFilter;
    
    private void gcSpreadSheet1_RangeFiltered(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeFilteredEventArgs e)
            {
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.FilterValues[0].ToString());
            }
    
    private void gcSpreadSheet1_RangeFiltering(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeFilteringEventArgs e)
            {
                listBox1.Items.Add(e.Column.ToString());
                listBox1.Items.Add(e.FilterValues[0].ToString());
            }
    
    private void gcSpreadSheet1_RangeSorted(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeSortedEventArgs e)
            {
                listBox1.Items.Add(e.Ascending.ToString());
                listBox1.Items.Add(e.Column.ToString());
            }
    
    private void gcSpreadSheet1_RangeSorting(object sender, GrapeCity.Windows.SpreadSheet.UI.RangeSortingEventArgs e)
            {
                listBox1.Items.Add(e.Ascending.ToString());
                listBox1.Items.Add(e.Column.ToString());
            }
    Dim cellrange As New GrapeCity.Windows.SpreadSheet.Data.CellRange(0, 0, 5, 1)
    Dim hideRowFilter As New GrapeCity.Windows.SpreadSheet.Data.HideRowFilter(cellrange)
    GcSpreadSheet1.Sheets(0).RowFilter = hideRowFilter
     
        Private Sub GcSpreadSheet1_RangeFiltered(sender As System.Object, e As GrapeCity.Windows.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 System.Object, e As GrapeCity.Windows.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 System.Object, e As GrapeCity.Windows.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 System.Object, e As GrapeCity.Windows.SpreadSheet.UI.RangeSortingEventArgs) Handles GcSpreadSheet1.RangeSorting
            ListBox1.Items.Add(e.Ascending.ToString())
            ListBox1.Items.Add(e.Column.ToString())
        End Sub
    See Also