Skip to main content

DevExpress.Xpf.PivotGrid Namespace

Contains classes which implement the main functionality of the DXPivotGrid Suite. To use these classes in XAML code, add the xmlns:dxpg=”http://schemas.devexpress.com/winfx/2008/xaml/pivotgrid“ namespace reference.

Assembly: DevExpress.Xpf.PivotGrid.v24.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Classes

Name Description
AsyncOperationResult The result of the asynchronous operation.
CalculationBinding The base class used to specify a PivotGrid’s field calculation data binding in Optimized mode.
CellElement A Pivot Grid’s data cell to which the cell style is applied.
CellElementData Contains the pivot grid’s cell data, location, and layout characteristics.
CellInfo Stores information about the data cell displayed within the PivotGrid control.
ColorScaleFormatCondition Represents a color scale format condition.
CustomizePivotCellEventArgs Contains data for the PivotGridXlsExportOptions.CustomizeCell, PivotGridCsvExportOptions.CustomizeCell and PivotGridXlsxExportOptions.CustomizeCell events.
CustomServerModeSortEventArgs Provides data for the PivotGridControl.CustomServerModeSort event.
DataAreaElement The base class for the data area cells and field value cells.
DataAreaElementData Contains the field value cell’s and data area cell’s data, location, and layout characteristics.
DataBarFormatCondition Represents a data bar format condition.
DataBinding Base class of the the Data Binding API. Specifies the source data for the PivotGrid fields in Optimized mode.
DataSourceColumnBinding Defines a data binding to a data source column.
DefaultMenuItemNames static Contains names of the context menu items.
DifferenceBinding Defines the difference calculation between values across a window.
DirectedCalculationBinding Base class to specify calculations whose result is dependent on the direction of the calculation. Used as a PivotGrid’s field calculation data binding in Optimized mode.
EventArgsToCellInfoConverter A converter used to convert the event argument to the CellInfo class.
EventArgsToFieldValueInfoConverter A converter used to convert the event argument to the FieldValueInfo class.
ExpressionConditionBase Serves as a base for classes that represent expression-type format conditions.
ExpressionDataBinding Defines a calculation based on a string expression.
FieldFilterValues Contains filter values for a specific field.
FieldListControlBase Serves as the base class for a pivot grid’s Customization Controls.
FieldValueCell Represents a field value cell.
FieldValueElement A Pivot Grid field value cell to which the cell style is applied.
FieldValueElementData Contains the pivot grid’s field value cell data, location, and layout characteristics.
FieldValueInfo Stores information about the row and column fields related to the selected cell.
FormatCondition Represents a format condition based on a specified rule(s) or expression.
FormatConditionBase Serves as a base for classes that represent format conditions.
FormatConditionCollection Represents a collection of format conditions.
FormatConditionCommandParameters Contains parameters for conditional formatting commands.
GroupChangedEventArgs Provides data for the PivotGridGroup.Changed event.
GroupFilterValue A group filter value.
GroupFilterValues Represents a group filter condition.
GroupFilterValuesCollection A collection of group filter values.
IconSetFormatCondition Represents an icon set format condition.
IndicatorFormatConditionBase Serves as a base for classes that represent indicator-type format conditions.
LightweightCellElement
LightweightFieldValueElement
MovingCalculationBinding Defines aggregations across a specified number of values before and/or after the current value.
OlapExpressionBinding Allows you to use an expression to evaluate values for a Pivot Grid’s field in OLAP mode.
PercentOfTotalBinding Allows you to calculate the input of all values in the window as a percentage of the total.
PivotBrushChangedEventArgs Provides data for the PivotGridControl.BrushChanged event.
PivotCellBaseEventArgs Provides data for the events which are invoked for particular data cells.
PivotCellDisplayTextEventArgs Provides data for the PivotGridControl.CustomCellDisplayText event.
PivotCellEventArgs Provides data for the PivotGridControl.CellClick and PivotGridControl.CellDoubleClick events.
PivotCellValueEventArgs Provides data for the PivotGridControl.CustomCellValue event.
PivotChartDataSourceRow A row in the datasource passed to the chart control.
PivotCustomCellAppearanceEventArgs Provides data for the PivotGridControl.CustomCellAppearance event.
PivotCustomChartDataSourceDataEventArgs Provides data for the PivotGridControl.CustomChartDataSourceData event.
PivotCustomChartDataSourceRowsEventArgs Provides data for the PivotGridControl.CustomChartDataSourceRows event.
PivotCustomFieldDataEventArgs Provides data for the PivotGridControl.CustomUnboundFieldData event.
PivotCustomFieldListSortEventArgs Provides data for the PivotGridControl.CustomFieldListSort event.
PivotCustomFieldSortEventArgs Provides data for the PivotGridControl.CustomFieldSort event.
PivotCustomFieldValueCellsEventArgs Provides data for the PivotGridControl.CustomFieldValueCells event.
PivotCustomFilterPopupItemsEventArgs Provides data for the PivotGridControl.CustomFilterPopupItems event.
PivotCustomGroupIntervalEventArgs Provides data for the PivotGridControl.CustomGroupInterval event.
PivotCustomSummaryEventArgs Provides data for the PivotGridControl.CustomSummary event.
PivotCustomValueAppearanceEventArgs Provides data for the PivotGridControl.CustomValueAppearance event.
PivotDrillDownDataRow Represents a single row in the data source which provides the data used to calculate summaries for individual cells.
PivotDrillDownDataSource Represents a list of the records which are used to calculate summaries for individual cells.
PivotExcelFieldListControl An Excel-style Field List.
PivotExpressionEditorEventArgs Provides data for the ExpressionEditorCreated event.
PivotFieldAreaChangingEventArgs Provides data for the PivotGridControl.FieldAreaChanging event.
PivotFieldDisplayTextEventArgs Provides data for the PivotGridControl.FieldValueDisplayText event.
PivotFieldEventArgs Provides data for all field handling events.
PivotFieldFilterChangingEventArgs Provides data for the PivotGridControl.FieldFilterChanging event.
PivotFieldListControl A simple-style Field List.
PivotFieldPropertyChangedEventArgs Provides data for the PivotGridControl.FieldPropertyChanged event.
PivotFieldValueCancelEventArgs Provides data for the PivotGridControl.FieldValueCollapsing and PivotGridControl.FieldValueExpanding events.
PivotFieldValueEventArgs Serves as a base for the classes that provide data for the events which are used to customize column and row headers.
PivotGridCellMenuInfo
PivotGridCommands static Provides access to pivot grid commands.
PivotGridControl The PivotGrid control.
PivotGridCsvExportOptions Contains options that define how a document is exported to CSV.
PivotGridCustomTotal Represents a custom total.
PivotGridCustomTotalCollection Represents a collection of custom totals.
PivotGridField Represents a Pivot Grid field.
PivotGridFieldCollection Represents a field collection for the PivotGridControl.
PivotGridFieldValueMenuInfo
PivotGridFilterPopupMenuInfo
PivotGridGroup Represents an individual group of fields.
PivotGridGroupCollection Represents a collection of field groups.
PivotGridHeaderMenuInfo Contains information about the field header context menu.
PivotGridHeadersAreaMenuInfo
PivotGridMenuInfo Contains information about the context menu.
PivotGridPopupMenu A pop-up menu for the Pivot Grid.
PivotGridXlsExportOptions Contains export options specific to XLS format.
PivotGridXlsxExportOptions Contains export options specific to XLS format.
PivotGroupEventArgs Provides data for the PivotGridControl.GroupFilterChanged event.
PivotLayoutAllowEventArgs Provides data for the PivotGridControl.BeforeLoadLayout event.
PivotLayoutUpgradeEventArgs Provides data for the PivotGridControl.LayoutUpgrade event.
PivotOlapExceptionEventArgs Provides data for the PivotGridControl.OlapException event.
PivotOlapKpiMeasures Contains the names of the OLAP measures that represent values of a particular KPI.
PivotOlapKpiValue Represents values of a KPI.
PivotOlapMember An OLAP member.
PivotPropertyChangedEventArgs Provides data for the PivotGridControl.PropertyChanged event.
PivotQueryExceptionEventArgs Provides data for the PivotGridControl.QueryException event.
PivotSerializationOptions Contains options that control how the PivotGridControl’s layout is saved to and restored from a data store (an XML file or stream).
PivotSummaryDataRow Represents a summary data source row.
PivotSummaryDataSource Represents a summary data source.
PivotUnboundExpressionEditorEventArgs Provides data for the PivotGridControl.UnboundExpressionEditorCreated event.
PopupMenuShowingEventArgs Provides data for the PivotGridControl.PopupMenuShowing event.
RankBinding Defines the calculation of a ranking in the window.
RunningTotalBinding Defines the calculation that aggregates values cumulatively in the window.
SortByCondition Represents a sort condition used to identify the column/row by whose values the other field values will be sorted.
SortByConditionCollection A collection of sort conditions.
TopBottomRuleFormatCondition Represents a top/bottom format condition.
WindowExpressionBinding Specifies a custom string expression with window functions to calculate values. Used as a PivotGrid’s field calculation databinding in Optimized mode.

