PivotLocation.PageRange Property

Gets the cell range that contains the page area of the PivotTable report.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

CellRange PageRange { get; }

ReadOnly Property PageRange As CellRange

Property Value

A CellRange object that is the contiguous or noncontiguous (union) range of cells occupied by the page fields.

|

Remarks

The page area is highlighted in the following image.

To get a cell range that contains the entire pivot table including the page area, use the PivotLocation.WholeRange property. To obtain the cell range occupied by the pivot table disregarding the page area, use the PivotLocation.Range property. The PivotLocation.DataRange property returns the cell range that contains the PivotTable’s summary values. The PivotLocation.ColumnRange and PivotLocation.RowRange properties return cell ranges containing the PivotTable’s column area and row area, respectively.

See Also

Pivot Table Structure

PivotLocation Interface

PivotLocation Members

DevExpress.Spreadsheet Namespace