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