[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Expand]Controls and Libraries
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.Charts.Designer
  [Expand]DevExpress.Data
  [Expand]DevExpress.Mvvm.UI
  [Expand]DevExpress.Mvvm.UI.Interactivity
  [Expand]DevExpress.Mvvm.UI.ModuleInjection
  [Expand]DevExpress.Xpf.Accordion
  [Expand]DevExpress.Xpf.Bars
  [Expand]DevExpress.Xpf.Carousel
  [Expand]DevExpress.Xpf.Charts
  [Expand]DevExpress.Xpf.Charts.Localization
  [Expand]DevExpress.Xpf.Charts.RangeControlClient
  [Expand]DevExpress.Xpf.ChunkList
  [Expand]DevExpress.Xpf.Controls
  [Expand]DevExpress.Xpf.Core
  [Expand]DevExpress.Xpf.Core.ConditionalFormatting
  [Expand]DevExpress.Xpf.Core.DataSources
  [Expand]DevExpress.Xpf.Core.FilteringUI
  [Expand]DevExpress.Xpf.Core.ServerMode
  [Expand]DevExpress.Xpf.Data
  [Expand]DevExpress.Xpf.DataAccess
  [Expand]DevExpress.Xpf.DataAccess.DataSourceWizard
  [Expand]DevExpress.Xpf.Diagram
  [Expand]DevExpress.Xpf.Dialogs
  [Expand]DevExpress.Xpf.Docking
  [Expand]DevExpress.Xpf.Docking.Base
  [Expand]DevExpress.Xpf.DocumentViewer
  [Expand]DevExpress.Xpf.DXBinding
  [Expand]DevExpress.Xpf.Editors
  [Expand]DevExpress.Xpf.Editors.DataPager
  [Expand]DevExpress.Xpf.Editors.DateNavigator
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor
  [Expand]DevExpress.Xpf.Editors.ExpressionEditor.Native
  [Expand]DevExpress.Xpf.Editors.Filtering
  [Expand]DevExpress.Xpf.Editors.Flyout
  [Expand]DevExpress.Xpf.Editors.Flyout.Native
  [Expand]DevExpress.Xpf.Editors.Helpers
  [Expand]DevExpress.Xpf.Editors.Native
  [Expand]DevExpress.Xpf.Editors.Popups
  [Expand]DevExpress.Xpf.Editors.RangeControl
  [Expand]DevExpress.Xpf.Editors.Settings
  [Expand]DevExpress.Xpf.Editors.Validation
  [Expand]DevExpress.Xpf.ExpressionEditor
  [Expand]DevExpress.Xpf.Gantt
  [Expand]DevExpress.Xpf.Gauges
  [Expand]DevExpress.Xpf.Gauges.Localization
  [Expand]DevExpress.Xpf.Grid
  [Expand]DevExpress.Xpf.Grid.ConditionalFormatting
  [Expand]DevExpress.Xpf.Grid.LookUp
  [Expand]DevExpress.Xpf.Grid.TreeList
  [Expand]DevExpress.Xpf.Layout.Core
  [Expand]DevExpress.Xpf.LayoutControl
  [Expand]DevExpress.Xpf.Map
  [Expand]DevExpress.Xpf.NavBar
  [Expand]DevExpress.Xpf.Navigation
  [Expand]DevExpress.Xpf.PdfViewer
  [Collapse]DevExpress.Xpf.PivotGrid
    AllowHideFieldsType Enumeration
    AsyncCompletedHandler Delegate
   [Expand]AsyncOperationResult Class
   [Expand]CellElement Class
   [Expand]CellElementData Class
   [Expand]CellInfo Class
   [Expand]ColorScaleFormatCondition Class
    CopyCollapsedValuesMode Enumeration
    CopyMultiSelectionMode Enumeration
   [Expand]CustomPrefilterDisplayTextEventArgs Class
    CustomPrefilterDisplayTextEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
   [Expand]DataAreaElement Class
   [Expand]DataAreaElementData Class
   [Expand]DataBarFormatCondition Class
    DataFieldArea Enumeration
    DataHeadersDisplayMode Enumeration
    DataProcessingEngine Enumeration
   [Expand]DefaultMenuItemNames Class
   [Expand]EventArgsToCellInfoConverter Class
   [Expand]EventArgsToFieldValueInfoConverter Class
   [Expand]ExpressionConditionBase Class
    FieldAllowedAreas Enumeration
    FieldArea Enumeration
    FieldBestFitArea Enumeration
    FieldColumnTotalsLocation Enumeration
    FieldFilterType Enumeration
   [Expand]FieldFilterValues Class
    FieldGroupInterval Enumeration
    FieldListAllowedLayouts Enumeration
    FieldListArea Enumeration
   [Expand]FieldListControlBase Class
    FieldListLayout Enumeration
    FieldListOrientation Enumeration
    FieldListStyle Enumeration
    FieldOLAPFilterUsingWhereClause Enumeration
    FieldPropertyName Enumeration
    FieldRowTotalsLocation Enumeration
    FieldSortBySummaryOrder Enumeration
    FieldSortLocation Enumeration
    FieldSortMode Enumeration
    FieldSortOrder Enumeration
    FieldSummaryDisplayType Enumeration
    FieldSummaryType Enumeration
    FieldTopValueMode Enumeration
    FieldTopValueType Enumeration
    FieldTotalsVisibility Enumeration
    FieldUnboundColumnType Enumeration
    FieldUnboundExpressionMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FieldValueElement Class
   [Expand]FieldValueElementData Class
   [Expand]FieldValueInfo Class
    FieldValueType Enumeration
    FilterPopupMode Enumeration
   [Expand]FormatCondition Class
   [Expand]FormatConditionBase Class
   [Expand]FormatConditionCollection Class
   [Expand]FormatConditionCommandParameters Class
   [Expand]GroupChangedEventArgs Class
    GroupChangedEventHandler Delegate
    GroupChangeType Enumeration
    GroupFilterMode Enumeration
   [Expand]GroupFilterValue Class
   [Expand]GroupFilterValues Class
   [Expand]GroupFilterValuesCollection Class
   [Expand]IconSetFormatCondition Class
   [Expand]IndicatorFormatConditionBase Class
   [Expand]IThreadSafeField Interface
   [Expand]LightweightCellElement Class
   [Expand]LightweightFieldValueElement Class
    OlapDataProvider Enumeration
   [Expand]PivotBrushChangedEventArgs Class
    PivotBrushChangedEventHandler Delegate
    PivotBrushType Enumeration
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
    PivotCellValueEventHandler Delegate
    PivotChartDataProvideMode Enumeration
    PivotChartDataProvidePriority Enumeration
   [Expand]PivotChartDataSourceRow Class
    PivotChartExportFieldValueMode Enumeration
    PivotChartFieldValuesProvideMode Enumeration
    PivotChartItemDataMember Enumeration
    PivotChartItemType Enumeration
   [Expand]PivotCustomCellAppearanceEventArgs Class
    PivotCustomCellAppearanceEventHandler Delegate
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomFieldDataEventArgs Class
    PivotCustomFieldDataEventHandler Delegate
   [Expand]PivotCustomFieldListSortEventArgs Class
   [Expand]PivotCustomFieldSortEventArgs Class
    PivotCustomFieldSortEventHandler Delegate
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomSummaryEventArgs Class
    PivotCustomSummaryEventHandler Delegate
   [Expand]PivotCustomValueAppearanceEventArgs Class
    PivotCustomValueAppearanceEventHandler Delegate
    PivotDefaultMemberFields Enumeration
   [Expand]PivotDrillDownDataRow Class
   [Expand]PivotDrillDownDataSource Class
   [Expand]PivotExcelFieldListControl Class
   [Expand]PivotFieldAreaChangingEventArgs Class
    PivotFieldAreaChangingEventHandler Delegate
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldListControl Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFilterEditorEventArgs Class
    PivotFilterEditorEventHandler Delegate
   [Expand]PivotGridCellMenuInfo Class
   [Expand]PivotGridCommands Class
   [Collapse]PivotGridControl Class
     PivotGridControl Members
     PivotGridControl Constructor
    [Collapse]PivotGridControl Properties
      ActiveFilterInfo Property
      AllowConditionalFormattingManager Property
      AllowConditionalFormattingMenu Property
      AllowCrossGroupVariation Property
      AllowCustomizationForm Property
      AllowDrag Property
      AllowDragInCustomizationForm Property
      AllowExpand Property
      AllowExpandOnDoubleClick Property
      AllowFilter Property
      AllowFilterInFieldList Property
      AllowHideFields Property
      AllowMRUFilterList Property
      AllowPrefilter Property
      AllowResizing Property
      AllowSort Property
      AllowSortBySummary Property
      AllowSortInFieldList Property
      AutoExpandGroups Property
      BestFitArea Property
      BestFitMaxRowCount Property
      BestFitMode Property
      CanEnablePrefilter Property
      CellBackground Property
      CellForeground Property
      CellMenuCustomizations Property
      CellSelectedBackground Property
      CellSelectedForeground Property
      CellStyle Property
      CellTotalBackground Property
      CellTotalForeground Property
      CellTotalSelectedBackground Property
      CellTotalSelectedForeground Property
      ChartAutoTranspose Property
      ChartDataProvideMode Property
      ChartDataProvidePriority Property
      ChartDataSource Property
      ChartFieldValuesProvideMode Property
      ChartMaxPointCountInSeries Property
      ChartMaxSeriesCount Property
      ChartProvideCellValuesAsType Property
      ChartProvideColumnCustomTotals Property
      ChartProvideColumnFieldValuesAsType Property
      ChartProvideColumnGrandTotals Property
      ChartProvideColumnTotals Property
      ChartProvideDataByColumns Property
      ChartProvideEmptyCells Property
      ChartProvideRowCustomTotals Property
      ChartProvideRowFieldValuesAsType Property
      ChartProvideRowGrandTotals Property
      ChartProvideRowTotals Property
      ChartSelectionOnly Property
      ChartUpdateDelay Property
      ClipboardCopyCollapsedValuesMode Property
      ClipboardCopyMultiSelectionMode Property
      ColumnCount Property
      ColumnFieldValuesAlignment Property
      ColumnTotalsLocation Property
      ConditionalFormattingManagerServiceTemplate Property
      CopyToClipboardWithFieldValues Property
      Data Attached Property
      DataFieldArea Property
      DataFieldAreaIndex Property
      DataFieldCaption Property
      DataFieldHeight Property
      DataFieldUnboundExpressionMode Property
      DataFieldWidth Property
      DataHeadersDisplayMode Property
      DataProcessingEngine Property
      DataSource Property
      DefaultDataProcessingEngine Property
      DeferredUpdates Property
      DrawFocusedCellRect Property
      DrillDownCustomColumns Property
      DrillDownMaxRowCount Property
      ErrorPanelStyle Property
      ErrorPanelText Property
      ExcelFieldListState Property
      ExcelFieldListTemplate Property
      ExpressionEditorContainer Property
      FieldCellKpiTemplate Property
      FieldCellKpiTemplateSelector Property
      FieldCellTemplate Property
      FieldCellTemplateSelector Property
      FieldFilterPopupMode Property
      FieldGeneratorStyle Property
      FieldGeneratorTemplate Property
      FieldGeneratorTemplateSelector Property
      FieldHeaderContentStyle Property
      FieldHeaderDragIndicatorSize Attached Property
      FieldHeaderDragIndicatorTemplate Property
      FieldHeaderListTemplate Property
      FieldHeaderListTemplateSelector Property
      FieldHeaderTemplate Property
      FieldHeaderTemplateSelector Property
      FieldHeaderTreeViewTemplate Property
      FieldHeaderTreeViewTemplateSelector Property
      FieldHeight Property
      FieldListAllowedLayouts Property
      FieldListFactory Property
      FieldListIncludeVisibleFields Property
      FieldListLayout Property
      FieldListSplitterX Property
      FieldListSplitterY Property
      FieldListState Property
      FieldListStyle Property
      FieldListTemplate Property
      Fields Property
      FieldsSource Property
      FieldValueMenuCustomizations Property
      FieldValueStyle Property
      FieldValueTemplate Property
      FieldValueTemplateSelector Property
      FieldWidth Property
      FilterByVisibleFieldsOnly Property
      FilterCriteria Property
      FilterEditorDialogServiceTemplate Property
      FilterEditorTemplate Property
      FilteringContext Property
      FilterString Property
      FixedRowHeaders Property
      FocusedCell Property
      FocusedCellBorderTemplate Property
      FormatConditionDialogServiceTemplate Property
      FormatConditionGeneratorTemplate Property
      FormatConditionGeneratorTemplateSelector Property
      FormatConditions Property
      FormatConditionsSource Property
      GridMenu Property
      GroupDataCaseSensitive Property
      GroupFieldsInFieldList Property
      GroupFilterMode Property
      GroupGeneratorStyle Property
      GroupGeneratorTemplate Property
      GroupGeneratorTemplateSelector Property
      Groups Property
      GroupsSource Property
      HeaderAreaMenuCustomizations Property
      HeaderMenuCustomizations Property
      HiddenFields Property
      IsAsyncInProgress Property
      IsCellMenuEnabled Property
      IsErrorPanelVisible Property
      IsFieldListMenuEnabled Property
      IsFieldListVisible Property
      IsFieldValueMenuEnabled Property
      IsFilterPopupMenuEnabled Property
      IsFilterPopupWaitIndicatorVisible Property
      IsHeaderAreaMenuEnabled Property
      IsHeaderMenuEnabled Property
      IsLoading Property
      IsMainWaitIndicatorVisible Property
      IsPrefilterEnabled Property
      IsPrefilterVisible Property
      IsUpdateLocked Property
      LeftTopCoord Property
      LeftTopPixelCoord Property
      LoadingPanelDelay Property
      MergeColumnFieldValues Property
      MergeRowFieldValues Property
      MRUFilterListCount Property
      MRUFilters Property
      MultiSelection Property
      OlapConnectionString Property
      OlapDataProvider Property
      OlapDefaultMemberFields Property
      OlapFilterByUniqueName Property
      OlapModificationCheckInterval Property
      OlapServerDefinedDrillDownColumns Property
      OlapSortUsingDiscoverXmlMetadata Property
      OptimizeSummaryTypeCalculation Property
      PivotGrid Attached Property
      PredefinedColorScaleFormats Property
      PredefinedDataBarFormats Property
      PredefinedFormats Property
      PredefinedIconSetFormats Property
      PrefilterContainer Property
      PrefilterControl Property
      PrefilterCriteria Property
      PrefilterPanelText Property
      PrefilterString Property
      PrintCellBackground Property
      PrintCellForeground Property
      PrintCellTotalBackground Property
      PrintCellTotalForeground Property
      PrintColumnHeaders Property
      PrintDataHeaders Property
      PrintFieldCellKpiTemplate Property
      PrintFieldCellKpiTemplateSelector Property
      PrintFieldCellTemplate Property
      PrintFieldCellTemplateSelector Property
      PrintFieldHeaderTemplate Property
      PrintFieldHeaderTemplateSelector Property
      PrintFieldValueTemplate Property
      PrintFieldValueTemplateSelector Property
      PrintFilterHeaders Property
      PrintHeadersOnEveryPage Property
      PrintHorzLines Property
      PrintInsertPageBreaks Property
      PrintLayoutMode Property
      PrintRowHeaders Property
      PrintUnusedFilterFields Property
      PrintValueBackground Property
      PrintValueForeground Property
      PrintValueTotalBackground Property
      PrintValueTotalForeground Property
      PrintVertLines Property
      ResizingIndicatorTemplate Property
      RowCount Property
      RowFieldValuesAlignment Property
      RowTotalsHeightFactor Property
      RowTotalsLocation Property
      RowTreeHeight Property
      RowTreeMinHeight Property
      RowTreeMinWidth Property
      RowTreeOffset Property
      RowTreeWidth Property
      ScrollingMode Property
      ScrollViewerTemplate Property
      SelectedCellInfo Property
      Selection Property
      SelectMode Property
      ShowBorder Property
      ShowColumnGrandTotalHeader Property
      ShowColumnGrandTotals Property
      ShowColumnHeaders Property
      ShowColumnsBorder Property
      ShowColumnTotals Property
      ShowCustomTotalsForSingleValues Property
      ShowDataHeaders Property
      ShowFilterHeaders Property
      ShowGrandTotalsForSingleValues Property
      ShowLoadingPanel Property
      ShowOnlyAvailableFilterItems Property
      ShowPrefilterPanel Property
      ShowPrefilterPanelMode Property
      ShowRowGrandTotalHeader Property
      ShowRowGrandTotals Property
      ShowRowHeaders Property
      ShowRowTotals Property
      ShowTotalsForSingleValues Property
      SortBySummaryDefaultOrder Property
      SummaryDataSourceFieldNaming Property
      UseAsyncMode Property
      UseLegacyFilterEditor Property
      UseLightweightTemplates Property
      UserAction Property
      ValueBackground Property
      ValueForeground Property
      ValueSelectedBackground Property
      ValueSelectedForeground Property
      ValueTotalBackground Property
      ValueTotalForeground Property
      ValueTotalSelectedBackground Property
      ValueTotalSelectedForeground Property
    [Expand]PivotGridControl Events
    [Expand]PivotGridControl Methods
   [Expand]PivotGridCsvExportOptions Class
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldValueMenuInfo Class
   [Expand]PivotGridFilterPopupMenuInfo Class
   [Expand]PivotGridGroup Class
   [Expand]PivotGridGroupCollection Class
   [Expand]PivotGridHeaderMenuInfo Class
   [Expand]PivotGridHeadersAreaMenuInfo Class
   [Expand]PivotGridMenuInfo Class
    PivotGridMenuType Enumeration
   [Expand]PivotGridXlsExportOptions Class
   [Expand]PivotGridXlsxExportOptions Class
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
    PivotKpiGraphic Enumeration
    PivotKpiType Enumeration
   [Expand]PivotLayoutAllowEventArgs Class
    PivotLayoutAllowEventHandler Delegate
   [Expand]PivotLayoutUpgradeEventArgs Class
    PivotLayoutUpgradeEventHandler Delegate
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotOlapKpiMeasures Class
   [Expand]PivotOlapKpiValue Class
   [Expand]PivotOlapMember Class
   [Expand]PivotPropertyChangedEventArgs Class
    PivotPropertyChangedEventHandler Delegate
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
   [Expand]PivotSerializationOptions Class
   [Expand]PivotSummaryDataRow Class
   [Expand]PivotSummaryDataSource Class
   [Expand]PivotUnboundExpressionEditorEventArgs Class
    PivotUnboundExpressionEditorEventHandler Delegate
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
    ScrollingMode Enumeration
    SelectMode Enumeration
    ShowPrefilterPanelMode Enumeration
   [Expand]SortByCondition Class
   [Expand]SortByConditionCollection Class
    StoreLayoutMode Enumeration
   [Expand]TopBottomRuleFormatCondition Class
    UnboundExpressionMode Enumeration
    UseLightweightTemplates Enumeration
    UserAction Enumeration
  [Expand]DevExpress.Xpf.PivotGrid.Printing
  [Expand]DevExpress.Xpf.Printing
  [Expand]DevExpress.Xpf.Printing.Parameters
  [Expand]DevExpress.Xpf.Printing.Parameters.Models
  [Expand]DevExpress.Xpf.Printing.PreviewControl
  [Expand]DevExpress.Xpf.Printing.PreviewControl.Bars
  [Expand]DevExpress.Xpf.Prism
  [Expand]DevExpress.Xpf.PropertyGrid
  [Expand]DevExpress.Xpf.Reports.UserDesigner
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Extensions
  [Expand]DevExpress.Xpf.Reports.UserDesigner.Localization
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard
  [Expand]DevExpress.Xpf.Reports.UserDesigner.ReportWizard.Pages
  [Expand]DevExpress.Xpf.Ribbon
  [Expand]DevExpress.Xpf.RichEdit
  [Expand]DevExpress.Xpf.RichEdit.Menu
  [Expand]DevExpress.Xpf.Scheduler
  [Expand]DevExpress.Xpf.Scheduler.Drawing
  [Expand]DevExpress.Xpf.Scheduler.Menu
  [Expand]DevExpress.Xpf.Scheduler.Reporting
  [Expand]DevExpress.Xpf.Scheduler.UI
  [Expand]DevExpress.Xpf.Scheduling
  [Expand]DevExpress.Xpf.Scheduling.Editors
  [Expand]DevExpress.Xpf.Scheduling.iCalendar
  [Expand]DevExpress.Xpf.Scheduling.Reporting
  [Expand]DevExpress.Xpf.Scheduling.Visual
  [Expand]DevExpress.Xpf.Scheduling.VisualData
  [Expand]DevExpress.Xpf.SpellChecker
  [Expand]DevExpress.Xpf.Spreadsheet
  [Expand]DevExpress.Xpf.Spreadsheet.Menu
  [Expand]DevExpress.Xpf.TreeMap
  [Expand]DevExpress.Xpf.Utils.Themes
  [Expand]DevExpress.Xpf.WindowsUI
  [Expand]DevExpress.Xpf.WindowsUI.Internal
  [Expand]DevExpress.Xpf.WindowsUI.Navigation
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Printing
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

