Back to Devexpress

PivotLayout Methods

officefileapi-devexpress-dot-spreadsheet-dot-pivotlayout-dot-underscore-methods.md

latest1.8 KB
Original Source

PivotLayout Methods

Contains various options used to adjust the layout of the PivotTable report.

NameDescription
HideAllSubtotals()Hides all subtotals in the PivotTable report.
InsertBlankRows()Inserts a blank row after each outer row field item in a pivot table.
RemoveBlankRows()Removes blank rows after items of the outer row fields in a pivot table.
RepeatAllItemLabels(Boolean)Specifies whether to repeat item labels for all outer row and column fields in a pivot table.
SetReportLayout(PivotReportLayout)Applies the specified report layout to a pivot table.
ShowAllSubtotals(Boolean)Displays all subtotals in the PivotTable report.

See Also

PivotLayout Interface

PivotLayout Members

DevExpress.Spreadsheet Namespace