PivotGridControl Members
Allows you to create a pivot table (cross-tabular format) for multi-dimensional analysis of large amounts of data.Constructors
| Name | Description |
|---|---|
| PivotGridControl() | Initializes a new instance of the PivotGridControl class. |
Properties
| Name | Description |
|---|---|
| AccessibilityObject | Gets the AccessibleObject assigned to the control. Inherited from Control. |
| AccessibleDefaultActionDescription | Gets or sets the default action description of the control for use by accessibility client applications. Inherited from Control. |
| AccessibleDescription | Gets or sets the description of the control used by accessibility client applications. Inherited from Control. |
| AccessibleName | Gets or sets the name of the control used by accessibility client applications. Inherited from Control. |
| AccessibleRole | Gets or sets the accessible role of the control. Inherited from Control. |
| ActiveEditor | Gets the PivotGrid’s active editor. |
| ActiveFilter | Provides access to settings of the filter applied to the PivotGridControl‘s data. |
| ActiveFilterCriteria | Gets or sets the filter criteria applied to the PivotGridControl‘s data. |
| ActiveFilterEnabled | Gets or sets whether to apply the filter criteria specified using the PivotGridControl.ActiveFilterCriteria or PivotGridControl.ActiveFilterString. |
| ActiveFilterString | Gets or sets a string that specifies the filter criteria applied to the PivotGridControl‘s data. |
| AllowDrop | Gets or sets a value indicating whether the control can accept data that the user drags onto it. Inherited from Control. |
| AllowTouchGestures | Gets or sets whether the EditorContainer allows touch gestures when the app runs on touch-enabled devices. Inherited from EditorContainer. |
| Anchor | Gets or sets the edges of the container to which a control is bound and determines how a control is resized with its parent. Inherited from Control. |
| Appearance | Provides access to the properties that control the appearance of the PivotGrid control’s elements. |
| AppearancePrint | Provides access to the properties that specify the appearances of the PivotGrid control’s elements when it’s printed. |
| AutoScrollOffset | Gets or sets where this control is scrolled to in ScrollControlIntoView(Control). Inherited from Control. |
| AutoSize | This property is not relevant for this class. Inherited from Control. |
| BackColor | Gets or sets the control’s background color. Inherited from EditorContainer. |
| BackgroundImage | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
| BackgroundImageLayout | This member supports the .NET Framework infrastructure and is not intended to be used directly from your code. |
| BindingContext | Gets or sets the BindingContext for the control. Inherited from Control. |
| BorderStyle | Gets or sets the border style for the PivotGridControl. |
| Bottom | Gets the distance, in pixels, between the bottom edge of the control and the top edge of its container’s client area. Inherited from Control. |
| Bounds | Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. Inherited from Control. |
| CanEnableIme protected | Gets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. Inherited from Control. |
| CanFocus | Gets a value indicating whether the control can receive focus. Inherited from Control. |
| CanRaiseEvents protected | Determines if events can be raised on the control. Inherited from Control. |
| CanSelect | Gets a value indicating whether the control can be selected. Inherited from Control. |
| Capture | Gets or sets a value indicating whether the control has captured the mouse. Inherited from Control. |
| CausesValidation | Gets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. Inherited from Control. |
| Cells | Gets the object which contains information on the cells that are displayed by the control. |
| CheckForIllegalCrossThreadCalls static | Gets or sets a value indicating whether to catch calls on the wrong thread that access a control’s Handle property when an application is being debugged. Inherited from Control. |
| ClientRectangle | Gets the rectangle that represents the client area of the control. Inherited from Control. |
| ClientSize | Gets or sets the height and width of the client area of the control. Inherited from Control. |
| CompanyName | Gets the name of the company or creator of the application containing the control. Inherited from Control. |
| Container | Gets the IContainer that contains the Component. Inherited from Component. |
| ContainsFocus | Gets a value indicating whether the control, or one of its child controls, currently has the input focus. Inherited from Control. |
| ContextMenu | Gets or sets the shortcut menu associated with the control. Inherited from Control. |
| Controls | Gets the collection of controls contained within the control. Inherited from Control. |
| Created | Gets a value indicating whether the control has been created. Inherited from Control. |
| CreateParams protected | Gets the required creation parameters when the control handle is created. Inherited from Control. |
| Cursor | Gets or sets the cursor that is displayed when the mouse pointer is over the control. Inherited from Control. |
| CustomizationForm | Provides access to the Customization Form. |
| CustomizationFormBounds | Gets or sets the boundaries of the Customization Form. |
| CustomizationTreeNodeImages static | Specifies the collection of images identifying nodes in the Customization Form used when the control is in OLAP mode. |
| CustomizationTreeNodeSvgImages static | Gets or sets a vector image that identifies nodes in the Customization Form when the control is in OLAP mode. |
| DataBindings | Gets the data bindings for the control. Inherited from Control. |
| DataMember | Gets or sets the data source member which supplies data to the control. |
| DataSource | Gets or sets the object used as the data source for the current control. |
| DefaultBackColor static | Gets the default background color of the control. Inherited from Control. |
| DefaultCursor protected | Gets or sets the default cursor for the control. Inherited from Control. |
| DefaultDataProcessingEngine static | Gets or sets a default engine used to perform data processing in the pivot grid. |
| DefaultFilterEditorView | Gets or sets the how an end-user can edit criteria in the Filter Editor. |
| DefaultFont static | Gets the default font of the control. Inherited from Control. |
| DefaultForeColor static | Gets the default foreground color of the control. Inherited from Control. |
| DefaultImeMode protected | Gets the default Input Method Editor (IME) mode supported by the control. Inherited from Control. |
| DefaultMargin protected | Gets the space, in pixels, that is specified by default between controls. Inherited from Control. |
| DefaultMaximumSize protected | Gets the length and height, in pixels, that is specified as the default maximum size of a control. Inherited from Control. |
| DefaultMinimumSize protected | Gets the length and height, in pixels, that is specified as the default minimum size of a control. Inherited from Control. |
| DefaultPadding protected | Gets the internal spacing, in pixels, of the contents of a control. Inherited from Control. |
| DesignMode protected | Gets a value that indicates whether the Component is currently in design mode. Inherited from Component. |
| DisplayRectangle | Gets the rectangle that represents the display area of the control. Inherited from Control. |
| Disposing | Gets a value indicating whether the base Control class is in the process of disposing. Inherited from Control. |
| Dock | Gets or sets which control borders are docked to its parent control and determines how a control is resized with its parent. Inherited from Control. |
| DoubleBuffered protected | Gets or sets a value indicating whether this control should redraw its surface using a secondary buffer to reduce or prevent flicker. Inherited from Control. |
| EditValue | Gets or sets the active editor’s value. |
| Enabled | Gets or sets a value indicating whether the control can respond to user interaction. Inherited from Control. |
| EndUpdateMode static | Gets or sets whether the PivotGrid will be immediately redrawn after calling the PivotGridControl.EndUpdate method. |
| Events protected | Gets the list of event handlers that are attached to this Component. Inherited from Component. |
| ExternalRepository | Gets or sets the external repository of in-place editors. Inherited from EditorContainer. |
| Fields | Provides access to a PivotGrid control’s field collection. |
| FixedColumnFieldValues | Provides access to the fixed columns collection. |
| FixedLineWidth | Gets or sets the width of pinned columns separators. |
| Focused | Gets a value indicating whether the control has input focus. Inherited from Control. |
| Font | Overrides the base class Font property. |
| FontHeight protected | Gets or sets the height of the font of the control. Inherited from Control. |
| ForeColor | Gets or sets the control’s foreground color. Inherited from EditorContainer. |
| FormatConditions | Gets the collection of style format conditions. |
| FormatRules | Gets the collection of style format rules for a PivotGridControl. |
| Groups | Gets the collection of field groups. |
| Handle | Gets the window handle that the control is bound to. Inherited from Control. |
| HasChildren | Gets a value indicating whether the control contains one or more child controls. Inherited from Control. |
| HeaderImages | Gets or sets the source of images available for display within field headers. |
| Height | Gets or sets the height of the control. Inherited from Control. |
| HtmlImages | Gets or sets a collection of images which can be used in HTML string displayed in the field headers or values. |
| ImeMode | Gets or sets the Input Method Editor (IME) mode of the control. Inherited from Control. |
| ImeModeBase protected | Gets or sets the IME mode of a control. Inherited from Control. |
| InvokeRequired | Gets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. Inherited from Control. |
| IsAccessible | Gets or sets a value indicating whether the control is visible to accessibility applications. Inherited from Control. |
| IsAsyncInProgress | Gets whether an asynchronous operation is in progress. |
| IsDesignMode | This member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer. |
| IsDisposed | Gets a value indicating whether the control has been disposed of. Inherited from Control. |
| IsDragging | Indicates whether a field header is being dragged by a user. |
| IsHandleCreated | Gets a value indicating whether the control has a handle associated with it. Inherited from Control. |
| IsLoading | Gets whether the control is being initialized. Inherited from EditorContainer. |
| IsMirrored | Gets a value indicating whether the control is mirrored. Inherited from Control. |
| IsOLAPDataSource | Returns whether a connection string is specified via the PivotGridControl.OLAPConnectionString property, and so the control is bound to a cube in an MS Analysis Services database. |
| IsPrintingAvailable | Indicates whether the Pivot Grid Control can be printed. |
| IsUpdateLocked | Gets whether the PivotGridControl has been locked for updating. |
| LayoutEngine | Gets a cached instance of the control’s layout engine. Inherited from Control. |
| Left | Gets or sets the distance, in pixels, between the left edge of the control and the left edge of its container’s client area. Inherited from Control. |
| LeftTopCoord | Gets or sets the column and row indexes of the data cell displayed in the top left corner. |
| ListSource | Gets the actual data source whose data is displayed within the control. |
| LoadingPanelVisible | Gets or sets whether the animated loading panel that indicates the data load process is displayed. |
| Location | Gets or sets the coordinates of the upper-left corner of the control relative to the upper-left corner of its container. Inherited from Control. |
| LookAndFeel | Inherited from EditorContainer. |
| Margin | Gets or sets the space between controls. Inherited from Control. |
| MaximumSize | Gets or sets the size that is the upper limit that GetPreferredSize(Size) can specify. Inherited from Control. |
| MenuManager | Gets or sets an object that controls the look and feel of the popup menus. Inherited from EditorContainer. |
| MinimumSize | Gets or sets the size that is the lower limit that GetPreferredSize(Size) can specify. Inherited from Control. |
| ModifierKeys static | Gets a value indicating which of the modifier keys (SHIFT, CTRL, and ALT) is in a pressed state. Inherited from Control. |
| MouseButtons static | Gets a value indicating which of the mouse buttons is in a pressed state. Inherited from Control. |
| MousePosition static | Gets the position of the mouse cursor in screen coordinates. Inherited from Control. |
| MRUFilters | Gets the recently applied filters list (see MRU Filter List article). |
| Name | Gets or sets the name of the control. Inherited from Control. |
| OLAPConnectionString | Specifies a connection string to a cube in an MS Analysis Services database. |
| OLAPDataProvider | Gets or sets which data provider should be used to bind to an OLAP cube. |
| OptionsBehavior | Provides access to the control’s behavior options. |
| OptionsChartDataSource | Provides access to the options controlling the display of the PivotGrid control’s data in a chart control. |
| OptionsCustomization | Provides access to the Pivot Grid Control’s customization options. |
| OptionsData | Provides access to the Pivot Grid Control’s data specific options. |
| OptionsDataField | Provides access to the options which control the presentation of the data fields in the PivotGrid. |
| OptionsFilter | Provides access to the Pivot Grid’s filter options. |
| OptionsFilterPopup | Provides access to options that define the Classic filter popup’s appearance and behavior. |
| OptionsHint | Provides access to the Pivot Grid Control’s hint options. |
| OptionsLayout | Provides options that control how the Pivot Grid Control layout is stored to/restored from a storage (a stream, XML file or system registry). |
| OptionsMenu | Provides access to the Pivot Grid Control’s menu options. |
| OptionsOLAP | Provides access to the Pivot Grid Control’s OLAP mode specific options. |
| OptionsPrint | Provides access to the Pivot Grid’s appearance and layout options used when printing or exporting the control in WYSIWYG mode. |
| OptionsSelection | Provides access to the Pivot Grid Control’s selection options. |
| OptionsView | Provides access to the Pivot Grid Control’s display options. |
| Padding | Gets or sets padding within the control. Inherited from Control. |
| PaintAppearance | Provides access to the appearance settings currently used to paint the Pivot Grid Control’s elements. |
| PaintAppearancePrint | Provides access to the appearance settings used to paint the Pivot Grid Control’s elements when it’s printed. |
| Parent | Gets or sets the parent container of the control. Inherited from Control. |
| PreferredSize | Gets the size of a rectangular area into which the control can fit. Inherited from Control. |
| ProductName | Gets the product name of the assembly containing the control. Inherited from Control. |
| ProductVersion | Gets the version of the assembly containing the control. Inherited from Control. |
| PropagatingImeMode protected static | Gets an object that represents a propagating IME mode. Inherited from Control. |
| RecreatingHandle | Gets a value indicating whether the control is currently re-creating its handle. Inherited from Control. |
| Region | Gets or sets the window region associated with the control. Inherited from Control. |
| RenderRightToLeft protected | This property is now obsolete. Inherited from Control. |
| RepositoryItems | Provides access to the control’s internal repository of in-place editors. Inherited from EditorContainer. |
| ResizeRedraw protected | Gets or sets a value indicating whether the control redraws itself when resized. Inherited from Control. |
| Right | Gets the distance, in pixels, between the right edge of the control and the left edge of its container’s client area. Inherited from Control. |
| RightToLeft | Gets or sets a value indicating whether control’s elements are aligned to support locales using right-to-left fonts. Inherited from Control. |
| ScaleChildren protected | Gets a value that determines the scaling of child controls. Inherited from Control. |
| ScaleFactor | This member supports the internal infrastructure, and is not intended to be used directly from your code. Inherited from EditorContainer. |
| ShowCustomFunctions | Gets or sets whether to show custom function-based filters. |
| ShowFocusCues protected | Gets a value indicating whether the control should display focus rectangles. Inherited from Control. |
| ShowKeyboardCues protected | Gets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. Inherited from Control. |
| Site | Gets or sets the site of the control. Inherited from Control. |
| Size | Gets or sets the height and width of the control. Inherited from Control. |
| TabIndex | Gets or sets the tab order of the control within its container. Inherited from Control. |
| TabStop | Gets or sets a value indicating whether the user can give the focus to this control using the TAB key. Inherited from Control. |
| Tag | Gets or sets the object that contains data about the control. Inherited from Control. |
| Text | Gets or sets the string associated with the control. |
| ToolTipController | Gets or sets the component that controls the behavior and appearance of hints displayed for a container control’s visual elements. Inherited from EditorContainer. |
| Top | Gets or sets the distance, in pixels, between the top edge of the control and the top edge of its container’s client area. Inherited from Control. |
| TopLevelControl | Gets the parent control that is not parented by another Windows Forms control. Typically, this is the outermost Form that the control is contained in. Inherited from Control. |
| UseDirectXPaint | Gets or sets whether the DirectX Hardware Acceleration is enabled for this Pivot Grid Control. |
| UseDisabledStatePainter | Gets or sets whether the control is painted grayed out, when in the disabled state. |
| UserAction | Gets the end-user action performed on the PivotGridControl. |
| UseWaitCursor | Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. Inherited from Control. |
| ValueImages | Gets or sets the source of images that are available for display within field values. |
| Visible | Gets or sets a value indicating whether the control and all its child controls are displayed. Inherited from Control. |
| Width | Gets or sets the width of the control. Inherited from Control. |
| WindowTarget | This property is not relevant for this class. Inherited from Control. |
Methods
| Name | Description |
|---|---|
| About() static | Activates the Pivot Grid Control’s About dialog box. |
| AccessibilityNotifyClients(AccessibleEvents, Int32, Int32) protected | Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . Inherited from Control. |
| AccessibilityNotifyClients(AccessibleEvents, Int32) protected | Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control. Inherited from Control. |
| BeginInit() | Notifies the control that the initialization has started. Inherited from EditorContainer. |
| BeginInvoke(Delegate, Object[]) | Executes the specified delegate asynchronously with the specified arguments, on the thread that the control’s underlying handle was created on. Inherited from Control. |
| BeginInvoke(Delegate) | Executes the specified delegate asynchronously on the thread that the control’s underlying handle was created on. Inherited from Control. |
| BeginUpdate() | Locks the PivotGridControl object by preventing visual updates of the object and its elements until the EndUpdate method is called. |
| BestFit() | Resizes all columns to fit their contents. |
| BestFit(PivotGridField) | Resizes the column(s) related to the specified field to fit the longest text currently displayed in the column. |
| BestFitColumnArea() | Resizes columns in the Data Area to the minimum width required to display their contents. |
| BestFitDataHeaders(Boolean) | Resizes the Data Header Area to the minimum width required to display data field headers. |
| BestFitRowArea() | Resizes columns that display row field values to the minimum width required to display their contents. |
| BringToFront() | Brings the control to the front of the z-order. Inherited from Control. |
| CalcHitInfo(Point) | Returns information on the grid elements located at the specified point. |
| CanResizeField(Point) | Indicates whether the field can be resized. |
| ChangeFieldExpandedAsync(PivotGridFieldBase, Boolean) | Expands or collapses all values of the specified Pivot Grid field asynchronously. |
| ChangeFieldSortOrderAsync(PivotGridField) | Toggles the sort order of the specified field asynchronously. |
| CheckActiveEditor(Control) static | Returns whether the EditorContainer descendant is active. Inherited from EditorContainer. |
| ClearFieldSortingAsync(PivotGridField) | Clears field sorting asynchronously in OLAP mode. |
| CloseEditor() | Hides the active editor, saving changes made. |
| CloseEditorAsync() | |
| CollapseAll() | Collapses all the columns and rows in the PivotGridControl. |
| CollapseAllAsync() | Collapses all columns and rows in a Pivot Grid control asynchronously. |
| CollapseAllColumns() | Collapses all columns. |
| CollapseAllColumnsAsync() | Collapses all columns asynchronously. |
| CollapseAllRows() | Collapses all rows. |
| CollapseAllRowsAsync() | Collapses all rows asynchronously. |
| CollapseValue(Boolean, Object[]) | Collapses a specific column or row that is identified by the specified values. |
| CollapseValueAsync(Boolean, Object[]) | Collapses the specified column or row asynchronously. |
| Contains(Control) | Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control. |
| ConvertFormatConditionToFormatRules() | Converts the PivotGridStyleFormatCondition object to the PivotGridFormatRule object. |
| CreateControl() | Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control. |
| CreateControlsInstance() protected | Creates a new instance of the control collection for the control. Inherited from Control. |
| CreateDrillDownDataSource() | Returns data records used to calculate summary values for all cells. |
| CreateDrillDownDataSource(Int32, Int32, List<String>) | Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns to return. |
| CreateDrillDownDataSource(Int32, Int32, Int32, List<String>) | Returns data records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to return. |
| CreateDrillDownDataSource(Int32, Int32, Int32) | Returns data records used to calculate a summary value for the specified cell. Allows you to limit the number of returned records. |
| CreateDrillDownDataSource(Int32, Int32) | Returns a list of records used to calculate a summary value for the specified cell. |
| CreateDrillDownDataSourceAsync() | Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
| CreateDrillDownDataSourceAsync(Int32, Int32, List<String>) | Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
| CreateDrillDownDataSourceAsync(Int32, Int32, Int32, List<String>) | Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
| CreateDrillDownDataSourceAsync(Int32, Int32, Int32) | Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
| CreateDrillDownDataSourceAsync(Int32, Int32) | Returns a list of records used to calculate a summary value for the specified cell asynchronously. |
| CreateGraphics() | Creates the Graphics for the control. Inherited from Control. |
| CreateObjRef(Type) | Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. Inherited from MarshalByRefObject. |
| CreateOLAPDataSourceClone() | Creates a copy of the current pivot grid’s OLAP data source instance. |
| CreateOLAPDrillDownDataSource(Int32, Int32, List<String>) | Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns to be returned. |
| CreateOLAPDrillDownDataSource(Int32, Int32, Int32, List<String>) | Obsolete. In OLAP mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned. |
| CreateServerModeDrillDownDataSource(Int32, Int32, List<String>) | Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell. |
| CreateServerModeDrillDownDataSource(Int32, Int32, Int32, List<String>) | Obsolete. In server mode, returns a list of records used to calculate a summary value for the specified cell. Allows you to specify the columns and limit the number of records to be returned. |
| CreateSummaryDataSource() | Returns a summary data source. |
| DefWndProc(Message) protected | Sends the specified message to the default window procedure. Inherited from Control. |
| DestroyHandle() protected | Destroys the handle associated with the control. Inherited from Control. |
| Dispose() | Releases all resources used by the Component. Inherited from Component. |
| DoDragDrop(Object, DragDropEffects) | Begins a drag-and-drop operation. Inherited from Control. |
| DrawToBitmap(Bitmap, Rectangle) | Supports rendering to the specified bitmap. Inherited from Control. |
| EndInit() | Notifies the control that the initialization has been completed. Inherited from EditorContainer. |
| EndInvoke(IAsyncResult) | Retrieves the return value of the asynchronous operation represented by the IAsyncResult passed. Inherited from Control. |
| EndUpdate() | Unlocks the PivotGridControl object after a call to the BeginUpdate method and causes an immediate visual update. |
| EndUpdateAsync() | Unlocks the Pivot Grid control after the PivotGridControl.BeginUpdate method call, and starts an asynchronous update. |
| EnsureViewInfoIsCalculated() | Ensures that the Pivot Grid Control’s view information has been calculated. If not, forces the Pivot Grid Control to calculate the view information. |
| Equals(Object, Object) static | Determines whether the specified object instances are considered equal. Inherited from Object. |
| Equals(Object) | Determines whether the specified object is equal to the current object. Inherited from Object. |
| ExpandAll() | Expands all the columns and rows in the PivotGridControl. |
| ExpandAllAsync() | Expands all columns and rows in the Pivot Grid control asynchronously. |
| ExpandAllColumns() | Expands all columns. |
| ExpandAllColumnsAsync() | Expands all columns asynchronously. |
| ExpandAllRows() | Expands all rows. |
| ExpandAllRowsAsync() | Expands all rows asynchronously. |
| ExpandValue(Boolean, Object[]) | Expands a specific column or row that is identified by the specified values. |
| ExpandValueAsync(Boolean, Object[]) | Expands the specified column or row asynchronously. |
| ExportToCsv(Stream, CsvExportOptions) | Exports the control’s data to the specified stream in CSV format using the specified options. |
| ExportToCsv(Stream) | Exports the control’s data to the specified stream in CSV. |
| ExportToCsv(String, CsvExportOptions) | Exports the control’s data to the specified file in CSV format using the specified options. |
| ExportToCsv(String) | Exports the control’s data to the specified file in CSV format. |
| ExportToDocx(Stream, DocxExportOptions) | Exports the control’s data to the specified stream in DOCX format using the specified options. |
| ExportToDocx(Stream) | Exports the Pivot Grid Control’s data to a DOCX document and sends it to the specified stream. |
| ExportToDocx(String, DocxExportOptions) | Exports the control’s data to the specified file in DOCX format using the specified options. |
| ExportToDocx(String) | Exports the Pivot Grid Control’s data to the specified DOCX file. |
| ExportToHtml(Stream, HtmlExportOptions) | Exports the control’s data to the specified stream in HTML format using the specified options. |
| ExportToHtml(Stream, String, String, Boolean) | Exports the Pivot Grid Control’s data to an HTML document with the specified encoding and title and sends it to the specified stream. The output file can be compressed (secondary characters e.g. spaces are removed) if required. |
| ExportToHtml(Stream) | Exports the Pivot Grid Control’s data as HTML and sends it to the specified stream. |
| ExportToHtml(String, HtmlExportOptions) | Exports the control’s data to the specified file in HTML format using the specified options. |
| ExportToHtml(String, String, String, Boolean) | Exports the Pivot Grid Control’s data to an HTML file with the specified encoding and title. The output file can be compressed (secondary characters e.g. spaces are removed) if required. |
| ExportToHtml(String, String) | Exports the Pivot Grid Control’s data to a HTML file with the specified encoding. |
| ExportToHtml(String) | Exports the Pivot Grid Control’s data to the specified file as HTML. |
| ExportToImage(Stream, ImageExportOptions) | Exports the control’s data to the specified stream in Image format using the specified Image-specific options. |
| ExportToImage(Stream) | Exports the control’s data to the specified stream in BMP format. |
| ExportToImage(String, ImageExportOptions) | Exports the control’s data to the specified file in Image format using the specified Image-specific options. |
| ExportToImage(String) | Exports the control’s data to the specified file in BMP format. |
| ExportToMht(Stream, MhtExportOptions) | Exports the control’s data to the specified stream in MHT format using the specified options. |
| ExportToMht(Stream, String, String, Boolean) | Exports the Pivot Grid Control’s data to an MHT document (Web archive, single file) at the specified path and title and sends it to the specified stream. The output file can be compressed (secondary characters e.g. spaces are removed) if required. |
| ExportToMht(String, MhtExportOptions) | Exports the control’s data to the specified file in MHT format using the specified options. |
| ExportToMht(String, String, String, Boolean) | Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) with the specified path and title. The output file can be compressed (secondary characters e.g. spaces are removed) if required. |
| ExportToMht(String, String) | Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) at the specified path and with the specified encoding. |
| ExportToMht(String) | Exports the Pivot Grid Control’s data to an MHT file (Web archive, single file) at the specified path. |
| ExportToPdf(Stream, PdfExportOptions) | Exports the control’s data to the specified stream in PDF format using the specified options. |
| ExportToPdf(Stream) | Exports the Pivot Grid Control’s data to a PDF document and sends it to the specified stream. |
| ExportToPdf(String, PdfExportOptions) | Exports the control’s data to the specified file in PDF format using the specified options. |
| ExportToPdf(String) | Exports the Pivot Grid Control’s data to the specified PDF file. |
| ExportToRtf(Stream) | Exports the Pivot Grid Control’s data as Rich Text and sends it to the specified stream. |
| ExportToRtf(String) | Exports the Pivot Grid Control’s data to the specified RTF file. |
| ExportToText(Stream, TextExportOptions) | Exports the control’s data to the specified stream in Text format using the specified options. |
| ExportToText(Stream, String, Encoding) | Exports the Pivot Grid Control’s data to a text document with the specified separator string, text encoding settings and sends it to the specified stream. |
| ExportToText(Stream, String) | Exports the Pivot Grid Control’s data to a text document with the specified separator string and sends it to the specified stream. |
| ExportToText(Stream) | Exports the Pivot Grid Control’s data to a text document and sends it to the specified stream. |
| ExportToText(String, TextExportOptions) | Exports the control’s data to the specified file in Text format using the specified options. |
| ExportToText(String, String, Encoding) | Exports the Pivot Grid Control’s data to a text document with the specified separator string and text encoding settings, and sends it to the specified file. |
| ExportToText(String, String) | Exports the Pivot Grid Control’s data to a text file at the specified path and with the specified separator string. |
| ExportToText(String) | Exports the Pivot Grid Control’s data to a text file at the specified path. |
| ExportToXls(Stream, TextExportMode) | Exports the control’s data to the specified stream in XLS format using the specified options. |
| ExportToXls(Stream, XlsExportOptions) | Exports the control’s data to the specified stream in XLS format using the specified options. |
| ExportToXls(Stream) | Exports the Pivot Grid Control’s data as XLS and sends it to the specified stream. |
| ExportToXls(String, TextExportMode) | Exports the control’s data to the specified file in XLS format using the specified options. |
| ExportToXls(String, XlsExportOptions) | Exports the control’s data to the specified file in XLS format using the specified options. |
| ExportToXls(String) | Exports the Pivot Grid Control’s data to the specified file as XLS. |
| ExportToXlsx(Stream, TextExportMode) | Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
| ExportToXlsx(Stream, XlsxExportOptions) | Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
| ExportToXlsx(Stream) | Exports the control’s data to the specified stream in XLSX (MS Excel 2007) format. |
| ExportToXlsx(String, TextExportMode) | Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
| ExportToXlsx(String, XlsxExportOptions) | Exports the control’s data to the specified file in XLSX (MS Excel 2007) format using the specified options. |
| ExportToXlsx(String) | Exports the control’s data to the specified file in XLSX (MS Excel 2007) format. |
| FindForm() | Retrieves the form that the control is on. Inherited from Control. |
| Focus() | Sets input focus to the control. Inherited from Control. |
| ForceInitialize() | Forces the Pivot Grid Control to finish its initialization. |
| FromChildHandle(IntPtr) static | Retrieves the control that contains the specified handle. Inherited from Control. |
| FromHandle(IntPtr) static | Returns the control that is currently associated with the specified handle. Inherited from Control. |
| GetAutoSizeMode() protected | Retrieves a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control. |
| GetCellValue(Int32, Int32) | Returns a cell value by the column and row indexes. |
| GetCellValue(Object[], Object[], PivotGridField) | Returns a cell value calculated for the specified column and row field values, against the specified data field. |
| GetCellValue(Object[], Object[]) | Returns a cell value calculated for the specified column and row field values. |
| GetChildAtPoint(Point, GetChildAtPointSkip) | Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control. |
| GetChildAtPoint(Point) | Retrieves the child control that is located at the specified coordinates. Inherited from Control. |
| GetColumnIndex(Object[], PivotGridField) | Returns the index of the specified column. |
| GetColumnIndex(Object[]) | Returns the index of the specified column. |
| GetContainerControl() | Returns the next ContainerControl up the control’s chain of parent controls. Inherited from Control. |
| GetFieldAt(Point) | Returns the field whose header is displayed at the specified point. |
| GetFieldByArea(PivotArea, Int32) | Returns a field at the specified visual position in the specified area. |
| GetFieldList() | Returns the list of fields that are available in the bound data source. |
| GetFieldsByArea(PivotArea) | Returns a list of fields displayed in the specified area. |
| GetFieldValue(PivotGridField, Int32) | Returns the specified column or row field’s value for the cell addressed by its zero-based index in the Data Area. |
| GetFieldValueOLAPMember(PivotGridField, Int32) | Returns an OLAP member for the specified field value. |
| GetFieldValueType(PivotGridField, Int32) | Gets the type of a specific column/row field’s value. |
| GetFieldValueType(Boolean, Int32) | Gets the type of a field value in the column or row area. |
| GetHashCode() | Serves as the default hash function. Inherited from Object. |
| GetKPISvgBitmap(PivotKPIGraphic, Int32) | |
| GetLifetimeService() | Retrieves the current lifetime service object that controls the lifetime policy for this instance. Inherited from MarshalByRefObject. |
| GetNextControl(Control, Boolean) | Retrieves the next control forward or back in the tab order of child controls. Inherited from Control. |
| GetOLAPKPIList() | Gets the list of key performance indicators (KPI) in a cube. |
| GetOLAPKPIMeasures(String) | Returns the Measures dimension’s members used to calculate the value, goal, status and weight of the specified Key Performance Indicator (KPI). |
| GetOLAPKPIServerGraphic(String, PivotKPIType) | Returns a graphic set defined on the server for the specified KPI’s trend and status. |
| GetOLAPKPIValue(String) | Returns the specified KPI’s value. |
| GetPreferredSize(Size) | Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control. |
| GetRowIndex(Object[], PivotGridField) | Returns the index of the specified row. |
| GetRowIndex(Object[]) | Returns the index of the specified row. |
| GetScaledBounds(Rectangle, SizeF, BoundsSpecified) protected | Retrieves the bounds within which the control is scaled. Inherited from Control. |
| GetService(Type) protected | Returns an object that represents a service provided by the Component or by its Container. Inherited from Component. |
| GetStyle(ControlStyles) protected | Retrieves the value of the specified control style bit for the control. Inherited from Control. |
| GetToolTipController() | Returns the actual tooltip controller that controls the behavior and appearance of hints for the container editor. Inherited from EditorContainer. |
| GetTopLevel() protected | Determines if the control is a top-level control. Inherited from Control. |
| GetType() | Gets the Type of the current instance. Inherited from Object. |
| Hide() | Conceals the control from the user. Inherited from Control. |
| HideCustomization() | Closes the Customization Form. |
| HideEditor() | Hides the active editor discarding any changes made. |
| InitializeLifetimeService() | Obtains a lifetime service object to control the lifetime policy for this instance. Inherited from MarshalByRefObject. |
| InitLayout() protected | Called after the control has been added to another container. Inherited from Control. |
| Invalidate() | Invalidates the entire surface of the control and causes the control to be redrawn. Inherited from Control. |
| Invalidate(Boolean) | Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
| Invalidate(Rectangle, Boolean) | Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
| Invalidate(Rectangle) | Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
| Invalidate(Region, Boolean) | Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
| Invalidate(Region) | Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
| Invoke(Delegate, Object[]) | Executes the specified delegate, on the thread that owns the control’s underlying window handle, with the specified list of arguments. Inherited from Control. |
| Invoke(Delegate) | Executes the specified delegate on the thread that owns the control’s underlying window handle. Inherited from Control. |
| InvokeGotFocus(Control, EventArgs) protected | Raises the GotFocus event for the specified control. Inherited from Control. |
| InvokeLostFocus(Control, EventArgs) protected | Raises the LostFocus event for the specified control. Inherited from Control. |
| InvokeOnClick(Control, EventArgs) protected | Raises the Click event for the specified control. Inherited from Control. |
| InvokePaint(Control, PaintEventArgs) protected | Raises the Paint event for the specified control. Inherited from Control. |
| InvokePaintBackground(Control, PaintEventArgs) protected |
Raises the PaintBackground event for the specified control.
Inherited from Control. |
| IsInputChar(Char) protected | Determines if a character is an input character that the control recognizes. Inherited from Control. |
| IsInputKey(Keys) protected | Determines whether the specified key is a regular input key or a special key that requires preprocessing. Inherited from Control. |
| IsKeyLocked(Keys) static | Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control. |
| IsMnemonic(Char, String) static | Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control. |
| IsObjectCollapsed(PivotGridField, Int32) | Returns whether the specified column field value or row field value is collapsed. |
| IsObjectCollapsed(Boolean, Int32, Int32) | Returns whether the specified column field value or row field value is collapsed. |
| LayoutChanged() | Updates a PivotGridControl. |
| LoadCollapsedStateFromFile(String) | Restores the collapsed state of field values from the specified file. |
| LoadCollapsedStateFromStream(Stream) | Restores the collapsed state of field values from the specified stream. |
| MemberwiseClone() protected | Creates a shallow copy of the current Object. Inherited from Object. |
| MemberwiseClone(Boolean) protected | Creates a shallow copy of the current MarshalByRefObject object. Inherited from MarshalByRefObject. |
| NotifyInvalidate(Rectangle) protected | Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control. |
| OnAutoSizeChanged(EventArgs) protected | Raises the AutoSizeChanged event. Inherited from Control. |
| OnBackColorChanged(EventArgs) protected | Raises the BackColorChanged event. Inherited from Control. |
| OnBackgroundImageChanged(EventArgs) protected | Raises the BackgroundImageChanged event. Inherited from Control. |
| OnBackgroundImageLayoutChanged(EventArgs) protected | Raises the BackgroundImageLayoutChanged event. Inherited from Control. |
| OnCausesValidationChanged(EventArgs) protected | Raises the CausesValidationChanged event. Inherited from Control. |
| OnChangeUICues(UICuesEventArgs) protected | Raises the ChangeUICues event. Inherited from Control. |
| OnClientSizeChanged(EventArgs) protected | Raises the ClientSizeChanged event. Inherited from Control. |
| OnContextMenuChanged(EventArgs) protected | Raises the ContextMenuChanged event. Inherited from Control. |
| OnContextMenuStripChanged(EventArgs) protected | Raises the ContextMenuStripChanged event. Inherited from Control. |
| OnControlAdded(ControlEventArgs) protected | Raises the ControlAdded event. Inherited from Control. |
| OnControlRemoved(ControlEventArgs) protected | Raises the ControlRemoved event. Inherited from Control. |
| OnCursorChanged(EventArgs) protected | Raises the CursorChanged event. Inherited from Control. |
| OnDockChanged(EventArgs) protected | Raises the DockChanged event. Inherited from Control. |
| OnDragDrop(DragEventArgs) protected | Raises the DragDrop event. Inherited from Control. |
| OnDragEnter(DragEventArgs) protected | Raises the DragEnter event. Inherited from Control. |
| OnDragLeave(EventArgs) protected | Raises the DragLeave event. Inherited from Control. |
| OnDragOver(DragEventArgs) protected | Raises the DragOver event. Inherited from Control. |
| OnEnabledChanged(EventArgs) protected | Raises the EnabledChanged event. Inherited from Control. |
| OnFontChanged(EventArgs) protected | Raises the FontChanged event. Inherited from Control. |
| OnForeColorChanged(EventArgs) protected | Raises the ForeColorChanged event. Inherited from Control. |
| OnGiveFeedback(GiveFeedbackEventArgs) protected | Raises the GiveFeedback event. Inherited from Control. |
| OnHelpRequested(HelpEventArgs) protected | Raises the HelpRequested event. Inherited from Control. |
| OnImeModeChanged(EventArgs) protected | Raises the ImeModeChanged event. Inherited from Control. |
| OnInvalidated(InvalidateEventArgs) protected | Raises the Invalidated event. Inherited from Control. |
| OnKeyUp(KeyEventArgs) protected | Raises the KeyUp event. Inherited from Control. |
| OnLayout(LayoutEventArgs) protected | Raises the Layout event. Inherited from Control. |
| OnLocationChanged(EventArgs) protected | Raises the LocationChanged event. Inherited from Control. |
| OnMarginChanged(EventArgs) protected | Raises the MarginChanged event. Inherited from Control. |
| OnMouseCaptureChanged(EventArgs) protected | Raises the MouseCaptureChanged event. Inherited from Control. |
| OnMouseHover(EventArgs) protected | Raises the MouseHover event. Inherited from Control. |
| OnMove(EventArgs) protected | Raises the Move event. Inherited from Control. |
| OnNotifyMessage(Message) protected | Notifies the control of Windows messages. Inherited from Control. |
| OnPaddingChanged(EventArgs) protected | Raises the PaddingChanged event. Inherited from Control. |
| OnPaintBackground(PaintEventArgs) protected | Paints the background of the control. Inherited from Control. |
| OnParentBackColorChanged(EventArgs) protected | Raises the BackColorChanged event when the BackColor property value of the control’s container changes. Inherited from Control. |
| OnParentBackgroundImageChanged(EventArgs) protected | Raises the BackgroundImageChanged event when the BackgroundImage property value of the control’s container changes. Inherited from Control. |
| OnParentBindingContextChanged(EventArgs) protected | Raises the BindingContextChanged event when the BindingContext property value of the control’s container changes. Inherited from Control. |
| OnParentCursorChanged(EventArgs) protected | Raises the CursorChanged event. Inherited from Control. |
| OnParentEnabledChanged(EventArgs) protected | Raises the EnabledChanged event when the Enabled property value of the control’s container changes. Inherited from Control. |
| OnParentFontChanged(EventArgs) protected | Raises the FontChanged event when the Font property value of the control’s container changes. Inherited from Control. |
| OnParentForeColorChanged(EventArgs) protected | Raises the ForeColorChanged event when the ForeColor property value of the control’s container changes. Inherited from Control. |
| OnParentRightToLeftChanged(EventArgs) protected | Raises the RightToLeftChanged event when the RightToLeft property value of the control’s container changes. Inherited from Control. |
| OnParentVisibleChanged(EventArgs) protected | Raises the VisibleChanged event when the Visible property value of the control’s container changes. Inherited from Control. |
| OnPreviewKeyDown(PreviewKeyDownEventArgs) protected | Raises the PreviewKeyDown event. Inherited from Control. |
| OnPrint(PaintEventArgs) protected | Raises the Paint event. Inherited from Control. |
| OnQueryContinueDrag(QueryContinueDragEventArgs) protected | Raises the QueryContinueDrag event. Inherited from Control. |
| OnRegionChanged(EventArgs) protected | Raises the RegionChanged event. Inherited from Control. |
| OnResize(EventArgs) protected | Raises the Resize event. Inherited from Control. |
| OnStyleChanged(EventArgs) protected | Raises the StyleChanged event. Inherited from Control. |
| OnSystemColorsChanged(EventArgs) protected | Raises the SystemColorsChanged event. Inherited from Control. |
| OnTabIndexChanged(EventArgs) protected | Raises the TabIndexChanged event. Inherited from Control. |
| OnTabStopChanged(EventArgs) protected | Raises the TabStopChanged event. Inherited from Control. |
| OnTextChanged(EventArgs) protected | Raises the TextChanged event. Inherited from Control. |
| PerformLayout() | Forces the control to apply layout logic to all its child controls. Inherited from Control. |
| PerformLayout(Control, String) | Forces the control to apply layout logic to all its child controls. Inherited from Control. |
| PointToClient(Point) | Computes the location of the specified screen point into client coordinates. Inherited from Control. |
| PointToScreen(Point) | Computes the location of the specified client point into screen coordinates. Inherited from Control. |
| PostEditor() | Posts the value being edited to the associated data source without closing the editor. |
| PostEditorAsync() | |
| PreProcessControlMessage(Message) | Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
| PreProcessMessage(Message) | Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
| Print() | Prints the PivotGridControl. |
| ProcessCmdKey(Message, Keys) protected | Processes a command key. Inherited from Control. |
| ProcessDialogChar(Char) protected | Processes a dialog character. Inherited from Control. |
| ProcessKeyEventArgs(Message) protected | Processes a key message and generates the appropriate control events. Inherited from Control. |
| ProcessKeyMessage(Message) protected | Processes a keyboard message. Inherited from Control. |
| ProcessKeyPreview(Message) protected | Previews a keyboard message. Inherited from Control. |
| ProcessMnemonic(Char) protected | Processes a mnemonic character. Inherited from Control. |
| RaiseDragEvent(Object, DragEventArgs) protected | Raises the appropriate drag event. Inherited from Control. |
| RaiseKeyEvent(Object, KeyEventArgs) protected | Raises the appropriate key event. Inherited from Control. |
| RaiseMouseEvent(Object, MouseEventArgs) protected | Raises the appropriate mouse event. Inherited from Control. |
| RaisePaintEvent(Object, PaintEventArgs) protected | Raises the appropriate paint event. Inherited from Control. |
| RecreateHandle() protected | Forces the re-creation of the handle for the control. Inherited from Control. |
| RectangleToClient(Rectangle) | Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control. |
| RectangleToScreen(Rectangle) | Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control. |
| ReferenceEquals(Object, Object) static | Determines whether the specified Object instances are the same instance. Inherited from Object. |
| ReflectMessage(IntPtr, Message) protected static | Reflects the specified message to the control that is bound to the specified handle. Inherited from Control. |
| RefreshData() | Reloads data from the control’s data source and recalculates summaries. |
| RefreshDataAsync() | Reloads data from the control data source and recalculates summaries asynchronously. |
| ResetBackColor() | Resets the BackColor property to its default value. Inherited from Control. |
| ResetBindings() | Causes a control bound to the BindingSource to reread all the items in the list and refresh their displayed values. Inherited from Control. |
| ResetCursor() | Resets the Cursor property to its default value. Inherited from Control. |
| ResetEditorsCache(RepositoryItem) | For internal use. Inherited from EditorContainer. |
| ResetEditorsCache(Type) | For internal use. Inherited from EditorContainer. |
| ResetFont() | Resets the Font property to its default value. Inherited from Control. |
| ResetForeColor() | Resets the ForeColor property to its default value. Inherited from Control. |
| ResetImeMode() | Resets the ImeMode property to its default value. Inherited from Control. |
| ResetMouseEventArgs() protected | Resets the control to handle the MouseLeave event. Inherited from Control. |
| ResetRightToLeft() | Resets the RightToLeft property to its default value. Inherited from Control. |
| ResetText() | Resets the Text property to its default value (Empty). Inherited from Control. |
| RestoreLayoutFromRegistry(String, OptionsLayoutBase) | Restores the Pivot Grid Control’s layout stored at the specified system registry path, using the specified settings. |
| RestoreLayoutFromRegistry(String) | Restores the layout stored at the specified system registry path. |
| RestoreLayoutFromStream(Stream, OptionsLayoutBase) | Restores a Pivot Grid Control’s layout from the specified stream, using the specified settings. |
| RestoreLayoutFromStream(Stream) | Restores a Pivot Grid Control’s layout from the specified stream. |
| RestoreLayoutFromXml(String, OptionsLayoutBase) | Restores a Pivot Grid Control’s layout using the specified settings from the specified XML file. |
| RestoreLayoutFromXml(String) | Restores a Pivot Grid Control’s layout from the specified XML file. |
| ResumeLayout() | Resumes usual layout logic. Inherited from Control. |
| ResumeLayout(Boolean) | Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control. |
| RetrieveFields() | Creates PivotGridField objects for all columns in the bound data source. |
| RetrieveFields(PivotArea, Boolean) | Creates PivotGridField objects for all columns in the bound data source, and moves the fields to the specified area, making them visible or hidden. |
| RetrieveFieldsAsync() | Creates PivotGridField objects for all columns in a data source asynchronously. |
| RetrieveFieldsAsync(PivotArea, Boolean) | Creates PivotGridField objects for all columns in a data source and specifies the area and visibility of the fields. This method executes these actions asynchronously. |
| RtlTranslateAlignment(ContentAlignment) protected | Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control. |
| RtlTranslateAlignment(HorizontalAlignment) protected | Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control. |
| RtlTranslateAlignment(LeftRightAlignment) protected | Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control. |
| RtlTranslateContent(ContentAlignment) protected | Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. Inherited from Control. |
| RtlTranslateHorizontal(HorizontalAlignment) protected | Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. Inherited from Control. |
| RtlTranslateLeftRight(LeftRightAlignment) protected | Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. Inherited from Control. |
| SaveCollapsedStateToFile(String) | Saves the collapsed state of field values to the specified file. |
| SaveCollapsedStateToStream(Stream) | Saves the collapsed state of field values to the specified stream. |
| SaveLayoutToRegistry(String, OptionsLayoutBase) | Saves a Pivot Grid Control’s layout to the specified system registry path, using the specified settings. |
| SaveLayoutToRegistry(String) | Saves a Pivot Grid Control’s layout to a system registry path. |
| SaveLayoutToStream(Stream, OptionsLayoutBase) | Saves a Pivot Grid Control’s layout to the specified stream, using the specified settings. |
| SaveLayoutToStream(Stream) | Saves a Pivot Grid Control’s layout to the specified stream. |
| SaveLayoutToXml(String, OptionsLayoutBase) | Saves a Pivot Grid Control’s layout to the specified XML file, using the specified settings. |
| SaveLayoutToXml(String) | Saves a Pivot Grid Control’s layout to an XML file. |
| SavePivotGridToFile(String, Boolean) | Saves the Pivot Grid Control’s data and full layout to the specified file, and allows the data to be compressed. |
| SavePivotGridToFile(String) | Saves the Pivot Grid Control’s data and full layout to the specified file. |
| SavePivotGridToStream(Stream, Boolean) | Saves the Pivot Grid Control’s data and full layout to the specified stream, and allows the data to be compressed. |
| SavePivotGridToStream(Stream) | Saves the Pivot Grid Control’s data and full layout to the specified stream. |
| Scale(SizeF) | Scales the control and all child controls by the specified scaling factor. Inherited from Control. |
| Scale(Single, Single) | Scales the entire control and any child controls. Inherited from Control. |
| Scale(Single) | Scales the control and any child controls. Inherited from Control. |
| ScaleCore(Single, Single) protected | This method is not relevant for this class. Inherited from Control. |
| Select() | Activates the control. Inherited from Control. |
| Select(Boolean, Boolean) protected | Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control. |
| SelectNextControl(Control, Boolean, Boolean, Boolean, Boolean) | Activates the next control. Inherited from Control. |
| SendToBack() | Sends the control to the back of the z-order. Inherited from Control. |
| SetAutoSizeMode(AutoSizeMode) protected | Sets a value indicating how a control will behave when its AutoSize property is enabled. Inherited from Control. |
| SetBounds(Int32, Int32, Int32, Int32, BoundsSpecified) | Sets the specified bounds of the control to the specified location and size. Inherited from Control. |
| SetBounds(Int32, Int32, Int32, Int32) | Sets the bounds of the control to the specified location and size. Inherited from Control. |
| SetBoundsCore(Int32, Int32, Int32, Int32, BoundsSpecified) protected | Performs the work of setting the specified bounds of this control. Inherited from Control. |
| SetClientSizeCore(Int32, Int32) protected | Sets the size of the client area of the control. Inherited from Control. |
| SetDataSourceAsync(Object) | Sets the data source for the Pivot Grid control and loads data asynchronously. |
| SetFieldSortingAsync(PivotGridField, PivotSortOrder) | Sets the sort order for the specified field asynchronously. |
| SetOLAPConnectionStringAsync(String) | Sets a connection string to a cube in an MS Analysis Services database, and loads data from the cube asynchronously. |
| SetOLAPFilterByUniqueName(Boolean) | |
| SetOLAPFilterByUniqueNameAsync(Boolean) | |
| SetStyle(ControlStyles, Boolean) protected |
Sets a specified ControlStyles flag to either true or false.
Inherited from Control. |
| SetTopLevel(Boolean) protected | Sets the control as the top-level control. Inherited from Control. |
| SetVisibleCore(Boolean) protected | Sets the control to the specified visible state. Inherited from Control. |
| Show() | Displays the control to the user. Inherited from Control. |
| ShowContextMenu() | |
| ShowCustomization() | Displays the Customization Form. |
| ShowCustomization(Point) | Displays the Customization Form at the specified point. |
| ShowCustomization(Control) | Displays the Customization Form and assigns it to the specified parent. |
| ShowEditor() | Invokes the focused cell’s editor. |
| ShowEditor(Point) | Invokes the in-place editor for the cell at the specified position. |
| ShowExpressionEditor(PivotGridField) | Invokes the Expression Editor where a user can edit the specified field’s binding expression. |
| ShowPrintPreview() | Opens the Print Preview window with a toolbar-based interface. |
| ShowRibbonPrintPreview() | Opens the Print Preview window with a Ribbon-based interface. |
| ShowUnboundExpressionEditor(PivotGridField) | Invokes the Expression Editor that enables editing a specified unbound field’s expression. |
| SizeFromClientSize(Size) protected | Determines the size of the entire control from the height and width of its client area. Inherited from Control. |
| SuspendLayout() | Temporarily suspends the layout logic for the control. Inherited from Control. |
| IDropTarget.OnDragDrop(DragEventArgs) | Raises the DragDrop event. Inherited from Control. |
| IDropTarget.OnDragEnter(DragEventArgs) | Raises the DragEnter event. Inherited from Control. |
| IDropTarget.OnDragLeave(EventArgs) | Raises the DragLeave event. Inherited from Control. |
| IDropTarget.OnDragOver(DragEventArgs) | Raises the DragOver event. Inherited from Control. |
| ToString() | Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component. |
| Update() | Causes the control to redraw the invalidated regions within its client area. Inherited from Control. |
| UpdateBounds() protected | Updates the bounds of the control with the current size and location. Inherited from Control. |
| UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32) protected | Updates the bounds of the control with the specified size, location, and client size. Inherited from Control. |
| UpdateBounds(Int32, Int32, Int32, Int32) protected | Updates the bounds of the control with the specified size and location. Inherited from Control. |
| UpdateStyles() protected | Forces the assigned styles to be reapplied to the control. Inherited from Control. |
| UpdateZOrder() protected | Updates the control in its parent’s z-order. Inherited from Control. |
| ValidateEditor() | Validates the active editor. |
| XtraFindFieldsItem(XtraItemEventArgs) | For internal use. |
Events
| 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