Skip to main content
A newer version of this page is available. .

PivotGridOptionsDataField.Area Property

Gets or sets the area in which the data field headers are displayed.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v19.1.Core.dll

Declaration

[DefaultValue(PivotDataArea.None)]
[XtraSerializableProperty]
public PivotDataArea Area { get; set; }

Property Value

Type Default Description
PivotDataArea **None**

A PivotDataArea value that specifies the area in which the data field headers are displayed.

Available values:

Name Description
None

The data field headers are displayed as column headers. The data header is hidden.

ColumnArea

The data field headers are displayed as column headers. The data header is displayed within the column header area.

RowArea

The data field headers are displayed as row headers. The data header is displayed within the row header area.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to Area
WinForms Controls PivotGridControl
Reporting XRPivotGrid
ASP.NET Web Forms Controls ASPxPivotGrid
MVCxPivotGrid
PivotGridSettings

Remarks

The Area property determines the area in which the data field headers are displayed when there are two or more data fields. This property also enables the data header which allows end-users to move data field headers between and within the column header area and row header area.

By default, the data field headers are displayed as column headers:

OptionsDataField_LocationIndex-1

If the Area property is set to PivotDataArea.ColumnArea the data field headers are still displayed as column headers. In addition, the data header is enabled and displayed within the column header area. The data header is a header which is linked with the data field headers. 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 an appropriate location.

OptionsDataField_LocationIndex-1_DataHeader

If the Area property is set to PivotDataArea.RowArea the data header will be moved to the row header area and the data field headers will be displayed as row headers:

OptionsDataField_LocationIndex-1_DataHeader_Row

The following code snippets (auto-collected from DevExpress Examples) contain references to the Area property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also