officefileapi-devexpress-dot-spreadsheet-dot-documentsettings-b8e24490.md
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.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
bool ShowPivotTableFieldList { get; set; }
Property ShowPivotTableFieldList As Boolean
| Type | Description |
|---|---|
| Boolean |
true , to show the Field List for pivot tables contained in the workbook; otherwise, false.
|
You can access this nested property as listed below:
| Object Type | Path to ShowPivotTableFieldList |
|---|---|
| IWorkbook |
.DocumentSettings .ShowPivotTableFieldList
| | Workbook |
.DocumentSettings .ShowPivotTableFieldList
|
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