Skip to main content

PivotGridControl Events

Allows you to create a pivot table (cross-tabular format) for multi-dimensional analysis of large amounts of data.
Name Description
ActiveFilterCriteriaChanged Occurs when the filter criteria, currently applied to the PivotGridControl, is changed.
AsyncOperationCompleted Occurs after an asynchronous operation has been completed.
AsyncOperationStarting Occurs before an asynchronous operation is started.
AutoSizeChanged This event is not relevant for this class. Inherited from Control.
BackColorChanged Occurs when the value of the BackColor property changes. Inherited from Control.
BackgroundImageChanged Occurs when the value of the BackgroundImage property changes. Inherited from Control.
BackgroundImageLayoutChanged Occurs when the BackgroundImageLayout property changes. Inherited from Control.
BeforeLoadLayout Occurs before a layout is restored from storage (a stream, xml file or the system registry).
BeginRefresh Occurs before the control’s data recalculation starts.
BindingContextChanged Occurs when the value of the BindingContext property changes. Inherited from Control.
CausesValidationChanged Occurs when the value of the CausesValidation property changes. Inherited from Control.
CellClick Occurs when a cell is clicked.
CellDoubleClick Occurs when a cell is double-clicked.
CellSelectionChanged Occurs when the cell selection is modified.
ChangeUICues Occurs when the focus or keyboard user interface (UI) cues change. Inherited from Control.
Click Occurs when the control is clicked. Inherited from Control.
ClientSizeChanged Occurs when the value of the ClientSize property changes. Inherited from Control.
ContextMenuChanged Occurs when the value of the ContextMenu property changes. Inherited from Control.
ContextMenuStripChanged Occurs when the value of the ContextMenuStrip property changes. Inherited from Control.
ControlAdded Occurs when a new control is added to the Control.ControlCollection. Inherited from Control.
ControlRemoved Occurs when a control is removed from the Control.ControlCollection. Inherited from Control.
CursorChanged Occurs when the value of the Cursor property changes. Inherited from Control.
CustomAppearance Allows the appearances of cells to be dynamically customized when the control is displayed on screen and in the print output.
CustomCellDisplayText Enables custom display text to be provided for the cells displayed within the Data Area.
CustomCellEdit Allows you to assign editors for particular cells. To avoid performance issues and increased memory consumption, assign repository items that already exist in the PivotGridControl.RepositoryItems collection. Do not create new repository items in this handler.
CustomCellEditForEditing Allows you to assign a custom editor to a cell for in-place editing, and override the default cell editor, which is used in both display and edit modes, by default. To avoid performance issues and increased memory consumption, assign repository items that already exist in the PivotGridControl.RepositoryItems collection. Do not create new repository items in this handler.
CustomCellValue Allows you to replace cell values with values calculated in the event handler.
CustomChartDataSourceData Occurs when a PivotGridControl prepares data to be displayed in a ChartControl.
CustomChartDataSourceRows Allows you to customize pivot grid data before passing it to a chart control.
CustomColumnWidth Enables the column width to be customized.
CustomCustomizationFormSort Allows you to change fields and folders order in the Customization Form.
CustomDrawCell Enables data cells to be painted manually.
CustomDrawEmptyArea Enables a Pivot Grid Control’s background to be custom painted.
CustomDrawFieldHeader Enables field headers to be painted manually.
CustomDrawFieldHeaderArea Enables header areas to be painted manually.
CustomDrawFieldValue Enables column and row headers to be painted manually.
CustomEditValue Enables you to change cell values.
CustomExportCell Enables you to render different content for individual cells in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomExportFieldValue Enables you to render different content for individual field values in a printed or exported document, if the PivotGrid is exported in the WYSIWYG mode.
CustomExportHeader Enables you to render different content for individual field headers in a printed or exported document, if the control is exported in the WYSIWYG mode.
CustomFieldSort Allows you to implement a custom sorting algorithm for field values.
CustomFieldValueCells Allows you to customize field value cells.
CustomFilterDisplayText Enables custom text to be displayed in the Filter Panel.
CustomFilterPopupItems Allows you to customize items displayed in the Classic filter popup.
CustomGroupInterval Allows you to custom group values of column and row fields.
CustomRowHeight Enables the rows height to be customized.
CustomServerModeSort Allows you to implement a custom sorting algorithm for the field values in OLAP and server modes.
CustomSummary Allows you to calculate a custom summary.
CustomUnboundFieldData Enables providing data to unbound fields.
DataSourceChanged Fires when the Pivot Grid Control’s data source changes.
Disposed Occurs when the component is disposed by a call to the Dispose() method. Inherited from Component.
DockChanged Occurs when the value of the Dock property changes. Inherited from Control.
DoubleClick Occurs when the control is double-clicked. Inherited from Control.
DragDrop Occurs when a drag-and-drop operation is completed. Inherited from Control.
DragEnter Occurs when an object is dragged into the control’s bounds. Inherited from Control.
DragLeave Occurs when an object is dragged out of the control’s bounds. Inherited from Control.
DragOver Occurs when an object is dragged over the control’s bounds. Inherited from Control.
EditorKeyDown Occurs when a key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyPress Occurs when a character key is pressed within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditorKeyUp Occurs when a pressed key is released within an in-place editor that belongs to the container control. Inherited from EditorContainer.
EditValueChanged Occurs when the cell value changes and allows you to save the changed value.
EnabledChanged Occurs when the Enabled property value has changed. Inherited from Control.
EndRefresh Occurs after the control’s data recalculation has been completed.
Enter Occurs when the control is entered. Inherited from Control.
ExportFinished Occurs after the PivotGrid’s export has been completed.
ExportStarted Occurs after the PivotGrid’s export has been started.
ExpressionEditorCreated
FieldAreaChanged Occurs after a field location or visibility has been changed.
FieldAreaChanging Enables you to control whether the dragged field header can be dropped at the area it’s currently located over.
FieldAreaIndexChanged Occurs after a field has been moved.
FieldExpandedInFieldGroupChanged Fires when the expansion status of fields combined into a field group is changed.
FieldFilterChanged Occurs after a specific field’s filter criteria was changed.
FieldFilterChanging Allows you to customize the filter that is being applied or cancel filtering.
FieldPropertyChanged Occurs after a field’s property has been changed.
FieldTooltipShowing Occurs before a tooltip is invoked.
FieldUnboundExpressionChanged Fires after the PivotGridFieldBase.UnboundExpression property’s value has been changed.
FieldValueCollapsed Fires after a field value has been collapsed.
FieldValueCollapsing Enables you to control whether field values can be collapsed.
FieldValueDisplayText Allows you to change the display text and display field’s data in a more user-friendly format.
FieldValueExpanded Fires after a field value has been expanded.
FieldValueExpanding Enables you to control whether field values can be expanded.
FieldValueImageIndex Enables images to be shown within column and row headers.
FieldValueNotExpanded Occurs in OLAP mode, when an end-user clicks an expand button or selects Expand All from the context menu, and the field value cannot be expanded.
FieldVisibleChanged Occurs after a field has been shown or hidden.
FieldWidthChanged Provides a notification that the field’s width has been changed.
FilterEditorCreated Allows you to customize the Filter Editor before it is displayed on-screen.
FilterPopupExcelCustomizeTemplate Allows you to customize templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelData Allows you to add, remove, and modify data values and customize predefined filters in the Excel style pop-up filter menus. Filter items added manually on this event must be unique and sorted.
FilterPopupExcelParseFilterCriteria Allows you to parse the filter criteria applied to data and select the corresponding values in the filter menu.
FilterPopupExcelPrepareTemplate Allows you to replace templates used by Excel-style filter popups and external editors generated using Filtering UI Context.
FilterPopupExcelQueryFilterCriteria Fires when a filter criteria is about to be applied to data and allows you to customize the filter criteria.
FocusedCellChanged Fires in response to cell focus changing.
FontChanged Occurs when the Font property value changes. Inherited from Control.
ForeColorChanged Occurs when the ForeColor property value changes. Inherited from Control.
GiveFeedback Occurs during a drag operation. Inherited from Control.
GotFocus Occurs when the control receives focus. Inherited from Control.
GridLayout Fires after the control’s layout has been changed.
GroupFilterChanged Occurs after a group filter condition was changed.
HandleCreated Occurs when a handle is created for the control. Inherited from Control.
HandleDestroyed Occurs when the control’s handle is in the process of being destroyed. Inherited from Control.
HelpRequested Occurs when the user requests help for a control. Inherited from Control.
HiddenEditor Fires after an in-place editor has been closed.
HideCustomizationForm Fires before the Customization Form is closed.
ImeModeChanged Occurs when the ImeMode property has changed. Inherited from Control.
Invalidated Occurs when a control’s display requires redrawing. Inherited from Control.
InvalidValueException Enables you to provide a proper response to entering an invalid cell value.
KeyDown Occurs when a key is pressed while the control has focus. Inherited from Control.
KeyPress Occurs when a character. space or backspace key is pressed while the control has focus. Inherited from Control.
KeyUp Occurs when a key is released while the control has focus. Inherited from Control.
Layout Occurs when a control should reposition its child controls. Inherited from Control.
LayoutUpgrade Occurs when a layout is restored from a data store (a stream, xml file or the system registry) and its version is different than that of the control’s current layout version.
Leave Occurs when the input focus leaves the control. Inherited from Control.
LeftTopCellChanged Occurs after the Pivot Grid Control is scrolled.
LocationChanged Occurs when the Location property value has changed. Inherited from Control.
LostFocus Occurs when the control loses focus. Inherited from Control.
MarginChanged Occurs when the control’s margin changes. Inherited from Control.
MenuItemClick Allows custom responses to be provided for clicks on context menu items.
MouseCaptureChanged Occurs when the control loses mouse capture. Inherited from Control.
MouseClick Occurs when the control is clicked by the mouse. Inherited from Control.
MouseDoubleClick Occurs when the control is double clicked by the mouse. Inherited from Control.
MouseDown Occurs when the mouse pointer is over the control and a mouse button is pressed. Inherited from Control.
MouseEnter Occurs when the mouse pointer enters the control. Inherited from Control.
MouseHover Occurs when the mouse pointer rests on the control. Inherited from Control.
MouseLeave Occurs when the mouse pointer leaves the control. Inherited from Control.
MouseMove Occurs when the mouse pointer is moved over the control. Inherited from Control.
MouseUp Occurs when the mouse pointer is over the control and a mouse button is released. Inherited from Control.
MouseWheel Occurs when the mouse wheel moves while the control has focus. Inherited from Control.
Move Occurs when the control is moved. Inherited from Control.
OLAPException Obsolete. Raised when a query processing error occurs on a bound OLAP server, or when the connection to this server is lost.
OLAPQueryData Allows you to get a query used to obtain data in PivotGrid.
OLAPQueryTimeout Fires after a specific interval of time has elapsed when sending a query to an OLAP server.
PaddingChanged Occurs when the control’s padding changes. Inherited from Control.
Paint Occurs when the control is redrawn. Inherited from Control.
PaintEx A DirectX-compatible method that replaces the standard Control.Paint method.
ParentChanged Occurs when the Parent property value changes. Inherited from Control.
PopupMenuShowing Allows you to customize built-in context menus or invoke custom menus.
PreviewKeyDown Occurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control.
PropertyDeserializing
PropertySerializing
QueryAccessibilityHelp Occurs when AccessibleObject is providing help to accessibility applications. Inherited from Control.
QueryContinueDrag Occurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. Inherited from Control.
QueryCustomFunctions Allows you to add custom-function-based filters (for example, ‘discount is more than 15%’) to Excel-style pop-up filter menus and/or the filter editor.
QueryException Occurs when a query processing error occurs on a bound server providing data for the PivotGridControl.
RegionChanged Occurs when the value of the Region property changes. Inherited from Control.
Resize Occurs when the control is resized. Inherited from Control.
RightToLeftChanged Occurs when the RightToLeft property value changes. Inherited from Control.
ShowCustomizationForm Fires immediately after the Customization Form has been invoked.
ShowFilterPopupExcel Allows you to customize the Excel-style filter popup (for instance, to hide specific filter conditions from the Filters tab).
ShowingCustomizationForm Occurs before the Customization Form is displayed.
ShowingEditor Allows you to cancel editor activation.
ShownEditor Fires after a cell editor has been invoked.
SizeChanged Occurs when the Size property value changes. Inherited from Control.
StyleChanged Occurs when the control style changes. Inherited from Control.
SystemColorsChanged Occurs when the system colors change. Inherited from Control.
TabIndexChanged Occurs when the TabIndex property value changes. Inherited from Control.
TabStopChanged Occurs when the TabStop property value changes. Inherited from Control.
TextChanged Occurs when the Text property value changes. Inherited from Control.
UnboundExpressionEditorCreated Fires after an Expression Editor is created for an unbound field.
UserActionChanged Allows you to respond to end-user actions performed on the PivotGridControl.
Validated Occurs when the control is finished validating. Inherited from Control.
Validating Occurs when the control is validating. Inherited from Control.
ValidatingEditor Enables you to manually validate cell values.
VisibleChanged Occurs when the Visible property value changes. Inherited from Control.
See Also