Interfaces

Name Description
IThreadSafeField When implemented, provides a read-only access to basic settings of a field.

Delegates

Name Description
AsyncCompletedHandler References a method executed after an asynchronous operation is completed.
GroupChangedEventHandler Represents a method that will handle the PivotGridGroup.Changed event.
PivotBrushChangedEventHandler A method that will handle the PivotGridControl.BrushChanged event.
PivotCellDisplayTextEventHandler Represents a method that will handle the PivotGridControl.CustomCellDisplayText event.
PivotCellEventHandler Represents a method that will handle the PivotGridControl.CellClick and PivotGridControl.CellDoubleClick events.
PivotCellValueEventHandler Represents a method that will handle the PivotGridControl.CustomCellValue event.
PivotCustomCellAppearanceEventHandler A method that will handle the PivotGridControl.CustomCellAppearance event.
PivotCustomChartDataSourceDataEventHandler Represents a method that will handle the PivotGridControl.CustomChartDataSourceData event.
PivotCustomChartDataSourceRowsEventHandler References a method that will handle the PivotGridControl.CustomChartDataSourceRows event.
PivotCustomFieldDataEventHandler Represents a method that will handle the PivotGridControl.CustomUnboundFieldData event.
PivotCustomFieldSortEventHandler Represents a method that will handle the PivotGridControl.CustomFieldSort event.
PivotCustomFieldValueCellsEventHandler Represents a method that will handle the PivotGridControl.CustomFieldValueCells event.
PivotCustomFilterPopupItemsEventHandler Represents a method that will handle the PivotGridControl.CustomFilterPopupItems event.
PivotCustomGroupIntervalEventHandler Represents a method that will handle the PivotGridControl.CustomGroupInterval event.
PivotCustomSummaryEventHandler Represents a method that will handle the PivotGridControl.CustomSummary event.
PivotCustomValueAppearanceEventHandler A method that will handle the PivotGridControl.CustomValueAppearance event.
PivotExpressionEditorEventHandler
PivotFieldAreaChangingEventHandler Represents a method that will handle the PivotGridControl.FieldAreaChanging event.
PivotFieldDisplayTextEventHandler Represents a method that will handle the PivotGridControl.FieldValueDisplayText event.
PivotFieldEventHandler Represents a method that will handle the PivotGridControl.FieldAreaChanged, PivotGridControl.FieldExpandedInGroupChanged, PivotGridControl.FieldFilterChanged, PivotGridControl.FieldSizeChanged and PivotGridControl.FieldUnboundExpressionChanged events.
PivotFieldFilterChangingEventHandler Represents a method that will handle the PivotGridControl.FieldFilterChanging event.
PivotFieldPropertyChangedEventHandler Represents a method that will handle the PivotGridControl.FieldPropertyChanged event.
PivotFieldValueCancelEventHandler Represents a method that will handle the PivotGridControl.FieldValueCollapsing and PivotGridControl.FieldValueExpanding events.
PivotFieldValueEventHandler Represents a method that will handle the PivotGridControl.FieldValueCollapsed, PivotGridControl.FieldValueExpanded and PivotGridControl.FieldValueNotExpanded events.
PivotGroupEventHandler Represents a method that will handle the PivotGridControl.GroupFilterChanged event.
PivotLayoutAllowEventHandler References a method that will handle the PivotGridControl.BeforeLoadLayout event.
PivotLayoutUpgradeEventHandler Represents a method that will handle the PivotGridControl.LayoutUpgrade event.
PivotOlapExceptionEventHandler References a method that will handle the PivotGridControl.OlapException event.
PivotPropertyChangedEventHandler Represents a method that will handle the PivotGridControl.PropertyChanged event.
PivotQueryExceptionEventHandler References a method that will handle the PivotGridControl.QueryException event.
PivotUnboundExpressionEditorEventHandler
PopupMenuShowingEventHandler References a method that will handle the PivotGridControl.PopupMenuShowing event.

