Back to Devexpress

IPivotTable Members

blazor-devexpress-dot-blazor-dot-pivottable-dot-ipivottable-dot-underscore-members.md

latest7.7 KB
Original Source

IPivotTable Members

An interface that defines the DxPivotTable component’s API members (properties and methods).

Properties

NameDescription
AllowDragFieldsSpecifies whether users can drag field headers and drop them to other areas.
AllowDragFieldsInFieldListSpecifies whether users can drag fields in the Field List.
AllowFieldListDeferredUpdateSpecify whether to enable the Defer Layout Update option in the Field List.
AllowFilterInFieldListSpecifies whether users can apply field filters in the Field List.
AllowSortInFieldListSpecifies whether users can change field sort order in the Field List.
AttributesSpecifies a collection of standard HTML attributes applied to the Pivot Table.
AutoExpandGroupsSpecifies whether to automatically expand all groups when the Pivot loads data.
ColumnTotalsPositionSpecifies the position of column totals.
CssClassAssigns a CSS class to the Pivot Table.
DataSpecifies an object that supplies Pivot Table data.
FieldCellTemplateSpecifies a common template for all data cells in the Pivot Table.
FieldFilterMenuTemplateSpecifies a common template used to display all Field Filter Menus in the Pivot Table.
FieldHeaderTemplateSpecifies a common template to display field captions in the header area.
FieldPositionChangingFires after a user starts dragging a field to another area.
FieldValueTemplateSpecifies a common template to display field values in rows or columns.
FilterCriteriaChangedFires when filter criteria applied to Pivot Table data change.
FilterHeaderAreaDisplayModeSpecifies when to display the Filter Header Area in the Pivot Table.
FilterMenuButtonDisplayModeSpecifies when field headers display filter menu buttons.
RowTotalsPositionSpecifies the position of row totals.
ShowColumnGrandTotalsSpecifies whether to display column grand totals.
ShowColumnTotalsSpecifies whether to display column totals.
ShowRowGrandTotalsSpecifies whether to display row grand totals.
ShowRowTotalsSpecifies whether to display row totals.
VirtualScrollingEnabledSpecifies whether vertical virtual scrolling is enabled.
VirtualScrollingModeSpecifies the virtual scrolling mode for the Pivot Table.

Methods

NameDescription
BeginUpdate()Suspends Pivot Table updates caused by parameter changes and method calls until the EndUpdate() method is called.
ClearFilter()Clears the filter applied to Pivot Table data.
CollapseAllColumns()Collapses all columns in the Pivot Table component.
CollapseAllGroups()Collapses all groups in the Pivot Table component.
CollapseAllRows()Collapses all rows in the Pivot Table component.
EndUpdate()Resumes Pivot Table updates (when the BeginUpdate() method pauses updates) and re-renders the Pivot Table.
ExpandAllColumns()Expands all columns in the Pivot Table component.
ExpandAllGroups()Expands all groups in the Pivot Table component.
ExpandAllRows()Expands all rows in the Pivot Table component.
GetFields()Returns a collection of Pivot Table fields.
GetFilterCriteria()Returns the filter criteria applied to Pivot Table data.
HideFieldList()Hides the Field List.
LoadLayout(PivotTablePersistentLayout)Restores the Pivot Table layout.
Reload()Reloads Pivot Table data.
SaveLayout()Saves information about the Pivot Table layout.
SetFieldPosition(String, PivotTableArea, Int32)Positions the field at the specified area, sets the field’s index.
SetFilterCriteria(CriteriaOperator)Applies a filter to Pivot Table data.
SetFilterCriteria(String)Applies a filter to Pivot Table data.
ShowFieldList()Displays the Field List.
ShowFieldList(DialogDisplayOptions)Displays the Field List and positions it based on specified display options.

See Also

IPivotTable Interface

DevExpress.Blazor.PivotTable Namespace