private void ApplyFilterByMonthAndSortByCompany(object sender, RoutedEventArgs e)
{
this.workbook.History.BeginUndoGroup();
ValuesCollectionFilter valuesCollectionFilter = new ValuesCollectionFilter(1, null, new DateGroupItem[] { new DateGroupItem(2014, 6) });
this.ApplyFilter(valuesCollectionFilter);
ISortCondition[] conditions = new ISortCondition[] { new ValuesSortCondition(4, SortOrder.Ascending) };
this.SetSortState(conditions);
this.workbook.History.EndUndoGroup();
}
private void ApplyFilterByCompanySortByFill(object sender, RoutedEventArgs e)
{
this.workbook.History.BeginUndoGroup();
ValuesCollectionFilter valuesCollectionFilter = new ValuesCollectionFilter(4, new string[] { "Plan Smart" }, null);
this.ApplyFilter(valuesCollectionFilter);
ISortCondition[] conditions = this.GetSortingConditions();
this.SetSortState(conditions);
this.workbook.History.EndUndoGroup();
}
private void FilterByDepartment(string departmentName)
{
worksheet.Filter.FilterRange = new CellRange(5, 1, 31, 4);
string[] valuesToShow = new string[]
{
departmentName,
String.Format("{0} Expenses", departmentName),
"Total Expenses"
};
IFilter departmentFilter = new ValuesCollectionFilter(0, valuesToShow, true);
worksheet.Filter.SetFilter(departmentFilter);
}
public void CreateValuesCollectionFilter()
{
#region radspreadprocessing-features-filtering_0
IEnumerable <string> stringItems = new List <string>()
{
"test", "1%", "1.0"
};
IEnumerable <DateGroupItem> dateItems = new List <DateGroupItem>()
{
new DateGroupItem(2013),
new DateGroupItem(2014, 3)
};
ValuesCollectionFilter filter = new ValuesCollectionFilter(0, stringItems, dateItems, true);
#endregion
}
private void FilterByDepartment(string departmentName)
{
worksheet.Filter.FilterRange = new CellRange(5, 1, 31, 4);
string[] valuesToShow = new string[]
{
departmentName,
String.Format("{0} Expenses", departmentName),
"Total Expenses"
};
IFilter departmentFilter = new ValuesCollectionFilter(0, valuesToShow, true);
worksheet.Filter.SetFilter(departmentFilter);
}
