officefileapi-devexpress-dot-spreadsheet-dot-pivotviewoptions-dot-underscore-members.md
Contains display settings for a pivot table.
| Name | Description |
|---|---|
| AltTextDescription | Gets or sets the alternative description of the information in a PivotTable report. |
| AltTextTitle | Gets or sets the alternative text for a PivotTable report. |
| ColumnHeaderCaption | Gets or sets the text to be displayed in the column header of a pivot table shown in compact form. |
| DataCaption | Gets or sets the caption for a virtual field named Data (Values in the UI) which appears in a pivot table containing two or more data fields. |
| ErrorCaption | Gets or sets the text to be displayed in cells that contain errors. |
| GrandTotalCaption | Gets or sets the text to be displayed in grand totals for rows and columns in a pivot table. |
| MissingCaption | Gets or sets the text to be displayed in cells with no values. |
| RowHeaderCaption | Gets or sets the text to be displayed in the row header of a pivot table shown in compact form. |
| ShowDrillIndicators | Gets or sets a value indicating whether the expand/collapse buttons should be displayed in a pivot table. |
| ShowError | Gets or sets a value indicating whether to show custom error messages in cells. |
| ShowFieldHeaders | Gets or sets a value indicating whether to display the row and column field captions and filter drop-down arrows in a pivot table. |
| ShowMissing | Gets or sets a value indicating whether to display a custom string in cells that contain no values. |
| ShowMultipleLabels | Gets or sets a value indicating whether to display the “(Multiple Items)” string in the report filter area when multiple items, but not all, are selected in a page field. |
| ShowValuesRow | Gets or sets a value indicating whether to display the Values row that may appear when there are multiple fields in the PivotTable data area. |
See Also