Back to Devexpress

PivotFieldReferenceCollection Members

officefileapi-devexpress-dot-spreadsheet-dot-pivotfieldreferencecollection-dot-underscore-members.md

latest5.0 KB
Original Source

PivotFieldReferenceCollection Members

Represents the collection of row or column fields in the PivotTable report.

Properties

NameDescription
CountGets the number of elements contained in the ICollection. Inherited from ICollection.
IsSynchronizedGets a value indicating whether access to the ICollection is synchronized (thread safe). Inherited from ICollection.
Item[String]Provides access to an individual row or column field in the collection by its name.
SyncRootGets an object that can be used to synchronize access to the ICollection. Inherited from ICollection.

Methods

NameDescription
Add(PivotField)Adds a field to the row or column area of the pivot table.
AddValuesReference()Adds the virtual “Values” field to the row or column area of the pivot table.
Clear()Removes all row or column fields from the collection.
Contains(PivotFieldReference)Determines whether the collection contains the specified column or row field.
CopyTo(Array, Int32)Copies the elements of the ICollection to an Array, starting at a particular Array index. Inherited from ICollection.
GetEnumerator()Returns an enumerator that iterates through the collection. Inherited from IEnumerable<T>.
IndexOf(PivotFieldReference)Returns the index of the specified row or column field in the collection.
Insert(Int32, PivotField)Inserts a row or column field into the collection at the specified index.
InsertValuesReference(Int32)Inserts the virtual “Values” field into the collection at the specified index.
Remove(PivotFieldReference)Removes the specified row or column field from the collection.
RemoveAt(Int32)Removes the row or column field at the specified index from the collection.

See Also

PivotFieldReferenceCollection Interface

DevExpress.Spreadsheet Namespace