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

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

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

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