menu

UWP

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

    Show / Hide Table of Contents

    Class PivotGridControlBase

    Defines the internal Grid control which is used to form the Pivot Grid control. It derives from SfCellGrid and hence share the basic characteristics of the Cell Grid control.

    Inheritance
    System.Object
    SfCellGrid
    PivotGridControlBase
    Implements
    System.ComponentModel.INotifyPropertyChanged
    System.IDisposable
    ICalcData
    Inherited Members
    SfCellGrid.add_CellClick(GridCellClickEventHandler)
    SfCellGrid.add_CellCommentOpening(CellCommentOpeningEventHandler)
    SfCellGrid.add_CellContextMenuOpening(CellContextMenuOpeningEventHandler)
    SfCellGrid.add_CellRequestNavigate(CellRequestNavigateEventHandler)
    SfCellGrid.add_CellTooltipOpening(CellTooltipOpeningEventHandler)
    SfCellGrid.add_CurrentCellActivated(CurrentCellActivatedEventHandler)
    SfCellGrid.add_CurrentCellActivating(CurrentCellActivatingEventHandler)
    SfCellGrid.add_CurrentCellBeginEdit(CurrentCellBeginEditEventHandler)
    SfCellGrid.add_CurrentCellEndEdit(CurrentCellEndEditEventHandler)
    SfCellGrid.add_CurrentCellValidated(CurrentCellValidatedEventHandler)
    SfCellGrid.add_CurrentCellValidating(CurrentCellValidatingEventHandler)
    SfCellGrid.add_CurrentCellValueChanged(CurrentCellValueChangedEventhandler)
    SfCellGrid.add_ResizingColumns(ResizingColumnsEventHandler)
    SfCellGrid.add_ResizingRows(ResizingRowsEventHandler)
    SfCellGrid.add_SelectionChanged(SelectionChangedEventHandler)
    SfCellGrid.add_SelectionChanging(SelectionChangingEventHandler)
    SfCellGrid.add_ValueChanged(ValueChangedEventHandler)
    SfCellGrid.AllowColumnResize
    SfCellGrid.AllowEditing
    SfCellGrid.AllowEditorsContextMenu
    SfCellGrid.AllowExcelLikeKeyNavigation
    SfCellGrid.AllowFloatingCell
    SfCellGrid.AllowFloatingCellInEdit
    SfCellGrid.AllowHiddenColumnResize
    SfCellGrid.AllowHiddenRowResize
    SfCellGrid.AllowRowResize
    SfCellGrid.AllowSelection
    SfCellGrid.ArrangeOverride(Size)
    SfCellGrid.AutoScroller
    SfCellGrid.CellClick
    SfCellGrid.CellCommentOpening
    SfCellGrid.CellContextMenu
    SfCellGrid.CellContextMenuOpening
    SfCellGrid.CellRenderers
    SfCellGrid.CellRequestNavigate
    SfCellGrid.CellTooltipOpening
    SfCellGrid.ColumnCount
    SfCellGrid.ColumnResizingController
    SfCellGrid.ColumnWidths
    SfCellGrid.CopyPaste
    SfCellGrid.CoveredCells
    SfCellGrid.CreateGridColumn
    SfCellGrid.currentCell
    SfCellGrid.CurrentCell
    SfCellGrid.CurrentCellActivated
    SfCellGrid.CurrentCellActivating
    SfCellGrid.CurrentCellBeginEdit
    SfCellGrid.CurrentCellEndEdit
    SfCellGrid.CurrentCellValidated
    SfCellGrid.CurrentCellValidating
    SfCellGrid.CurrentCellValueChanged
    SfCellGrid.DefaultColumnWidth
    SfCellGrid.DefaultRowHeight
    SfCellGrid.Dispose(Boolean)
    SfCellGrid.EditorSelectionBehavior
    SfCellGrid.EditTrigger
    SfCellGrid.FooterColumns
    SfCellGrid.FooterRows
    SfCellGrid.FormulaEngine
    SfCellGrid.FrozenColumns
    SfCellGrid.FrozenRows
    SfCellGrid.GetCellValue(Int32, Int32)
    SfCellGrid.GetDependentCellValue(Int32, Int32)
    SfCellGrid.GetDisplayText(Int32, Int32)
    SfCellGrid.GetValueRowCol(Int32, Int32)
    SfCellGrid.GridLineColor
    SfCellGrid.HeaderColumns
    SfCellGrid.HeaderRows
    SfCellGrid.InvalidateCell(GridRangeInfo, Boolean)
    SfCellGrid.InvalidateCell(Int32, Int32)
    SfCellGrid.InvalidateCellBorders(GridRangeInfo)
    SfCellGrid.InvalidateCells(Boolean)
    SfCellGrid.InvalidateSelection()
    SfCellGrid.InvalidateVisual()
    SfCellGrid.InvalidateVisual(Boolean)
    SfCellGrid.InvalidateVisual(Boolean, GridRangeInfo)
    SfCellGrid.IsDisposed
    SfCellGrid.MeasureOverride(Size)
    SfCellGrid.OnApplyTemplate()
    SfCellGrid.OnCellRequestNavigateEvent(CellRequestNavigateEventArgs)
    SfCellGrid.OnContainerKeyDown(KeyRoutedEventArgs)
    SfCellGrid.OnCoreWindowCharacterReceived(CoreWindow, CharacterReceivedEventArgs)
    SfCellGrid.OnCreateCopyPaste()
    SfCellGrid.OnCreateCurrentCell()
    SfCellGrid.OnCreateGridColumn(SfCellGrid)
    SfCellGrid.OnCurrentCellEndEdit(CurrentCellEndEditEventArgs)
    SfCellGrid.OnGotFocus(RoutedEventArgs)
    SfCellGrid.OnKeyDown(KeyRoutedEventArgs)
    SfCellGrid.OnLostFocus(RoutedEventArgs)
    SfCellGrid.OnValueChanged(Int32, Int32, String)
    SfCellGrid.OnVisualContainerPointerEntered(Object, PointerRoutedEventArgs)
    SfCellGrid.OnVisualContainerPointerExited(Object, PointerRoutedEventArgs)
    SfCellGrid.OnVisualContainerPointerMoved(Object, PointerRoutedEventArgs)
    SfCellGrid.OnVisualContainerPointerPressed(Object, PointerRoutedEventArgs)
    SfCellGrid.OnVisualContainerPointerReleased(Object, PointerRoutedEventArgs)
    SfCellGrid.PointToCellRowColumnIndex(Point)
    SfCellGrid.PointToCellRowColumnIndexOutsideCells(Point, Boolean)
    SfCellGrid.PropertyChanged
    SfCellGrid.RecalculateCell(Int32, Int32, Boolean)
    SfCellGrid.remove_CellClick(GridCellClickEventHandler)
    SfCellGrid.remove_CellCommentOpening(CellCommentOpeningEventHandler)
    SfCellGrid.remove_CellContextMenuOpening(CellContextMenuOpeningEventHandler)
    SfCellGrid.remove_CellRequestNavigate(CellRequestNavigateEventHandler)
    SfCellGrid.remove_CellTooltipOpening(CellTooltipOpeningEventHandler)
    SfCellGrid.remove_CurrentCellActivated(CurrentCellActivatedEventHandler)
    SfCellGrid.remove_CurrentCellActivating(CurrentCellActivatingEventHandler)
    SfCellGrid.remove_CurrentCellBeginEdit(CurrentCellBeginEditEventHandler)
    SfCellGrid.remove_CurrentCellEndEdit(CurrentCellEndEditEventHandler)
    SfCellGrid.remove_CurrentCellValidated(CurrentCellValidatedEventHandler)
    SfCellGrid.remove_CurrentCellValidating(CurrentCellValidatingEventHandler)
    SfCellGrid.remove_CurrentCellValueChanged(CurrentCellValueChangedEventhandler)
    SfCellGrid.remove_ResizingColumns(ResizingColumnsEventHandler)
    SfCellGrid.remove_ResizingRows(ResizingRowsEventHandler)
    SfCellGrid.remove_SelectionChanged(SelectionChangedEventHandler)
    SfCellGrid.remove_SelectionChanging(SelectionChangingEventHandler)
    SfCellGrid.remove_ValueChanged(ValueChangedEventHandler)
    SfCellGrid.ResizingColumns
    SfCellGrid.ResizingRows
    SfCellGrid.RowCount
    SfCellGrid.RowHeights
    SfCellGrid.RowResizingController
    SfCellGrid.ScrollColumns
    SfCellGrid.ScrollInView(RowColumnIndex)
    SfCellGrid.ScrollRows
    SfCellGrid.SelectedRanges
    SfCellGrid.SelectionBorderBrush
    SfCellGrid.SelectionBorderThickness
    SfCellGrid.SelectionBrush
    SfCellGrid.SelectionChanged
    SfCellGrid.SelectionChanging
    SfCellGrid.SelectionController
    SfCellGrid.SetColumnWidth(Int32, Int32, Double)
    SfCellGrid.SetRowHeight(Int32, Int32, Double)
    SfCellGrid.SetValueRowCol(Object, Int32, Int32)
    SfCellGrid.ShowComment
    SfCellGrid.ShowGridLines
    SfCellGrid.ShowHidePopup(Boolean)
    SfCellGrid.ShowTooltip
    SfCellGrid.UnWireEvents()
    SfCellGrid.ValueChanged
    SfCellGrid.WireEvents()
    SfCellGrid.WireParentObject()
    Namespace: Syncfusion.UI.Xaml.PivotGrid
    Assembly: Syncfusion.SfPivotGrid.UWP.dll
    Syntax
    public class PivotGridControlBase : SfCellGrid, INotifyPropertyChanged, IDisposable, ICalcData

    Constructors

    PivotGridControlBase()

    Initializes a new instance of the PivotGridControlBase class.

    Declaration
    public PivotGridControlBase()

    Fields

    EngineProperty

    Identifies the Engine dependency property.

    Declaration
    public static DependencyProperty EngineProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    GridLineStrokeProperty

    Identifies the GridLineStroke dependency property.

    Declaration
    public static DependencyProperty GridLineStrokeProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    PivotGridProperty

    Identifies the Syncfusion.UI.Xaml.PivotGrid.PivotGridControlBase.PivotGrid dependency property.

    Declaration
    public static DependencyProperty PivotGridProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    ResizeColumnsToFitProperty

    Identifies the ResizeColumnsToFit dependency property.

    Declaration
    public static DependencyProperty ResizeColumnsToFitProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    ResizeRowsToFitProperty

    Identifies the ResizeRowsToFit dependency property.

    Declaration
    public static DependencyProperty ResizeRowsToFitProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    ShowHeaderCellsToolTipProperty

    Identifies the ShowHeaderCellsToolTip dependency property.

    Declaration
    public static DependencyProperty ShowHeaderCellsToolTipProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    ShowValueCellToolTipProperty

    Identifies the ShowValueCellToolTip dependency property.

    Declaration
    public static DependencyProperty ShowValueCellToolTipProperty
    Field Value
    Type
    Windows.UI.Xaml.DependencyProperty

    Properties

    ColumnHeaderStyle

    Gets or sets the style for column header cells.

    Declaration
    public PivotGridCellStyle ColumnHeaderStyle { get; set; }
    Property Value
    Type
    PivotGridCellStyle

    DataManager

    Gets or sets the OLAP data manager.

    Declaration
    public OlapDataManager DataManager { get; set; }
    Property Value
    Type
    OlapDataManager

    Engine

    Gets or sets the engine data for Pivot Grid control.

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

    FreezeHeaders

    Gets or sets a value indicating whether the header cells are frozen.

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

    GridLineStroke

    Gets or sets the stroke of grid lines.

    Declaration
    public Brush GridLineStroke { get; set; }
    Property Value
    Type
    Windows.UI.Xaml.Media.Brush

    GridLineThickness

    Gets or sets the thickness of grid lines.

    Declaration
    public double GridLineThickness { get; set; }
    Property Value
    Type
    System.Double

    HiddenColumnGroups

    Gets or sets the collection of hidden column groups.

    Declaration
    public List<HiddenGroup> HiddenColumnGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.List<HiddenGroup>

    HiddenPivotColumnGroups

    Gets or sets the collection of hidden pivot column groups.

    Declaration
    public Dictionary<int, List<HiddenGroup>> HiddenPivotColumnGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.Dictionary<System.Int32, System.Collections.Generic.List<HiddenGroup>>

    HiddenPivotRowGroups

    Gets or sets the collection of hidden pivot row groups.

    Declaration
    public Dictionary<int, List<HiddenGroup>> HiddenPivotRowGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.Dictionary<System.Int32, System.Collections.Generic.List<HiddenGroup>>

    HiddenRowGroups

    Gets or sets the collection of hidden row groups.

    Declaration
    public List<HiddenGroup> HiddenRowGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.List<HiddenGroup>

    HiddenSubTotalsColumnGroups

    Gets or sets the collection of hidden subtotal column groups.

    Declaration
    public List<HiddenGroup> HiddenSubTotalsColumnGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.List<HiddenGroup>

    HiddenSubTotalsRowGroups

    Gets or sets the collection of hidden subtotal row groups.

    Declaration
    public List<HiddenGroup> HiddenSubTotalsRowGroups { get; set; }
    Property Value
    Type
    System.Collections.Generic.List<HiddenGroup>

    Layout

    Gets or sets the layout for the Pivot Grid control.

    Declaration
    public GridLayout Layout { get; set; }
    Property Value
    Type
    GridLayout

    Model

    Gets the model of Pivot Grid control.

    Declaration
    public PivotGridModel Model { get; }
    Property Value
    Type
    PivotGridModel

    ResizeColumnsToFit

    Gets or sets a value indicating whether to resize the columns to fit the grid based on values or not.

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

    ResizeRowsToFit

    Gets or sets a value indicating whether to resize the rows to fit the grid based on values or not.

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

    RowHeaderStyle

    Gets or sets the style for row header cells.

    Declaration
    public PivotGridCellStyle RowHeaderStyle { get; set; }
    Property Value
    Type
    PivotGridCellStyle

    ShowHeaderCellsToolTip

    Gets or sets a value indicating whether to show or hide the tool tip for header cells.

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

    ShowValueCellToolTip

    Gets or sets a value indicating whether to show or hide the tool tip for value cells.

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

    SummaryColumnStyle

    Gets or sets the style for summary column cells.

    Declaration
    public PivotGridCellStyle SummaryColumnStyle { get; set; }
    Property Value
    Type
    PivotGridCellStyle

    SummaryRowStyle

    Gets or sets the style for summary row cells.

    Declaration
    public PivotGridCellStyle SummaryRowStyle { get; set; }
    Property Value
    Type
    PivotGridCellStyle

    ValueCellStyle

    Gets or sets the style for value cells.

    Declaration
    public PivotGridCellStyle ValueCellStyle { get; set; }
    Property Value
    Type Description
    PivotGridCellStyle

    The value cells style.

    ValueCellTextAlignment

    Gets or sets the horizontal alignment of text in value cells.

    Declaration
    public HorizontalAlignment ValueCellTextAlignment { get; set; }
    Property Value
    Type
    Windows.UI.Xaml.HorizontalAlignment

    Methods

    add_AfterRefresh(PivotGridDrillDownEventHandler)

    Declaration
    public void add_AfterRefresh(PivotGridDrillDownEventHandler value)
    Parameters
    Type Name Description
    PivotGridDrillDownEventHandler value

    add_BeforeRefresh(PivotGridDrillDownEventHandler)

    Declaration
    public void add_BeforeRefresh(PivotGridDrillDownEventHandler value)
    Parameters
    Type Name Description
    PivotGridDrillDownEventHandler value

    add_LinkClick(LinkLabelClickEventHandler)

    Declaration
    public void add_LinkClick(LinkLabelClickEventHandler value)
    Parameters
    Type Name Description
    LinkLabelClickEventHandler value

    DataBind()

    Binds the data to render the Pivot Grid control.

    Declaration
    public void DataBind()

    DataBind(PivotEngine)

    Binds the specified engine data for rendering the Pivot Grid control.

    Declaration
    public void DataBind(PivotEngine engine)
    Parameters
    Type Name Description
    PivotEngine engine

    The pivot engine data.

    Dispose()

    Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

    Declaration
    protected void Dispose()

    InitializeCellRendererCollection()

    Initializes the collection of renderer used to render the grid.

    Declaration
    protected override void InitializeCellRendererCollection()
    Overrides
    SfCellGrid.InitializeCellRendererCollection()

    OnCreateModel()

    Creates a new instance for GridModel.

    Declaration
    protected override GridModel OnCreateModel()
    Returns
    Type
    GridModel
    Overrides
    SfCellGrid.OnCreateModel()

    remove_AfterRefresh(PivotGridDrillDownEventHandler)

    Declaration
    public void remove_AfterRefresh(PivotGridDrillDownEventHandler value)
    Parameters
    Type Name Description
    PivotGridDrillDownEventHandler value

    remove_BeforeRefresh(PivotGridDrillDownEventHandler)

    Declaration
    public void remove_BeforeRefresh(PivotGridDrillDownEventHandler value)
    Parameters
    Type Name Description
    PivotGridDrillDownEventHandler value

    remove_LinkClick(LinkLabelClickEventHandler)

    Declaration
    public void remove_LinkClick(LinkLabelClickEventHandler value)
    Parameters
    Type Name Description
    LinkLabelClickEventHandler value

    Events

    AfterRefresh

    Occurs after the data gets refreshed.

    Declaration
    public event PivotGridDrillDownEventHandler AfterRefresh
    Event Type
    Type
    PivotGridDrillDownEventHandler

    BeforeRefresh

    Occurs before the data gets refreshed.

    Declaration
    public event PivotGridDrillDownEventHandler BeforeRefresh
    Event Type
    Type
    PivotGridDrillDownEventHandler

    LinkClick

    Occurs when the hyperlink cell is clicked.

    Declaration
    public event LinkLabelClickEventHandler LinkClick
    Event Type
    Type
    LinkLabelClickEventHandler

    Implements

    System.ComponentModel.INotifyPropertyChanged
    System.IDisposable
    ICalcData

    Extension Methods

    SelectionHelper.GetGridRow(SfCellGrid, Int32)
    SelectionHelper.GetVisibleRowColumnIndex(SfCellGrid, Int32, Int32)
    SelectionHelper.GetPreviousVisibleRowColumnIndex(SfCellGrid, Int32, Int32)
    SelectionHelper.GetPreviousVisibleRowIndex(SfCellGrid, Int32)
    SelectionHelper.GetPreviousVisibleColumnIndex(SfCellGrid, Int32)
    SelectionHelper.GetFirstVisibleRowIndex(SfCellGrid)
    SelectionHelper.GetFirstVisibleColumnIndex(SfCellGrid)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, Stream)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, Stream, ExcelImportingOptions)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, StorageFile)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, StorageFile, ExcelImportingOptions)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, IWorksheet)
    ExcelImportExtension.ImportFromExcel(SfCellGrid, IWorksheet, ExcelImportingOptions)
    DateTimeExtension.ToDateTime(Object)
    Back to top Generated by DocFX
    Copyright © 2001 - 2025 Syncfusion Inc. All Rights Reserved