DevExpress.XtraPivotGrid Namespace

Contains classes which implement the main functionality of the PivotGridControl.

Assemblies: DevExpress.XtraEditors.v24.1.dll, DevExpress.XtraPivotGrid.v24.1.dll

NuGet Packages: DevExpress.Win.Navigation, DevExpress.Win.PivotGrid

Classes

Name	Description
CancelPivotCellEditEventArgs	Provides data for the PivotGridControl.ShowingEditor event.
CustomCustomizationFormSortEventArgs	Provides data for the PivotGridControl.CustomCustomizationFormSort event.
CustomEditValueEventArgs	Provides data for the PivotGridControl.CustomEditValue event.
CustomExportCellEventArgs	Provides data for the PivotGridControl.CustomExportCell event.
CustomExportFieldValueEventArgs	Provides data for the PivotGridControl.CustomExportFieldValue event.
CustomExportHeaderEventArgs	Provides data for the PivotGridControl.CustomExportHeader event.
CustomFieldDataEventArgs	Provides data for the PivotGridControl.CustomUnboundFieldData event.
CustomizationFormShowingEventArgs	Provides data for the PivotGridControl.ShowingCustomizationForm event.
CustomizePivotCellEventArgs	Provides data for the PivotXlsExportOptions.CustomizeCell and PivotXlsxExportOptions.CustomizeCell events.
CustomServerModeSortEventArgs	Provides data for the PivotGridControl.CustomServerModeSort event
DataSourceColumnBinding	Defines a data binding to a source data column.
DifferenceBinding	Defines the difference calculation between values across a window.
EditValueChangedEventArgs	Provides data for the PivotGridControl.EditValueChanged event.
ExpressionDataBinding	Defines a calculation based on a string expression.
FieldValueCell	Represents a field value cell.
FilterPopupExcelCustomizeTemplateEventArgs	Provides data for the PivotGridControl.FilterPopupExcelCustomizeTemplate event.
FilterPopupExcelDataEventArgs	Provides data for the PivotGridControl.FilterPopupExcelData event.
FilterPopupExcelEventArgs	Provides data for the PivotGridControl.ShowFilterPopupExcel event.
FilterPopupExcelParseFilterCriteriaEventArgs	Provides data for the FilterPopupExcelParseFilterCriteria event.
FilterPopupExcelPrepareTemplateEventArgs	Provides data for the PivotGridControl.FilterPopupExcelPrepareTemplate event.
FilterPopupExcelQueryFilterCriteriaEventArgs	Provides data for the PivotGridControl.FilterPopupExcelQueryFilterCriteria event.
FormatRuleFieldIntersectionSettings	Contains format rule settings used to apply conditional formatting to data cells placed at the intersection of specified column and row fields.
FormatRuleSettings	Serves as the base class for classes that provide format rule settings used to apply conditional formatting to data cells.
FormatRuleTotalTypeSettings	Contains format rule settings used to apply conditional formatting to various types of data cells (data cells, custom total cells, grand total cells, and total cells).
MovingCalculationBinding	Defines aggregations across a specified number of values before and/or after the current value.
OLAPExpressionBinding	Gets or sets an expression that is used to evaluate values for a Pivot Grid’s field in OLAP mode.
PercentOfTotalBinding	Defines the calculation of a percentage of all values in the window.
PivotAreaChangingEventArgs	Provides data for the PivotGridControl.FieldAreaChanging event.
PivotCellBaseEventArgs	Provides data for the events which are invoked for particular data cells.
PivotCellDisplayTextEventArgs	Provides data for the PivotGridControl.CustomCellDisplayText event.
PivotCellEditEventArgs	Provides data for the PivotGridControl.HiddenEditor and PivotGridControl.ShownEditor events.
PivotCellEventArgs	Provides data for the PivotGridControl.CellClick and PivotGridControl.CellDoubleClick events.
PivotCellValueEventArgs	Provides data for the PivotGridControl.CustomCellValue event.
PivotCustomAppearanceEventArgs	Provides data for the PivotGridControl.CustomAppearance event.
PivotCustomAppearanceThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomAppearance event data.
PivotCustomCellEditEventArgs	Provides data for the PivotGridControl.CustomCellEdit event.
PivotCustomChartDataSourceDataEventArgs	Provides data for the PivotGridControl.CustomChartDataSourceData event.
PivotCustomChartDataSourceRowsEventArgs	Provides data for the PivotGridControl.CustomChartDataSourceRows event.
PivotCustomColumnWidthEventArgs	Provides data for the PivotGridControl.CustomColumnWidth event.
PivotCustomDrawBaseThreadSafeEventArgs	Provides thread-safe access to custom painting events data.
PivotCustomDrawCellBaseEventArgs	Provides data for custom painting events invoked for particular data cells.
PivotCustomDrawCellBaseThreadSafeEventArgs	Provides thread-safe access to data for custom painting events invoked for particular data cells.
PivotCustomDrawCellEventArgs	Provides data for the PivotGridControl.CustomDrawCell event.
PivotCustomDrawCellThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomDrawCell event data.
PivotCustomDrawEventArgs	Provides data for the PivotGridControl.CustomDrawEmptyArea event.
PivotCustomDrawFieldHeaderEventArgs	Provides data for the PivotGridControl.CustomDrawFieldHeader event.
PivotCustomDrawFieldHeaderThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomDrawFieldHeader event data.
PivotCustomDrawFieldValueEventArgs	Provides data for the PivotGridControl.CustomDrawFieldValue event.
PivotCustomDrawFieldValueThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomDrawFieldValue event data.
PivotCustomDrawHeaderAreaEventArgs	Provides data for the PivotGridControl.CustomDrawFieldHeaderArea event.
PivotCustomDrawHeaderAreaThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomDrawFieldHeaderArea event data.
PivotCustomDrawThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.CustomDrawEmptyArea event data.
PivotCustomFieldValueCellsEventArgs	Provides data for the PivotGridControl.CustomFieldValueCells event.
PivotCustomFilterPopupItemsEventArgs	Provides data for the PivotGridControl.CustomFilterPopupItems event.
PivotCustomGroupIntervalEventArgs	Provides data for the PivotGridControl.CustomGroupInterval event.
PivotCustomRowHeightEventArgs	Provides data for the PivotGridControl.CustomRowHeight 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.
PivotFieldImageIndexEventArgs	Provides data for the PivotGridControl.FieldValueImageIndex event.
PivotFieldImageIndexThreadSafeEventArgs	Provides thread-safe access to the PivotGridControl.FieldValueImageIndex event data.
PivotFieldPropertyChangedEventArgs	Provides data for the PivotGridControl.FieldPropertyChanged event.
PivotFieldTooltipShowingEventArgs	Provides data for the PivotGridControl.FieldTooltipShowing 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.
PivotFieldValueHitInfo	Contains information on the field value located under the test point.
PivotFilter	A filter applied to data displayed in the PivotGridControl.
PivotGridAppearances	Provides the appearance settings used to paint a PivotGridControl.
PivotGridAppearancesBase	Represents the base class for classes that provide appearance settings for a PivotGridControl.
PivotGridAppearancesPrint	Provides the appearance settings used to paint the elements in a Pivot Grid Control when it’s printed.
PivotGridCells	Stores information on the cells displayed within the PivotGrid control.
PivotGridControl	Allows you to create a pivot table (cross-tabular format) for multi-dimensional analysis of large amounts of data.
PivotGridCustomFieldSortEventArgs	Provides data for the PivotGridControl.CustomFieldSort event.
PivotGridCustomSummaryEventArgs	Provides data for the PivotGridControl.CustomSummary event.
PivotGridCustomTotal	Represents a custom total which can be calculated for an outer column field or row field.
PivotGridCustomTotalCollection	Represents a collection of custom totals for a field.
PivotGridField	A field within the PivotGridControl.
PivotGridFieldAppearances	Provides the appearance settings used to paint the elements in a field.
PivotGridFieldCollection	A collection of PivotGrid control fields.
PivotGridFieldImageOptions	Contains settings that allow you to set up raster and vector icons for the current PivotGridField.
PivotGridFieldOptionsEx	Contains options for a field.
PivotGridFieldOptionsFilter	Contains the field’s filtering options.
PivotGridFieldToolTips	Provides tooltip options for a Pivot Grid field.
PivotGridFormatConditionCollection	A collection of style format conditions.
PivotGridFormatRule	A format rule used to apply conditional formatting to Pivot Grid Control data cells.
PivotGridFormatRuleCollection	A collection of PivotGridFormatRule objects.
PivotGridHeadersAreaHitInfo	Contains information about a specific point within a Header Area.
PivotGridHitInfo	Contains information about a specific point within a PivotGridControl.
PivotGridMenu
PivotGridMenuEventArgs	Obsolete. Provides data for the DevExpress.XtraPivotGrid.PivotGridControl.ShowMenu event.
PivotGridMenuEventArgsBase	The base class for classes providing data for the PivotGrid control’s menu handling events.
PivotGridMenuItemClickEventArgs	Provides data for the PivotGridControl.MenuItemClick event.
PivotGridMenuItemClickEventArgsBase	The base class for classes that provide data for the PivotGrid control’s menu item clicking events.
PivotGridOptionsBehavior	Provides behavior options for the control.
PivotGridOptionsCustomizationEx	Provides customization options for a PivotGrid control.
PivotGridOptionsFilter	Contains Pivot Grid’s filter options.
PivotGridOptionsFilterPopup	Contains options that affect the appearance and behavior of filter dropdown windows.
PivotGridOptionsHint	Provides hint options for a PivotGrid control.
PivotGridOptionsMenu	Provides the context menu options for the control.
PivotGridOptionsView	Provides view options for the PivotGrid controls.
PivotGridStyleFormatCondition	A single style format condition.
PivotGroupEventArgs	Provides data for the PivotGridControl.GroupFilterChanged event.
PivotLeftTopCellChangedEventArgs	Provides data for the PivotGridControl.LeftTopCellChanged event.
PivotOlapExceptionEventArgs	Provides data for the PivotGridControl.OLAPException event.
PivotOlapQueryDataEventArgs	Provides data for the PivotGridControl.OLAPQueryData event.
PivotQueryExceptionEventArgs	Provides data for the PivotGridControl.QueryException event.
PivotUserActionEventArgs	Provides data for the PivotGridControl.UserActionChanged event.
PivotXlsExportOptions	Contains Pivot Grid options that define how a document is exported to XLS format in the data-aware export mode.
PivotXlsxExportOptions	Contains Pivot Grid options that define how a document is exported to XLSX format in the data-aware export mode.
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.
WindowExpressionBinding	Defines the calculation that uses a custom string expression with window functions.

