Class ExcelTableSlicerCache

Represents a slicer cache with a table as source

Inheritance

object

XmlHelper

ExcelSlicerCache

ExcelTableSlicerCache

Inherited Members

ExcelSlicerCache.SlicerCacheXml

ExcelSlicerCache.Name

ExcelSlicerCache.SourceName

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
bool

HideItemsWithNoData

If true, items that have no data are not displayed

Declaration

public bool HideItemsWithNoData { get; set; }

Property Value

Type	Description
bool

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

ExcelSlicerCache.SourceType

TableColumn

The table column that is the source for the slicer

Declaration

public ExcelTableColumn TableColumn { get; }

Property Value

Type	Description
ExcelTableColumn