CubeField Properties (Excel)
.png "GitHub-Mark-64px") |
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Properties
Name |
Description |
|---|---|
The AllItemsVisible property checks whether manual filtering is applied to a PivotField or CubeField. Read-only Boolean. |
|
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
|
Returns a String value that represents the label text for the cube field. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Specifies the type of a CubeField. Read-only. |
|
Indicates whether the OLAP cube field is a hierarchy field or a measure field. Can be one of the XlCubeFieldType constants. |
|
Returns or sets the page name for a CubeField. Read/write String. |
|
True if the specified field can be dragged to the column position. The default value is True. Read/write Boolean. |
|
True if the specified field can be dragged to the data position. The default value is True. Read/write Boolean |
|
True if the field can be hidden by being dragged off the PivotTable report. The default value is True. Read/write Boolean. |
|
True if the field can be dragged to the page position. The default value is True. Read/write Boolean. |
|
True if the field can be dragged to the row position. The default value is True. Read/write Boolean. |
|
Set to True to allow multiple items in the page field area for OLAP PivotTables to be selected. The default value is False. Read/write Boolean. |
|
Returns or sets whether items from all levels of hierarchies in a named set cube field are displayed in the same field of a PivotTable report based on an OLAP cube. Read/write |
|
Returns True when there are member properties specified to be displayed for the cube field. Read-only Boolean. |
|
Returns or sets whether to order and remove duplicates when displaying the specified named set in a PivotTable report based on an OLAP cube. Read/write |
|
The IncludeNewItemsInFilter property is used to track included/excluded items in OLAP PivotTables. Read/write. |
|
Returns True if the CubeField is a date. Read-only Boolean. |
|
Returns or sets the way the specified PivotTable items appear—in table format or in outline format. Read/write XlLayoutFormType. |
|
Returns or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field. Read/write XlSubtototalLocationType. |
|
Returns a String value that represents the name of the object. |
|
Returns or sets a XlPivotFieldOrientation value that represents the location of the field in the specified PivotTable report. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns the PivotFields collection. This collection contains all PivotTable fields, including those that aren’t currently visible on-screen. Read-only PivotFields object. |
|
Returns or sets a Long value that represents the position of the hierarchy field on the PivotTable report when it’s dragged from the field well. |
|
When set to True (default), a CubeField object will be shown in the field list. Read/write Boolean. |
|
Returns the TreeviewControl object of the CubeField object, representing the cube manipulation control of an OLAP-based PivotTable report. Read-only. |
|
Returns a String value that represents the name of the specified field. |