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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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