Page tree
Skip to end of metadata
Go to start of metadata

Introduced in build 8.4

Description

The PivotTableSettings class contains the set of properties specific to pivot tables. To get a PivotTableSettings object, use PivotTable.PivotTableSettings.

C#
vb.net

Properties

Name

Description

ClassicLayout

Sets or returns whether the PivotTable will display in classic layout mode

ValuesLabelOnRow

Sets or returns whether the values labels field should be placed as a Row Label or Column Label

EmptyValueCaption

Sets or returns the caption displayed in place of a empty cell.

FriendlyErrorCaption

Sets or returns the caption displayed in place of an error.

ItemsToRetain

The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.

RefreshOnOpen

Sets or returns whether Microsoft Excel will automatically refresh a PivotTable and the PivotTable cache when Excel opens the document.

ShowEmptyValueCaption

Sets or returns whether Microsoft Excel will automatically show a caption in place of a empty cell.

ShowFriendlyErrorCaption

Sets or returns whether Microsoft Excel will automatically show a caption in place of an error.
  • No labels