PLPivotField element

This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.

Usage

      
<PLPivotField
	Style="xsd:string"
	Style="xsd:string"
/>

Element Information

Element type	PLPivotFieldType
Namespace	urn:schemas-microsoft-com:office:excel
Schema name	XML Spreadsheet 2000

Elements and Attributes

Parent Elements

Element	Description
PivotTable	Contains information about a PivotTable view.

Child Elements

Element	Description
Name	Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.
SourceName	Contains the name of a field or item as it appears in a PivotTable cache.
BoundField	Specifies whether the PivotTable field is the bound field of an automatic date field set.
DataType	Specifies either the data type of a column in a PivotTable cache, or the data type of a PivotTable field for non-OLAP data sources.
FilterCaption	Contains the caption of a field set when the field set is the current filter.
PLDataOrientation	Specifies whether a field is on the detail grid.
PLPosition	Specifies the position of a field in the detail grid.
Orientation	Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden.
Position	Specifies the position of a PivotField when multiple fields are used.
ShowAllItems	Contains a Boolean value indicating whether all PivotItems should be shown even if they have no data.
NumberFormat	Specifies the display formatting to use when displaying the PivotItem or aggregate value.
CurrentPage	Specifies the name of the PivotItem selected for a PivotField when the PivotField is in the page area.
Caption	Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name.
NewItemsHidden	Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed.
Subtotal	Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.
PLSubtotal	Contains the subtotal to display when a PivotTable field is not on the column or row axis.
DetailFormat	Specifies the text formatting that is applied to a field when it is on the detail grid.
SubtotalFormat	Specifies the text formatting that is applied to a subtotal.
DetailWidth	Specifies the width of a field (in pixels) when it appears on the detail axis.
GroupedWidth	Specifies the width of a field (in pixels) when on the grouping axis, and whether the column width of a field is set automatically when the field is used on the row or column axis.
Expanded	Specifies whether the field members are expanded by default, or whether a leaf member was expanded.
TotalWidth	Specifies the width of a total and whether the width is automatically set.
PivotItem	Contains information on an item (PivotItem) in the PivotField.

Attributes

Attribute	Type	Required	Description	Possible Values
Style	xsd:string	required	Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field.	See external namespace.
Style	xsd:string	required	Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal.	See external namespace.

Definition

      
<xsd:element name="PLPivotField" type="PLPivotFieldType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>

©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp