GrapeCity.Documents.Excel.SlicerSortOrder

SlicerSortOrder Enum

Specifies the sort order for slicer items.

Use this enum with slicer-related APIs such as SortItems to control whether items are displayed in ascending or descending order.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum SlicerSortOrder

Public Enum SlicerSortOrder

Examples

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

Fields

Name	Description
Ascending	Specifies ascending sort.
Descending	Specifies descending sort.