Back to Devexpress

PivotDataField Properties

officefileapi-devexpress-dot-spreadsheet-dot-pivotdatafield-dot-underscore-properties.md

latest2.5 KB
Original Source

PivotDataField Properties

Represents a reference to a PivotField object that is currently shown as a data field.

NameDescription
BaseFieldReturns the base field used by the “Show Values As” calculation option applied to the data field.
BaseItemReturns the base item used by the “Show Values As” calculation option applied to the data field.
BaseItemTypeReturns the type of the base item used by the “Show Values As” calculation option applied to the data field.
FieldProvides access to the underlying pivot field referenced by the current object. Inherited from PivotFieldReferenceBase.
NameGets or sets the name of the data field.
NumberFormatSpecifies a number format (in the invariant culture) used to display summary values within the data field.
NumberFormatLocalSpecifies a local number format used to display summary values within the data field.
PositionReturns or specifies the field position in the collection that corresponds to the PivotTable area where this field is located. Inherited from PivotFieldReferenceBase.
ShowValuesAsGets the type of calculation applied to the data field in addition to the actual value of the field.
SummarizeValuesByGets or sets the summary function used to calculate values in the data field.

See Also

PivotDataField Interface

PivotDataField Members

DevExpress.Spreadsheet Namespace