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

PivotViewOptions.ShowDrillIndicators Property

Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool ShowDrillIndicators { get; set; }

#Property Value

Type Description
Boolean

true, to display drill indicators; otherwise, false.

#Property Paths

You can access this nested property as listed below:

Object Type Path to ShowDrillIndicators
PivotTable
.View .ShowDrillIndicators

#Remarks

The expand SpreadsheetControl_PlusOutlineSymbol and collapse SpreadsheetControl_MinusOutlineSymbol buttons are displayed in a multi-layered PivotTable report by default and allow end-users to expand or collapse items within the pivot table. However, you can hide these buttons by setting the ShowDrillIndicators property to false.

The images below demonstrate how the ShowDrillIndicators property works.

ShowDrillIndicators = true

(the default option)

ShowDrillIndicators = false

SpreadsheetPivotTable_DisplayExpandCollapseButtons

SpreadsheetPivotTable_HideExpandCollapseButtons

See Also