Back to Devexpress

DocumentSettings.ShowPivotTableFieldList Property

officefileapi-devexpress-dot-spreadsheet-dot-documentsettings-b8e24490.md

latest2.5 KB
Original Source

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.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

csharp
bool ShowPivotTableFieldList { get; set; }
vb
Property ShowPivotTableFieldList As Boolean

Property Value

TypeDescription
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 TypePath 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

EnableFieldList

DocumentSettings Interface

DocumentSettings Members

DevExpress.Spreadsheet Namespace