Skip to main content

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.