Class ExcelPivotAreaReferenceBase

Base class for pivot area references

Inheritance

object

XmlHelper

ExcelPivotAreaReferenceBase

ExcelPivotAreaDataFieldReference

ExcelPivotAreaReference

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml.Table.PivotTable

Assembly: EPPlus.dll

Syntax

public abstract class ExcelPivotAreaReferenceBase : XmlHelper

Properties

AvgSubtotal

If the Average aggregation function is included in the filter.

Declaration

public bool AvgSubtotal { get; set; }

Property Value

Type	Description
bool

CountASubtotal

If the CountA aggregation function is included in the filter.

Declaration

public bool CountASubtotal { get; set; }

Property Value

Type	Description
bool

CountSubtotal

If the Count aggregation function is included in the filter.

Declaration

public bool CountSubtotal { get; set; }

Property Value

Type	Description
bool

DefaultSubtotal

If the default subtotal is included in the filter.

Declaration

public bool DefaultSubtotal { get; set; }

Property Value

Type	Description
bool

MaxSubtotal

If the Maximum aggregation function is included in the filter.

Declaration

public bool MaxSubtotal { get; set; }

Property Value

Type	Description
bool

MinSubtotal

If the Minimum aggregation function is included in the filter.

Declaration

public bool MinSubtotal { get; set; }

Property Value

Type	Description
bool

ProductSubtotal

If the Product aggregation function is included in the filter.

Declaration

public bool ProductSubtotal { get; set; }

Property Value

Type	Description
bool

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
bool

StdDevPSubtotal

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

Declaration

public bool StdDevPSubtotal { get; set; }

Property Value

Type	Description
bool

StdDevSubtotal

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

Declaration

public bool StdDevSubtotal { get; set; }

Property Value

Type	Description
bool

SumSubtotal

If the sum aggregation function is included in the filter.

Declaration

public bool SumSubtotal { get; set; }

Property Value

Type	Description
bool

VarPSubtotal

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

Declaration

public bool VarPSubtotal { get; set; }

Property Value

Type	Description
bool

VarSubtotal

If the variance aggregation function is included in the filter.

Declaration

public bool VarSubtotal { get; set; }

Property Value

Type	Description
bool