Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Layout > Data Cell Layout
All docs
V24.2
WinForms Controls
.NET Support and Migration
Prerequisites
What's New
What's Installed
Build an Application
Redistribution and Deployment
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Asynchronous Mode
Data Shaping
Data Analysis
Layout
Field Location and Order
Data Cell Layout
Field Value Layout
Field Groups
Expand and Collapse Fields
Customization Form
Best Fit
Save and Restore Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Icon and Image Library
AI-powered Extensions
Common Features
Security Considerations
Data Access Security
Hybrid & Enterprise Development
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

Data Cell Layout

  • 2 minutes to read

The data header allows you to customize the location and orientation of data field headers and the location of data cells.

Data Header Overview

When the Pivot Grid contains two or more data fields, data field headers are displayed to distinguish between different summary values - data cells are located one after another as shown in the image below.

cdDataCellLayout1

The data header allows you to control the location and orientation of data field headers and therefore, the location of data cells. This header is linked with data field headers. The image below shows the data header located within the Row Header Area.

cdDataCellLayout2

Customize the Data Header

Like other field headers, users can drag and drop data headers to customize the layout of data field headers.

For example, users can position data field headers along the left inner edge…

cdDataCellLayout3

…or the top outer edge of the PivotGridControl.

cdDataCellLayout4

Customizing the Data Header in Code

The PivotGridControl.OptionsDataField property allows you to access options that control the content, size, and availability of the data header. These options are listed and described in the table below.

Property

Description

PivotGridOptionsDataField.Area

Determines the area in which the data field headers are displayed when there are two or more data fields.

Setting this property to PivotDataArea.ColumnArea or PivotDataArea.RowArea enables the Data Header. It can be dragged to a specific position within the column header area or row header area and as a result the data field headers will be moved to the associated location.

PivotGridOptionsDataField.AreaIndex

Specifies the position of the data field headers within the hierarchy of field values.

PivotGridOptionsDataField.Caption

Specifies the text displayed within the Data Header.

PivotGridOptionsDataField.RowHeaderWidth

Specifies the width of the data field headers when they are displayed as row headers.

PivotGridOptionsDataField.RowValueLineCount

Specifies the height of data field headers in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Row Header Area.

PivotGridOptionsDataField.ColumnValueLineCount

Specifies the height of data field headers, in text lines. This property is in effect when there are two or more data fields, and data field headers are displayed in the Column Header Area.

Demos

Refer to the following technical demos section for code examples on how to manage the Pivot Grid layout in code:

Run Demo: Code Examples — Layout