Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migration of unmigrated content due to installation of a new plugin

...

Introducedin
8.4

...

8.4
Description

Excerpt

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

Signature
C#
C#
 public sealed class PivotTableSettings
{signature}{signature:
}
Signature
vb.net
vb.net
Public NotInheritable Class PivotTableSettings
{signature}
{properties}
|| Name || Description ||
| [ClassicLayout|PivotTableSettings.ClassicLayout] | {excerpt-include:PivotTableSettings.ClassicLayout|nopanel=true} |
| [ValuesLabelOnRow|PivotTableSettings.ValuesLabelOnRow] | {excerpt-include:PivotTableSettings.ValuesLabelOnRow|nopanel=true} |
| [EmptyValueCaption|PivotTableSettings.EmptyValueCaption] | {excerpt-include:PivotTableSettings.EmptyValueCaption|nopanel=true} |
| [FriendlyErrorCaption|PivotTableSettings.FriendlyErrorCaption] | {excerpt-include:PivotTableSettings.FriendlyErrorCaption|nopanel=true} |
| [ItemsToRetain|ItemsToRetain] | {excerpt-include:ItemsToRetain|nopanel=true} |
| [RefreshOnOpen|PivotTableSettings.RefreshOnOpen] | {excerpt-include:PivotTableSettings.RefreshOnOpen|nopanel=true} |
| [ShowEmptyValueCaption|PivotTableSettings.ShowEmptyValueCaption] | {excerpt-include:PivotTableSettings.ShowEmptyValueCaption|nopanel=true} |
| [ShowFriendlyErrorCaption|PivotTableSettings.ShowFriendlyErrorCaption] | {excerpt-include:PivotTableSettings.ShowFriendlyErrorCaption|nopanel=true} |
Properties

Name

Description

ClassicLayout

Excerpt Include
PivotTableSettings.ClassicLayout
PivotTableSettings.ClassicLayout
nopaneltrue

ValuesLabelOnRow

Excerpt Include
PivotTableSettings.ValuesLabelOnRow
PivotTableSettings.ValuesLabelOnRow
nopaneltrue

EmptyValueCaption

Excerpt Include
PivotTableSettings.EmptyValueCaption
PivotTableSettings.EmptyValueCaption
nopaneltrue

FriendlyErrorCaption

Excerpt Include
PivotTableSettings.FriendlyErrorCaption
PivotTableSettings.FriendlyErrorCaption
nopaneltrue

ItemsToRetain

Excerpt Include
ItemsToRetain
ItemsToRetain
nopaneltrue

RefreshOnOpen

Excerpt Include
PivotTableSettings.RefreshOnOpen
PivotTableSettings.RefreshOnOpen
nopaneltrue

ShowEmptyValueCaption

Excerpt Include
PivotTableSettings.ShowEmptyValueCaption
PivotTableSettings.ShowEmptyValueCaption
nopaneltrue

ShowFriendlyErrorCaption

Excerpt Include
PivotTableSettings.ShowFriendlyErrorCaption
PivotTableSettings.ShowFriendlyErrorCaption
nopaneltrue