PivotBehaviorOptions.EnableGridDropZones Property

Specifies whether to display in-grid drop zones for a pivot table.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

bool EnableGridDropZones { get; set; }

VB.NET

Property EnableGridDropZones As Boolean

Property Value

Type	Description
Boolean	true to enable in-grid drop zones; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to EnableGridDropZones
PivotTable	.Behavior .EnableGridDropZones

Remarks

Set the EnableGridDropZones property to true to enable the classic PivotTable layout that was used in Microsoft® Excel® 2003.

The EnableGridDropZones property does not affect the layout of a pivot table when the document is displayed in the Spreadsheet control. However, the property value is saved to the workbook, so that you can view the document in Microsoft® Excel® or another spreadsheet application.