Delegates

Name	Description
CustomEditValueEventHandler	Represents a method that will handle the PivotGridControl.CustomEditValue event.
CustomFieldDataEventHandler	Represents a method that will handle the PivotGridControl.CustomUnboundFieldData event.
CustomizationFormShowingEventHandler	Represents a method that will handle the PivotGridControl.ShowingCustomizationForm event.
CustomizePivotCellEventHandler	Represents a method that will handle the PivotXlsxExportOptions.CustomizeCell and PivotXlsxExportOptions.CustomizeCell events.
EditValueChangedEventHandler	Represents a method that will handle the PivotGridControl.EditValueChanged event.
FilterPopupExcelCustomizeTemplateEventHandler	References a method that will handle the ColumnView.FilterPopupExcelCustomizeTemplate event.
FilterPopupExcelDataEventHandler	References a method that will handle the PivotGridControl.FilterPopupExcelData event.
FilterPopupExcelEventHandler	References a method that will handle the PivotGridControl.ShowFilterPopupExcel event.
FilterPopupExcelPrepareTemplateEventHandler	References a method that will handle the PivotGridControl.FilterPopupExcelPrepareTemplate event.
FilterPopupExcelQueryFilterCriteriaEventHandler	References a method that will handle the PivotGridControl.FilterPopupExcelCustomizeTemplate event.
PivotAreaChangingEventHandler	Represents a method that will handle the PivotGridControl.FieldAreaChanging event.
PivotCellDisplayTextEventHandler	Represents a method that will handle the PivotGridControl.CustomCellDisplayText event.
PivotCellEventHandler	Represents a method that will handle the PivotGridControl.CellDoubleClick event.
PivotCustomAppearanceEventHandler	Represents a method that will handle the PivotGridControl.CustomAppearance event.
PivotCustomChartDataSourceDataEventHandler	Represents a method that will handle the PivotGridControl.CustomChartDataSourceData event.
PivotCustomChartDataSourceRowsEventHandler	References a method that will handle the PivotGridControl.CustomChartDataSourceRows event.
PivotCustomDrawCellEventHandler	Represents a method that will handle the PivotGridControl.CustomDrawCell event.
PivotCustomDrawEventHandler	Represents a method that will handle the PivotGridControl.CustomDrawEmptyArea event.
PivotCustomDrawFieldHeaderEventHandler	Represents a method that will handle the PivotGridControl.CustomDrawFieldHeader event.
PivotCustomDrawFieldValueEventHandler	Represents a method that will handle the PivotGridControl.CustomDrawFieldValue event.
PivotCustomDrawHeaderAreaEventHandler	Represents a method that will handle the PivotGridControl.CustomDrawFieldHeaderArea 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.
PivotFieldDisplayTextEventHandler	Represents a method that will handle the PivotGridControl.FieldValueDisplayText event.
PivotFieldEventHandler	Represents a method that will handle the PivotGridControl.FieldFilterChanged, PivotGridControl.FieldAreaChanged and PivotGridControl.FieldWidthChanged events.
PivotFieldFilterChangingEventHandler	Represents a method that will handle the PivotGridControl.FieldFilterChanging event.
PivotFieldImageIndexEventHandler	Represents a method that will handle the PivotGridControl.FieldValueImageIndex event.
PivotFieldPropertyChangedEventHandler	Represents a method that will handle the PivotGridControl.FieldPropertyChanged event.
PivotFieldTooltipShowingEventHandler	Represents a method that will handle the PivotGridControl.FieldTooltipShowing 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 and PivotGridControl.FieldValueExpanded events.
PivotGridCustomFieldSortEventHandler	Represents a method that will handle the PivotGridControl.CustomFieldSort event.
PivotGridCustomSummaryEventHandler	Represents a method that will handle the PivotGridControl.CustomSummary event.
PivotGridMenuEventHandler	Represents a method that will handle the DevExpress.XtraPivotGrid.PivotGridControl.ShowMenu event.
PivotGridMenuItemClickEventHandler	Represents a method that will handle the PivotGridControl.MenuItemClick event.
PivotGroupEventHandler	Represents a method that will handle the PivotGridControl.GroupFilterChanged event.
PivotOlapExceptionEventHandler	References a method that will handle the PivotGridControl.OLAPException event.
PivotQueryExceptionEventHandler	References a method that will handle the PivotGridControl.QueryException event.
PivotUserActionEventHandler	References a method that will handle the PivotGridControl.UserActionChanged event.
PopupMenuShowingEventHandler	Represents a method that will handle the PivotGridControl.PopupMenuShowing event.

