Class PivotTableFormatCollection

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

Represents the collection of formats applied to PivotTable.

public class PivotTableFormatCollection : CollectionBase<pivottableformat>, IList<pivottableformat>, ICollection<pivottableformat>, IEnumerable<pivottableformat>, ICollection, IEnumerable

Inheritance

object ← CollectionBase<pivottableformat> ← PivotTableFormatCollection

Implements

IList<pivottableformat>, ICollection<pivottableformat>, IEnumerable<pivottableformat>, ICollection, IEnumerable

Inherited Members

CollectionBase<pivottableformat>.BinarySearch(PivotTableFormat), CollectionBase<pivottableformat>.BinarySearch(PivotTableFormat, IComparer<pivottableformat>), CollectionBase<pivottableformat>.BinarySearch(int, int, PivotTableFormat, IComparer<pivottableformat>), CollectionBase<pivottableformat>.Contains(PivotTableFormat), CollectionBase<pivottableformat>.CopyTo(PivotTableFormat[]), CollectionBase<pivottableformat>.CopyTo(PivotTableFormat[], int), CollectionBase<pivottableformat>.CopyTo(int, PivotTableFormat[], int, int), CollectionBase<pivottableformat>.Exists(Predicate<pivottableformat>), CollectionBase<pivottableformat>.Find(Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindAll(Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindIndex(Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindIndex(int, Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindIndex(int, int, Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindLast(Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindLastIndex(Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindLastIndex(int, Predicate<pivottableformat>), CollectionBase<pivottableformat>.FindLastIndex(int, int, Predicate<pivottableformat>), CollectionBase<pivottableformat>.IndexOf(PivotTableFormat), CollectionBase<pivottableformat>.IndexOf(PivotTableFormat, int), CollectionBase<pivottableformat>.IndexOf(PivotTableFormat, int, int), CollectionBase<pivottableformat>.LastIndexOf(PivotTableFormat), CollectionBase<pivottableformat>.LastIndexOf(PivotTableFormat, int), CollectionBase<pivottableformat>.LastIndexOf(PivotTableFormat, int, int), CollectionBase<pivottableformat>.GetEnumerator(), CollectionBase<pivottableformat>.Clear(), CollectionBase<pivottableformat>.RemoveAt(int), CollectionBase<pivottableformat>.OnClearComplete(), CollectionBase<pivottableformat>.OnClear(), CollectionBase<pivottableformat>.Capacity, CollectionBase<pivottableformat>.Count, CollectionBase<pivottableformat>.InnerList, CollectionBase<pivottableformat>.this[int], object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Properties

this[int]

Gets the format by the index.

public PivotTableFormat this[int index] { get; }

Property Value

PivotTableFormat

Methods

Add()

Add a Aspose.Cells.Pivot.PivotTableFormat.

public int Add()

Returns

int

The index of new format.

FormatArea(PivotFieldType, int, PivotFieldSubtotalType, PivotTableSelectionType, bool, bool, Style)

Formats selected area.

public PivotTableFormat FormatArea(PivotFieldType axisType, int fieldPosition, PivotFieldSubtotalType subtotalType, PivotTableSelectionType selectionType, bool isGrandRow, bool isGrandColumn, Style style)

Parameters

axisType PivotFieldType

The region of the PivotTable to which this rule applies.

fieldPosition int

Position of the field within the axis to which this rule applies.

subtotalType PivotFieldSubtotalType

The subtotal filter type of the pivot field

selectionType PivotTableSelectionType

Indicates how to select data.

isGrandRow bool

Indicates whether selecting grand total rows.

isGrandColumn bool

Indicates whether selecting grand total columns.

style Style

The style which appies to the area of the pivot table.

Returns

PivotTableFormat </pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat></pivottableformat>