SlicerCache.SortItems Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Gets or sets whether the items in the slicer are sorted.

public:
 property Microsoft::Office::Interop::Excel::XlSlicerSort SortItems { Microsoft::Office::Interop::Excel::XlSlicerSort get(); void set(Microsoft::Office::Interop::Excel::XlSlicerSort value); };

public Microsoft.Office.Interop.Excel.XlSlicerSort SortItems { get; set; }

Public Property SortItems As XlSlicerSort

Property Value

XlSlicerSort

A XlSlicerSort object.

Remarks

Read/write.

The default setting of this property is xlAscending.

The SortItems property of the SlicerCache object only applies to slicers that are based on PivotTables that are connected to workbook ranges or lists (SlicerCache.SourceType = xlDatabase). Attempting to access the SortItems property for slicers that are connected to a OLAP data sources (SlicerCache.OLAP = true) generates a run-time error. For OLAP data sources, use the SortItems property of the SlicerCacheLevel object instead.

Applies to