Enums

Name	Description
DateTimeGroupIntervals	Lists possible DateTime group interval combinations.
ExcelFilterDateTimeValuesTabFilterType	Lists values that specify the type of filtering UI used to create filters in the Values tab in the Excel-style Filter popup (if the current field contains date-time values).
ExcelFilterDefaultTab	Lists values that specify the default tab in the Excel-style filter popup.
ExcelFilterEnumFilters	Lists values that specify a set of relational operators (equality and inequalities) used to create a filter condition in the Filters tab of the Excel-style filter popup (if the current field contains enumeration data).
ExcelFilterNumericValuesTabFilterType	Lists values that specify the type of filtering UI used to create filters in the Values tab in the Excel-style filter popup (if the current field contains numeric data).
ExcelFilterTextFilters	Lists values that specify a set of relational operators (equality and inequalities) used to create a filter condition in the Filters tab of the Excel-style filter popup (if the current field contains text data).
FieldFilterPopupMode	Lists values that specify the field’s filter popup mode.
FilterPopupToolbarButtons	Lists values that identify buttons displayed within filter popup toolbars.
PivotContextMenuIds	Lists IDs that identify context menu items.
PivotEndUpdateMode	Lists values that specify whether the Pivot Grid Control is immediately redrawn after calling the PivotGridControl.EndUpdate method.
PivotGridAppearancesBase.PivotCellItemFlags
PivotGridHeaderHitTest	Lists values that identify the visual elements of a field header.
PivotGridHitTest	Lists values that identify a Pivot Grid Control’s elements.
PivotGridMenuType	Lists values that specify the Pivot Grid Control’s context menu types.
PivotGridScrolling	Contains values that specify how the PivotGrid control is scrolled horizontally.
PivotGridValueHitTest	Lists values that specify which field value cell element is located under the test point.
PivotShowButtonModeEnum	Contains values that specify which cells of a data field display editor buttons.
UserAction	Lists values that specify end-user actions on the PivotGridControl.