1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104875"><META NAME="lcid" CONTENT="1033"><title>PLPivotField element</title><link rel="stylesheet" type="text/css" href="office10.css"><script type="text/javascript" language="Javascript" src="ExpCollapse.js"></script><script type="text/javascript" language="JavaScript" src="inline.js"></script></head><body><h1>PLPivotField element</h1><p>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</p><h2>Usage</h2><pre>
<code>
<PLPivotField
Style="xsd:string"
Style="xsd:string"
/>
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td><a href="xtcoPLPivotFieldType_HV01105120.htm" id="HV01105120" lcid="">PLPivotFieldType</a></td>
</tr>
<tr>
<td>
<b class="bterm">Namespace</b>
</td>
<td>urn:schemas-microsoft-com:office:excel</td>
</tr>
<tr>
<td>
<b class="bterm">Schema name</b>
</td>
<td>XML Spreadsheet 2000</td>
</tr>
</table><h2>Elements and Attributes</h2><h3>Parent Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xelePivotTable_HV01104867.htm" id="HV01104867" lcid="">PivotTable</a></td>
<td>Contains information about a PivotTable view.</td>
</tr>
</table><h3>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xeleName_PLPivotFieldType_HV01104763.htm" id="HV01104763" lcid="">Name</a></td>
<td>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.</td>
</tr>
<tr>
<td><a href="xeleSourceName_PLPivotFieldType_HV01104993.htm" id="HV01104993" lcid="">SourceName</a></td>
<td>Contains the name of a field or item as it appears in a PivotTable cache.</td>
</tr>
<tr>
<td><a href="xeleBoundField_HV01104444.htm" id="HV01104444" lcid="">BoundField</a></td>
<td>Specifies whether the PivotTable field is the bound field of an automatic date field set.</td>
</tr>
<tr>
<td><a href="xeleDataType_PLPivotFieldType_HV01104517.htm" id="HV01104517" lcid="">DataType</a></td>
<td>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.</td>
</tr>
<tr>
<td><a href="xeleFilterCaption_PLPivotFieldType_HV01104611.htm" id="HV01104611" lcid="">FilterCaption</a></td>
<td>Contains the caption of a field set when the field set is the current filter.</td>
</tr>
<tr>
<td><a href="xelePLDataOrientation_PLPivotFieldType_HV01104871.htm" id="HV01104871" lcid="">PLDataOrientation</a></td>
<td>Specifies whether a field is on the detail grid.</td>
</tr>
<tr>
<td><a href="xelePLPosition_PLPivotFieldType_HV01104877.htm" id="HV01104877" lcid="">PLPosition</a></td>
<td>Specifies the position of a field in the detail grid.</td>
</tr>
<tr>
<td><a href="xeleOrientation_PLPivotFieldType_HV01104827.htm" id="HV01104827" lcid="">Orientation</a></td>
<td>Specifies whether the field is to be used for row headers, column headers, page area, as data, or is hidden.</td>
</tr>
<tr>
<td><a href="xelePosition_PLPivotFieldType_HV01104883.htm" id="HV01104883" lcid="">Position</a></td>
<td>Specifies the position of a PivotField when multiple fields are used.</td>
</tr>
<tr>
<td><a href="xeleShowAllItems_PLPivotFieldType_HV01104967.htm" id="HV01104967" lcid="">ShowAllItems</a></td>
<td>Contains a Boolean value indicating whether all PivotItems should be shown even if they have no data.</td>
</tr>
<tr>
<td><a href="xeleNumberFormat_PLPivotFieldType_HV01104818.htm" id="HV01104818" lcid="">NumberFormat</a></td>
<td>Specifies the display formatting to use when displaying the PivotItem or aggregate value.</td>
</tr>
<tr>
<td><a href="xeleCurrentPage_PLPivotFieldType_HV01104507.htm" id="HV01104507" lcid="">CurrentPage</a></td>
<td>Specifies the name of the PivotItem selected for a PivotField when the PivotField is in the page area.</td>
</tr>
<tr>
<td><a href="xeleCaption_PLPivotFieldType_HV01104462.htm" id="HV01104462" lcid="">Caption</a></td>
<td>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.</td>
</tr>
<tr>
<td><a href="xeleNewItemsHidden_PLPivotFieldType_HV01104771.htm" id="HV01104771" lcid="">NewItemsHidden</a></td>
<td>Contains a Boolean indicating whether new items from a refresh operation will be hidden by default in the PivotTable report or displayed.</td>
</tr>
<tr>
<td><a href="xeleSubtotal_PLPivotFieldType_HV01105005.htm" id="HV01105005" lcid="">Subtotal</a></td>
<td>Contains an enumeration indicating a type of subtotal to show for the PivotField. This element can appear multiple times specifying different subtotal types.</td>
</tr>
<tr>
<td><a href="xelePLSubtotal_PLPivotFieldType_HV01104879.htm" id="HV01104879" lcid="">PLSubtotal</a></td>
<td>Contains the subtotal to display when a PivotTable field is not on the column or row axis.</td>
</tr>
<tr>
<td><a href="xeleDetailFormat_PLPivotFieldType_HV01104531.htm" id="HV01104531" lcid="">DetailFormat</a></td>
<td>Specifies the text formatting that is applied to a field when it is on the detail grid.</td>
</tr>
<tr>
<td><a href="xeleSubtotalFormat_PLPivotFieldType_HV01105007.htm" id="HV01105007" lcid="">SubtotalFormat</a></td>
<td>Specifies the text formatting that is applied to a subtotal.</td>
</tr>
<tr>
<td><a href="xeleDetailWidth_PLPivotFieldType_HV01104538.htm" id="HV01104538" lcid="">DetailWidth</a></td>
<td>Specifies the width of a field (in pixels) when it appears on the detail axis.</td>
</tr>
<tr>
<td><a href="xeleGroupedWidth_PLPivotFieldType_HV01104649.htm" id="HV01104649" lcid="">GroupedWidth</a></td>
<td>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.</td>
</tr>
<tr>
<td><a href="xeleExpanded_PLPivotFieldType_HV01104596.htm" id="HV01104596" lcid="">Expanded</a></td>
<td>Specifies whether the field members are expanded by default, or whether a leaf member was expanded.</td>
</tr>
<tr>
<td><a href="xeleTotalWidth_PLPivotFieldType_HV01105032.htm" id="HV01105032" lcid="">TotalWidth</a></td>
<td>Specifies the width of a total and whether the width is automatically set.</td>
</tr>
<tr>
<td><a href="xelePivotItem_PLPivotFieldType_HV01104866.htm" id="HV01104866" lcid="">PivotItem</a></td>
<td>Contains information on an item (PivotItem) in the PivotField.</td>
</tr>
</table><h3>Attributes</h3><table>
<tr>
<th>Attribute</th>
<th>Type</th>
<th>Required</th>
<th>Description</th>
<th>Possible Values</th>
</tr>
<tr>
<td>Style</td>
<td>xsd:string</td>
<td>required</td>
<td>Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a field.</td>
<td>See external namespace.</td>
</tr>
<tr>
<td>Style</td>
<td>xsd:string</td>
<td>required</td>
<td>Specifies a text string containing attributes that describe the font weight, style, and effects that are applied to a subtotal.</td>
<td>See external namespace.</td>
</tr>
</table><h2>Definition</h2><pre>
<code>
<xsd:element name="PLPivotField" type="PLPivotFieldType" minOccurs="0" maxOccurs="unbounded" >
</xsd:element>
</code>
</pre><center><a href="XMLSchemaCopyright_HV01147162.htm">©2003-2004 Microsoft Corporation. All rights reserved.</a>
Permission to copy, display and distribute this document is available at: <a
href="http://r.office.microsoft.com/r/rlidAWSContentRedir?AssetID=XT010988631033&CTT=11&Origin=HV011232471033"
target="_new">http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp</a></center></body></html>
|
