PivotGridControl.GetFieldByArea(PivotArea, Int32) Method

Returns a field at the specified visual position in the specified area.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v19.2.dll

Declaration

C#

public PivotGridField GetFieldByArea(
    PivotArea area,
    int areaIndex
)

VB.NET

Public Function GetFieldByArea(
    area As PivotArea,
    areaIndex As Integer
) As PivotGridField

Parameters

Name	Type	Description
area	PivotArea	A PivotArea value that identifies the area containing the required field.
areaIndex	Int32	An integer value that specifies the visible index of the field within the specified area.

Returns

Type	Description
PivotGridField	A PivotGridField object at the specified visual position within the specified area.

Remarks

Hidden fields cannot be addressed by the GetFieldByArea method.

To return the list of fields in a specific area, use the PivotGridControl.GetFieldsByArea method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the GetFieldByArea(PivotArea, Int32) method.

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.

C#

how-to-reorder-pivotgrid-rows-and-columns-by-drag-and-drop-e4545/CS/ReorderHelper.cs#L301

{
    object field1GroupValue = dragInfo.GetFieldValue(targetPivot.GetFieldByArea(dragInfo.Field.Area, i), dragInfo.MinIndex);
    object field2GroupValue = targetInfo.GetFieldValue(targetPivot.GetFieldByArea(targetInfo.Field.Area, i), targetInfo.MinIndex);

how-to-show-the-tabular-data-below-the-chart-e1819/CS/Form1.cs#L67

private void AdjustPivotSize(PivotGridControl pivot) {
    PivotGridField columnField = pivot.GetFieldByArea(PivotArea.ColumnArea, 0);
    PivotGridField rowField = pivot.GetFieldByArea(PivotArea.RowArea, 0);

VB.NET

how-to-reorder-pivotgrid-rows-and-columns-by-drag-and-drop-e4545/VB/ReorderHelper.vb#L279

For i As Integer = 0 To minAreaIndex
    Dim field1GroupValue As Object = dragInfo.GetFieldValue(targetPivot_Renamed.GetFieldByArea(dragInfo.Field.Area, i), dragInfo.MinIndex)
    Dim field2GroupValue As Object = targetInfo.GetFieldValue(targetPivot_Renamed.GetFieldByArea(targetInfo.Field.Area, i), targetInfo.MinIndex)

how-to-show-the-tabular-data-below-the-chart-e1819/VB/Form1.vb#L68

Private Sub AdjustPivotSize(ByVal pivot As PivotGridControl)
    Dim columnField As PivotGridField = pivot.GetFieldByArea(PivotArea.ColumnArea, 0)
    Dim rowField As PivotGridField = pivot.GetFieldByArea(PivotArea.RowArea, 0)