CubeField.AllItemsVisible Property
The AllItemsVisible property checks whether manual filtering is applied to a PivotField or CubeField. Read-only Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property AllItemsVisible As Boolean
Get
'Usage
Dim instance As CubeField
Dim value As Boolean
value = instance.AllItemsVisible
bool AllItemsVisible { get; }
Property Value
Type: System.Boolean
Boolean
Remarks
Default value is True and is available for the PivotFieldand the CubeFieldobjects.
For OLAP PivotTables, this property is only available for the CubeField object. Trying to get or set it on the PivotField object in OLAP PivotTables will return a run-time error.
For PivotTables, this property is available for the PivotField object.
This property is automatically set to True when no manual filtering is applied (independent of whether the IncludeNewItemsInFilter property is true or false). It is automatically set to False when any manual filtering is applied (independent of whether the IncludeNewItemsInFilter property is true or false).