[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Collapse]Focus and Navigation
     Focusing Cells and Scrolling
     Selecting Data Cells
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[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]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Focusing Cells and Scrolling

Pivot Grid provides properties that enable you to move focus to desired cells automatically, so that end-users do not need to navigate through cells themselves. A focused cell's contents can be copied to the Clipboard and pasted into other applications (e.g. MS Excel, MS Word).

This topic provides information on moving focus between cells at runtime and scrolling Pivot Grid Control contents in code.

Expanded Focusing Cells

The information on cells displayed by a Pivot Grid Control is returned by the PivotGridControl.Cells property. The returned object's PivotGridCells.FocusedCell property allows focused cells to be obtained. This property's value is represented by the System.Drawing.Point structure whose X and Y properties identify the column and row of a focused cell, respectively.

A focused cell is painted with a dotted rectangle around it if the PivotGridOptionsViewBase.DrawFocusedCellRect property is set to true. Appearance settings used to paint focused cells are specified by the PivotGridAppearances.FocusedCell property.

After a focused cell has been changed, the PivotGridControl.FocusedCellChanged event is raised.

Expanded Scrolling

To scroll Pivot Grid Control contents in code, use the PivotGridControl.LeftTopCoord property that specifies column and row indexes of a data cell displayed in the top left corner. The minimum scroll step is one column (when scrolling horizontally) and one row (when scrolling vertically).

Use the PivotGridOptionsBehavior.HorizontalScrolling property to specify how the PivotGrid control is scrolled horizontally (only the Data Area or the entire control).

Expanded See Also

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