Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotField.Layout Property

Provides access to settings used to adjust the layout of the PivotField object.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

PivotFieldLayout Layout { get; }

#Property Value

Type Description
PivotFieldLayout

A PivotFieldLayout object containing layout settings for a pivot field.

#Remarks

Use the Layout property to get access to the PivotFieldLayout object, which allows you to adjust the layout of the row and column fields in the PivotTable report. In particular, you can show an outer row field in outline, compact or tabular form (PivotFieldLayout.Outline, PivotFieldLayout.Compact), insert a blank line after each item of an outer row field (PivotFieldLayout.InsertBlankRowAfterEachItem), specify the subtotal location for an outer row field (PivotFieldLayout.SubtotalOnTop), repeat item labels for an outer row or column field (PivotFieldLayout.RepeatItemLabels), or display items that have no data in the report (PivotFieldLayout.ShowItemsWithNoData).

See Also