Class PivotArea

Represents pivot area.

Inheritance
System.Object
PivotArea
Namespace: Syncfusion.XlsIO.Implementation.PivotTables
Assembly: Syncfusion.XlsIO.UWP.dll
Syntax
public class PivotArea : Object

Constructors

PivotArea(PivotCacheFieldImpl)

Initializes the PivotArea

Declaration
public PivotArea(PivotCacheFieldImpl cacheField)
Parameters
Type Name Description
PivotCacheFieldImpl cacheField

Properties

AreaType

Gets or sets the type of the selection rule.

Declaration
public PivotAreaType AreaType { get; set; }
Property Value
Type
PivotAreaType

Axis

Gets or sets the region of the PivotTable to which this rule applies.

Declaration
public PivotAxisTypes Axis { get; set; }
Property Value
Type
PivotAxisTypes

FieldIndex

Gets or sets the index of the field that this selection rule refers to.

Declaration
public int FieldIndex { get; set; }
Property Value
Type
System.Int32

FieldPosition

Gets or sets the position of the field within the axis to which this rule applies.

Declaration
public int FieldPosition { get; set; }
Property Value
Type
System.Int32

HasColumnGrand

Gets or sets a flag indicating whether the column grand total is included.

Declaration
public bool HasColumnGrand { get; set; }
Property Value
Type
System.Boolean

HasRowGrand

Gets or sets a flag indicating whether the row grand total is included.

Declaration
public bool HasRowGrand { get; set; }
Property Value
Type
System.Boolean

IsCacheIndex

Gets or sets a flag indicating whether any indexes refer to fields or items in the Pivot cache and not the view.

Declaration
public bool IsCacheIndex { get; set; }
Property Value
Type
System.Boolean

IsDataOnly

Gets or sets a flag indicating whether only the data values (in the data area of the view) for an item selection are selected and does not include the item labels.

Declaration
public bool IsDataOnly { get; set; }
Property Value
Type
System.Boolean

IsLableOnly

Gets or sets a flag indicating whether only the item labels for an item selection are selected and does not include the data values (in the data area of the view).

Declaration
public bool IsLableOnly { get; set; }
Property Value
Type
System.Boolean

IsOutline

Gets or sets a flag indicating whether the rule refers to an area that is in outline mode.

Declaration
public bool IsOutline { get; set; }
Property Value
Type
System.Boolean

IsSubtotal

Gets or sets a flag indicating whether any indexes refer to fields or items in the Pivot cache and not the view.

Declaration
public bool IsSubtotal { get; set; }
Property Value
Type
System.Boolean

Range

Declaration
public IRange Range { get; set; }
Property Value
Type
IRange

Extension Methods