Class ExcelPivotTableSlicerCacheTabularData

Tabular data for a pivot table slicer cache.

Inheritance

object

XmlHelper

ExcelPivotTableSlicerCacheTabularData

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 ExcelPivotTableSlicerCacheTabularData : XmlHelper

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

Items

The items of the slicer. Note that the sort order of this collection is the same as the pivot table field items, not the sortorder of the slicer. Showing/hiding items are reflects to the pivot table(s) field items collection.

Declaration

public ExcelPivotTableSlicerItemCollection Items { get; }

Property Value

Type	Description
ExcelPivotTableSlicerItemCollection

PivotCacheId

The pivot table cache id

Declaration

public int PivotCacheId { get; }

Property Value

Type	Description
int

SortOrder

How the table slicer items are sorted

Declaration

public eSortOrder SortOrder { get; set; }

Property Value

Type	Description
eSortOrder