Class PivotItemOptions

Represents a single item in PivotTable field.

Inheritance
System.Object
PivotItemOptions
Namespace: Syncfusion.XlsIO.Implementation.PivotTables
Assembly: Syncfusion.XlsIO.UWP.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 Description
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 Description
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 Description
System.Boolean

IsChar

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

Declaration
public bool IsChar { get; set; }
Property Value
Type Description
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 Description
System.Boolean

IsHidden

True if the item is hidden. False Otherwise.

Declaration
public bool IsHidden { get; set; }
Property Value
Type Description
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 Description
System.Boolean

IsMissing

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

Declaration
public bool IsMissing { get; set; }
Property Value
Type Description
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 Description
PivotItemType

UserCaption

Gets or sets the user caption of the item.

Declaration
public string UserCaption { get; set; }
Property Value
Type Description
System.String

Extension Methods