CubeField.IncludeNewItemsInFilter Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write.

public:
 property bool IncludeNewItemsInFilter { bool get(); void set(bool value); };

public bool IncludeNewItemsInFilter { get; set; }

Public Property IncludeNewItemsInFilter As Boolean

Property Value

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.

Applies to