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

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.v24.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

#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