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

PivotLocation.Range Property

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

Namespace: DevExpress.Spreadsheet

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


CellRange Range { get; }

Property Value

Type Description

A CellRange object that specifies a cell range occupied by the pivot table disregarding the page fields.


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


To get a cell range that contains the entire pivot table including the page area, use the PivotLocation.WholeRange 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