Skip to main content
Row

PivotLayout.RepeatAllItemLabels(Boolean) Method

Specifies whether to repeat item labels for all outer row and column fields in a pivot table.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

void RepeatAllItemLabels(
    bool repeat
)

Parameters

Name Type Description
repeat Boolean

true, to repeat item labels in the outer fields; otherwise, false.

Remarks

If your PivotTable report contains multiple fields in the row or column area, you can specify how to display item labels in the outer row and column fields. By default, items of the outermost column and row fields are displayed only once, while items in the remaining column and row fields are repeated as needed. If you wish to repeat item labels in all outer row and column fields, call the RepeatAllItemLabels method.

Do Not Repeat Item Labels

(the default option)

Repeat All Item Labels

SpreadsheetPivotTable_DoNotRepeatItemLabels

SpreadsheetPivotTable_RepeatAllItemLabels

To repeat item labels in a particular field, use the field’s PivotFieldLayout.RepeatItemLabels property.

Note

Repeated labels for the outer row fields are displayed only when a pivot table is shown in outline or tabular form. To change the report layout, use the PivotLayout.SetReportLayout method.

Example

View Example

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

' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Display repeated column labels.
pivotTable.Layout.RepeatAllItemLabels(True)

The following code snippets (auto-collected from DevExpress Examples) contain references to the RepeatAllItemLabels(Boolean) 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.

See Also