SlicerCache.SortUsingCustomLists 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 items in the specified slicer cache will be sorted by the custom lists.

public:
 property bool SortUsingCustomLists { bool get(); void set(bool value); };

public bool SortUsingCustomLists { get; set; }

Public Property SortUsingCustomLists As Boolean

Property Value

Boolean

true if items in the specified slicer cache will be sorted by the custom lists; otherwise, false.

Remarks

Read/write.

The SortUsingCustomLists property corresponds to the setting of the Use Custom Lists when sorting check box of the Slicer Settings dialog box. To access the custom lists associated with the current installation of Excel, click the File tab, click Options, click Advanced, and then click Edit Custom Lists under the General category.

The SortUsingCustomLists property only applies to slicers that are filtering non-OLAP data sources. Attempting to access this property from a slicer cache that is filtering an OLAP data source (SlicerCache.OLAP = true) generates a run-time error.

Applies to