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