.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotLayout.IndentInCompactForm Property

Gets or sets the indent increment for items from different row fields when a pivot table is shown in compact form.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v20.1.Core.dll

Declaration

int IndentInCompactForm { get; set; }
Property IndentInCompactForm As Integer

Property Value

Type Description
Int32

An integer value that specifies the amount by which items from different row fields are indented.

This value must be between 0 and 127. Otherwise, a ArgumentOutOfRangeException will be thrown.

Remarks

When a pivot table is shown in compact form, items from different row fields are displayed in a single column and subsidiary row field items are shown indented from the left (see the image below). The default indent value is 1 character. To change the indent value, use the IndentInCompactForm property.

SpreadsheetPivotTable_CompactReportLayout

See Also