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

PivotLocation.WholeRange Property

Gets the cell range that contains the entire PivotTable report including the page area.

Namespace: DevExpress.Spreadsheet

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

Declaration

CellRange WholeRange { get; }

Property Value

Type Description
CellRange

A CellRange object that specifies a noncontiguous (union) range of cells occupied by the PivotTable report along with the page area.

Remarks

The cell range that the WholeRange property returns for a sample pivot table is highlighted in the image below.

PivotLocation_WholeRange

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.RowRange, PivotLocation.ColumnRange and PivotLocation.PageRange properties return cell ranges containing the PivotTable’s row area, column area and page area, respectively.

See Also