Class PivotItemOptions
Represents a single item in PivotTable field.
Inheritance
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 |
---|
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 |