PivotField.AllItemsVisible 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.

Retrieves a value that indicates whether or not any manual filtering is applied to the Microsoft.Office.Interop.Excel.Pivotfield. Read-only.

public:
 property bool AllItemsVisible { bool get(); };

public bool AllItemsVisible { get; }

Public ReadOnly Property AllItemsVisible As Boolean

Property Value

Boolean

Boolean

Remarks

This property provides a simple way to easily check whether manual filtering is applied to a PivotField or CubeField.

For OLAP PivotTables, this property is available only for the CubeField object. Trying to get or set it on the PivotField object in an OLAP PivotTable will return a run-time error.

For PivotTables, this property is available for the PivotField object.

The default value is True. 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).

This property directly reflects the state of the Select All check box in the filter drop-down list for the PivotField or CubeField.

Applies to