Class ExcelPivotAreaReferenceBase¶

Namespace: OfficeOpenXml.Table.PivotTable
Assembly: EPPlus.dll

Base class for pivot area references

public abstract class ExcelPivotAreaReferenceBase : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelPivotAreaReferenceBase

Derived¶

ExcelPivotAreaDataFieldReference
ExcelPivotAreaReference

Inherited Members¶

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties¶

AvgSubtotal¶

If the Average aggregation function is included in the filter.

public bool AvgSubtotal { get; set; }

Property Value¶

bool

CountASubtotal¶

If the CountA aggregation function is included in the filter.

public bool CountASubtotal { get; set; }

Property Value¶

bool

CountSubtotal¶

If the Count aggregation function is included in the filter.

public bool CountSubtotal { get; set; }

Property Value¶

bool

DefaultSubtotal¶

If the default subtotal is included in the filter.

public bool DefaultSubtotal { get; set; }

Property Value¶

bool

MaxSubtotal¶

If the Maximum aggregation function is included in the filter.

public bool MaxSubtotal { get; set; }

Property Value¶

bool

MinSubtotal¶

If the Minimum aggregation function is included in the filter.

public bool MinSubtotal { get; set; }

Property Value¶

bool

ProductSubtotal¶

If the Product aggregation function is included in the filter.

public bool ProductSubtotal { get; set; }

Property Value¶

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.

public bool Selected { get; set; }

Property Value¶

bool

StdDevPSubtotal¶

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

public bool StdDevPSubtotal { get; set; }

Property Value¶

bool

StdDevSubtotal¶

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

public bool StdDevSubtotal { get; set; }

Property Value¶

bool

SumSubtotal¶

If the sum aggregation function is included in the filter.

public bool SumSubtotal { get; set; }

Property Value¶

bool

VarPSubtotal¶

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

public bool VarPSubtotal { get; set; }

Property Value¶

bool

VarSubtotal¶

If the variance aggregation function is included in the filter.

public bool VarSubtotal { get; set; }

Property Value¶

bool