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

DocumentSettings.ShowPivotTableFieldList Property

Gets or sets a value indicating whether the PivotTable Field List should be displayed for pivot tables in the workbook.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

bool ShowPivotTableFieldList { get; set; }

#Property Value

Type Description
Boolean

true, to show the Field List for pivot tables contained in the workbook; otherwise, false.

#Property Paths

You can access this nested property as listed below:

Object Type Path to ShowPivotTableFieldList
IWorkbook
.DocumentSettings .ShowPivotTableFieldList
Workbook
.DocumentSettings .ShowPivotTableFieldList

#Remarks

By default, the ShowPivotTableFieldList property is true and the Field List is invoked automatically when an end-user clicks any cell in the PivotTable report. If the ShowPivotTableFieldList property is set to false, the Field List doesn’t appear automatically and can be displayed only by using the corresponding commands in the application’s UI.

To prevent the Field List from being displayed for a specific pivot table in the document, use the PivotBehaviorOptions.EnableFieldList property.

See Also