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. |
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. |
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 | Provides the capability to sort data using custom rules. |
CustomFieldValueCells | Allows you to customize field value cells. |
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 | In OLAP and server mode, provides the capability to sort data using custom rules. |
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. |
DpiChangedAfterParent | Occurs when the DPI setting for a control is changed programmatically after the DPI of its parent control or form has changed. Inherited from Control. |
DpiChangedBeforeParent | Occurs when the DPI setting for a control is changed programmatically before a DPI change event for its parent control or form has occurred. 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 | Fires after a cell value has been changed, allowing you to save changes. |
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. |
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 | |
FilterPopupExcelCustomizeTemplate | Allows you to customize templates used by Excel-style filter popups and external editors generated using Filtering UI Context. |
FilterPopupExcelData | Allows you to remove and modify items within Excel-style filter popups, as well as add custom items that apply specific filtering conditions. |
FilterPopupExcelPrepareTemplate | Allows you to replace templates used by Excel-style filter popups and external editors generated using Filtering UI Context. |
FilterPopupExcelQueryFilterCriteria | Allows you to customize a filter criteria applied using Excel-style filter popups. |
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. |
ParentChanged | Occurs when the Parent property value changes. Inherited from Control. |
PopupMenuShowing | Allows you to customize context menus. |
PrefilterCriteriaChanged | Fires when the Prefilter’s criteria are changed. |
PreviewKeyDown | Occurs before the KeyDown event when a key is pressed while focus is on this control. Inherited from Control. |
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. |
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 filtering 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 | |
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