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

PivotTable.Location Property

Provides access to an object that contains information about the location of a pivot table and its regions.

Namespace: DevExpress.Spreadsheet

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

Declaration

PivotLocation Location { get; }

Property Value

Type Description
PivotLocation

A PivotLocation object containing location information for a PivotTable report.

Remarks

Use the Location property to access an object exposing the PivotLocation interface. Utilize properties of the returned object to obtain the cell range that contains the entire PivotTable report (PivotLocation.WholeRange or PivotLocation.Range) or its specific areas: the row area (PivotLocation.RowRange), column area (PivotLocation.ColumnRange), page area (PivotLocation.PageRange), or data area (PivotLocation.DataRange).

See Also