GrapeCity.Documents.Excel.ISlicerCache.SortItems

SortItems Property

SortItems

Gets or sets the sort order of the items in the slicer.

Use this property to retrieve whether slicer items are currently sorted in ascending or descending order.

Declaration

SlicerSortOrder SortItems { get; set; }

Property SortItems As SlicerSortOrder

Examples

object[,] sourceData = {{"Category"}, {"Fruit"}, {"Vegetables"}};
worksheet.Range["A1:A3"].Value = sourceData;
ITable table = worksheet.Tables.Add(worksheet.Range["A1:A3"], true);
ISlicerCache slicerCache = workbook.SlicerCaches.Add(table, "Category", "categoryCache");
slicerCache.SortItems = SlicerSortOrder.Descending;
SlicerSortOrder sortOrder = slicerCache.SortItems;