Class PivotAreaFilter

Namespace: Aspose.Cells.Pivot
Assembly: Aspose.Cells.dll (25.2.0)

Represents the filter of Aspose.Cells.Pivot.PivotArea for Aspose.Cells.Pivot.PivotTable.

public class PivotAreaFilter

Inheritance

object ← PivotAreaFilter

Inherited Members

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

Constructors

PivotAreaFilter()

public PivotAreaFilter()

Properties

Selected

Indicates whether this field has selection. Only works when the PivotTable is in Outline view.

public bool Selected { get; set; }

Property Value

bool

Methods

IsSubtotalSet(PivotFieldSubtotalType)

Gets which subtotal is set for this filter.

public bool IsSubtotalSet(PivotFieldSubtotalType subtotalType)

Parameters

subtotalType PivotFieldSubtotalType

The subtotal function type.

Returns

bool

SetSubtotals(PivotFieldSubtotalType, bool)

Subtotal for the filter.

public void SetSubtotals(PivotFieldSubtotalType subtotalType, bool shown)

Parameters

subtotalType PivotFieldSubtotalType

The subtotal function.

shown bool

Indicates if showing this subtotal data.