Class PivotItemOptions

Represents a single item in PivotTable field.

Inheritance

System.Object

PivotItemOptions

Namespace: Syncfusion.XlsIO.Implementation.PivotTables

Assembly: Syncfusion.XlsIO.Portable.dll

Syntax

public class PivotItemOptions : Object

Constructors

PivotItemOptions()

Initializes the pivot item options

Declaration

public PivotItemOptions()

Properties

DrillAcross

Gets or sets a Boolean value that indicates whether attribute hierarchies nested next to each other on a PivotTable row or column will offer drilling "across" each other or not.

Declaration

public bool DrillAcross { get; set; }

Property Value

Type
System.Boolean

HasChildItems

Gets or sets a Boolean value that indicates whether the pivot filed item has child items.

Declaration

public bool HasChildItems { get; set; }

Property Value

Type
System.Boolean

IsCalculatedItem

Gets or sets a Boolean value indicating whether this item is a calculated item.

Declaration

public bool IsCalculatedItem { get; set; }

Property Value

Type
System.Boolean

IsChar

True if the item has a character value. False Otherwise.

Declaration

public bool IsChar { get; set; }

Property Value

Type
System.Boolean

IsExpaned

Gets or sets a Boolean value indicating whether this item is expanded in the PivotTable view.

Declaration

public bool IsExpaned { get; set; }

Property Value

Type
System.Boolean

IsHidden

True if the item is hidden. False Otherwise.

Declaration

public bool IsHidden { get; set; }

Property Value

Type
System.Boolean

IsHiddenDetails

Gets or sets a Boolean value that indicates whether the details for this item are hidden.

Declaration

public bool IsHiddenDetails { get; set; }

Property Value

Type
System.Boolean

IsMissing

True if the item has a missing value. False otherwise.

Declaration

public bool IsMissing { get; set; }

Property Value

Type
System.Boolean

ItemType

Gets or sets the type of the item. Value of 'default' indicates a grand total as the last row item value.

Declaration

public PivotItemType ItemType { get; set; }

Property Value

Type
PivotItemType

UserCaption

Gets or sets the user caption of the item.

Declaration

public string UserCaption { get; set; }

Property Value

Type
System.String