Class ExcelTableSlicerCache

Represents a slicer cache with a table as source

Inheritance
Object
XmlHelper
ExcelSlicerCache
ExcelTableSlicerCache
Inherited Members
Object.Equals(Object)
Object.Equals(Object, Object)
Object.GetHashCode()
Object.GetType()
Object.MemberwiseClone()
Object.ReferenceEquals(Object, Object)
Object.ToString()
Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll
Syntax
public class ExcelTableSlicerCache : ExcelSlicerCache

Properties

CrossFilter

How the items that are used in slicer cross filtering are displayed

Declaration
public eCrossFilter CrossFilter { get; set; }
Property Value
Type Description
eCrossFilter

CustomListSort

If custom lists are used when sorting the items

Declaration
public bool CustomListSort { get; set; }
Property Value
Type Description
Boolean

HideItemsWithNoData

If true, items that have no data are not displayed

Declaration
public bool HideItemsWithNoData { get; set; }
Property Value
Type Description
Boolean

SortOrder

How the table slicer items are sorted

Declaration
public eSortOrder SortOrder { get; set; }
Property Value
Type Description
eSortOrder

SourceType

The source type for the slicer cache

Declaration
public override eSlicerSourceType SourceType { get; }
Property Value
Type Description
eSlicerSourceType
Overrides

TableColumn

The table column that is the source for the slicer

Declaration
public ExcelTableColumn TableColumn { get; }
Property Value
Type Description
ExcelTableColumn