PivotArea Class
Represents pivot area.
Inheritance
Inherited Members
Namespace: Syncfusion.XlsIO.Implementation.PivotTables
Assembly: Syncfusion.XlsIO.Base.dll
Syntax
public class PivotArea
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 |