Class ExcelPivotTableSlicerCacheTabularData¶

Namespace: OfficeOpenXml.Drawing.Slicer
Assembly: EPPlus.dll

Tabular data for a pivot table slicer cache.

public class ExcelPivotTableSlicerCacheTabularData : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelPivotTableSlicerCacheTabularData

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

CrossFilter¶

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

public eCrossFilter CrossFilter { get; set; }

Property Value¶

eCrossFilter

CustomListSort¶

If custom lists are used when sorting the items

public bool CustomListSort { get; set; }

Property Value¶

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.

public ExcelPivotTableSlicerItemCollection Items { get; }

Property Value¶

ExcelPivotTableSlicerItemCollection

PivotCacheId¶

The pivot table cache id

public int PivotCacheId { get; }

Property Value¶

int

SortOrder¶

How the table slicer items are sorted

public eSortOrder SortOrder { get; set; }

Property Value¶

eSortOrder