OfficeWriter Documentation
.
ExcelWriter v8 Docs
Space Shortcuts
Page tree
ConfigureSpace tools

Versions Compared

Old Version 8

changes.mady.by.user Alison Bird [softartisans]

Saved on

compared with

New Version 9

changes.mady.by.user Alison Bird [softartisans]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Name

Description

Max

Excerpt Include
EW8:ItemsToRetain.Max
EW8:ItemsToRetain.Max
nopaneltrue

Value

Excerpt Include
EW8:ItemsToRetain.Value
EW8:ItemsToRetain.Value
nopaneltrue
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.