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
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
|
<html dir="ltr"><head>
<META http-equiv="Content-Type" content="text/html; charset=UTF-8">
<META HTTP-EQUIV="assetid" CONTENT="HV01104591"><META NAME="lcid" CONTENT="1033"><title>ExcelWorkbook 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>ExcelWorkbook element</h1><p>Contains the properties of a workbook.</p><h2>Usage</h2><pre>
<code>
<ExcelWorkbook />
</code>
</pre><h2>Element Information</h2><table>
<tr>
<td>
<b class="bterm">Element type</b>
</td>
<td>Anonymous</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>Child Elements</h3><table>
<tr>
<th>Element</th>
<th>Description</th>
</tr>
<tr>
<td><a href="xelePublishObjects_HV01104904.htm" id="HV01104904" lcid="">PublishObjects</a></td>
<td>Contains information about all published items in a workbook.</td>
</tr>
<tr>
<td><a href="xeleSupBook_HV01105010.htm" id="HV01105010" lcid="">SupBook</a></td>
<td>Contains information about references and links to other workbooks and data sources.</td>
</tr>
<tr>
<td><a href="xeleSelectedSheets_HV01104952.htm" id="HV01104952" lcid="">SelectedSheets</a></td>
<td>Specifies the number of sheets selected in a workbook.</td>
</tr>
<tr>
<td><a href="xeleWindowHidden_HV01105078.htm" id="HV01105078" lcid="">WindowHidden</a></td>
<td>Specifies whether a workbook window is hidden.</td>
</tr>
<tr>
<td><a href="xeleHideHorizontalScrollBar_HV01104669.htm" id="HV01104669" lcid="">HideHorizontalScrollBar</a></td>
<td>Specifies whether the horizontal scroll bar in a workbook window is hidden.</td>
</tr>
<tr>
<td><a href="xeleHideVerticalScrollBar_HV01104672.htm" id="HV01104672" lcid="">HideVerticalScrollBar</a></td>
<td>Specifies whether the vertical scroll bar in a workbook window is hidden.</td>
</tr>
<tr>
<td><a href="xeleHideWorkbookTabs_HV01104673.htm" id="HV01104673" lcid="">HideWorkbookTabs</a></td>
<td>Specifies whether the worksheet tabs in a workbook window are hidden.</td>
</tr>
<tr>
<td><a href="xeleWindowHeight_HV01105077.htm" id="HV01105077" lcid="">WindowHeight</a></td>
<td>Contains a value specifying the height in points of a workbook window.</td>
</tr>
<tr>
<td><a href="xeleWindowWidth_HV01105082.htm" id="HV01105082" lcid="">WindowWidth</a></td>
<td>Contains a value in points that specifies the width of a workbook window.</td>
</tr>
<tr>
<td><a href="xeleWindowTopX_HV01105080.htm" id="HV01105080" lcid="">WindowTopX</a></td>
<td>Contains a value in points that specifies the horizontal position of a workbook window relative to the left border of the application window.</td>
</tr>
<tr>
<td><a href="xeleWindowTopY_HV01105081.htm" id="HV01105081" lcid="">WindowTopY</a></td>
<td>Contains a value in points that specifies the vertical position of a workbook window relative to the top border of the application window.</td>
</tr>
<tr>
<td><a href="xeleActiveSheet_HV01104391.htm" id="HV01104391" lcid="">ActiveSheet</a></td>
<td>Contains the index number of the active worksheet in a workbook.</td>
</tr>
<tr>
<td><a href="xeleActiveChart_HV01104385.htm" id="HV01104385" lcid="">ActiveChart</a></td>
<td>Contains the name of the active chart in a workbook.</td>
</tr>
<tr>
<td><a href="xeleFirstVisibleSheet_HV01104615.htm" id="HV01104615" lcid="">FirstVisibleSheet</a></td>
<td>Specifies that all worksheets before to the worksheet identified in this element are hidden and that no navigation tabs are shown for hidden sheets.</td>
</tr>
<tr>
<td><a href="xeleHidePivotTableFieldList_HV01104670.htm" id="HV01104670" lcid="">HidePivotTableFieldList</a></td>
<td>Prevents the PivotTable Field List dialog box from appearing when the user moves the input focus to the PivotTable view.</td>
</tr>
<tr>
<td><a href="xeleProtectStructure_HV01104892.htm" id="HV01104892" lcid="">ProtectStructure</a></td>
<td>Specifies whether the structure of a workbook is protected.</td>
</tr>
<tr>
<td><a href="xeleProtectWindows_HV01104893.htm" id="HV01104893" lcid="">ProtectWindows</a></td>
<td>Specifies whether the worksheet windows are protected.</td>
</tr>
<tr>
<td><a href="xeleDisplayInkNotes_HV01104553.htm" id="HV01104553" lcid="">DisplayInkNotes</a></td>
<td>Specifies whether ink comments are displayed.</td>
</tr>
<tr>
<td><a href="xeleEmbedSaveSmartTags_HV01104577.htm" id="HV01104577" lcid="">EmbedSaveSmartTags</a></td>
<td>Causes smart tags in the document to be saved to the XML spreadsheet.</td>
</tr>
<tr>
<td><a href="xeleFutureVer_HV01104641.htm" id="HV01104641" lcid="">FutureVer</a></td>
<td>Enables Excel 2002 to warn users that they may lose data on save back to XMLSS, when the XMLSS loaded was created with Excel 2003. This element will only be written into the XMLSS if were writing out the MapInfo collection (new feature in Excel 2003).</td>
</tr>
<tr>
<td><a href="xeleTabRatio_HV01105015.htm" id="HV01105015" lcid="">TabRatio</a></td>
<td>Specifies the ratio of the worksheet tab area width to the width of the horizontal scroll bar.</td>
</tr>
<tr>
<td><a href="xeleWindowIconic_HV01105079.htm" id="HV01105079" lcid="">WindowIconic</a></td>
<td>Specifies whether a workbook window is minimized.</td>
</tr>
<tr>
<td><a href="xeleDisplayDrawingObjects_HV01104547.htm" id="HV01104547" lcid="">DisplayDrawingObjects</a></td>
<td>Specifies whether drawing objects are displayed, placeholders are displayed in their place, or all drawing objects are hidden in a workbook.</td>
</tr>
<tr>
<td><a href="xeleCreateBackup_HV01104502.htm" id="HV01104502" lcid="">CreateBackup</a></td>
<td>Specifies whether a backup file is created when you save a workbook.</td>
</tr>
<tr>
<td><a href="xeleCalculation_ExcelWorkbook_HV01104453.htm" id="HV01104453" lcid="">Calculation</a></td>
<td>Specifies the type of calculation for a PivotTable field or the mode of calculation for a workbook.</td>
</tr>
<tr>
<td><a href="xeleDoNotCalculateBeforeSave_HV01104558.htm" id="HV01104558" lcid="">DoNotCalculateBeforeSave</a></td>
<td>Specifies whether a workbook is calculated before it is saved.</td>
</tr>
<tr>
<td><a href="xeleDate1904_HV01104520.htm" id="HV01104520" lcid="">Date1904</a></td>
<td>Specifies the date system used in a workbook.</td>
</tr>
<tr>
<td><a href="xeleRefModeR1C1_HV01104923.htm" id="HV01104923" lcid="">RefModeR1C1</a></td>
<td>Specifies that references are in R1C1 reference style.</td>
</tr>
<tr>
<td><a href="xeleIteration_HV01104700.htm" id="HV01104700" lcid="">Iteration</a></td>
<td>Specifies whether to track the number of iterations through circular references in formulas.</td>
</tr>
<tr>
<td><a href="xeleMaxIterations_HV01104731.htm" id="HV01104731" lcid="">MaxIterations</a></td>
<td>Specifies the maximum number of iterations when resolving circular references in Excel.</td>
</tr>
<tr>
<td><a href="xeleMaxChange_HV01104729.htm" id="HV01104729" lcid="">MaxChange</a></td>
<td>Specifies the maximum amount of change for a value between each iteration when Excel resolves circular references in formulas.</td>
</tr>
<tr>
<td><a href="xelePrecisionAsDisplayed_HV01104884.htm" id="HV01104884" lcid="">PrecisionAsDisplayed</a></td>
<td>Specifies whether calculations are performed using the precision of numbers as they are displayed.</td>
</tr>
<tr>
<td><a href="xeleDoNotSaveLinkValues_HV01104571.htm" id="HV01104571" lcid="">DoNotSaveLinkValues</a></td>
<td>Specifies whether the values in linked cells are saved.</td>
</tr>
<tr>
<td><a href="xeleNoAutoRecover_HV01104778.htm" id="HV01104778" lcid="">NoAutoRecover</a></td>
<td>Suppresses autorecovery of documents if Excel fails.</td>
</tr>
<tr>
<td><a href="xeleAcceptLabelsInFormulas_HV01104384.htm" id="HV01104384" lcid="">AcceptLabelsInFormulas</a></td>
<td>Specifies whether range names are allowed in formulas.</td>
</tr>
<tr>
<td><a href="xeleUncalced_HV01105036.htm" id="HV01105036" lcid="">Uncalced</a></td>
<td>Specifies whether a workbook has already been calculated.</td>
</tr>
</table><h3>Attributes</h3><p>None.</p><h2>Definition</h2><pre>
<code>
<xsd:element name="ExcelWorkbook" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="PublishObjects" type="PublishObjectsType" minOccurs="0">
</xsd:element>
<xsd:element name="SupBook" type="SupBookType" minOccurs="0" maxOccurs="unbounded">
</xsd:element>
<xsd:element name="SelectedSheets" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="WindowHidden" minOccurs="0">
</xsd:element>
<xsd:element name="HideHorizontalScrollBar" minOccurs="0">
</xsd:element>
<xsd:element name="HideVerticalScrollBar" minOccurs="0">
</xsd:element>
<xsd:element name="HideWorkbookTabs" minOccurs="0">
</xsd:element>
<xsd:element name="WindowHeight" type="xsd:long" minOccurs="0">
</xsd:element>
<xsd:element name="WindowWidth" type="xsd:long" minOccurs="0">
</xsd:element>
<xsd:element name="WindowTopX" type="xsd:long" minOccurs="0">
</xsd:element>
<xsd:element name="WindowTopY" type="xsd:long" minOccurs="0">
</xsd:element>
<xsd:element name="ActiveSheet" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="ActiveChart" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="FirstVisibleSheet" type="xsd:int" default="1" minOccurs="0">
</xsd:element>
<xsd:element name="HidePivotTableFieldList" minOccurs="0">
</xsd:element>
<xsd:element name="ProtectStructure" type="TrueFalseType" minOccurs="0">
</xsd:element>
<xsd:element name="ProtectWindows" type="TrueFalseType" minOccurs="0">
</xsd:element>
<xsd:element name="DisplayInkNotes" type="TrueFalseType" minOccurs="0">
</xsd:element>
<xsd:element name="EmbedSaveSmartTags" minOccurs="0">
</xsd:element>
<xsd:element name="FutureVer" type="xsd:string" minOccurs="0">
</xsd:element>
<xsd:element name="TabRatio" type="xsd:int" default="600" minOccurs="0">
</xsd:element>
<xsd:element name="WindowIconic" minOccurs="0">
</xsd:element>
<xsd:element name="DisplayDrawingObjects" default="DisplayShapes" minOccurs="0">
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="DisplayShapes" />
<xsd:enumeration value="PlaceHolders" />
<xsd:enumeration value="HideAll" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="CreateBackup" minOccurs="0">
</xsd:element>
<xsd:element name="Calculation" type="CalculationWorkbookType" default="AutomaticCalculation" minOccurs="0">
</xsd:element>
<xsd:element name="DoNotCalculateBeforeSave" minOccurs="0">
</xsd:element>
<xsd:element name="Date1904" minOccurs="0">
</xsd:element>
<xsd:element name="RefModeR1C1" minOccurs="0">
</xsd:element>
<xsd:element name="Iteration" minOccurs="0">
</xsd:element>
<xsd:element name="MaxIterations" minOccurs="0">
</xsd:element>
<xsd:element name="MaxChange" type="xsd:double" default="0.001" minOccurs="0">
</xsd:element>
<xsd:element name="PrecisionAsDisplayed" minOccurs="0">
</xsd:element>
<xsd:element name="DoNotSaveLinkValues" minOccurs="0">
</xsd:element>
<xsd:element name="NoAutoRecover" minOccurs="0">
</xsd:element>
<xsd:element name="AcceptLabelsInFormulas" minOccurs="0">
</xsd:element>
<xsd:element name="Uncalced" minOccurs="0">
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</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>
|
