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

PivotTable.BandedRows Property

Gets or sets a value indicating whether alternate shading should be applied to the pivot table rows.

Namespace: DevExpress.Spreadsheet

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

Declaration

bool BandedRows { get; set; }
Property BandedRows As Boolean

Property Value

Type Description
Boolean

true, to apply banded row formatting to the pivot table; otherwise, false.

Remarks

To apply banding to rows in a pivot table, set the BandedRows property to true.

To change the format of alternate row stripes, modify the TableStyleElementType.FirstRowStripe and TableStyleElementType.SecondRowStripe elements of the style applied to a pivot table. The TableStyleElement.StripeSize property of these table style elements allows you to specify the number of pivot table rows to be displayed as odd and even row stripes. You can also specify the borders (TableStyleElement.Borders), background color (TableStyleElement.Fill) and font (TableStyleElement.Font) of row stripes.

The images below demonstrate how the BandedRows property works.

BandedRows = false BandedRows = true
SpreadsheetPivotTable_BandedColumns_Disabled SpreadsheetPivotTable_BandedRows_Enabled
See Also