[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Expand]Controls and Libraries
 [Expand]Common Features
  Get More Help
 [Collapse]API Reference
  [Expand]DevExpress.DataAccess.UI
  [Expand]DevExpress.DataAccess.UI.Design
  [Expand]DevExpress.DataAccess.UI.EntityFramework
  [Expand]DevExpress.DataAccess.UI.Excel
  [Expand]DevExpress.DataAccess.UI.ObjectBinding
  [Expand]DevExpress.DataAccess.UI.Sql
  [Expand]DevExpress.DataAccess.UI.Wizard
  [Expand]DevExpress.DataAccess.UI.Wizard.Services
  [Expand]DevExpress.DataAccess.UI.Wizard.Views
  [Expand]DevExpress.DocumentView
  [Expand]DevExpress.DocumentView.Controls
  [Expand]DevExpress.LookAndFeel
  [Expand]DevExpress.LookAndFeel.Helpers
  [Expand]DevExpress.Skins
  [Expand]DevExpress.Snap
  [Expand]DevExpress.Snap.API.Native
  [Expand]DevExpress.Snap.Core
  [Expand]DevExpress.Snap.Core.API
  [Expand]DevExpress.Snap.Core.Fields
  [Expand]DevExpress.Snap.Core.Forms
  [Expand]DevExpress.Snap.Core.Options
  [Expand]DevExpress.Snap.Core.Services
  [Expand]DevExpress.Snap.Extensions
  [Expand]DevExpress.Snap.Extensions.Localization
  [Expand]DevExpress.Snap.Extensions.UI
  [Expand]DevExpress.Snap.Localization
  [Expand]DevExpress.Snap.Options
  [Expand]DevExpress.Snap.Services
  [Expand]DevExpress.Utils
  [Expand]DevExpress.Utils.Animation
  [Expand]DevExpress.Utils.Behaviors
  [Expand]DevExpress.Utils.Controls
  [Expand]DevExpress.Utils.DragDrop
  [Expand]DevExpress.Utils.Drawing
  [Expand]DevExpress.Utils.Filtering
  [Expand]DevExpress.Utils.Layout
  [Expand]DevExpress.Utils.Menu
  [Expand]DevExpress.Utils.MVVM
  [Expand]DevExpress.Utils.Taskbar
  [Expand]DevExpress.Utils.Taskbar.Core
  [Expand]DevExpress.Utils.UI.Localization
  [Expand]DevExpress.Utils.VisualEffects
  [Expand]DevExpress.Utils.Win
  [Expand]DevExpress.XtraBars
  [Expand]DevExpress.XtraBars.Alerter
  [Expand]DevExpress.XtraBars.Docking
  [Expand]DevExpress.XtraBars.Docking2010
  [Expand]DevExpress.XtraBars.Docking2010.Base
  [Expand]DevExpress.XtraBars.Docking2010.Customization
  [Expand]DevExpress.XtraBars.Docking2010.Views
  [Expand]DevExpress.XtraBars.Docking2010.Views.NativeMdi
  [Expand]DevExpress.XtraBars.Docking2010.Views.Tabbed
  [Expand]DevExpress.XtraBars.Docking2010.Views.Widget
  [Expand]DevExpress.XtraBars.Docking2010.Views.WindowsUI
  [Expand]DevExpress.XtraBars.FluentDesignSystem
  [Expand]DevExpress.XtraBars.Localization
  [Expand]DevExpress.XtraBars.Navigation
  [Expand]DevExpress.XtraBars.Ribbon
  [Expand]DevExpress.XtraBars.Ribbon.Gallery
  [Expand]DevExpress.XtraBars.Ribbon.ViewInfo
  [Expand]DevExpress.XtraBars.ToastNotifications
  [Expand]DevExpress.XtraBars.ToolbarForm
  [Expand]DevExpress.XtraBars.Utils
  [Expand]DevExpress.XtraBars.WinRTLiveTiles
  [Expand]DevExpress.XtraCharts
  [Expand]DevExpress.XtraCharts.Designer
  [Expand]DevExpress.XtraCharts.Wizard
  [Expand]DevExpress.XtraDataLayout
  [Expand]DevExpress.XtraDiagram
  [Expand]DevExpress.XtraDiagram.Docking
  [Expand]DevExpress.XtraDiagram.Options
  [Expand]DevExpress.XtraEditors
  [Expand]DevExpress.XtraEditors.ButtonPanel
  [Expand]DevExpress.XtraEditors.Calendar
  [Expand]DevExpress.XtraEditors.Camera
  [Expand]DevExpress.XtraEditors.Container
  [Expand]DevExpress.XtraEditors.Controls
  [Expand]DevExpress.XtraEditors.CustomEditor
  [Expand]DevExpress.XtraEditors.DXErrorProvider
  [Expand]DevExpress.XtraEditors.Filtering
  [Expand]DevExpress.XtraEditors.Mask
  [Expand]DevExpress.XtraEditors.Persistent
  [Expand]DevExpress.XtraEditors.Repository
  [Expand]DevExpress.XtraEditors.ViewInfo
  [Expand]DevExpress.XtraFilterEditor
  [Expand]DevExpress.XtraGauges.Presets.Styles
  [Expand]DevExpress.XtraGauges.Win
  [Expand]DevExpress.XtraGauges.Win.Base
  [Expand]DevExpress.XtraGauges.Win.Gauges.Circular
  [Expand]DevExpress.XtraGauges.Win.Gauges.Digital
  [Expand]DevExpress.XtraGauges.Win.Gauges.Linear
  [Expand]DevExpress.XtraGauges.Win.Gauges.State
  [Expand]DevExpress.XtraGrid
  [Expand]DevExpress.XtraGrid.Columns
  [Expand]DevExpress.XtraGrid.EditForm
  [Expand]DevExpress.XtraGrid.FilterEditor
  [Expand]DevExpress.XtraGrid.Localization
  [Expand]DevExpress.XtraGrid.Views.BandedGrid
  [Expand]DevExpress.XtraGrid.Views.BandedGrid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Base
  [Expand]DevExpress.XtraGrid.Views.Base.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Card
  [Expand]DevExpress.XtraGrid.Views.Card.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Grid
  [Expand]DevExpress.XtraGrid.Views.Grid.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Layout
  [Expand]DevExpress.XtraGrid.Views.Layout.Events
  [Expand]DevExpress.XtraGrid.Views.Layout.ViewInfo
  [Expand]DevExpress.XtraGrid.Views.Printing
  [Expand]DevExpress.XtraGrid.Views.Tile
  [Expand]DevExpress.XtraGrid.Views.WinExplorer
  [Expand]DevExpress.XtraGrid.WinExplorer
  [Expand]DevExpress.XtraLayout
  [Expand]DevExpress.XtraLayout.Converter
  [Expand]DevExpress.XtraLayout.Customization
  [Expand]DevExpress.XtraLayout.HitInfo
  [Expand]DevExpress.XtraLayout.Localization
  [Expand]DevExpress.XtraLayout.Utils
  [Expand]DevExpress.XtraMap
  [Expand]DevExpress.XtraMap.Printing
  [Expand]DevExpress.XtraNavBar
  [Expand]DevExpress.XtraNavBar.ViewInfo
  [Expand]DevExpress.XtraPdfViewer
  [Expand]DevExpress.XtraPdfViewer.Commands
  [Expand]DevExpress.XtraPdfViewer.Extensions
  [Expand]DevExpress.XtraPdfViewer.Localization
  [Collapse]DevExpress.XtraPivotGrid
   [Expand]CancelPivotCellEditEventArgs Class
   [Expand]CustomCustomizationFormSortEventArgs Class
   [Expand]CustomEditValueEventArgs Class
    CustomEditValueEventHandler Delegate
   [Expand]CustomExportCellEventArgs Class
   [Expand]CustomExportFieldValueEventArgs Class
   [Expand]CustomExportHeaderEventArgs Class
   [Expand]CustomFieldDataEventArgs Class
    CustomFieldDataEventHandler Delegate
   [Expand]CustomizationFormShowingEventArgs Class
    CustomizationFormShowingEventHandler Delegate
   [Expand]CustomizePivotCellEventArgs Class
    CustomizePivotCellEventHandler Delegate
   [Expand]CustomServerModeSortEventArgs Class
    DateTimeGroupIntervals Enumeration
   [Expand]EditValueChangedEventArgs Class
    EditValueChangedEventHandler Delegate
    ExcelFilterDateTimeValuesTabFilterType Enumeration
    ExcelFilterDefaultTab Enumeration
    ExcelFilterEnumFilters Enumeration
    ExcelFilterNumericValuesTabFilterType Enumeration
    ExcelFilterTextFilters Enumeration
    FieldFilterPopupMode Enumeration
   [Expand]FieldValueCell Class
   [Expand]FilterPopupExcelCustomizeTemplateEventArgs Class
    FilterPopupExcelCustomizeTemplateEventHandler Delegate
   [Expand]FilterPopupExcelDataEventArgs Class
    FilterPopupExcelDataEventHandler Delegate
   [Expand]FilterPopupExcelEventArgs Class
    FilterPopupExcelEventHandler Delegate
   [Expand]FilterPopupExcelPrepareTemplateEventArgs Class
    FilterPopupExcelPrepareTemplateEventHandler Delegate
   [Expand]FilterPopupExcelQueryFilterCriteriaEventArgs Class
    FilterPopupExcelQueryFilterCriteriaEventHandler Delegate
    FilterPopupToolbarButtons Enumeration
   [Expand]FormatRuleFieldIntersectionSettings Class
   [Expand]FormatRuleSettings Class
   [Expand]FormatRuleTotalTypeSettings Class
   [Expand]PivotAreaChangingEventArgs Class
    PivotAreaChangingEventHandler Delegate
   [Expand]PivotCellBaseEventArgs Class
   [Expand]PivotCellDisplayTextEventArgs Class
    PivotCellDisplayTextEventHandler Delegate
   [Expand]PivotCellEditEventArgs Class
   [Expand]PivotCellEventArgs Class
    PivotCellEventHandler Delegate
   [Expand]PivotCellValueEventArgs Class
    PivotContextMenuIds Enumeration
   [Expand]PivotCustomAppearanceEventArgs Class
    PivotCustomAppearanceEventHandler Delegate
   [Expand]PivotCustomAppearanceThreadSafeEventArgs Class
   [Expand]PivotCustomCellEditEventArgs Class
   [Expand]PivotCustomChartDataSourceDataEventArgs Class
    PivotCustomChartDataSourceDataEventHandler Delegate
   [Expand]PivotCustomChartDataSourceRowsEventArgs Class
    PivotCustomChartDataSourceRowsEventHandler Delegate
   [Expand]PivotCustomColumnWidthEventArgs Class
   [Expand]PivotCustomDrawBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellBaseEventArgs Class
   [Expand]PivotCustomDrawCellBaseThreadSafeEventArgs Class
   [Expand]PivotCustomDrawCellEventArgs Class
    PivotCustomDrawCellEventHandler Delegate
   [Expand]PivotCustomDrawCellThreadSafeEventArgs Class
   [Expand]PivotCustomDrawEventArgs Class
    PivotCustomDrawEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderEventArgs Class
    PivotCustomDrawFieldHeaderEventHandler Delegate
   [Expand]PivotCustomDrawFieldHeaderThreadSafeEventArgs Class
   [Expand]PivotCustomDrawFieldValueEventArgs Class
    PivotCustomDrawFieldValueEventHandler Delegate
   [Expand]PivotCustomDrawFieldValueThreadSafeEventArgs Class
   [Expand]PivotCustomDrawHeaderAreaEventArgs Class
    PivotCustomDrawHeaderAreaEventHandler Delegate
   [Expand]PivotCustomDrawHeaderAreaThreadSafeEventArgs Class
   [Expand]PivotCustomDrawThreadSafeEventArgs Class
   [Expand]PivotCustomFieldValueCellsEventArgs Class
    PivotCustomFieldValueCellsEventHandler Delegate
   [Expand]PivotCustomFilterPopupItemsEventArgs Class
    PivotCustomFilterPopupItemsEventHandler Delegate
   [Expand]PivotCustomGroupIntervalEventArgs Class
    PivotCustomGroupIntervalEventHandler Delegate
   [Expand]PivotCustomRowHeightEventArgs Class
    PivotEndUpdateMode Enumeration
   [Expand]PivotFieldDisplayTextEventArgs Class
    PivotFieldDisplayTextEventHandler Delegate
   [Expand]PivotFieldEventArgs Class
    PivotFieldEventHandler Delegate
   [Expand]PivotFieldFilterChangingEventArgs Class
    PivotFieldFilterChangingEventHandler Delegate
   [Expand]PivotFieldImageIndexEventArgs Class
    PivotFieldImageIndexEventHandler Delegate
   [Expand]PivotFieldImageIndexThreadSafeEventArgs Class
   [Expand]PivotFieldPropertyChangedEventArgs Class
    PivotFieldPropertyChangedEventHandler Delegate
   [Expand]PivotFieldTooltipShowingEventArgs Class
    PivotFieldTooltipShowingEventHandler Delegate
   [Expand]PivotFieldValueCancelEventArgs Class
    PivotFieldValueCancelEventHandler Delegate
   [Expand]PivotFieldValueEventArgs Class
    PivotFieldValueEventHandler Delegate
   [Expand]PivotFieldValueHitInfo Class
   [Expand]PivotFilter Class
   [Expand]PivotGridAppearances Class
   [Expand]PivotGridAppearancesBase Class
   [Expand]PivotGridAppearancesPrint Class
   [Expand]PivotGridCells Class
   [Expand]PivotGridControl Class
   [Expand]PivotGridCustomFieldSortEventArgs Class
    PivotGridCustomFieldSortEventHandler Delegate
   [Expand]PivotGridCustomSummaryEventArgs Class
    PivotGridCustomSummaryEventHandler Delegate
   [Expand]PivotGridCustomTotal Class
   [Expand]PivotGridCustomTotalCollection Class
   [Expand]PivotGridField Class
   [Expand]PivotGridFieldAppearances Class
   [Expand]PivotGridFieldCollection Class
   [Expand]PivotGridFieldImageOptions Class
   [Expand]PivotGridFieldOptionsEx Class
   [Expand]PivotGridFieldOptionsFilter Class
   [Expand]PivotGridFieldToolTips Class
   [Expand]PivotGridFormatConditionCollection Class
   [Expand]PivotGridFormatRule Class
   [Expand]PivotGridFormatRuleCollection Class
    PivotGridHeaderHitTest Enumeration
   [Expand]PivotGridHeadersAreaHitInfo Class
   [Expand]PivotGridHitInfo Class
    PivotGridHitTest Enumeration
   [Expand]PivotGridMenuEventArgs Class
   [Expand]PivotGridMenuEventArgsBase Class
    PivotGridMenuEventHandler Delegate
   [Expand]PivotGridMenuItemClickEventArgs Class
   [Expand]PivotGridMenuItemClickEventArgsBase Class
    PivotGridMenuItemClickEventHandler Delegate
    PivotGridMenuType Enumeration
   [Collapse]PivotGridOptionsBehavior Class
     PivotGridOptionsBehavior Members
     PivotGridOptionsBehavior Constructor
    [Collapse]PivotGridOptionsBehavior Properties
      ApplyBestFitOnFieldDragging Property
      BestFitConsiderCustomAppearance Property
      EditorShowMode Property
      ExpressionEditorMode Property
      HorizontalScrolling Property
      RepaintGridOnFocusedCellChanged Property
    [Expand]PivotGridOptionsBehavior Methods
   [Expand]PivotGridOptionsCustomizationEx Class
   [Expand]PivotGridOptionsFilterPopup Class
   [Expand]PivotGridOptionsHint Class
   [Expand]PivotGridOptionsMenu Class
   [Expand]PivotGridOptionsView Class
    PivotGridScrolling Enumeration
   [Expand]PivotGridStyleFormatCondition Class
    PivotGridValueHitTest Enumeration
   [Expand]PivotGroupEventArgs Class
    PivotGroupEventHandler Delegate
   [Expand]PivotLeftTopCellChangedEventArgs Class
   [Expand]PivotOlapExceptionEventArgs Class
    PivotOlapExceptionEventHandler Delegate
   [Expand]PivotOlapQueryDataEventArgs Class
   [Expand]PivotQueryExceptionEventArgs Class
    PivotQueryExceptionEventHandler Delegate
    PivotShowButtonModeEnum Enumeration
   [Expand]PivotUserActionEventArgs Class
    PivotUserActionEventHandler Delegate
   [Expand]PivotXlsExportOptions Class
   [Expand]PivotXlsxExportOptions Class
   [Expand]PopupMenuShowingEventArgs Class
    PopupMenuShowingEventHandler Delegate
   [Expand]Prefilter Class
    UserAction Enumeration
  [Expand]DevExpress.XtraPivotGrid.Data
  [Expand]DevExpress.XtraPrinting
  [Expand]DevExpress.XtraPrinting.Control
  [Expand]DevExpress.XtraPrinting.Preview
  [Expand]DevExpress.XtraPrintingLinks
  [Expand]DevExpress.XtraReports.UI
  [Expand]DevExpress.XtraRichEdit
  [Expand]DevExpress.XtraRichEdit.Commands
  [Expand]DevExpress.XtraRichEdit.Export
  [Expand]DevExpress.XtraRichEdit.Import
  [Expand]DevExpress.XtraRichEdit.Menu
  [Expand]DevExpress.XtraScheduler
  [Expand]DevExpress.XtraScheduler.Drawing
  [Expand]DevExpress.XtraScheduler.GoogleCalendar
  [Expand]DevExpress.XtraScheduler.Printing
  [Expand]DevExpress.XtraScheduler.Reporting
  [Expand]DevExpress.XtraScheduler.Reporting.UI
  [Expand]DevExpress.XtraScheduler.Services
  [Expand]DevExpress.XtraScheduler.Services.Implementation
  [Expand]DevExpress.XtraScheduler.UI
  [Expand]DevExpress.XtraSpellChecker
  [Expand]DevExpress.XtraSpellChecker.Localization
  [Expand]DevExpress.XtraSplashForm
  [Expand]DevExpress.XtraSplashScreen
  [Expand]DevExpress.XtraSpreadsheet
  [Expand]DevExpress.XtraSpreadsheet.Services
  [Expand]DevExpress.XtraTab
  [Expand]DevExpress.XtraTab.Buttons
  [Expand]DevExpress.XtraTab.ViewInfo
  [Expand]DevExpress.XtraTabbedMdi
  [Expand]DevExpress.XtraToolbox
  [Expand]DevExpress.XtraTreeList
  [Expand]DevExpress.XtraTreeList.Columns
  [Expand]DevExpress.XtraTreeList.Data
  [Expand]DevExpress.XtraTreeList.Localization
  [Expand]DevExpress.XtraTreeList.Menu
  [Expand]DevExpress.XtraTreeList.Nodes
  [Expand]DevExpress.XtraTreeList.Nodes.Operations
  [Expand]DevExpress.XtraTreeList.StyleFormatConditions
  [Expand]DevExpress.XtraTreeMap
  [Expand]DevExpress.XtraTreeMap.Printing
  [Expand]DevExpress.XtraVerticalGrid
  [Expand]DevExpress.XtraVerticalGrid.Events
  [Expand]DevExpress.XtraVerticalGrid.Localization
  [Expand]DevExpress.XtraVerticalGrid.Rows
  [Expand]DevExpress.XtraWaitForm
  [Expand]DevExpress.XtraWizard
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[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
WinForms Controls > DevExpress.XtraPivotGrid > PivotGridOptionsBehavior
View this topic on docs.devexpress.com (Learn more)

PivotGridOptionsBehavior Properties

Provides behavior options for the control.

Expanded Public Properties

Show: Inherited
  Name Description
Public property ApplyBestFitOnFieldDragging Gets or sets whether the Best-Fit feature is automatically applied to a field after it has been dragged and dropped at another location.
Public property BestFitConsiderCustomAppearance Gets or sets whether custom appearance settings should be taken into account when calculating minimum column width for Best Fit.
Public property BestFitMode Gets or sets which visual elements are taken into account when calculating the optimal width for columns. (Inherited from PivotGridOptionsBehaviorBase)
Public property ClipboardCopyCollapsedValuesMode Gets or sets how to copy collapsed field values to the Clipboard. (Inherited from PivotGridOptionsBehaviorBase)
Public property ClipboardCopyMultiSelectionMode Gets or sets how to copy cells to the Clipboard when multiple cells are selected. (Inherited from PivotGridOptionsBehaviorBase)
Public property CopyToClipboardWithFieldValues Gets or sets whether field values are copied to the Clipboard when CTRL+C is pressed or the PivotGridCells.CopySelectionToClipboard method is called. (Inherited from PivotGridOptionsBehaviorBase)
Public property EditorShowMode Gets or sets how in-place editors are activated.
Public property ExpressionEditorMode Gets or sets the type of editor that end-users can invoke to modify expressions for Unbound Fields.
Public property HorizontalScrolling Gets or sets a value which specifies the Pivot Grid Control's behavior when it is scrolled horizontally.
Public property LoadingPanelDelay Gets or sets the delay between starting an asynchronous operation and displaying the loading panel. (Inherited from PivotGridOptionsBehaviorBase)
Public property RepaintGridOnFocusedCellChanged Gets or sets whether the grid control is repainted when focus is moved from one cell to another.
Public property SortBySummaryDefaultOrder Gets or sets the sort order applied to a field when sorting by summaries is enabled for it. (Inherited from PivotGridOptionsBehaviorBase)
Public property UseAsyncMode Gets or sets whether data-aware operations caused by end-user actions are performed asynchronously. (Inherited from PivotGridOptionsBehaviorBase)
Top

Expanded See Also

PivotGridOptionsBehavior Class
PivotGridOptionsBehavior Members
DevExpress.XtraPivotGrid Namespace
Is this topic helpful?​​​​​​​
Copyright (c) 1998-2019 Developer Express Inc. All rights reserved.