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

PivotBehaviorOptions.EnableGridDropZones Property

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

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool EnableGridDropZones { get; set; }

#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.

Classic PivotTable layout

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.

See Also