IPivotSettings Properties

Properties

Name Description
AddNewColumns

Specifies whether columns deleted via the IPivotSettings.Settings property in the current Application Model layer, but existing in previous layers, should be retained in the Pivot Grid List Editor.

ChartDataVertical

Specifies whether chart series are created based on pivot table columns or rows.

ChartSettings

Specifies settings of the chart accompanying the pivot table.

CustomizationEnabled

Indicates whether end-users can customize pivot table settings in Windows Forms applications, via the context menu's Invoke Wizard and Clear Settings Actions.

LayoutSettings

Specifies layout settings.

RemoveOldColumns

Specifies whether columns defined via the IPivotSettings.Settings property in previous Application Model layers, not defined in the current layer, should be available in the Pivot Grid List Editor.

Settings

Provides access to the settings of the pivot grid List Editor used by a List View, editable via the Pivot Grid Property Editor.

ShowChart

Specifies whether the chart accompanying the pivot table is displayed.

ShowColumnGrandTotals

Specifies whether column grand totals are displayed in the chart accompanying the pivot table.

ShowColumnTotals

Specifies whether column totals are displayed in the chart accompanying the pivot table.

ShowRowGrandTotals

Specifies whether row grand totals are displayed in the chart accompanying the pivot table.

ShowRowTotals

Specifies whether row totals are displayed in the chart accompanying the pivot table.