OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools
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 11 Next »

Introduced in build 8.4

Description

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

C#
vb.net

Examples

C#
vb.net

Fields

Name

Description

Automatic

ItemsToRetain's value for automatic.

None

ItemsToRetain's value for none.

Properties

Name

Description

Max

Returns the maximum number of items the PivotTable's cache can support.

Value

Sets or Returns the current number of items the PivotTable's cache is set to retain.

Remarks

Setting PivotTableSettings.ItemsToRetain is the same as going to PivotTable Options > Data > Retain items deleted from the data source and setting Number of items to retain per field to Automatic, Max, None, or a different integer value.
  • No labels