Show / Hide Table of Contents

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
Back to top Generated by DocFX