menu

WinForms

  • Code Examples
  • Upgrade Guide
  • User Guide
  • Demos
  • Support
  • Forums
  • Download
Class PivotGridControlBase - WindowsForms API Reference | Syncfusion

    Show / Hide Table of Contents

    Class PivotGridControlBase

    Represents the functionality of a pivot table, which is a data summarization tool that automatically sorts, count and total the table data and represents in cross tabular format.

    Inheritance
    System.Object
    BaseControl
    ScrollControl
    GridControlBase
    GridControlBaseImp
    PivotGridControlBase
    Implements
    System.IDisposable
    ICancelModeProvider
    ISplitterPaneSupport
    IScrollBarWrapperContainer
    ISupportUpdating
    ISupportIntelliMouse
    IQueryFocusInside
    INonClientPaintingSupport
    IThemedControl
    ICreateNewWindow
    IGridModelSource
    IGridWindowlessSite
    IGridWindowlessObject
    IFindParentForm
    IThemeProvider
    IVisualStyle
    IPivotControl
    Inherited Members
    BaseControl.CanApplyTheme
    BaseControl.CanOverrideStyle
    BaseControl.ControlName
    BaseControl.IThemeProvider.BaseThemeName
    BaseControl.RaiseThemeChanged(Object, ThemeChangedEventArgs)
    BaseControl.ThemeNameChanged
    GridControlBase.AllowColumnResizeUsingCellBoundaries
    GridControlBase.AllowDrawItemRaiseExceptionCatched
    GridControlBase.AllowFixFocusWhenCurrentCellIsEditingInMouseUp
    GridControlBase.AllowHScrollOnMouseWheel
    GridControlBase.AllowProportionalColumnSizing
    GridControlBase.AllowRowResizeUsingCellBoundaries
    GridControlBase.AllowTextBoxAutoSize
    GridControlBase.AllowViewStyleCacheBaseStyleValues
    GridControlBase.BackColor
    GridControlBase.BackgroundImageID
    GridControlBase.BeginUpdate(BeginUpdateOptions)
    GridControlBase.BeginUpdateModel(BeginUpdateOptions, Boolean)
    GridControlBase.Capture
    GridControlBase.CellButtonClicked
    GridControlBase.CellCancelMode
    GridControlBase.CellClick
    GridControlBase.CellCursor
    GridControlBase.CellDoubleClick
    GridControlBase.CellDrawn
    GridControlBase.CellHitTest
    GridControlBase.CellMouseDown
    GridControlBase.CellMouseHover
    GridControlBase.CellMouseHoverEnter
    GridControlBase.CellMouseHoverLeave
    GridControlBase.CellMouseMove
    GridControlBase.CellMouseUp
    GridControlBase.CellRenderers
    GridControlBase.CheckBoxClick
    GridControlBase.ColIndexToHScrollPixelPos(Int32)
    GridControlBase.CommentTipShowing
    GridControlBase.CommentTipShown
    GridControlBase.CreateGridGraphics()
    GridControlBase.CreateNewControl(Control, Int32, Int32)
    GridControlBase.CurrentCell
    GridControlBase.CurrentCellAcceptedChanges
    GridControlBase.CurrentCellActivated
    GridControlBase.CurrentCellActivateFailed
    GridControlBase.CurrentCellActivating
    GridControlBase.CurrentCellChanged
    GridControlBase.CurrentCellChanging
    GridControlBase.CurrentCellCloseDropDown
    GridControlBase.CurrentCellConfirmChangesFailed
    GridControlBase.CurrentCellControlDoubleClick
    GridControlBase.CurrentCellControlGotFocus
    GridControlBase.CurrentCellControlKeyMessage
    GridControlBase.CurrentCellControlLostFocus
    GridControlBase.CurrentCellDeactivated
    GridControlBase.CurrentCellDeactivateFailed
    GridControlBase.CurrentCellDeactivating
    GridControlBase.CurrentCellDeleting
    GridControlBase.CurrentCellEditingComplete
    GridControlBase.CurrentCellErrorMessage
    GridControlBase.CurrentCellInitializeControlText
    GridControlBase.CurrentCellKeyDown
    GridControlBase.CurrentCellKeyPress
    GridControlBase.CurrentCellKeyUp
    GridControlBase.CurrentCellMoved
    GridControlBase.CurrentCellMoveFailed
    GridControlBase.CurrentCellMoving
    GridControlBase.CurrentCellRejectedChanges
    GridControlBase.CurrentCellShowedDropDown
    GridControlBase.CurrentCellShowingDropDown
    GridControlBase.CurrentCellStartEditing
    GridControlBase.CurrentCellValidated
    GridControlBase.CurrentCellValidateString
    GridControlBase.CurrentCellValidating
    GridControlBase.Cursor
    GridControlBase.DefaultColWidth
    GridControlBase.DefaultRowHeight
    GridControlBase.DefaultSize
    GridControlBase.DisableFormattedTextInEditMode
    GridControlBase.DrawCell
    GridControlBase.DrawCellBackground
    GridControlBase.DrawCellButton
    GridControlBase.DrawCellButtonBackground
    GridControlBase.DrawCellDisplayText
    GridControlBase.DrawCellFrameAppearance
    GridControlBase.DrawClippedGrid(Graphics, Rectangle)
    GridControlBase.DrawClippedGrid(Graphics, Rectangle, Boolean)
    GridControlBase.DrawCommentIndicator
    GridControlBase.DrawCurrentCellBorder
    GridControlBase.DrawErrorIcon(GridDrawCellEventArgs, GridIconPaint)
    GridControlBase.DrawGrid(Graphics)
    GridControlBase.DrawGrid(Graphics, Boolean)
    GridControlBase.DrawGrid(Graphics, Rectangle, Boolean)
    GridControlBase.DrawGrid(Graphics, Rectangle, Boolean, Boolean)
    GridControlBase.DrawInvertCell(Graphics, Int32, Int32, Rectangle, Boolean)
    GridControlBase.DrawSingleCell(Graphics, Int32, Int32, Rectangle, GridStyleInfo, Boolean, Boolean)
    GridControlBase.DropDownContainerParent
    GridControlBase.EnableRTLMark
    GridControlBase.EndUpdate(Boolean)
    GridControlBase.EndUpdateModel(Boolean, Boolean)
    GridControlBase.ExcelLikeAlignment
    GridControlBase.ExcelLikeFrameSelections
    GridControlBase.ExternalMove
    GridControlBase.FillRect(Graphics, Rectangle)
    GridControlBase.FillRectangleHook
    GridControlBase.FindParentForm()
    GridControlBase.firstPaint
    GridControlBase.FixCurrentCellGotFocus()
    GridControlBase.FixCurrentCellGotFocus(Boolean)
    GridControlBase.FixCurrentCellLostFocus()
    GridControlBase.Focus()
    GridControlBase.Focused
    GridControlBase.FocusOnMouseDown
    GridControlBase.ForceCurrentCellMoveTo
    GridControlBase.GetActiveThemeName()
    GridControlBase.GetBackColor(Color)
    GridControlBase.GetBackgroundColor()
    GridControlBase.GetCachedGraphics()
    GridControlBase.GetCellRenderer(Int32, Int32)
    GridControlBase.GetClientCol(Int32)
    GridControlBase.GetClientRow(Int32)
    GridControlBase.GetCol(Int32)
    GridControlBase.GetColHidden(Int32)
    GridControlBase.GetColWidth(Int32)
    GridControlBase.GetControlName(String)
    GridControlBase.GetCurrentCell()
    GridControlBase.GetCurrentHScrollPixelDelta()
    GridControlBase.GetCurrentHScrollPixelPos()
    GridControlBase.GetCurrentVScrollPixelDelta()
    GridControlBase.GetCurrentVScrollPixelPos()
    GridControlBase.GetDefaultMaxStandardValuesSize()
    GridControlBase.GetFirstScrollableCol()
    GridControlBase.GetFirstScrollableRow()
    GridControlBase.GetForeColor(Color)
    GridControlBase.GetGridVisualStyles()
    GridControlBase.GetGridVisualStylesDrawing()
    GridControlBase.GetGridWindow()
    GridControlBase.GetHScrollPixelMinimum()
    GridControlBase.GetHScrollPixelWidth()
    GridControlBase.GetInterior(BrushInfo)
    GridControlBase.GetMaximumLeftColIndex()
    GridControlBase.GetMaximumPossibleLeftCol(Rectangle)
    GridControlBase.GetMaximumPossibleTopRow(Rectangle)
    GridControlBase.GetMaximumTopRowIndex()
    GridControlBase.GetMinimumLeftColIndex()
    GridControlBase.GetMinimumTopRowIndex()
    GridControlBase.GetNextCurrentCellPosition(GridDirectionType, Int32, Int32)
    GridControlBase.GetOtherSplitColumnChildPane(Int32, Int32)
    GridControlBase.GetOtherSplitRowChildPane(Int32, Int32)
    GridControlBase.GetRow(Int32)
    GridControlBase.GetRowHeight(Int32)
    GridControlBase.GetRowHidden(Int32)
    GridControlBase.GetRowRangeHeight(Int32, Int32)
    GridControlBase.GetRowRangeHeight(Int32, Int32, Int32)
    GridControlBase.GetScrollOutOfViewCurrentCellState(GridCellRendererBase, Control, Rectangle, Int32, Int32, GridDirectionType)
    GridControlBase.GetViewStyleInfo(Int32, Int32)
    GridControlBase.GetViewStyleInfo(Int32, Int32, Boolean)
    GridControlBase.GetVisibleBounds()
    GridControlBase.GetVisibleFrozenCols()
    GridControlBase.GetVisibleFrozenRows()
    GridControlBase.GetVScrollPixelHeight()
    GridControlBase.GetVScrollPixelMinimum()
    GridControlBase.GetWindow()
    GridControlBase.GridBounds
    GridControlBase.GridBoundsChanged
    GridControlBase.GridCapture
    GridControlBase.GridCellsRange
    GridControlBase.GridControlBaseEventsTarget
    GridControlBase.GridControlMouseDown
    GridControlBase.GridControlMouseMove
    GridControlBase.GridControlMouseUp
    GridControlBase.GridOfficeScrollBars
    GridControlBase.GridPointToClient(Point)
    GridControlBase.GridPointToScreen(Point)
    GridControlBase.GridRectangleToClient(Rectangle)
    GridControlBase.GridRectangleToScreen(Rectangle)
    GridControlBase.HandleWMSYSCHAR
    GridControlBase.HasBackgroundImageID
    GridControlBase.HasControlFocus
    GridControlBase.HasGridBounds
    GridControlBase.HitTestSelectionEdge
    GridControlBase.HorizontalScrollTips
    GridControlBase.HorizontalThumbTrack
    GridControlBase.HScroll
    GridControlBase.HScrollBehavior
    GridControlBase.HScrollIncrement
    GridControlBase.HScrollPixel
    GridControlBase.HScrollPixelPosChanged
    GridControlBase.HScrollPixelPosChanging
    GridControlBase.HScrollPixelPosToColIndex(Int32, Int32, Int32)
    GridControlBase.HScrollPixelScrollInView(Rectangle)
    GridControlBase.IgnoreCurrentCellInvalidate
    GridControlBase.IGridModelSource.Model
    GridControlBase.InImeComposition
    GridControlBase.Initialize()
    GridControlBase.InitLayout()
    GridControlBase.InitPrintInfo()
    GridControlBase.InitSplitterControl()
    GridControlBase.IntDrawInvertCell(Graphics, Int32, Int32, Rectangle, Boolean)
    GridControlBase.InUpdateWithCustomPaint
    GridControlBase.Invalidate()
    GridControlBase.Invalidate(Rectangle)
    GridControlBase.Invalidate(Rectangle, Boolean)
    GridControlBase.InvalidateDeactivatedCurrentCell(Int32, Int32, Rectangle)
    GridControlBase.InvalidateRange(GridRangeInfo)
    GridControlBase.InvalidateRange(GridRangeInfo, GridRangeOptions)
    GridControlBase.InvalidBounds
    GridControlBase.InvertRect(Graphics, Rectangle)
    GridControlBase.IsActiveControl
    GridControlBase.IsDeactivated
    GridControlBase.IsDesignMode()
    GridControlBase.IsDrawing
    GridControlBase.IsInLeaveOrValidate
    GridControlBase.IsInputChar(Char)
    GridControlBase.IsInputKey(Keys)
    GridControlBase.IsMousePressed
    GridControlBase.IsRightToLeft()
    GridControlBase.IsShowCurrentRow(Int32)
    GridControlBase.IsTouchOverSelectionBubbles(Point)
    GridControlBase.IsValidated
    GridControlBase.IsValidating
    GridControlBase.IsVisibleCell(Int32, Int32)
    GridControlBase.IsVisualStyleEnabled
    GridControlBase.IsWindowless
    GridControlBase.LeftColChanged
    GridControlBase.LeftColChanging
    GridControlBase.LeftColIndex
    GridControlBase.m_bInvertRect
    GridControlBase.MakeClientRange(GridRangeInfo)
    GridControlBase.MarkColHeader
    GridControlBase.MarkRowHeader
    GridControlBase.MetroColorTable
    GridControlBase.MetroScrollBars
    GridControlBase.Model
    GridControlBase.ModelChanged
    GridControlBase.ModelFixedColChanged(Object, GridCountChangedEventArgs)
    GridControlBase.ModelFixedRowChanged(Object, GridCountChangedEventArgs)
    GridControlBase.ModelHeaderColChanged(Object, GridCountChangedEventArgs)
    GridControlBase.ModelHeaderRowChanged(Object, GridCountChangedEventArgs)
    GridControlBase.ModelInvalidateRangeRequest(Object, GridInvalidateRangeRequestEventArgs)
    GridControlBase.ModelRefreshRequest(Object, EventArgs)
    GridControlBase.MouseActivating
    GridControlBase.MoveCurrentCellDirection
    GridControlBase.NotifyCellHighlighted(Int32, Int32, GridStyleInfo)
    GridControlBase.NotifyCurrentCellChanged()
    GridControlBase.NotifyCurrentCellControlPreProcessMessage(Message)
    GridControlBase.NotifyCurrentCellControlWndProc(Message)
    GridControlBase.NotifySelectionFrameChanged(Graphics)
    GridControlBase.NotifySelectionFrameChanging(Graphics)
    GridControlBase.Office2007ScrollBars
    GridControlBase.Office2007ScrollBarsColorScheme
    GridControlBase.Office2010ScrollBarsColorScheme
    GridControlBase.Office2016ScrollBarsColorScheme
    GridControlBase.OleDragDropEventsTarget
    GridControlBase.OnAutoScrollingChanged(EventArgs)
    GridControlBase.OnBackgroundImageChanged(EventArgs)
    GridControlBase.OnBeforePaint(EventArgs)
    GridControlBase.OnCanApplyThemeChanged(Boolean)
    GridControlBase.OnCancelMode(EventArgs)
    GridControlBase.OnCanOverrideStyleChanged(Boolean)
    GridControlBase.OnCellButtonClicked(GridCellButtonClickedEventArgs)
    GridControlBase.OnCellCancelMode(GridCellMouseEventArgs)
    GridControlBase.OnCellClick(GridCellClickEventArgs)
    GridControlBase.OnCellCursor(GridCellCursorEventArgs)
    GridControlBase.OnCellDoubleClick(GridCellClickEventArgs)
    GridControlBase.OnCellDrawn(GridDrawCellEventArgs)
    GridControlBase.OnCellHitTest(GridCellHitTestEventArgs)
    GridControlBase.OnCellMouseDown(GridCellMouseEventArgs)
    GridControlBase.OnCellMouseHover(GridCellMouseEventArgs)
    GridControlBase.OnCellMouseHoverEnter(GridCellMouseEventArgs)
    GridControlBase.OnCellMouseHoverLeave(GridCellMouseEventArgs)
    GridControlBase.OnCellMouseMove(GridCellMouseEventArgs)
    GridControlBase.OnCellMouseUp(GridCellMouseEventArgs)
    GridControlBase.OnCheckBoxClick(GridCellClickEventArgs)
    GridControlBase.OnClientSizeChanged(EventArgs)
    GridControlBase.OnCommentTipShowing(CommentTipShowingEventArgs)
    GridControlBase.OnCommentTipShown(CommentTipShownEventArgs)
    GridControlBase.OnControlAdded(ControlEventArgs)
    GridControlBase.OnControlGotFocus()
    GridControlBase.OnControlLostFocus()
    GridControlBase.OnCreatedNewControl(GridControlBase, Int32, Int32)
    GridControlBase.OnCurrentCellAcceptedChanges(CancelEventArgs)
    GridControlBase.OnCurrentCellActivated(EventArgs)
    GridControlBase.OnCurrentCellActivateFailed(GridCurrentCellActivateFailedEventArgs)
    GridControlBase.OnCurrentCellActivating(GridCurrentCellActivatingEventArgs)
    GridControlBase.OnCurrentCellChanged(EventArgs)
    GridControlBase.OnCurrentCellChanging(CancelEventArgs)
    GridControlBase.OnCurrentCellCloseDropDown(PopupClosedEventArgs)
    GridControlBase.OnCurrentCellConfirmChangesFailed(EventArgs)
    GridControlBase.OnCurrentCellControlDoubleClick(ControlEventArgs)
    GridControlBase.OnCurrentCellControlGotFocus(ControlEventArgs)
    GridControlBase.OnCurrentCellControlKeyMessage(GridCurrentCellControlKeyMessageEventArgs)
    GridControlBase.OnCurrentCellControlLostFocus(ControlEventArgs)
    GridControlBase.OnCurrentCellDeactivated(GridCurrentCellDeactivatedEventArgs)
    GridControlBase.OnCurrentCellDeactivateFailed(EventArgs)
    GridControlBase.OnCurrentCellDeactivating(CancelEventArgs)
    GridControlBase.OnCurrentCellDeleting(CancelEventArgs)
    GridControlBase.OnCurrentCellEditingComplete(EventArgs)
    GridControlBase.OnCurrentCellErrorMessage(GridCurrentCellErrorMessageEventArgs)
    GridControlBase.OnCurrentCellInitializeControlText(GridCurrentCellInitializeControlTextEventArgs)
    GridControlBase.OnCurrentCellKeyDown(KeyEventArgs)
    GridControlBase.OnCurrentCellKeyPress(KeyPressEventArgs)
    GridControlBase.OnCurrentCellKeyUp(KeyEventArgs)
    GridControlBase.OnCurrentCellMoved(GridCurrentCellMovedEventArgs)
    GridControlBase.OnCurrentCellMoveFailed(GridCurrentCellMoveFailedEventArgs)
    GridControlBase.OnCurrentCellMoving(GridCurrentCellMovingEventArgs)
    GridControlBase.OnCurrentCellRejectedChanges(EventArgs)
    GridControlBase.OnCurrentCellShowedDropDown(EventArgs)
    GridControlBase.OnCurrentCellShowingDropDown(GridCurrentCellShowingDropDownEventArgs)
    GridControlBase.OnCurrentCellStartEditing(CancelEventArgs)
    GridControlBase.OnCurrentCellValidated(EventArgs)
    GridControlBase.OnCurrentCellValidateString(GridCurrentCellValidateStringEventArgs)
    GridControlBase.OnCurrentCellValidating(CancelEventArgs)
    GridControlBase.OnDeactivated(EventArgs)
    GridControlBase.OnDragDrop(DragEventArgs)
    GridControlBase.OnDragEnter(DragEventArgs)
    GridControlBase.OnDragLeave(EventArgs)
    GridControlBase.OnDragOver(DragEventArgs)
    GridControlBase.OnDrawCellBackground(GridDrawCellBackgroundEventArgs)
    GridControlBase.OnDrawCellButton(GridDrawCellButtonEventArgs)
    GridControlBase.OnDrawCellButtonBackground(GridDrawCellButtonBackgroundEventArgs)
    GridControlBase.OnDrawCellDisplayText(GridDrawCellDisplayTextEventArgs)
    GridControlBase.OnDrawCellFrameAppearance(GridDrawCellBackgroundEventArgs)
    GridControlBase.OnDrawClientRowCol(Int32, Int32, Int32, Int32, Graphics, Rectangle)
    GridControlBase.OnDrawCommentIndicator(DrawCommentIndicatorEventArgs)
    GridControlBase.OnDrawCurrentCellBorder(GridDrawCurrentCellBorderEventArgs)
    GridControlBase.OnDrawItem(Graphics, Int32, Int32, Rectangle, GridStyleInfo)
    GridControlBase.OnEnabledChanged(EventArgs)
    GridControlBase.OnEnsurePaintCodeJitted()
    GridControlBase.OnEnter(EventArgs)
    GridControlBase.OnFillRectangleHook(GridFillRectangleHookEventArgs)
    GridControlBase.OnGridBoundsChanged(EventArgs)
    GridControlBase.OnGridControlMouseDown(CancelMouseEventArgs)
    GridControlBase.OnGridControlMouseMove(CancelMouseEventArgs)
    GridControlBase.OnGridControlMouseUp(CancelMouseEventArgs)
    GridControlBase.OnGridValidating(CancelEventArgs)
    GridControlBase.OnHScroll(Object, ScrollEventArgs)
    GridControlBase.OnHScrollPixelPosChanged(GridScrollPositionChangedEventArgs)
    GridControlBase.OnHScrollPixelPosChanging(GridScrollPositionChangingEventArgs)
    GridControlBase.OnInvalidated(InvalidateEventArgs)
    GridControlBase.OnKeyDown(KeyEventArgs)
    GridControlBase.OnKeyPress(KeyPressEventArgs)
    GridControlBase.OnKeyUp(KeyEventArgs)
    GridControlBase.OnLayout(LayoutEventArgs)
    GridControlBase.OnLeftColChanged(GridRowColIndexChangedEventArgs)
    GridControlBase.OnLeftColChanging(GridRowColIndexChangingEventArgs)
    GridControlBase.OnModelChanged(EventArgs)
    GridControlBase.OnMouseActivating(CancelEventArgs)
    GridControlBase.OnMouseDown(MouseEventArgs)
    GridControlBase.OnMouseUp(MouseEventArgs)
    GridControlBase.OnMouseWheel(MouseEventArgs)
    GridControlBase.OnMoveCurrentCellDirection(GridMoveCurrentCellDirectionEventArgs)
    GridControlBase.OnPaint(PaintEventArgs)
    GridControlBase.OnPrepareViewStyleInfo(GridPrepareViewStyleInfoEventArgs)
    GridControlBase.OnPrintingModeChanged(EventArgs)
    GridControlBase.OnPushButtonClick(GridCellPushButtonClickEventArgs)
    GridControlBase.OnQueryCanOleDragRange(GridQueryCanOleDragRangeEventArgs)
    GridControlBase.OnQueryCreateCellTextBox(GridQueryCreateCellTextBoxEventArgs)
    GridControlBase.OnQueryNextCurrentCellPosition(GridQueryNextCurrentCellPositionEventArgs)
    GridControlBase.OnQueryScrollCellInView(GridQueryScrollCellInViewEventArgs)
    GridControlBase.OnResizingColumns(GridResizingColumnsEventArgs)
    GridControlBase.OnResizingRows(GridResizingRowsEventArgs)
    GridControlBase.OnScrollControlMouseDown(CancelMouseEventArgs)
    GridControlBase.OnScrollInfoChanged(EventArgs)
    GridControlBase.OnScrollTipFeedback(ScrollTipFeedbackEventArgs)
    GridControlBase.OnSelectionDragged(GridSelectionDragEventArgs)
    GridControlBase.OnSelectionDragging(GridSelectionDragEventArgs)
    GridControlBase.OnSelectionFrameChanged(GraphicsEventArgs)
    GridControlBase.OnSelectionFrameChanging(GraphicsEventArgs)
    GridControlBase.OnSizeChanged(EventArgs)
    GridControlBase.OnSplitterPaneClosing(EventArgs)
    GridControlBase.OnSupportsTransparentBackColorChanged(EventArgs)
    GridControlBase.OnThemeChanged(EventArgs)
    GridControlBase.OnThemeNameChanged(String)
    GridControlBase.OnTopRowChanged(GridRowColIndexChangedEventArgs)
    GridControlBase.OnTopRowChanging(GridRowColIndexChangingEventArgs)
    GridControlBase.OnValidating(CancelEventArgs)
    GridControlBase.OnVisibleChanged(EventArgs)
    GridControlBase.OnVScrollPixelPosChanged(GridScrollPositionChangedEventArgs)
    GridControlBase.OnVScrollPixelPosChanging(GridScrollPositionChangingEventArgs)
    GridControlBase.OnWindowScrolled(ScrollWindowEventArgs)
    GridControlBase.OnWrapCellNextControlInForm(GridWrapCellNextControlInFormEventArgs)
    GridControlBase.OptimizeDrawBackground
    GridControlBase.OptimizeInsertRemoveCells
    GridControlBase.OutlineCurrentCellHeader(Int32, Int32, ScrollBars)
    GridControlBase.PaneDesc
    GridControlBase.ParentSite
    GridControlBase.PdfExport
    GridControlBase.PersistAppearanceSettings
    GridControlBase.PointToClient(Point)
    GridControlBase.PointToRangeInfo(Point)
    GridControlBase.PointToRangeInfo(Point, Int32)
    GridControlBase.PointToRowCol(Point, Int32, Int32)
    GridControlBase.PointToRowCol(Point, Int32, Int32, Int32)
    GridControlBase.PointToScreen(Point)
    GridControlBase.PrepareViewStyleInfo
    GridControlBase.PreProcessMessage(Message)
    GridControlBase.PrintBounds
    GridControlBase.PrintInfo
    GridControlBase.PrintingMode
    GridControlBase.PrintingModeChanged
    GridControlBase.ProcessCmdKey(Message, Keys)
    GridControlBase.ProcessDialogChar(Char)
    GridControlBase.ProcessDialogKey(Keys)
    GridControlBase.ProcessKeyEventArgs(Message)
    GridControlBase.ProcessKeyMessage(Message)
    GridControlBase.ProcessKeyPreview(Message)
    GridControlBase.ProcessScrollCellInView(Int32, Int32, Boolean, GridScrollCurrentCellReason)
    GridControlBase.ProcessTabKeyMovingFocus(Boolean)
    GridControlBase.PushButtonClick
    GridControlBase.QueryCanOleDragRange
    GridControlBase.QueryCreateCellTextBox
    GridControlBase.QueryFocusInside()
    GridControlBase.QueryNextCurrentCellPosition
    GridControlBase.QueryScrollCellInView
    GridControlBase.RaiseCellButtonClicked(Int32, Int32, Int32, GridCellButton)
    GridControlBase.RaiseCellCancelMode(GridCellMouseEventArgs)
    GridControlBase.RaiseCellClick(Int32, Int32, MouseEventArgs)
    GridControlBase.RaiseCellClick(Int32, Int32, MouseEventArgs, Boolean)
    GridControlBase.RaiseCellCursor(GridCellCursorEventArgs)
    GridControlBase.RaiseCellDoubleClick(Int32, Int32, MouseEventArgs)
    GridControlBase.RaiseCellDoubleClick(Int32, Int32, MouseEventArgs, Boolean)
    GridControlBase.RaiseCellHitTest(GridCellHitTestEventArgs)
    GridControlBase.RaiseCellMouseDown(GridCellMouseEventArgs)
    GridControlBase.RaiseCellMouseHover(GridCellMouseEventArgs)
    GridControlBase.RaiseCellMouseHoverEnter(GridCellMouseEventArgs)
    GridControlBase.RaiseCellMouseHoverLeave(GridCellMouseEventArgs)
    GridControlBase.RaiseCellMouseMove(GridCellMouseEventArgs)
    GridControlBase.RaiseCellMouseUp(GridCellMouseEventArgs)
    GridControlBase.RaiseCheckBoxClick(Int32, Int32, MouseEventArgs)
    GridControlBase.RaiseCurrentCellCloseDropDown(PopupClosedEventArgs)
    GridControlBase.RaiseCurrentCellControlKeyMessage(GridCurrentCellControlKeyMessageEventArgs)
    GridControlBase.RaiseCurrentCellDeleting()
    GridControlBase.RaiseCurrentCellErrorMessage(GridCurrentCellErrorMessageEventArgs)
    GridControlBase.RaiseCurrentCellInitializeControlText(GridCurrentCellInitializeControlTextEventArgs)
    GridControlBase.RaiseCurrentCellShowedDropDown(EventArgs)
    GridControlBase.RaiseCurrentCellShowingDropDown(GridCurrentCellShowingDropDownEventArgs)
    GridControlBase.RaiseCurrentCellValidated()
    GridControlBase.RaiseDrawCellBackground(GridDrawCellBackgroundEventArgs)
    GridControlBase.RaiseDrawCellButton(GridDrawCellButtonEventArgs)
    GridControlBase.RaiseDrawCellButtonBackground(GridDrawCellButtonBackgroundEventArgs)
    GridControlBase.RaiseDrawCellDisplayText(GridDrawCellDisplayTextEventArgs)
    GridControlBase.RaiseDrawCellFrameAppearance(GridDrawCellBackgroundEventArgs)
    GridControlBase.RaiseDrawCurrentCellBorder(GridDrawCurrentCellBorderEventArgs)
    GridControlBase.RaiseMouseActivating()
    GridControlBase.RaiseMouseWheel(MouseEventArgs)
    GridControlBase.RaisePrepareViewStyleInfo(Int32, Int32, GridStyleInfo)
    GridControlBase.RaisePushButtonClick(Int32, Int32)
    GridControlBase.RaiseQueryCanOleDragRange(GridQueryCanOleDragRangeEventArgs)
    GridControlBase.RaiseResizingColumns(GridResizingColumnsEventArgs)
    GridControlBase.RaiseResizingRows(GridResizingRowsEventArgs)
    GridControlBase.RaiseSelectionDragged(GridSelectionDragEventArgs)
    GridControlBase.RaiseSelectionDragging(GridSelectionDragEventArgs)
    GridControlBase.RaiseWrapCellNextControlInForm(GridWrapCellNextControlInFormEventArgs)
    GridControlBase.RangeInfoToRectangle(GridRangeInfo)
    GridControlBase.RangeInfoToRectangle(GridRangeInfo, GridRangeOptions)
    GridControlBase.recalcScrollBars
    GridControlBase.RectangleToClient(Rectangle)
    GridControlBase.RectangleToRangeInfo(Rectangle)
    GridControlBase.RectangleToRangeInfo(Rectangle, Int32)
    GridControlBase.RectangleToScreen(Rectangle)
    GridControlBase.Refresh()
    GridControlBase.RefreshRange(GridRangeInfo)
    GridControlBase.RefreshRange(GridRangeInfo, Boolean)
    GridControlBase.RefreshRange(GridRangeInfo, GridRangeOptions)
    GridControlBase.RefreshRange(GridRangeInfo, GridRangeOptions, Boolean)
    GridControlBase.ResetBackgroundImageID()
    GridControlBase.ResetCursor()
    GridControlBase.ResetGridBounds()
    GridControlBase.ResetSortIconPlacement()
    GridControlBase.ResetWindowlessBounds()
    GridControlBase.ResizingColumns
    GridControlBase.ResizingRows
    GridControlBase.RestoreBoundsAfterPrint()
    GridControlBase.ResumeInvalidate()
    GridControlBase.RowIndexToVScrollPixelPos(Int32)
    GridControlBase.ScrollableGridRangeInfo
    GridControlBase.ScrollCellInView(GridRangeInfo)
    GridControlBase.ScrollCellInView(GridRangeInfo, GridScrollCurrentCellReason)
    GridControlBase.ScrollCellInView(Int32, Int32)
    GridControlBase.ScrollCellInView(Int32, Int32, GridScrollCurrentCellReason)
    GridControlBase.ScrollInfoChanged
    GridControlBase.ScrollWindow(Int32, Int32, Rectangle, Rectangle, Boolean)
    GridControlBase.SelectionDragged
    GridControlBase.SelectionDragging
    GridControlBase.SelectionFrameChanged
    GridControlBase.SelectionFrameChanging
    GridControlBase.Selections
    GridControlBase.SetColHidden(Int32, Int32, Boolean)
    GridControlBase.SetColHidden(Int32, Int32, Boolean[])
    GridControlBase.SetColumnWidths()
    GridControlBase.SetColWidth(Int32, Int32, Int32)
    GridControlBase.SetColWidth(Int32, Int32, Int32[])
    GridControlBase.SetCurrentHScrollPixelPos(Int32)
    GridControlBase.SetCurrentVScrollPixelPos(Int32)
    GridControlBase.SetLeftCol(Int32)
    GridControlBase.SetRowHeight(Int32, Int32, Int32)
    GridControlBase.SetRowHeight(Int32, Int32, Int32[])
    GridControlBase.SetRowHidden(Int32, Int32, Boolean)
    GridControlBase.SetRowHidden(Int32, Int32, Boolean[])
    GridControlBase.SetTopRow(Int32)
    GridControlBase.SetWindowlessBounds(Control, Rectangle, Boolean)
    GridControlBase.SetWindowStyle(ControlStyles, Boolean)
    GridControlBase.SetWmGetDlgCodeValue(Int32)
    GridControlBase.ShouldActivateCurrentCell()
    GridControlBase.ShouldActivateCurrentCellInEnter()
    GridControlBase.ShouldDeactivateCurrentCell()
    GridControlBase.ShouldDeleteKeyClearCurrentCellContentsOnly()
    GridControlBase.ShouldDisplayHeaderCol()
    GridControlBase.ShouldDisplayHeaderRow()
    GridControlBase.ShouldIgnoreInvalidate()
    GridControlBase.ShouldSerializeHScrollBehavior()
    GridControlBase.ShouldSerializeSortIconPlacement()
    GridControlBase.ShouldSerializeVScrollBehavior()
    GridControlBase.ShowDisabledGridAsGray
    GridControlBase.ShowMessageBoxOnDrop
    GridControlBase.ShowRowHeaderErroricon
    GridControlBase.ShowTouchIndicator
    GridControlBase.SortIconPlacement
    GridControlBase.SplitCol
    GridControlBase.SplitRow
    GridControlBase.SupportsPrepareViewStyleInfo
    GridControlBase.SupportsTransparentBackColor
    GridControlBase.SupportsTransparentBackColorChanged
    GridControlBase.SuspendInvalidate()
    GridControlBase.ThemeChanged
    GridControlBase.ThemeName
    GridControlBase.ThemesEnabled
    GridControlBase.ThemeStyle
    GridControlBase.TopRowChanged
    GridControlBase.TopRowChanging
    GridControlBase.TopRowIndex
    GridControlBase.ToString()
    GridControlBase.UnHideColsOnDblClick
    GridControlBase.Update()
    GridControlBase.UpdateScrollBars()
    GridControlBase.UpdateScrollTips(ScrollEventArgs)
    GridControlBase.UpdateSelectRange_OldRange
    GridControlBase.UpdateSelectRange_Range
    GridControlBase.UpdateWithCustomPaint(Rectangle, PaintEventHandler)
    GridControlBase.UpdateWithDrawClippedGrid(Rectangle)
    GridControlBase.UseGdiPlusRightAlignedTextWorkaround
    GridControlBase.UseImageListDrawing
    GridControlBase.UseOldHiddenScrollLogic
    GridControlBase.VerticalScrollTips
    GridControlBase.VerticalThumbTrack
    GridControlBase.ViewLayout
    GridControlBase.VScroll
    GridControlBase.VScrollBehavior
    GridControlBase.VScrollIncrement
    GridControlBase.VScrollPixel
    GridControlBase.VScrollPixelPosChanged
    GridControlBase.VScrollPixelPosChanging
    GridControlBase.VScrollPixelPosToRowIndex(Int32, Int32, Int32)
    GridControlBase.VScrollPixelScrollInView(Rectangle)
    GridControlBase.WantEnterKey
    GridControlBase.WantEscapeKey
    GridControlBase.WantKeys
    GridControlBase.WantTabKey
    GridControlBase.WantTabKeyInPreProcessMessage
    GridControlBase.WndProc(Message)
    GridControlBase.WrapCellNextControlInForm
    GridControlBaseImp.AccessibilityEnabled
    GridControlBaseImp.ActivateToolTip
    GridControlBaseImp.CellToolTip
    GridControlBaseImp.CreateAccessibilityInstance()
    GridControlBaseImp.CreateCellToolTip()
    GridControlBaseImp.CreateOleDropTarget(GridControlBase, Int32)
    GridControlBaseImp.Dispose(Boolean)
    GridControlBaseImp.EnableOleDataSource()
    GridControlBaseImp.EnableOleDataSource(Int32)
    GridControlBaseImp.EnableOleDropTarget()
    GridControlBaseImp.EnableOleDropTarget(Int32)
    GridControlBaseImp.InitializeDataObjectConsumerOptions()
    GridControlBaseImp.InitializeMouseControllers()
    GridControlBaseImp.IntUpdateSelectRange()
    GridControlBaseImp.OnActivateToolTip(GridActivateToolTipEventArgs)
    GridControlBaseImp.OnMouseMove(MouseEventArgs)
    GridControlBaseImp.OnQueryAllowDragColumnHeader(GridQueryDragColumnHeaderEventArgs)
    GridControlBaseImp.PaintSelectCells
    GridControlBaseImp.QueryAllowDragColumnHeader
    GridControlBaseImp.RegisterDataObjectConsumer(IGridDataObjectConsumer)
    GridControlBaseImp.ResetMouseControllers()
    GridControlBaseImp.UnwireModel()
    GridControlBaseImp.WireModel()
    ScrollControl.AccelerateScrolling
    ScrollControl.AccelerateScrollingChanged
    ScrollControl.ActiveController
    ScrollControl.AllowIncreaseSmallChange
    ScrollControl.AllowRaiseMouseMoveInOnDragOver
    ScrollControl.AllowSizeGrip
    ScrollControl.AutoScrollBounds
    ScrollControl.AutoScrolling
    ScrollControl.AutoScrollingChanged
    ScrollControl.AutoScrollTimerEnable
    ScrollControl.BeginUpdate()
    ScrollControl.BorderStyle
    ScrollControl.Bounds
    ScrollControl.CancelMode
    ScrollControl.CancelUpdate()
    ScrollControl.ClientRectangle
    ScrollControl.ClientSize
    ScrollControl.CreateParams
    ScrollControl.Deactivated
    ScrollControl.DisableScrollWindow
    ScrollControl.DiscardPaintMessagesAfterBeginUpdate
    ScrollControl.Dispose()
    ScrollControl.DoubleBufferSurface
    ScrollControl.DpiAware
    ScrollControl.EnableDoubleBufferSurface()
    ScrollControl.EnableIntelliMouse
    ScrollControl.EnableTouchMode
    ScrollControl.EndUpdate()
    ScrollControl.EnsurePaintCodeJitted(Boolean)
    ScrollControl.FillSplitterPane
    ScrollControl.FillSplitterPaneChanged
    ScrollControl.FixRenderOrigin(Graphics)
    ScrollControl.ForceSizeBox
    ScrollControl.GetDynamicSplitterFrameOfComponent(Object)
    ScrollControl.GetScrollBarFrameOfComponent(Object)
    ScrollControl.HasDoubleBufferSurface
    ScrollControl.HitTest(Point)
    ScrollControl.HitTest(Point, MouseButtons)
    ScrollControl.HitTest(Point, MouseButtons, IMouseController)
    ScrollControl.HitTest(Point, MouseButtons, Int32, IMouseController)
    ScrollControl.HorizontalScroll
    ScrollControl.HScrollBar
    ScrollControl.IgnoreSizeGripStyleHideShow
    ScrollControl.IgnoreUICues
    ScrollControl.INonClientPaintingSupport.NonClientPaint(PaintEventArgs, Rectangle, Rectangle)
    ScrollControl.InsideScrollBounds
    ScrollControl.InsideScrollMargins
    ScrollControl.IntelliMouseDragScrolling
    ScrollControl.InvalidateNc()
    ScrollControl.InvalidateNc(Rectangle)
    ScrollControl.IsDisposing
    ScrollControl.ISplitterPaneSupport.FillSplitterPane
    ScrollControl.ISplitterPaneSupport.PaneClosed()
    ScrollControl.ISplitterPaneSupport.PaneClosing()
    ScrollControl.IsSplitterPaneClosed
    ScrollControl.IsSplitterPaneClosing
    ScrollControl.ISupportUpdating.Updating
    ScrollControl.IVisualStyle.VisualTheme
    ScrollControl.LastMousePosition
    ScrollControl.LastMousePositionToClient()
    ScrollControl.MouseControllerDispatcher
    ScrollControl.MouseWheelScrollLines
    ScrollControl.MouseWheelZoom
    ScrollControl.NotifyCancelMode()
    ScrollControl.Office2007ScrollBarsChanged
    ScrollControl.Office2007ScrollBarsColorSchemeChanged
    ScrollControl.Office2010ScrollBarsColorSchemeChanged
    ScrollControl.Office2016BlackColorTable
    ScrollControl.Office2016ColorfulColorTable
    ScrollControl.Office2016DarkGrayColorTable
    ScrollControl.Office2016ScrollBars
    ScrollControl.Office2016ScrollBarsColorSchemeChanged
    ScrollControl.Office2016WhiteColorTable
    ScrollControl.OfficeScrollBarsChanged
    ScrollControl.OnAccelerateScrollingChanged(EventArgs)
    ScrollControl.OnBeginUpdateScrollBars()
    ScrollControl.OnControlRemoved(ControlEventArgs)
    ScrollControl.OnCreateScrollTipWindow()
    ScrollControl.OnEndUpdateScrollBars()
    ScrollControl.OnFillSplitterPaneChanged(EventArgs)
    ScrollControl.OnGotFocus(EventArgs)
    ScrollControl.OnHandleCreated(EventArgs)
    ScrollControl.OnHorizontalScroll(ScrollEventArgs)
    ScrollControl.OnHScrollBarValueChanged(Object, EventArgs)
    ScrollControl.OnIntelliMouseDragScrolling(IntelliMouseDragScrollEventArgs)
    ScrollControl.OnLeave(EventArgs)
    ScrollControl.OnLocationChanged(EventArgs)
    ScrollControl.OnLostFocus(EventArgs)
    ScrollControl.OnMouseHover(EventArgs)
    ScrollControl.OnMouseLeave(EventArgs)
    ScrollControl.OnMouseWheelZoom(MouseWheelZoomEventArgs)
    ScrollControl.OnNcCalcSize(Rectangle)
    ScrollControl.OnNCPaint(NCPaintEventArgs)
    ScrollControl.OnOffice2007ScrollBarsChanged(EventArgs)
    ScrollControl.OnOffice2007ScrollBarsColorSchemeChanged(EventArgs)
    ScrollControl.OnOffice2010ScrollBarsColorSchemeChanged(EventArgs)
    ScrollControl.OnOffice2016ScrollBarsColorSchemeChanged(EventArgs)
    ScrollControl.OnOfficeScrollBarsChanged(ScrollControl.OfficeScrollBarsEventArgs)
    ScrollControl.OnParentChanged(EventArgs)
    ScrollControl.OnScrollbarsVisibleChanged(EventArgs)
    ScrollControl.OnScrollControlHandledMouseDown(MouseEventArgs)
    ScrollControl.OnScrollControlHandledMouseMove(MouseEventArgs)
    ScrollControl.OnScrollControlHandledMouseUp(MouseEventArgs)
    ScrollControl.OnScrollControlMouseMove(CancelMouseEventArgs)
    ScrollControl.OnScrollControlMouseUp(CancelMouseEventArgs)
    ScrollControl.OnSetCursor(Message)
    ScrollControl.OnShowContextMenu(ShowContextMenuEventArgs)
    ScrollControl.OnSplitterPaneClosed(EventArgs)
    ScrollControl.OnStartAutoScrolling(StartAutoScrollingEventArgs)
    ScrollControl.OnUpdatingChanged(EventArgs)
    ScrollControl.OnValidated(EventArgs)
    ScrollControl.OnValidatingLostFocus()
    ScrollControl.OnVerticalScroll(ScrollEventArgs)
    ScrollControl.OnVScroll(Object, ScrollEventArgs)
    ScrollControl.OnVScrollBarValueChanged(Object, EventArgs)
    ScrollControl.OnWindowScrolling(ScrollWindowEventArgs)
    ScrollControl.PaintPending
    ScrollControl.PreJitPaint
    ScrollControl.ProcessMouseWheel(MouseEventArgs)
    ScrollControl.ResetInsideScrollMargins()
    ScrollControl.ResetMouseController()
    ScrollControl.ResetMouseWheelScrollLines()
    ScrollControl.ScrollbarsVisibleChanged
    ScrollControl.ScrollControlHandledMouseDown
    ScrollControl.ScrollControlHandledMouseMove
    ScrollControl.ScrollControlHandledMouseUp
    ScrollControl.ScrollControlMouseDown
    ScrollControl.ScrollControlMouseMove
    ScrollControl.ScrollControlMouseUp
    ScrollControl.ScrollTip
    ScrollControl.ScrollTipFeedback
    ScrollControl.ScrollTipFormat
    ScrollControl.ShouldPrepareUpdate()
    ScrollControl.ShouldPrepareUpdate(Boolean)
    ScrollControl.ShouldSerializeMouseWheelScrollLines()
    ScrollControl.ShowContextMenu
    ScrollControl.Size
    ScrollControl.SizeGripStyle
    ScrollControl.SmartSizeBox
    ScrollControl.SmoothMouseWheelScrolling
    ScrollControl.SplitterPaneClosed
    ScrollControl.SplitterPaneClosing
    ScrollControl.StartAutoScrolling
    ScrollControl.StartAutoScrollTimer(Message)
    ScrollControl.StartAutoScrollTimer(Message, Int32)
    ScrollControl.StartAutoScrollTimer(ScrollBarWrapper, ScrollEventType)
    ScrollControl.SupportsThumbTrack
    ScrollControl.TabIndex
    ScrollControl.UpdateNc()
    ScrollControl.UpdateOptions
    ScrollControl.UpdateStyles()
    ScrollControl.Updating
    ScrollControl.UpdatingChanged
    ScrollControl.UpdatingStyles
    ScrollControl.UseSharedScrollBars
    ScrollControl.VerticalScroll
    ScrollControl.VScrollBar
    ScrollControl.WindowScrolled
    ScrollControl.WindowScrolling
    Namespace: Syncfusion.Windows.Forms.PivotAnalysis
    Assembly: Syncfusion.PivotAnalysis.Windows.dll
    Syntax
    public class PivotGridControlBase : GridControlBaseImp, IDisposable, ICancelModeProvider, ISplitterPaneSupport, IScrollBarWrapperContainer, ISupportUpdating, ISupportIntelliMouse, IQueryFocusInside, INonClientPaintingSupport, IThemedControl, ICreateNewWindow, IGridModelSource, IGridWindowlessSite, IGridWindowlessObject, IFindParentForm, IThemeProvider, IVisualStyle, IPivotControl
    Remarks

    To use this control, you must assign some IList object to the ItemSource property. The IList object must have public properties, which you want to use it in the pivot table. To represent the data in cross tabular format, you need to specify the pivot information in
    PivotRows, PivotColumns and PivotCalculations properties.

    Constructors

    PivotGridControlBase()

    Initializes a new instance of the PivotGridControlBase class.

    Declaration
    public PivotGridControlBase()

    PivotGridControlBase(GridModel)

    Initializes a new instance of the PivotGridControlBase class with the specified GridModel.

    Declaration
    public PivotGridControlBase(GridModel model)
    Parameters
    Type Name Description
    GridModel model

    The instance of GridModel class.

    Fields

    PivotFilters

    Gets or sets the collection of FilterExpression.

    Declaration
    public ObservableCollection<FilterExpression> PivotFilters
    Field Value
    Type
    System.Collections.ObjectModel.ObservableCollection<FilterExpression>

    Properties

    AllowedFields

    Gets a collection of FieldInfo instances that hold field names which are visible in the engine.

    Declaration
    public List<FieldInfo> AllowedFields { get; }
    Property Value
    Type
    System.Collections.Generic.List<FieldInfo>
    Remarks

    The names can be either public property names of the underlying data objects, or they can be expression field. If your data contains fields that you do not want exposed to the pivoting process, then add the names of the properties you want to include to this list. All other fields will be excluded. If you leave this collection empty, the default behavior will be to make all public properties available for use in the pivot table. To add an expression field, set the FieldInfo.FieldType to FieldsType.Expression and set FieldInfo.Expression to be a string holding a well formed expression defining the value that should appear in this field.

    AllowFiltering

    Gets or sets a value indicating whether to enable or disable the filtering.

    Declaration
    public bool AllowFiltering { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the filtering is enabled; otherwise, false. The default value istrue.

    AllowRowPivotFiltering

    Gets or sets a value indicating whether the filtering option is enabled for RowPivotsOnly mode.

    Declaration
    public bool AllowRowPivotFiltering { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the filtering is enabled; otherwise, false. The default value is true.

    AllowSelection

    Gets or sets a value indicating whether to allow selection of cells as in Excel or not.

    Declaration
    public bool AllowSelection { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the selection is enabled; otherwise, false. The default value is false.

    AllowSorting

    Gets or sets a value indicating whether to enable or disable the sorting.

    Declaration
    public bool AllowSorting { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the sorting is enabled; otherwise, false. The default value istrue.

    ConditionalFormats

    Declaration
    public ObservableCollection<PivotGridConditionalFormat> ConditionalFormats { get; set; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotGridConditionalFormat>

    CustomizeSystemTheme

    Gets or sets a value indicating whether the system theme should be customized or not.

    Declaration
    public bool CustomizeSystemTheme { get; set; }
    Property Value
    Type Description
    System.Boolean

    trueif the system theme is customized; otherwise, false. The default value is false.

    DeferLayoutUpdate

    Gets or sets a value indicating whether the layout should be updated immediately for dynamic change in PivotGrid's information or it should wait for a Refresh() call.

    Declaration
    public bool DeferLayoutUpdate { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the layout waits for the Refresh() call; otherwise, false. The default value is false.

    FilterArea

    Gets or sets the FilterBar for FilterArea.

    Declaration
    public FilterBar FilterArea { get; set; }
    Property Value
    Type
    FilterBar

    Filters

    Gets the collection of FilterExpression.

    Declaration
    public ObservableCollection<FilterExpression> Filters { get; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<FilterExpression>

    FreezeHeaders

    Gets or sets a value indicating whether the column and row headers should be frozen or not.

    Declaration
    public bool FreezeHeaders { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the headers are frozen; otherwise, false. The default value is false.

    GridColumnList

    Gets or sets the value of grid column list.

    Declaration
    public GridList GridColumnList { get; set; }
    Property Value
    Type
    GridList

    GridFilterList

    Gets or sets the value of filter list.

    Declaration
    public GridList GridFilterList { get; set; }
    Property Value
    Type
    GridList

    GridRowList

    Gets or sets the value of grid row list.

    Declaration
    public GridList GridRowList { get; set; }
    Property Value
    Type
    GridList

    GridValueList

    Gets or sets the value of GridValueList.

    Declaration
    public GridList GridValueList { get; set; }
    Property Value
    Type
    GridList

    GridVisualStyles

    Gets or sets the VisualStyles (skins) like Office2010, Office2007, Office2003.

    Declaration
    public GridVisualStyles GridVisualStyles { get; set; }
    Property Value
    Type
    GridVisualStyles
    Examples

    This example shows how to use the GridVisualStyles property.

    // Sets the Visual style for the pivot grid. Here "Metro" theme is set.
    this.pivotGridControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro;
    ' Sets the Visual style for the pivot grid. Here "Metro" theme is set.
    Me.pivotGridControl1.GridVisualStyles = Syncfusion.Windows.Forms.GridVisualStyles.Metro

    GridVisualStylesDrawing

    Gets or sets the VisualStylesDrawing object.

    Declaration
    public IVisualStylesDrawing GridVisualStylesDrawing { get; set; }
    Property Value
    Type
    IVisualStylesDrawing

    GroupDropArea

    Gets or sets the value of GroupBar.

    Declaration
    public GroupBar GroupDropArea { get; set; }
    Property Value
    Type
    GroupBar

    IsDynamicData

    Gets or sets a value indicating whether the supplied data is dynamic or not.

    Declaration
    public bool IsDynamicData { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if dynamic data is set; otherwise, false. The default value isfalse.

    IsExternalEngine

    Gets or sets a value indicating whether the engine of this control is internally created or supplied from external source.

    Declaration
    public bool IsExternalEngine { get; }
    Property Value
    Type Description
    System.Boolean

    true if the external engine is set; otherwise, false. The default value is false.

    ItemSource

    Gets or sets source of data for this pivot table. This object should be either an IEnumerable list, or a DataTable.

    Declaration
    public object ItemSource { get; set; }
    Property Value
    Type
    System.Object
    Examples

    This example shows how to use the ItemSource property.

    // Adding ItemSource to the pivot grid. Here "ProdutSales" is the datasource assigned to the grid.
    this.pivotGridControl1.ItemSource = ProductSales.GetSalesData();
    ' Adding ItemSource to the pivot grid. Here "ProdutSales" is the datasource assigned to the grid.
    Me.pivotGridControl1.ItemSource = ProductSales.GetSalesData()

    MetroStyle

    Gets or sets the value of metro style.

    Declaration
    public MetroColors MetroStyle { get; set; }
    Property Value
    Type
    MetroColors

    NewRuleConditionalFormat

    Gets or sets the collection of PivotGridNewRuleConditionalFormat.

    Declaration
    public ObservableCollection<PivotGridNewRuleConditionalFormat> NewRuleConditionalFormat { get; set; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotGridNewRuleConditionalFormat>
    Examples

    This example shows how to use the NewRuleConditionalFormat property.

    void TableControl_CellClick(object sender, Syncfusion.Windows.Forms.Grid.GridCellClickEventArgs e)
    {
       // Initializing a new rule.
       NewRuleConditionalFormat newRule1 = new NewRuleConditionalFormat();
       // Setting the condition types and predicate types.
       ConditionalFormat form = new ConditionalFormat();
       form.ConditionType = PivotGridDataConditionType.Equals;
       form.PredicateType = PredicateType.Or;
       form.StartValue = 5;
       form.EndValue = 555;
       newRule1.Conditions.Add(form);
       // Formatting is done if the condition gets satisfied.
       PivotGridNewRuleConditionalFormat newRuleFormat1 = new PivotGridNewRuleConditionalFormat();
       newRuleFormat1.NewRuleCollections.Add(newRule1);
       // Sample condition.
       if (form.StartValue < e.RowIndex)
       {
           this.pivotGridControl1.TableModel[e.RowIndex, e.ColIndex].TextColor = Color.Red;
       }
       // The new rule gets associated with the pivot grid.
       this.pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1);
    }
    Private Sub TableControl_CellClick(ByVal sender As Object, ByVal e As Syncfusion.Windows.Forms.Grid.GridCellClickEventArgs)
       ' Initializing a new rule.
       Dim newRule1 As New NewRuleConditionalFormat()
       ' Setting the condition types and predicate types.
       Dim form As New ConditionalFormat()
       form.ConditionType = PivotGridDataConditionType.Equals
       form.PredicateType = PredicateType.Or
       form.StartValue = 5
       form.EndValue = 555
       newRule1.Conditions.Add(form)
       ' Formatting is done if the condition gets satisfied.
       Dim newRuleFormat1 As New PivotGridNewRuleConditionalFormat()
       newRuleFormat1.NewRuleCollections.Add(newRule1)
       ' Sample condition.
       If form.StartValue<e.RowIndex Then
          Me.pivotGridControl1.TableModel(e.RowIndex, e.ColIndex).TextColor = Color.Red
       End If
       ' The new rule gets associated with the pivot grid.
       Me.pivotGridControl1.TableControl.NewRuleConditionalFormat.Add(newRuleFormat1)
       End Sub

    PivotCalculations

    Gets the collection of PivotComputationInfo.

    Declaration
    public ObservableCollection<PivotComputationInfo> PivotCalculations { get; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotComputationInfo>
    Examples

    This example shows how to use the PivotCalculations property.

    // Adding PivotCalculations to the pivot grid.
    this.pivotGridControl1.PivotCalculations.Add(new PivotComputationInfo { FieldName = "Amount", Format = "#,##0", SummaryType = SummaryType.DoubleTotalSum});
    ' Adding PivotCalculations to the pivot grid.
    Me.pivotGridControl1.PivotCalculations.Add(New PivotComputationInfo With {.FieldName = "Amount", .Format = "#,##0", .SummaryType = SummaryType.DoubleTotalSum})

    PivotColumns

    Gets the collection of PivotItem.

    Declaration
    public ObservableCollection<PivotItem> PivotColumns { get; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotItem>
    Examples

    This example shows how to use the PivotColumns property. Here "Country" is the field's mapping name and "Total" is the header.

    // Adding PivotColumns to the pivot grid.
    this.pivotGridControl1.PivotColumns.Add(new PivotItem { FieldMappingName = "Country", TotalHeader = "Total" });
    ' Adding PivotColumns to the pivot grid. Here "Country" is the field's mapping name and "Total" is the header.
    Me.pivotGridControl1.PivotColumns.Add(New PivotItem With {.FieldMappingName = "Country", .TotalHeader = "Total"})

    PivotEngine

    Gets or sets the PivotEngine.

    Declaration
    public PivotEngine PivotEngine { get; set; }
    Property Value
    Type
    PivotEngine

    PivotFields

    Gets the collection of PivotItem.

    Declaration
    public ObservableCollection<PivotItem> PivotFields { get; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotItem>

    PivotRows

    Gets the collection of PivotItem.

    Declaration
    public ObservableCollection<PivotItem> PivotRows { get; }
    Property Value
    Type
    System.Collections.ObjectModel.ObservableCollection<PivotItem>
    Examples

    This example shows how to use the PivotRows property.

    // Adding PivotRows to the pivot grid. Here "Product" is the field's mapping name and "Total" is the header.
    this.pivotGridControl1.PivotRows.Add(new PivotItem { FieldMappingName = "Product", TotalHeader = "Total" });
    ' Adding PivotRows to the pivot grid. Here "Product" is the field's mapping name and "Total" is the header.
    Me.pivotGridControl1.PivotRows.Add(New PivotItem With {.FieldMappingName = "Product", .TotalHeader = "Total"})

    PivotTableFieldList

    Gets or sets the value of field list in the pivot table.

    Declaration
    public GridList PivotTableFieldList { get; set; }
    Property Value
    Type
    GridList

    RowGroupDropArea

    Gets or sets the value of Row GroupBar.

    Declaration
    public RowGroupBar RowGroupDropArea { get; set; }
    Property Value
    Type
    RowGroupBar

    ShowCalculationsAsColumns

    Gets or sets a value indicating whether the calculations should be appeared as columns or not.

    Declaration
    public bool ShowCalculationsAsColumns { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the calculations are shown as columns; otherwise, false. The default value istrue.

    ShowGrandTotals

    Gets or sets a value indicating whether the grand total calculations should be computed by the engine or not.

    Declaration
    public bool ShowGrandTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the calculations are computed by the engine; otherwise, false. The default value is true.

    ShowGroupBar

    Gets or sets a value indicating whether to enable or disable the grouping bar.

    Declaration
    public bool ShowGroupBar { get; set; }
    Property Value
    Type Description
    System.Boolean

    true if the grouping bar is enabled; otherwise, false. The default value is false.

    ShowSubTotals

    Gets or sets a value indicating whether the subtotal values should be shown or not.

    Declaration
    public bool ShowSubTotals { get; set; }
    Property Value
    Type Description
    System.Boolean

    truethe subtotal values is shown; otherwise, false. The default value is true.

    Methods

    CellStyle_PropertyChanged(Object, PropertyChangedEventArgs)

    Handles the PropertyChanged event of the CellStyle control.

    Declaration
    public void CellStyle_PropertyChanged(object sender, PropertyChangedEventArgs e)
    Parameters
    Type Name Description
    System.Object sender

    The source of the event.

    System.ComponentModel.PropertyChangedEventArgs e

    The System.ComponentModel.PropertyChangedEventArgs instance containing the event data.

    CollapseAllColumnGroups()

    Collapses all the grouped columns.

    Declaration
    public void CollapseAllColumnGroups()
    Examples

    This example shows how to collapse all column groups.

    // Collapse all the column groups.
    this.pivotGridControl1.TableControl.CollapseAllColumnGroups();
    ' Collapse all the column groups.
    Me.pivotGridControl1.TableControl.CollapseAllColumnGroups()

    CollapseAllGroups()

    Collapses all the groups.

    Declaration
    public void CollapseAllGroups()
    Examples

    This example shows how to collapse all the groups.

    // Collapse all the groups either it may be row group or column group.
    this.pivotGridControl1.TableControl.CollapseAllGroups();
    ' Collapse all the groups either it may be row group or column group.
    Me.pivotGridControl1.TableControl.CollapseAllGroups()

    CollapseAllRowGroups()

    Collapses all the grouped rows.

    Declaration
    public void CollapseAllRowGroups()
    Examples

    This example shows how to collapse all the row groups.

    // Collapse all the row groups.
    this.pivotGridControl1.TableControl.CollapseAllRowGroups();
    ' Collapse all the row groups.
    Me.pivotGridControl1.TableControl.CollapseAllRowGroups()

    CollapseColumn(List<String>)

    Collapse the Columns for the specified unique text.

    Declaration
    public void CollapseColumn(List<string> list)
    Parameters
    Type Name Description
    System.Collections.Generic.List<System.String> list

    Array of Unique text of the Expander headers.

    Examples

    This example shows how to collapse a list of columns.

    // Collapses a list of columns. Here "Total", "StateId", "Amount" are all mapping names.
    List<string> collumnColapsed = new List<string>();
    // Columns to be collapsed.
    collumnColapsed.Add("Total");
    collumnColapsed.Add("StateId");
    collumnColapsed.Add("Amount");
    this.pivotGridControl1.TableControl.CollapseColumn(collumnColapsed);
    ' Collapses a list of columns. Here "Total", "StateId", "Amount" are all mapping names.
    Dim collumnColapsed As New List(Of String)()
    ' Columns to be collapsed.
    collumnColapsed.Add("Total")
    collumnColapsed.Add("StateId")
    collumnColapsed.Add("Amount")
    Me.pivotGridControl1.TableControl.CollapseColumn(collumnColapsed)

    CollapseColumn(String)

    Collapses the column for the specified unique text.

    Declaration
    public void CollapseColumn(string uniqueText)
    Parameters
    Type Name Description
    System.String uniqueText

    An unique way of representation for the header cell which has a parent cell UniqueText.

    Examples

    This example shows how to collapse a column with a specified column header-mapping name.

    // Collapse the specified column. Here "Total" is column mapping name.
    this.pivotGridControl1.TableControl.CollapseColumn("Total");
    ' Collapse the specified column. Here "Total" is column mapping name.
    Me.pivotGridControl1.TableControl.CollapseColumn("Total")

    CollapseRow(List<String>)

    Collapse the rows for the specified unique text.

    Declaration
    public void CollapseRow(List<string> list)
    Parameters
    Type Name Description
    System.Collections.Generic.List<System.String> list

    Array of Unique text of the Expander headers.

    Examples

    This example shows how to collapse a list of rows.

    // Collapses a list of rows.  Here "Total", "StateId", "Amount" are all mapping names.
    List<string> rowColapsed = new List<string>();
    rowColapsed.Add("Total");
    rowColapsed.Add("StateId");
    rowColapsed.Add("Amount");
    this.pivotGridControl1.TableControl.CollapseRow(rowColapsed);
    ' Collapses a list of rows.  Here "Total", "StateId", "Amount" are all mapping names.
    Dim rowColapsed As New List(Of String)()
    rowColapsed.Add("Total")
    rowColapsed.Add("StateId")
    rowColapsed.Add("Amount")
    Me.pivotGridControl1.TableControl.CollapseRow(rowColapsed)

    CollapseRow(String)

    Collapses the row for the specified unique text.

    Declaration
    public void CollapseRow(string uniqueText)
    Parameters
    Type Name Description
    System.String uniqueText

    An unique way of representation for the header cell which has a parent cell UniqueText.

    Examples

    This example shows how to collapse the specific row.

    // Collapse the specified row. Here "Amount" is a mapping name.
    this.pivotGridControl1.TableControl.CollapseRow("Amount");
    ' Collapse the specified row. Here "Amount" is a mapping name.
    Me.pivotGridControl1.TableControl.CollapseRow("Amount")

    ExpandAllColumnGroups()

    Expands all the grouped columns.

    Declaration
    public void ExpandAllColumnGroups()
    Examples

    This example shows how to expand all the column groups.

    // Expands all the columns groups.
    this.pivotGridControl1.TableControl.ExpandAllColumnGroups();
    ' Expands all the columns groups.
    Me.pivotGridControl1.TableControl.ExpandAllColumnGroups()

    ExpandAllGroups()

    Expands all the groups.

    Declaration
    public void ExpandAllGroups()
    Examples

    This example shows how to expand all groups.

    // Expands all the groups either it may be column or row.
    this.pivotGridControl1.TableControl.ExpandAllGroups();
    ' Expands all the groups either it may be column or row.
    Me.pivotGridControl1.TableControl.ExpandAllGroups()

    ExpandAllRowGroups()

    Expands all the grouped rows.

    Declaration
    public void ExpandAllRowGroups()
    Examples

    This example shows how to expand all the row groups.

    // Expands all the row groups.
    this.pivotGridControl1.TableControl.ExpandAllRowGroups();
    ' Expands all the row groups.
    Me.pivotGridControl1.TableControl.ExpandAllRowGroups()

    ExpandColumn(List<String>)

    Expand the Columns for provided array of unique text.

    Declaration
    public void ExpandColumn(List<string> list)
    Parameters
    Type Name Description
    System.Collections.Generic.List<System.String> list

    Array of Unique text of the Expander headers.

    Examples

    This example shows how to expand the list of columns.

    // Expands all the columns. Here "Total", "StateId", "Amount" are all mapping names.
    List<string> myExpandingColumns = new List<string>();
    myExpandingColumns.Add("Total");
    myExpandingColumns.Add("StateId");
    myExpandingColumns.Add("Amount");
    this.pivotGridControl1.TableControl.ExpandColumn(myExpandingColumns);
    ' Expands all the columns. Here "Total", "StateId", "Amount" are all mapping names.
    Dim myExpandingColumns As New List(Of String)()
    myExpandingColumns.Add("Total")
    myExpandingColumns.Add("StateId")
    myExpandingColumns.Add("Amount")
    Me.pivotGridControl1.TableControl.ExpandColumn(myExpandingColumns)

    ExpandColumn(String)

    Expands the column for the specified unique text.

    Declaration
    public void ExpandColumn(string uniqueText)
    Parameters
    Type Name Description
    System.String uniqueText

    An unique way of representation for the header cell which has a parent cell UniqueText.

    Examples

    This example shows how to expand a specific column with the given column mapping-name.

    // Expand the specific column with the given column mapping name.
    this.pivotGridControl1.TableControl.ExpandColumn("Amount");
    ' Expand the specific column with the given column mapping name.
    Me.pivotGridControl1.TableControl.ExpandColumn("Amount")

    ExpandRow(List<String>)

    Expand the rows for provided array of unique text.

    Declaration
    public void ExpandRow(List<string> list)
    Parameters
    Type Name Description
    System.Collections.Generic.List<System.String> list

    Array of Unique text of the Expander headers.

    Examples

    This example shows how to expand a list of rows.

    // Expands all the rows. Here "Total", "StateId", "Amount" are all mapping names.
    List<string> myExpandingRows = new List<string>();
    myExpandingRows.Add("Total");
    myExpandingRows.Add("StateId");
    myExpandingRows.Add("Amount");
    this.pivotGridControl1.TableControl.ExpandRow(myExpandingRows);
    ' Expands all the rows. Here "Total", "StateId", "Amount" are all mapping names.
    Dim myExpandingRows As New List(Of String)()
    myExpandingRows.Add("Total")
    myExpandingRows.Add("StateId")
    myExpandingRows.Add("Amount")
    Me.pivotGridControl1.TableControl.ExpandRow(myExpandingRows)

    ExpandRow(String)

    Expands the row for the specified unique text.

    Declaration
    public void ExpandRow(string uniqueText)
    Parameters
    Type Name Description
    System.String uniqueText

    An unique way of representation for the header cell which has a parent cell UniqueText.

    Examples

    This example shows how to expand a specific row.

    // Expand the specific row. Here "Total" is a mapping name.
    this.pivotGridControl1.TableControl.ExpandRow("Total");
    ' Expand the specific row. Here "Total" is a mapping name.
    Me.pivotGridControl1.TableControl.ExpandRow("Total")

    GroupBarSize()

    Calculates the group bar size.

    Declaration
    public void GroupBarSize()

    InvalidateCells()

    Invalidates the cells.

    Declaration
    public void InvalidateCells()

    InvalidateCells(GridRangeInfo)

    Invalidates a range of cells.

    Declaration
    public void InvalidateCells(GridRangeInfo range)
    Parameters
    Type Name Description
    GridRangeInfo range

    range to be invalidated

    Model_SelectionChanging(Object, GridSelectionChangingEventArgs)

    Occurs before selecting a range of cells.

    Declaration
    protected void Model_SelectionChanging(object sender, GridSelectionChangingEventArgs e)
    Parameters
    Type Name Description
    System.Object sender

    The source of the event.

    GridSelectionChangingEventArgs e

    The GridSelectionChangingEventArgs that contains the event data.

    OnCreateControl()

    When overridden in a derived class, is invoked whenever application code or internal processes call System.Windows.FrameworkElement.ApplyTemplate.

    Declaration
    protected override void OnCreateControl()
    Overrides
    GridControlBase.OnCreateControl()

    OnDrawCell(GridDrawCellEventArgs)

    Overridden to raises the cell drawn event.

    Declaration
    protected override void OnDrawCell(GridDrawCellEventArgs e)
    Parameters
    Type Name Description
    GridDrawCellEventArgs e

    The GridDrawCellEventArgs that contains the event data.

    Overrides
    GridControlBase.OnDrawCell(GridDrawCellEventArgs)

    OnRightToLeftChanged(EventArgs)

    Overridden to handle the PivotGridControl changed to RTL mode.

    Declaration
    protected override void OnRightToLeftChanged(EventArgs e)
    Parameters
    Type Name Description
    System.EventArgs e

    TheSystem.EventArgs that contains the event data.

    Overrides
    ScrollControl.OnRightToLeftChanged(EventArgs)

    OnTouchPan(Point, Boolean)

    Handles the touch selection or scrolling operations

    Declaration
    protected override bool OnTouchPan(Point currentTouchPoint, bool isSwipeScroll)
    Parameters
    Type Name Description
    System.Drawing.Point currentTouchPoint

    Current touch position

    System.Boolean isSwipeScroll

    Used to check the swipe scrolling operation occurs in the control. When isSwipeScroll is true then cancel the operations while doing selection operations.

    Returns
    Type Description
    System.Boolean

    Retruns false if do the selection process. Otherwise return true

    Overrides
    GridControlBase.OnTouchPan(Point, Boolean)

    OnTouchPanBegin(Point)

    Initialize the touch selection operation or touch scrolling operations.

    Declaration
    protected override bool OnTouchPanBegin(Point touchBeginPoint)
    Parameters
    Type Name Description
    System.Drawing.Point touchBeginPoint

    Touch position when panning operation start

    Returns
    Type Description
    System.Boolean

    Returns false when do other operations like selection

    Overrides
    GridControlBase.OnTouchPanBegin(Point)

    OnTouchPanEnd(Point)

    Call the mouse up method when selection process done, otherwise call the base method to end the panning operation.

    Declaration
    protected override bool OnTouchPanEnd(Point touchEndPoint)
    Parameters
    Type Name Description
    System.Drawing.Point touchEndPoint

    touch control end point

    Returns
    Type Description
    System.Boolean

    Return false when resizing or selection or dragging process done

    Overrides
    GridControlBase.OnTouchPanEnd(Point)

    PivotGridControlBase_CurrentCellStartEditing(Object, CancelEventArgs)

    Occurs before the current cell switches into edit mode.

    Declaration
    protected void PivotGridControlBase_CurrentCellStartEditing(object sender, CancelEventArgs e)
    Parameters
    Type Name Description
    System.Object sender

    The source of the event.

    System.ComponentModel.CancelEventArgs e

    The that contains the event data.

    PopulateDefaultPropertyFields()

    Populates the default property fields.

    Declaration
    public void PopulateDefaultPropertyFields()

    RaiseOnCollapsing(CollapsingEventArgs, GridStyleInfo)

    Raises the OnCollapsing Event.

    Declaration
    public void RaiseOnCollapsing(CollapsingEventArgs collapsingEventArgs, GridStyleInfo styleInfo)
    Parameters
    Type Name Description
    CollapsingEventArgs collapsingEventArgs

    The CollapsingEventArgs instance containing the event data.

    GridStyleInfo styleInfo

    Stores the information about cell.

    RaiseOnExpanding(ExpandingEventArgs, PivotCellInfo)

    Raises the OnExpanding event.

    Declaration
    public void RaiseOnExpanding(ExpandingEventArgs expandingEventArgs, PivotCellInfo OriginalCell)
    Parameters
    Type Name Description
    ExpandingEventArgs expandingEventArgs

    The ExpandingEventArgs instance containing the event data.

    PivotCellInfo OriginalCell

    Information about specific cell.

    Refresh(Boolean)

    Refreshes the layout of PivotGridControlBase.

    Declaration
    public void Refresh(bool shouldPopulateEngine)
    Parameters
    Type Name Description
    System.Boolean shouldPopulateEngine

    It will repopulate the PivotEngine if True.

    ResetPivotData()

    Resets the pivot data (resets the pivot engine, pivot rows, pivot columns, pivot fields, pivot calculations and items source).

    Declaration
    public void ResetPivotData()
    Examples

    This example shows how to reset the data displayed in the pivot grid table.

    ' Resets the data displayed in the pivot grid.
    Me.pivotGridControl1.TableControl.ResetPivotData()
    ' Resets the data displayed in the pivot grid.
    Me.pivotGridControl1.TableControl.ResetPivotData()

    SynchronizeCalculations(NotifyCollectionChangedEventArgs)

    To synchronize the calculation items with the pivot grid control.

    Declaration
    public void SynchronizeCalculations(NotifyCollectionChangedEventArgs e)
    Parameters
    Type Name Description
    System.Collections.Specialized.NotifyCollectionChangedEventArgs e

    The System.Collections.Specialized.NotifyCollectionChangedEventArgs that contains the event data.

    SynchronizeFilters(NotifyCollectionChangedEventArgs)

    Declaration
    public void SynchronizeFilters(NotifyCollectionChangedEventArgs e)
    Parameters
    Type Name Description
    System.Collections.Specialized.NotifyCollectionChangedEventArgs e

    SynchronizePivotItems(NotifyCollectionChangedEventArgs, Boolean)

    To synchronize the column or row items with the pivot grid control.

    Declaration
    public void SynchronizePivotItems(NotifyCollectionChangedEventArgs e, bool isRow)
    Parameters
    Type Name Description
    System.Collections.Specialized.NotifyCollectionChangedEventArgs e

    The System.Collections.Specialized.NotifyCollectionChangedEventArgs that contains the event data.

    System.Boolean isRow

    Represents the boolean value.

    Events

    Collapsed

    Used to handle the Collapsed event

    Declaration
    public virtual event Collapsed Collapsed
    Event Type
    Type
    Collapsed

    Collapsing

    Used to handle the Collapsing event

    Declaration
    public virtual event Collapsing Collapsing
    Event Type
    Type
    Collapsing

    DataRefreshed

    Used to handle the DataRefreshed event

    Declaration
    public virtual event DataRefreshed DataRefreshed
    Event Type
    Type
    DataRefreshed

    DataRefreshing

    Used to handle the DataRefreshing event

    Declaration
    public virtual event DataRefreshing DataRefreshing
    Event Type
    Type
    DataRefreshing

    Expanded

    Used to handle the Expanded event

    Declaration
    public virtual event Expanded Expanded
    Event Type
    Type
    Expanded

    Expanding

    Used to handle the Expanding event

    Declaration
    public virtual event Expanding Expanding
    Event Type
    Type
    Expanding

    HyperlinkCellClick

    Used to handle the HyperlinkCellClick event

    Declaration
    public virtual event HyperlinkCellClick HyperlinkCellClick
    Event Type
    Type
    HyperlinkCellClick

    ItemSourceChanged

    Occurs when the ItemSource property value gets changed.

    Declaration
    public event ItemSourceChangedEventHandler ItemSourceChanged
    Event Type
    Type
    ItemSourceChangedEventHandler

    SelectionChanged

    Occurs when the SelectedItems instance value gets changed.

    Declaration
    public virtual event SelectionChanged SelectionChanged
    Event Type
    Type
    SelectionChanged

    ShowDisabledGroupBackgroundPropertyChanged

    Used to handle the event that has no event data.

    Declaration
    public virtual event EventHandler ShowDisabledGroupBackgroundPropertyChanged
    Event Type
    Type
    System.EventHandler

    Implements

    System.IDisposable
    ICancelModeProvider
    ISplitterPaneSupport
    IScrollBarWrapperContainer
    ISupportUpdating
    ISupportIntelliMouse
    IQueryFocusInside
    INonClientPaintingSupport
    IThemedControl
    ICreateNewWindow
    IGridModelSource
    IGridWindowlessSite
    IGridWindowlessObject
    IFindParentForm
    IThemeProvider
    IVisualStyle
    IPivotControl
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved