...
Wiki Markup |
---|
{introducedin: 8.4 |
...
Description |
---|
Excerpt |
---|
The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source. |
Signature | |||
---|---|---|---|
C# | C# | }
{description}
{excerpt}The ItemsToRetain class represents the number of items a PivotTable cache will retain even changes have been made to the data source.{excerpt}
{signature:C#}
public sealed class ItemsToRetain
| |
Signature | |||
{signature}{signature:vb.net | vb.net | }
Public NotInheritable Class ItemsToRetain
| |
Example | |||
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vbnet | vbnet | title |
Fields |
---|
...
Name
...
Description
...
...
...
Properties |
---|
...
Name
...
Description
...
...
...
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.{code}
{example}
{fields}
|| Name || Description ||
| [Automatic|ItemsToRetain.Automatic] | {excerpt-include:ItemsToRetain.Automatic|nopanel=true} |
| [None|ItemsToRetain.None] | {excerpt-include:ItemsToRetain.None|nopanel=true} |
{properties}
|| Name || Description ||
| [Max|ItemsToRetain.Max] | {excerpt-include:ItemsToRetain.Max|nopanel=true} |
| [Value|ItemsToRetain.Value] | {excerpt-include:ItemsToRetain.Value|nopanel=true} |
{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.
{remarks} |