Class ExcelPivotAreaReferenceBase

Base class for pivot area references

Inheritance

System.Object

XmlHelper

ExcelPivotAreaReferenceBase

ExcelPivotAreaDataFieldReference

ExcelPivotAreaReference

Inherited Members

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable

Assembly: EPPlus.dll

Syntax

public abstract class ExcelPivotAreaReferenceBase : XmlHelper

Fields

_pt

Declaration

protected ExcelPivotTable _pt

Field Value

Type	Description
ExcelPivotTable

Properties

AvgSubtotal

If the Average aggregation function is included in the filter.

Declaration

public bool AvgSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

CountASubtotal

If the CountA aggregation function is included in the filter.

Declaration

public bool CountASubtotal { get; set; }

Property Value

Type	Description
System.Boolean

CountSubtotal

If the Count aggregation function is included in the filter.

Declaration

public bool CountSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

DefaultSubtotal

If the default subtotal is included in the filter.

Declaration

public bool DefaultSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

MaxSubtotal

If the Maximum aggregation function is included in the filter.

Declaration

public bool MaxSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

MinSubtotal

If the Minimum aggregation function is included in the filter.

Declaration

public bool MinSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

ProductSubtotal

If the Product aggregation function is included in the filter.

Declaration

public bool ProductSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

Selected

If this field has selection. This property is used when the pivot table is in outline view. It is also used when both header and data cells have selection.

Declaration

public bool Selected { get; set; }

Property Value

Type	Description
System.Boolean

StdDevPSubtotal

If the population standard deviation aggregation function is included in the filter.

Declaration

public bool StdDevPSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

StdDevSubtotal

If the standard deviation aggregation function is included in the filter.

Declaration

public bool StdDevSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

SumSubtotal

If the sum aggregation function is included in the filter.

Declaration

public bool SumSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

VarPSubtotal

If the population variance aggregation function is included in the filter.

Declaration

public bool VarPSubtotal { get; set; }

Property Value

Type	Description
System.Boolean

VarSubtotal

If the variance aggregation function is included in the filter.

Declaration

public bool VarSubtotal { get; set; }

Property Value

Type	Description
System.Boolean