CubeField.IncludeNewItemsInFilter Property
The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property IncludeNewItemsInFilter As Boolean
Get
Set
'Usage
Dim instance As CubeField
Dim value As Boolean
value = instance.IncludeNewItemsInFilter
instance.IncludeNewItemsInFilter = value
bool IncludeNewItemsInFilter { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
Default value is False.
When this setting is set to True, excluded items are tracked when manual filtering is applied. When this setting is set to False, included items are tracked when manual filtering is applied.
When IncludeNewItemsInFilter is set to False, the HiddenItemsList and HiddenItems collections are empty and items cannot be added to them.
When IncludeNewItemsInFilter is set to True, the VisibleItemsList and VisibleItems collections are empty and items cannot be added to them.