PivotGridControl Properties

The PivotGrid control.

Expanded Public Properties

Show: Inherited
  Name Description
Public property ActiveFilterInfo For internal use. This is a dependency property.
Public property ActualHeight Gets the rendered height of this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property ActualWidth Gets the rendered width of this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property AllowConditionalFormattingManager Gets or sets whether the Conditional Formatting Rules Manager is enabled at runtime. This is a dependency property.
Public property AllowConditionalFormattingMenu Gets or sets whether to enable the conditional formatting menu for the pivot grid.
Public property AllowCrossGroupVariation Gets or sets whether summary variations and running totals are calculated independently within individual groups, or throughout the Pivot Grid. This is a dependency property.
Public property AllowCustomizationForm Gets or sets whether end-users are allowed to invoke the Customization Form.
Public property AllowDrag Gets or sets whether an end-user is allowed to drag the field headers. This is a dependency property.
Public property AllowDragInCustomizationForm Gets or sets whether end-users are allowed to drag field headers between areas in the Customization Form.
Public property AllowDrop Gets or sets a value indicating whether this element can be used as the target of a drag-and-drop operation. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property AllowExpand Gets or sets whether expand buttons are displayed. This is a dependency property.
Public property AllowExpandOnDoubleClick Gets or sets whether field values are expanded/collapsed on a double click. This is a dependency property.
Public property AllowFilter Gets or sets whether filter buttons are displayed within field headers. This is a dependency property.
Public property AllowFilterInFieldList Gets or sets whether filtering can be applied to fields via the Customization Form. This is a dependency property.
Public property AllowHideFields Gets or sets a value that specifies when fields can be hidden by end-users.
Public property AllowMRUFilterList Gets or sets whether end-users are allowed to invoke the MRU Filter List. This is a dependency property.
Public property AllowPrefilter Gets or sets whether end-users are allowed to invoke the Prefilter.
Public property AllowResizing Gets or sets whether end-users are allowed to resize the PivotGridControl's elements. This is a dependency property.
Public property AllowSort Gets or sets whether end-users can change the sort order of fields. This is a dependency property.
Public property AllowSortBySummary Gets or sets whether end-users can sort the row/column field values by other column/row summary values. This is a dependency property.
Public property AllowSortInFieldList

