Class PivotArea

Represents pivot area.

Inheritance

System.Object

PivotArea

Namespace: Syncfusion.XlsIO.Implementation.PivotTables

Assembly: Syncfusion.XlsIO.NET.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