Enums

Name Description
AllowHideFieldsType Lists values that specify when fields can be hidden by end-users.
CalculationDirection Lists possible calculation directions in a table.
CalculationPartitioningCriteria Lists values used to specify a partition (frame) in a data table for window calculations.
CopyCollapsedValuesMode Lists values that specify how to copy collapsed field values to the clipboard.
CopyMultiSelectionMode Lists values that specify how to copy cells to the clipboard when multiple cells are selected.
DataFieldArea Lists values that specify the area in which the data field headers are displayed.
DataHeadersDisplayMode
DataProcessingEngine Lists values that specify an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid.
DateTimeGroupIntervals Lists possible DateTime group interval combinations.
DifferenceTarget
DifferenceType Lists the types of differences.
FieldAllowedAreas Lists values that specify pivot grid areas where a field can be positioned.
FieldArea Lists the values that specify the areas where the pivot grid fields can be displayed.
FieldBestFitArea Lists the values used to specify which interface elements should be taken into account when calculating the optimal width for columns or rows.
FieldColumnTotalsLocation Lists values that specify the location of column totals.
FieldFilterType Contains the values that specify a field’s filter type in the PivotGrid control.
FieldGroupInterval Contains values that specify how the values of a specific column or row field are combined into groups.
FieldListAllowedLayouts Lists values that specify which layouts can be applied to the Field List.
FieldListArea Lists values that specify which fields the Customization Control should display.
FieldListLayout Lists values that specify the layout of the Field List.
FieldListOrientation Lists values that specify how field headers should be arranged within the Customization Control.
FieldListStyle Lists values that specify the Field List‘s style.
FieldOLAPFilterUsingWhereClause Lists values that specify whether to use the WHERE clause in an MDX query, when filtering against filter fields in OLAP mode.
FieldPropertyName Lists values that identify properties of fields.
FieldRowTotalsLocation Lists values that specify the location of row totals.
FieldSortBySummaryOrder Lists values that specify the sort order applied to a field when sorting by summaries is enabled for it.
FieldSortLocation Lists values that specify a target UI element whose items are sorted.
FieldSortMode Lists the values that specify how a field’s data should be sorted.
FieldSortOrder Lists the values that specify the sort order of a pivot grid’s fields.
FieldSummaryDisplayType Contains options that specify how summary values are displayed within cells (“as is” or adjusted using a specific predefined algorithm).
FieldSummaryType Lists values that specify the summary function types.
FieldTopValueMode Lists values that specify how the top n values for a specified data field are calculated.
FieldTopValueType Lists the values that specify how the number of Top Values is determined.
FieldTotalsVisibility Contains values that specify which summary totals are displayed for a specific column field or row field.
FieldUnboundColumnType Contains values that specify the data type and binding mode of columns.
FieldUnboundExpressionMode Lists values that specify how the unbound expressions for a specified data field are calculated.
FieldValueType Lists values that specify the types of column and row field values.
FilterPopupMode Lists styles of the filter drop-down to use for the current field.
GroupChangeType Lists values that specify what caused the field group to change.
GroupFilterMode Lists values that specify the filtering mode for grouped fields.
OlapDataProvider Lists values that specify which data provider should be used when binding to an OLAP cube.
PivotBrushType Lists values that identify a brush type.
PivotChartDataProvideMode Lists values that specify which data the pivot grid should pass to a bound chart control.
PivotChartDataProvidePriority Lists values that specify whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data.
PivotChartExportFieldValueMode Lists values that specify how the PivotGridControl’s field values are exported to the chart control.
PivotChartFieldValuesProvideMode Lists values that specify how the PivotGridControl’s field values are exported to the chart control.
PivotChartItemDataMember Lists values that specify the type of a chart data member.
PivotChartItemType Lists values that specify the type of a PivotGridControl’s item to be represented in a ChartControl.
PivotDefaultMemberFields Lists values that specify for which fields the pivot grid processes only data related to their default members.
PivotGridMenuType Lists values that specify the pivot grid’s context menu types.
PivotKpiGraphic Lists values that specify the graphic set used to indicate KPI values.
PivotKpiType Lists KPI types.
RankType Lists rank types.
ScrollingMode Lists values specifying the PivotGridControl scrolling mode.
SelectMode Lists values that specify the selection mode.
ShowFilterPanelMode Lists values that specify when the PivotGridControl displays the Filter Panel.
StoreLayoutMode Lists options that specify which settings should be saved when saving the PivotGrid’s layout.
SummaryDataSourceFieldNaming
SummaryFilterMode Lists options that specify the aggregation level for summary filtering.
UnboundExpressionMode Lists values that specify how the unbound expressions for data fields are calculated.
UseLightweightTemplates Lists values that specify whether to enable the lightweight templates feature.
UserAction Lists values that specify end-user actions on the PivotGridControl.