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.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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