Gets or sets whether the sort order of field values can be toggled via the Customization Form.

This is a dependency property.

Public property AreAnyTouchesCaptured (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesCapturedWithin (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesDirectlyOver (Inherited from System.Windows.UIElement)
Public property AreAnyTouchesOver (Inherited from System.Windows.UIElement)
Public property AutoExpandGroups Gets or sets whether field values are expanded or collapsed by default. This is a dependency property.
Public property Background Gets or sets a brush that describes the background of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property BestFitArea Gets or sets which interface elements are taken into account when calculating optimal width for columns.
Public property BestFitMaxRowCount Gets or sets the number of rows taken into account when calculating the optimal width required for columns (or rows) to completely display their contents.
Public property BestFitMode Gets or sets how the optimal width required for a column (or row) to completely display its contents is calculated.
Public property BindingGroup Gets or sets the System.Windows.Data.BindingGroup that is used for the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property BitmapEffect Obsolete. Gets or sets a bitmap effect that applies directly to the rendered content for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property BitmapEffectInput Obsolete. Gets or sets an input source for the bitmap effect that applies directly to the rendered content for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property BorderBrush Gets or sets a brush that describes the border background of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property BorderThickness Gets or sets the border thickness of a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property CacheMode (Inherited from System.Windows.UIElement)
Public property CanEnablePrefilter For internal use.
Public property CellBackground Gets or sets the brush used to paint the background of data cells. This is a dependency property.
Public property CellForeground Gets or sets the brush used to paint the foreground of data cells. This is a dependency property.
Public property CellMenuCustomizations Allows you to customize the context menu, invoked when right-clicking cells, by adding new menu items or removing existing items.
Public property CellSelectedBackground Gets or sets the brush used to paint the background of the selected data cell. This is a dependency property.
Public property CellSelectedForeground Gets or sets the brush used to paint the foreground of the selected data cell. This is a dependency property.
Public property CellStyle Gets or sets the style applied to data cells displayed within a Pivot Grid.
Public property CellTotalBackground Gets or sets the brush used to paint the background of total and grand total cells. This is a dependency property.
Public property CellTotalForeground Gets or sets the brush used to paint the foreground of total and grand total cells. This is a dependency property.
Public property CellTotalSelectedBackground Gets or sets the brush used to paint the background of the selected total or grand total Cell. This is a dependency property.
Public property CellTotalSelectedForeground Gets or sets the brush used to paint the foreground of the selected total or grand total Cell. This is a dependency property.
Public property ChartAutoTranspose Gets or sets whether a bound chart control should be transposed if the number of series exceeds the number of argument values. This is a dependency property.
Public property ChartDataProvideMode Gets or sets what data the pivot grid should pass to a bound chart control. This is a dependency property.
Public property ChartDataProvidePriority Gets or sets whether the pivot grid should pass columns or rows to a bound chart control when it is impossible to find the lowest-level data. This is a dependency property.
Public property ChartDataSource Gets a data source for a chart control.
Public property ChartFieldValuesProvideMode

Gets or sets how field values are passed to the chart control. This is a dependency property.

Public property ChartMaxPointCountInSeries

Gets or sets the maximum allowed number of points in a series. This is a dependency property.

Public property ChartMaxSeriesCount

Gets or sets the maximum allowed number of series in the chart data source. This is a dependency property.

Public property ChartProvideCellValuesAsType Gets or sets the type to which cell values are converted before they are exported to the Chart Control. This is a dependency property.
Public property ChartProvideColumnCustomTotals Gets or sets whether column custom totals should be passed to a chart control. This is a dependency property.
Public property ChartProvideColumnFieldValuesAsType Gets or sets the type to which the column field values are converted before they are exported to the chart control. This is a dependency property.
Public property ChartProvideColumnGrandTotals Gets or sets whether column grand totals are passed to a chart control. This is a dependency property.
Public property ChartProvideColumnTotals

Gets or sets whether column Totals are passed to a chart control. This is a dependency property.

Public property ChartProvideDataByColumns

Gets or sets whether series in a chart control are created based on PivotGrid columns or rows. This is a dependency property.

Public property ChartProvideEmptyCells Gets or sets whether empty cells should be processed by the Chart control. This is a dependency property.
Public property ChartProvideRowCustomTotals Gets or sets whether row custom totals should be displayed in a chart control. This is a dependency property.
Public property ChartProvideRowFieldValuesAsType

Gets or sets the type to which the row field values are converted before they are exported to the chart control. This is a dependency property.

Public property ChartProvideRowGrandTotals

Gets or sets whether row grand totals are passed to a chart control. This is a dependency property.

Public property ChartProvideRowTotals

Gets or sets whether row Totals are passed to a chart control. This is a dependency property.

Public property ChartSelectionOnly Gets or sets whether a chart control should visualize data from the selected cells only.
Public property ChartUpdateDelay

Gets or sets the delay between changing the cell focus or selection, and updating the bound Chart control. This is a dependency property.

Public property Clip Gets or sets the geometry used to define the outline of the contents of an element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property ClipboardCopyCollapsedValuesMode Gets or sets how to copy collapsed field values to the clipboard. This is a dependency property.
Public property ClipboardCopyMultiSelectionMode Gets or sets how to copy cells to the clipboard when multiple cells are selected. This is a dependency property.
Public property ClipToBounds Gets or sets a value indicating whether to clip the content of this element (or content coming from the child elements of this element) to fit into the size of the containing element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property ColumnCount Gets the number of columns in the PivotGridControl.
Public property ColumnFieldValuesAlignment Gets or sets the vertical alignment of column field values. This is a dependency property.
Public property ColumnTotalsLocation Gets or sets the column totals' location. This is a dependency property.
Public property CommandBindings Gets a collection of System.Windows.Input.CommandBinding objects associated with this element. A System.Windows.Input.CommandBinding enables command handling for this element, and declares the linkage between a command, its events, and the handlers attached by this element. (Inherited from System.Windows.UIElement)
Public property ConditionalFormattingManagerServiceTemplate Gets or sets the template that defines the presentation of the conditional formatting manager. This is a dependency property.
Public property ContextMenu Gets or sets the context menu element that should appear whenever the context menu is requested through user interface (UI) from within this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property CopyToClipboardWithFieldValues Gets or sets whether field values are copied to the clipboard when CTRL+C is pressed or the CopySelectionToClipboard method is called.
Public property Cursor Gets or sets the cursor that displays when the mouse pointer is over this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Data For internal use.
Public property DataContext Gets or sets the data context for an element when it participates in data binding. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property DataFieldArea Gets or sets the area in which the data field headers are displayed.
Public property DataFieldAreaIndex Gets or sets the position of the data field headers.
Public property DataFieldCaption Specifies the text displayed within the data header.
Public property DataFieldHeight Gets or sets the height of a Data Field value. This is a dependency property.
Public property DataFieldUnboundExpressionMode

Gets or sets whether unbound expressions for data fields are calculated based on the data source records, or summary values. This is a dependency property.

Public property DataFieldWidth Gets or sets the width of a Data Field value. This is a dependency property.
Public property DataHeadersDisplayMode Specifies how the data fields are displayed if the Data Header Area is too small to display all data fields, even truncated with ellipses. This is a dependency property.
Public property DataProcessingEngine Gets or sets an engine used to perform data processing (aggregation, summarization, etc.) in the pivot grid. This is a dependency property.
Public property DataSource Gets or sets the PivotGridControl data source.
Public propertyStatic member DefaultDataProcessingEngine Gets or sets a default engine used to perform data processing in the pivot grid.
Public property DeferredUpdates Gets or sets whether dragging fields within the Customization Form (when it's painted using the Excel2007 style) immediately updates the layout of fields in the PivotGrid control. This option controls the state of the 'Defer Layout Update' check box in the Customization Form, when the FieldListStyle option is set to Excel2007.
Public property DependencyObjectType Gets the System.Windows.DependencyObjectType that wraps the CLR type of this instance. (Inherited from System.Windows.DependencyObject)
Public property DesiredSize Gets the size that this element computed during the measure pass of the layout process. (Inherited from System.Windows.UIElement)
Public property Dispatcher Gets the System.Windows.Threading.Dispatcher this System.Windows.Threading.DispatcherObject is associated with. (Inherited from System.Windows.Threading.DispatcherObject)
Public property DrawFocusedCellRect Gets or sets whether a focus rectangle is painted around the currently focused cell.
Public property DrillDownCustomColumns Gets or sets a list of columns to be returned when you create a drill-down data source.
Public property DrillDownMaxRowCount Gets or sets the maximum number of rows returned when calling the CreateDrillDownDataSource method.
Public property Effect Gets or sets the bitmap effect to apply to the System.Windows.UIElement. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property ErrorPanelStyle Gets or sets a style of the error panel. This is a dependency property.
Public property ErrorPanelText Gets or sets a text from the error panel. This is a dependency property.
Public property ExcelFieldListState Gets or sets the state of an Excel-style Customization Form. This is a dependency property.
Public property ExcelFieldListTemplate Gets or sets the template used to display the Customization Form in the Excel style.
Public property ExpressionEditorContainer This member supports the internal infrastructure and is not intended to be used directly from your code.
Public property FieldCellKpiTemplate Gets or sets a template used to display data cells that contain KPI graphics. This is a dependency property.
Public property FieldCellKpiTemplateSelector Gets or sets an object that chooses a template for cells that contain KPI graphics. This is a dependency property.
Public property FieldCellTemplate Gets or sets a template used to display data cells. This is a dependency property.
Public property FieldCellTemplateSelector Gets or sets an object that chooses a Cell template based on custom logic. This is a dependency property.
Public property FieldFilterPopupMode Specifies the type of the Filter Drop-Down invoked by clicking a filter button in the Field Header. This is a dependency property.
Public property FieldGeneratorStyle Gets or sets a style that contains settings common to all fields generated using different templates. This is a dependency property.
Public property FieldGeneratorTemplate Gets or sets a template that describes pivot grid fields. This is a dependency property.
Public property FieldGeneratorTemplateSelector Gets or sets the data template selector which chooses a template based on the field's type. This is a dependency property.
Public property FieldHeaderContentStyle Gets or sets a style applied to the field headers. This is a dependency property.
Public property FieldHeaderDragIndicatorSize This member supports the internal infrastructure and is not intended to be used directly from your code.
Public property FieldHeaderDragIndicatorTemplate Gets or sets a template used to display the drag indicator.
Public property FieldHeaderListTemplate Gets or sets a template used to display field headers in the Customization Form when they are arranged in a list. This is a dependency property.
Public property FieldHeaderListTemplateSelector Gets or sets an object that chooses a template, used to display field headers in the Customization Form when they are arranged in a list. This is a dependency property.
Public property FieldHeaderTemplate Gets or sets a template used to display field headers. This is a dependency property.
Public property FieldHeaderTemplateSelector Gets or sets an object that chooses a Field Header template based on custom logic. This is a dependency property.
Public property FieldHeaderTreeViewTemplate Gets or sets a template used to display field headers in the Customization Form when they are arranged in a tree. This is a dependency property.
Public property FieldHeaderTreeViewTemplateSelector Gets or sets an object that chooses a template, used to display field headers in the Customization Form when they are arranged in a tree. This is a dependency property.
Public property FieldHeight Gets or sets the row height for the current pivot grid.
Public property FieldListAllowedLayouts

Gets or sets which layouts can be applied to the Customization Form when it is painted in Excel2007 style. This is a dependency property.

Public property FieldListFactory Represents a custom Customization Form. This is a dependency property.
Public property FieldListIncludeVisibleFields

Gets or sets whether to show visible fields in the Customization Form. This is a dependency property.

Public property FieldListLayout Gets or sets the customization form's layout when it is painted in Excel2007 style. This is a dependency property.
Public property FieldListSplitterX Gets or sets the position of the vertical splitter displayed in the Customization Form. This is a dependency property.
Public property FieldListSplitterY Gets or sets the position of the horizontal splitter displayed in the Customization Form. This is a dependency property.
Public property FieldListState Gets or sets the state of a simple Customization Form. This is a dependency property.
Public property FieldListStyle Gets or sets a style that defines the visual appearance of the Customization Form. This is a dependency property.
Public property FieldListTemplate Gets or sets the template used to display the Customization Form.
Public property Fields Provides access to a pivot grid's field collection.
Public property FieldsSource Gets or sets the source from which the Pivot Grid generates fields. This is a dependency property.
Public property FieldValueMenuCustomizations Allows you to customize the context menu, invoked when right-clicking the field values, by adding new menu items or removing existing items.
Public property FieldValueStyle Gets the style settings used to paint field values.
Public property FieldValueTemplate Gets or sets a template used to display field values. This is a dependency property.
Public property FieldValueTemplateSelector Gets or sets an object that chooses a Field Value template based on custom logic. This is a dependency property.
Public property FieldWidth Gets or sets the column width for the current pivot grid.
Public property FilterByVisibleFieldsOnly Gets or sets whether to take into account filter conditions of visible filter fields only.
Public property FilterCriteria Gets or sets a filter applied to the PivotGridControl. This is a dependency property.
Public property FilterEditorDialogServiceTemplate Gets or sets the template that defines the presentation of the Filter Editor dialog. This is a dependency property.
Public property FilterEditorTemplate Gets or sets a template that defines the presentation of the Filter Element within the Filter Editor dialog. This is a dependency property.
Public property FilteringContext Gets an object which the FilterEditorControl (see FilterEditorControl) uses to interact with a PivotGridControl.
Public property FilterString Gets or sets the filter expression used to filter PIvotGridControl's data. This is an attached property.
Public property FixedRowHeaders Gets or sets whether to anchor row headers to the control edge when scrolling the pivot grid horizontally. This is a dependency property.
Public property FlowDirection Gets or sets the direction that text and other user interface (UI) elements flow within any parent element that controls their layout. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Focusable Gets or sets a value that indicates whether the element can receive focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property FocusedCell Gets or sets the coordinates of the focused cell.
Public property FocusedCellBorderTemplate Gets or sets a template used to display border of the focused cell.
Public property FocusVisualStyle Gets or sets a property that enables customization of appearance, effects, or other style characteristics that will apply to this element when it captures keyboard focus. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property FontFamily Gets or sets the font family of the control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontSize Gets or sets the font size. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontStretch Gets or sets the degree to which a font is condensed or expanded on the screen. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontStyle Gets or sets the font style. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FontWeight Gets or sets the weight or thickness of the specified font. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property ForceCursor Gets or sets a value that indicates whether this System.Windows.FrameworkElement should force the user interface (UI) to render the cursor as declared by the System.Windows.FrameworkElement.Cursor property. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Foreground Gets or sets a brush that describes the foreground color. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property FormatConditionDialogServiceTemplate Gets or sets the template that defines the presentation of the format condition dialog. This is a dependency property.
Public property FormatConditionGeneratorTemplate Gets or sets a template that describes conditional formats. This is a dependency property.
Public property FormatConditionGeneratorTemplateSelector Gets or sets the data template selector which chooses a template based on the conditional format type. This is a dependency property.
Public property FormatConditions Gets the collection of style format rules for a pivot grid control.
Public property FormatConditionsSource Gets or set a list of conditional formats applied to the PivotGrid.
Public property GridMenu Gets the context menu currently being displayed within the PivotGridControl.
Public property GroupDataCaseSensitive Gets or sets whether data is grouped case-sensitively.
Public property GroupFieldsInFieldList Gets or sets whether hidden fields are grouped within the Customization Form. This is a dependency property.
Public property GroupFilterMode Gets or sets the filtering mode of grouped fields.
Public property GroupGeneratorStyle Gets or sets a style that contains settings common to all field groups generated using different templates. This is a dependency property.
Public property GroupGeneratorTemplate Gets or sets a template that describes Pivot Grid Field Groups. This is a dependency property.
Public property GroupGeneratorTemplateSelector Gets or sets the data template selector which chooses a template based on the group's type. This is a dependency property.
Public property Groups Gets the collection of Field Groups.
Public property GroupsSource Gets or sets the source from which the Pivot Grid generates field groups. This is a dependency property.
Public property HasAnimatedProperties Gets a value indicating whether this element has any animated properties. (Inherited from System.Windows.UIElement)
Public property HeaderAreaMenuCustomizations Allows you to customize the context menu, invoked when right-clicking the Header Area, by adding new menu items or removing existing items.
Public property HeaderMenuCustomizations Allows you to customize the context menu, invoked when right-clicking the field headers, by adding new menu items or removing existing items.
Public property Height Gets or sets the suggested height of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property HiddenFields Gets the collection of hidden fields.
Public property HorizontalAlignment Gets or sets the horizontal alignment characteristics applied to this element when it is composed within a parent element, such as a panel or items control. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property HorizontalContentAlignment Gets or sets the horizontal alignment of the control's content. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property InputBindings Gets the collection of input bindings associated with this element. (Inherited from System.Windows.UIElement)
Public property InputScope Gets or sets the context for input used by this System.Windows.FrameworkElement. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property IsArrangeValid Gets a value indicating whether the computed size and position of child elements in this element's layout are valid. (Inherited from System.Windows.UIElement)
Public property IsAsyncInProgress Gets whether an asynchronous operation is in progress.
Public property IsCellMenuEnabled Gets or sets whether a context menu is invoked when an end-user right-clicks a Cell. This is a dependency property.
Public property IsEnabled Gets or sets a value indicating whether this element is enabled in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsErrorPanelVisible Gets or sets a value indicating whether the error panel is visible. This is a dependency property.
Public property IsFieldListMenuEnabled Gets or sets whether the Customization Form Layout menu is available for end-users.
Public property IsFieldListVisible Gets or sets whether the Customization Form is visible. This is a dependency property.
Public property IsFieldValueMenuEnabled Gets or sets whether the Field Value Context Menu is shown when an end-user right-clicks a Field Value. This is a dependency property.
Public property IsFilterPopupMenuEnabled Gets or sets whether right-clicking a filter drop-down window invokes a context menu that allows you to invert the current check states of items. This is a dependency property.
Public property IsFilterPopupWaitIndicatorVisible For internal use.
Public property IsFocused Gets a value that determines whether this element has logical focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsHeaderAreaMenuEnabled Gets or sets whether the Header Area Context Menu is shown when an end-user right-clicks a header area. This is a dependency property.
Public property IsHeaderMenuEnabled Gets or sets whether the Field Header Context Menu is shown when an end-user right-clicks a field's header. This is a dependency property.
Public property IsHitTestVisible Gets or sets a value that declares whether this element can possibly be returned as a hit test result from some portion of its rendered content. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsInitialized Gets a value that indicates whether this element has been initialized, either during processing by a XAML processor, or by explicitly having its System.Windows.FrameworkElement.EndInit method called. (Inherited from System.Windows.FrameworkElement)
Public property IsInputMethodEnabled Gets a value indicating whether an input method system, such as an Input Method Editor (IME), is enabled for processing the input to this element. (Inherited from System.Windows.UIElement)
Public property IsKeyboardFocused Gets a value indicating whether this element has keyboard focus. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsKeyboardFocusWithin Gets a value indicating whether keyboard focus is anywhere within the element or its visual tree child elements. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsLoaded Gets a value that indicates whether this element has been loaded for presentation. (Inherited from System.Windows.FrameworkElement)
Public property IsLoading Gets whether the PivotGridControl is being initialized.
Public property IsMainWaitIndicatorVisible For internal use.
Public property IsManipulationEnabled (Inherited from System.Windows.UIElement)
Public property IsMeasureValid Gets a value indicating whether the current size returned by layout measure is valid. (Inherited from System.Windows.UIElement)
Public property IsMouseCaptured Gets a value indicating whether the mouse is captured to this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseCaptureWithin Gets a value that determines whether mouse capture is held by this element or by child elements in its visual tree. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseDirectlyOver Gets a value that indicates whether the position of the mouse pointer corresponds to hit test results, which take element compositing into account. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsMouseOver Gets a value indicating whether the mouse pointer is located over this element (including child elements in the visual tree). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsPrefilterEnabled Gets or sets whether the filter specified by the Prefilter, is enabled. This is a dependency property.
Public property IsPrefilterVisible Gets whether the Prefilter is invoked. This is a dependency property.
Public property IsSealed Gets a value that declares whether this instance is currently read-only. (Inherited from System.Windows.DependencyObject)
Public property IsStylusCaptured Gets a value indicating whether the stylus is captured by this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusCaptureWithin Gets a value that determines whether stylus capture is held by this element, or an element within the element bounds and its visual tree. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusDirectlyOver Gets a value that indicates whether the stylus position corresponds to hit test results, which take element compositing into account. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsStylusOver Gets a value indicating whether the stylus cursor is located over this element (including visual child elements). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property IsTabStop Gets or sets a value that indicates whether a control is included in tab navigation. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property IsUpdateLocked Gets whether the PivotGridControl has been locked for updating.
Public property IsVisible Gets a value indicating whether this element is visible in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Language Gets or sets localization/globalization language information that applies to an element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property LayoutTransform Gets or sets a graphics transformation that should apply to this element when layout is performed. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property LeftTopCoord Gets the column and row indexes of the data cell displayed in the top left corner.
Public property LeftTopPixelCoord Gets the coordinates of the data area displayed in the top left corner.
Public property LoadingPanelDelay Gets or sets the delay before displaying the loading panel in Asynchronous Mode. This is a dependency property.
Public property Margin Gets or sets the outer margin of an element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MaxHeight Gets or sets the maximum height constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MaxWidth Gets or sets the maximum width constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MergeColumnFieldValues Gets or sets whether to merge the neighboring column headers if they contain the same field value. This is a dependency property.
Public property MergeRowFieldValues Gets or sets whether to merge the neighboring row headers if they contain the same field value. This is a dependency property.
Public property MinHeight Gets or sets the minimum height constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MinWidth Gets or sets the minimum width constraint of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property MRUFilterListCount Gets or sets the number of filter criteria stored into the MRU Filter List. This is a dependency property.
Public property MRUFilters Gets the MRU Filter List.
Public property MultiSelection Gets the selected cells.
Public property Name Gets or sets the identifying name of the element. The name provides a reference so that code-behind, such as event handler code, can refer to a markup element after it is constructed during processing by a XAML processor. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property OlapConnectionString Gets or sets a connection string to a cube in an MS Analysis Services database.
Public property OlapDataProvider Gets or sets which data provider should be used to bind to an OLAP cube. This is a dependency property.
Public property OlapDefaultMemberFields Gets or sets for which filter fields the pivot grid processes only data related to their default members. This is a dependency property.
Public property OlapFilterByUniqueName Gets or sets whether PivotGridControl should take into account OLAP member values or unique names when filtering data in the OLAP mode. This is a dependency property.
Public property OlapModificationCheckInterval
Public property OlapServerDefinedDrillDownColumns Gets or sets whether the list of columns is defined by the server in the OLAP mode.
Public property OlapSortUsingDiscoverXmlMetadata
Public property Opacity Gets or sets the opacity factor applied to the entire System.Windows.UIElement when it is rendered in the user interface (UI). This is a dependency property. (Inherited from System.Windows.UIElement)
Public property OpacityMask Gets or sets an opacity mask, as a System.Windows.Media.Brush implementation that is applied to any alpha-channel masking for the rendered content of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property OptimizeSummaryTypeCalculation
Public property OverridesDefaultStyle Gets or sets a value that indicates whether this element incorporates style properties from theme styles. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Padding Gets or sets the padding inside a control. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property Parent Gets the logical parent element of this element. (Inherited from System.Windows.FrameworkElement)
Public property PersistId Obsolete. Gets a value that uniquely identifies this element. (Inherited from System.Windows.UIElement)
Public property PivotGrid Gets or sets the owner PivotGridControl of an element. This is an attached property.
Public property PredefinedColorScaleFormats Contains predefined color scale formats that are used to color cells proportional to their values. This is a dependency property.
Public property PredefinedDataBarFormats Contains predefined data bar formats that are used to fill cells with bars whose lengths are proportional to the cell values. This is a dependency property.
Public property PredefinedFormats Contains predefined formats that are used by conditional formatting rules. This is a dependency property.
Public property PredefinedIconSetFormats Contains predefined icon set formats that are used to display a specific icon in a cell according to the range to which this cell value belongs. This is a dependency property.
Public property PrefilterContainer This member supports the internal infrastructure and is not intended be used directly from your code.
Public property PrefilterControl Gets the Prefilter.
Public property PrefilterCriteria Gets or sets the pivot grid's prefilter criteria. This is a dependency property.
Public property PrefilterPanelText Gets the filter expression displayed within the prefilter panel. This is a dependency property.
Public property PrefilterString Gets or sets the filter expression specified by the Prefilter.
Public property PrintCellBackground Gets or sets the brush used to paint the background of data cells when the pivot grid is printed. This is a dependency property.
Public property PrintCellForeground Gets or sets the brush used to paint the foreground of data cells when the pivot grid is printed. This is a dependency property.
Public property PrintCellTotalBackground Gets or sets the brush used to paint the background of total and grand total cells when the pivot grid is printed. This is a dependency property.
Public property PrintCellTotalForeground Gets or sets the brush used to paint the foreground of total and grand total cells when the pivot grid is printed. This is a dependency property.
Public property PrintColumnHeaders Gets or sets whether to print headers of the column fields. This is a dependency property.
Public property PrintDataHeaders Gets or sets whether to print headers of the data fields. This is a dependency property.
Public property PrintFieldCellKpiTemplate Gets or sets a template used to print data cells that contain KPI graphics. This is a dependency property.
Public property PrintFieldCellKpiTemplateSelector Gets or sets a template selector that chooses a print template for data cells that contain KPI graphics. This is a dependency property.
Public property PrintFieldCellTemplate Gets or sets a template used to print data cells. This is a dependency property.
Public property PrintFieldCellTemplateSelector Gets or sets a template selector that chooses a print template for data cells based on custom logic. This is a dependency property.
Public property PrintFieldHeaderTemplate Gets or sets a template used to print field headers. This is a dependency property.
Public property PrintFieldHeaderTemplateSelector Gets or sets a template selector that chooses a print template for field headers based on custom logic. This is a dependency property.
Public property PrintFieldValueTemplate Gets or sets a template used to print field values. This is a dependency property.
Public property PrintFieldValueTemplateSelector Gets or sets a template selector that chooses a print template for field values based on custom logic. This is a dependency property.
Public property PrintFilterHeaders Gets or sets whether to print headers of the filter fields. This is a dependency property.
Public property PrintHeadersOnEveryPage Gets or sets whether to print field headers on every page. This is a dependency property.
Public property PrintHorzLines

Gets or sets whether the horizontal grid lines are printed. This is a dependency property.

Public property PrintInsertPageBreaks Gets or sets whether to insert page breaks at the end of every page. This is a dependency property.
Public property PrintLayoutMode Gets or sets the layout mode of the print document. This is a dependency property.
Public property PrintRowHeaders Gets or sets whether to print headers of the row fields. This is a dependency property.
Public property PrintUnusedFilterFields Gets or sets whether to print headers of the unused filter fields. This is a dependency property.
Public property PrintValueBackground Gets or sets the brush used to paint the background of Field Value cells when the pivot grid is printed. This is a dependency property.
Public property PrintValueForeground Gets or sets the brush used to paint the foreground of Field Value cells when the pivot grid is printed. This is a dependency property.
Public property PrintValueTotalBackground Gets or sets the brush used to paint the background of total and grand total headers when the pivot grid is printed. This is a dependency property.
Public property PrintValueTotalForeground Gets or sets the brush used to paint the foreground of total and grand total headers when the pivot grid is printed. This is a dependency property.
Public property PrintVertLines

Gets or sets whether the vertical grid lines are printed. This is a dependency property.

Public property RenderSize Gets (or sets, but see Remarks) the final render size of this element. (Inherited from System.Windows.UIElement)
Public property RenderTransform Gets or sets transform information that affects the rendering position of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property RenderTransformOrigin Gets or sets the center point of any possible render transform declared by System.Windows.UIElement.RenderTransform, relative to the bounds of the element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property ResizingIndicatorTemplate Gets or sets a template used to display the resizing indicator.
Public property Resources Gets or sets the locally-defined resource dictionary. (Inherited from System.Windows.FrameworkElement)
Public property RowCount Gets the number of rows in the PivotGridControl.
Public property RowFieldValuesAlignment Gets or sets the vertical alignment of row field values. This is a dependency property.
Public property RowTotalsHeightFactor Gets or sets the factor used to define how much higher the total rows are, compared to the Field Value rows. This is a dependency property.
Public property RowTotalsLocation Gets or sets the location of row totals. This is a dependency property.
Public property RowTreeHeight Gets or sets the height of a row when row field values are arranged in a tree. This is a dependency property.
Public property RowTreeMinHeight Gets or sets the minimum allowed height of a row when row field values are arranged in a tree. This is a dependency property.
Public property RowTreeMinWidth

Gets or sets the minimum allowed width of the innermost row field values when they are arranged into a tree. This is a dependency property.

Public property RowTreeOffset Gets or sets the tree offset. This is a dependency property.
Public property RowTreeWidth Gets or sets the width of the innermost row field values when they are arranged into a tree. This is a dependency property.
Public property ScrollingMode Gets or sets the scrolling mode. This is a dependency property.
Public property ScrollViewerTemplate For internal use.
Public property SelectedCellInfo Gets information about the selected data cell.
Public property Selection Gets or sets the coordinates of the selected cells.
Public property SelectMode Gets or sets the selection mode.
Public property ShowBorder Gets or sets whether the pivot grid's border is displayed. This is a dependency property.
Public property ShowColumnGrandTotalHeader Gets or sets whether the Grand Total column header is visible when there are two or more data fields. This is a dependency property.
Public property ShowColumnGrandTotals Gets or sets whether to display Row Grand Totals.
Public property ShowColumnHeaders Gets or sets whether column headers are displayed.
Public property ShowColumnsBorder For internal use.
Public property ShowColumnTotals Gets or sets whether to display Column Totals.
Public property ShowCustomTotalsForSingleValues Gets or sets whether custom totals are displayed for the field values which contain a single nesting field value.
Public property ShowDataHeaders Gets or sets whether data headers are displayed.
Public property ShowFilterHeaders Gets or sets whether to display the Filter Header Area.
Public property ShowGrandTotalsForSingleValues Gets or sets whether grand totals are displayed when the control lists a single value of an outer column field or row field along its left or top edge.
Public property ShowLoadingPanel Gets or sets whether the Loading Panel is displayed within the PivotGridControl when a time-consuming operation is performed. This is a dependency property.
Public property ShowOnlyAvailableFilterItems Gets or sets whether filter items that cannot be displayed because of filtering applied to other fields should be hidden. This is a dependency property.
Public property ShowPrefilterPanel Gets whether the Prefilter Panel is displayed within the PivotGridControl. This is a dependency property.
Public property ShowPrefilterPanelMode Gets or sets when the Prefilter Panel is displayed within the PivotGridControl. This is a dependency property.
Public property ShowRowGrandTotalHeader Gets or sets whether the Grand Total row header is visible when there are two or more data fields. This is a dependency property.
Public property ShowRowGrandTotals Gets or sets whether to display row grand totals.
Public property ShowRowHeaders Gets or sets whether row headers are displayed.
Public property ShowRowTotals Gets or sets whether to display Row Totals.
Public property ShowTotalsForSingleValues Gets or sets whether automatic Totals are displayed for the field values which contain a single nesting field value.
Public property SnapsToDevicePixels Gets or sets a value that determines whether rendering for this element should use device-specific pixel settings during rendering. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property SortBySummaryDefaultOrder Gets or sets the sort order applied to a field when sorting by summaries is enabled for it.
Public property Style Gets or sets the style used by this element when it is rendered. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property SummaryDataSourceFieldNaming Gets or sets the rule for naming columns that correspond to data fields, when creating a data source via the CreateSummaryDataSource methods.
Public property TabIndex Gets or sets a value that determines the order in which elements receive focus when the user navigates through controls by using the TAB key. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property Tag Gets or sets an arbitrary object value that can be used to store custom information about this element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property Template Gets or sets a control template. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property TemplatedParent Gets a reference to the template parent of this element. This property is not relevant if the element was not created through a template. (Inherited from System.Windows.FrameworkElement)
Public property ToolTip Gets or sets the tool-tip object that is displayed for this element in the user interface (UI). This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property TouchesCaptured (Inherited from System.Windows.UIElement)
Public property TouchesCapturedWithin (Inherited from System.Windows.UIElement)
Public property TouchesDirectlyOver (Inherited from System.Windows.UIElement)
Public property TouchesOver (Inherited from System.Windows.UIElement)
Public property Triggers Gets the collection of triggers established directly on this element, or in child elements. (Inherited from System.Windows.FrameworkElement)
Public property Uid Gets or sets the Uid for this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property UseAsyncMode Gets or sets whether data-aware operations caused by end-user actions are performed asynchronously. This is a dependency property.
Public property UseLayoutRounding (Inherited from System.Windows.FrameworkElement)
Public property UseLegacyFilterEditor Gets or sets whether to use the new, Excel-style, or the old Filter Editor. This is an attached property.
Public property UseLightweightTemplates Gets or sets whether to enable the PivotGrid's optimized mode. This is a dependency property.
Public property UserAction Gets an end-user action on the PivotGridControl.
Public property ValueBackground Gets or sets the brush used to paint the background of Field Value cells. This is a dependency property.
Public property ValueForeground Gets or sets the brush used to paint the foreground of Field Value cells. This is a dependency property.
Public property ValueSelectedBackground Gets or sets the brush used to paint the background of the selected Field Value cell. This is a dependency property.
Public property ValueSelectedForeground Gets or sets the brush used to paint the foreground of the selected Field Value cell. This is a dependency property.
Public property ValueTotalBackground Gets or sets the brush used to paint the background of total and grand total headers. This is a dependency property.
Public property ValueTotalForeground Gets or sets the brush used to paint the foreground of total and grand total headers. This is a dependency property.
Public property ValueTotalSelectedBackground Gets or sets the brush used to paint the background of the selected total or grand total header. This is a dependency property.
Public property ValueTotalSelectedForeground Gets or sets the brush used to paint the foreground of the selected total or grand total header. This is a dependency property.
Public property VerticalAlignment Gets or sets the vertical alignment characteristics applied to this element when it is composed within a parent element such as a panel or items control. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Public property VerticalContentAlignment Gets or sets the vertical alignment of the control's content. This is a dependency property. (Inherited from System.Windows.Controls.Control)
Public property Visibility Gets or sets the user interface (UI) visibility of this element. This is a dependency property. (Inherited from System.Windows.UIElement)
Public property Width Gets or sets the width of the element. This is a dependency property. (Inherited from System.Windows.FrameworkElement)
Top

Expanded See Also

Is this topic helpful?​​​​​​​