Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotLayout.PageWrap Property

Gets or sets the number of page fields to display before starting another column or row based on the PivotLayout.PageOrder property value.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

int PageWrap { get; set; }

#Property Value

Type Description
Int32

An integer value that specifies the number of page fields per column or row.

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

#Remarks

By default, when you add multiple fields to the report filter area, they are displayed in one column, one field below the other.

SpreadsheetPivotTable_OrganizePageFieldsInOneColumn

However, you can use the PivotLayout.PageOrder and PageWrap properties to rearrange page fields in the report.

  • To display page fields in multiple columns, set the PivotLayout.PageOrder property to PivotPageOrder.DownThenOver and then use the PageWrap property to specify the number of page fields to display in one column before the next column starts. The example below demonstrates how to organize six page fields in columns by three fields in each column.

    pivotTable.Layout.PageOrder = PivotPageOrder.DownThenOver;
    pivotTable.Layout.PageWrap = 3;
    

    SpreadsheetPivotTable_OrganizePageFieldsInColumns

  • To display page fields in multiple rows, set the PivotLayout.PageOrder property to PivotPageOrder.OverThenDown and then use the PageWrap property to specify the number of page fields to display in one row before the next row starts. The example below demonstrates how to organize six page fields in rows by three fields in each row.

    pivotTable.Layout.PageOrder = PivotPageOrder.OverThenDown;
    pivotTable.Layout.PageWrap = 3;
    

    SpreadsheetPivotTable_OrganizePageFieldsInRows

See Also