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

PivotTable.ShowRowHeaders Property

Gets or sets a value indicating whether to apply the style formatting to row headers.

Namespace: DevExpress.Spreadsheet

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

Declaration

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

Property Value

Type Description
Boolean

true, to format row headers; otherwise, false.

Remarks

Set the ShowRowHeaders property to true to apply formatting to the rows containing item labels for the outer row fields. These rows are highlighted in the following image.

Spreadsheet_PivotTable_ShowRowHeaders

The appearance of row headers is specified by the TableStyleElementType.FirstRowSubheading, TableStyleElementType.SecondRowSubheading and TableStyleElementType.ThirdRowSubheading elements of the table style applied to the pivot table.

Examples

Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Add the "Region" field to the column axis area. 
pivotTable.ColumnFields.Add(pivotTable.Fields("Region"))
' Remove formatting from row headers.
pivotTable.ShowRowHeaders = False
See Also