Skip to main content
All docs
V25.1
  • Row

    PivotBehaviorOptions.EnableGridDropZones Property

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

    Namespace: DevExpress.Spreadsheet

    Assembly: DevExpress.Spreadsheet.v25.1.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