main
1<?xml version="1.0" encoding="utf-8"?>
2<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
3 xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
4 xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
5 xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
6 xmlns:s="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes"
7 targetNamespace="http://schemas.openxmlformats.org/spreadsheetml/2006/main"
8 elementFormDefault="qualified">
9 <xsd:import namespace="http://schemas.openxmlformats.org/officeDocument/2006/relationships"
10 schemaLocation="shared-relationshipReference.xsd"/>
11 <xsd:import namespace="http://schemas.openxmlformats.org/officeDocument/2006/sharedTypes"
12 schemaLocation="shared-commonSimpleTypes.xsd"/>
13 <xsd:import
14 namespace="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing"
15 schemaLocation="dml-spreadsheetDrawing.xsd"/>
16 <xsd:complexType name="CT_AutoFilter">
17 <xsd:sequence>
18 <xsd:element name="filterColumn" minOccurs="0" maxOccurs="unbounded" type="CT_FilterColumn"/>
19 <xsd:element name="sortState" minOccurs="0" maxOccurs="1" type="CT_SortState"/>
20 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
21 </xsd:sequence>
22 <xsd:attribute name="ref" type="ST_Ref"/>
23 </xsd:complexType>
24 <xsd:complexType name="CT_FilterColumn">
25 <xsd:choice minOccurs="0" maxOccurs="1">
26 <xsd:element name="filters" type="CT_Filters" minOccurs="0" maxOccurs="1"/>
27 <xsd:element name="top10" type="CT_Top10" minOccurs="0" maxOccurs="1"/>
28 <xsd:element name="customFilters" type="CT_CustomFilters" minOccurs="0" maxOccurs="1"/>
29 <xsd:element name="dynamicFilter" type="CT_DynamicFilter" minOccurs="0" maxOccurs="1"/>
30 <xsd:element name="colorFilter" type="CT_ColorFilter" minOccurs="0" maxOccurs="1"/>
31 <xsd:element name="iconFilter" minOccurs="0" maxOccurs="1" type="CT_IconFilter"/>
32 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
33 </xsd:choice>
34 <xsd:attribute name="colId" type="xsd:unsignedInt" use="required"/>
35 <xsd:attribute name="hiddenButton" type="xsd:boolean" use="optional" default="false"/>
36 <xsd:attribute name="showButton" type="xsd:boolean" use="optional" default="true"/>
37 </xsd:complexType>
38 <xsd:complexType name="CT_Filters">
39 <xsd:sequence>
40 <xsd:element name="filter" type="CT_Filter" minOccurs="0" maxOccurs="unbounded"/>
41 <xsd:element name="dateGroupItem" type="CT_DateGroupItem" minOccurs="0" maxOccurs="unbounded"
42 />
43 </xsd:sequence>
44 <xsd:attribute name="blank" type="xsd:boolean" use="optional" default="false"/>
45 <xsd:attribute name="calendarType" type="s:ST_CalendarType" use="optional" default="none"/>
46 </xsd:complexType>
47 <xsd:complexType name="CT_Filter">
48 <xsd:attribute name="val" type="s:ST_Xstring"/>
49 </xsd:complexType>
50 <xsd:complexType name="CT_CustomFilters">
51 <xsd:sequence>
52 <xsd:element name="customFilter" type="CT_CustomFilter" minOccurs="1" maxOccurs="2"/>
53 </xsd:sequence>
54 <xsd:attribute name="and" type="xsd:boolean" use="optional" default="false"/>
55 </xsd:complexType>
56 <xsd:complexType name="CT_CustomFilter">
57 <xsd:attribute name="operator" type="ST_FilterOperator" default="equal" use="optional"/>
58 <xsd:attribute name="val" type="s:ST_Xstring"/>
59 </xsd:complexType>
60 <xsd:complexType name="CT_Top10">
61 <xsd:attribute name="top" type="xsd:boolean" use="optional" default="true"/>
62 <xsd:attribute name="percent" type="xsd:boolean" use="optional" default="false"/>
63 <xsd:attribute name="val" type="xsd:double" use="required"/>
64 <xsd:attribute name="filterVal" type="xsd:double" use="optional"/>
65 </xsd:complexType>
66 <xsd:complexType name="CT_ColorFilter">
67 <xsd:attribute name="dxfId" type="ST_DxfId" use="optional"/>
68 <xsd:attribute name="cellColor" type="xsd:boolean" use="optional" default="true"/>
69 </xsd:complexType>
70 <xsd:complexType name="CT_IconFilter">
71 <xsd:attribute name="iconSet" type="ST_IconSetType" use="required"/>
72 <xsd:attribute name="iconId" type="xsd:unsignedInt" use="optional"/>
73 </xsd:complexType>
74 <xsd:simpleType name="ST_FilterOperator">
75 <xsd:restriction base="xsd:string">
76 <xsd:enumeration value="equal"/>
77 <xsd:enumeration value="lessThan"/>
78 <xsd:enumeration value="lessThanOrEqual"/>
79 <xsd:enumeration value="notEqual"/>
80 <xsd:enumeration value="greaterThanOrEqual"/>
81 <xsd:enumeration value="greaterThan"/>
82 </xsd:restriction>
83 </xsd:simpleType>
84 <xsd:complexType name="CT_DynamicFilter">
85 <xsd:attribute name="type" type="ST_DynamicFilterType" use="required"/>
86 <xsd:attribute name="val" type="xsd:double" use="optional"/>
87 <xsd:attribute name="valIso" type="xsd:dateTime" use="optional"/>
88 <xsd:attribute name="maxVal" type="xsd:double" use="optional"/>
89 <xsd:attribute name="maxValIso" type="xsd:dateTime" use="optional"/>
90 </xsd:complexType>
91 <xsd:simpleType name="ST_DynamicFilterType">
92 <xsd:restriction base="xsd:string">
93 <xsd:enumeration value="null"/>
94 <xsd:enumeration value="aboveAverage"/>
95 <xsd:enumeration value="belowAverage"/>
96 <xsd:enumeration value="tomorrow"/>
97 <xsd:enumeration value="today"/>
98 <xsd:enumeration value="yesterday"/>
99 <xsd:enumeration value="nextWeek"/>
100 <xsd:enumeration value="thisWeek"/>
101 <xsd:enumeration value="lastWeek"/>
102 <xsd:enumeration value="nextMonth"/>
103 <xsd:enumeration value="thisMonth"/>
104 <xsd:enumeration value="lastMonth"/>
105 <xsd:enumeration value="nextQuarter"/>
106 <xsd:enumeration value="thisQuarter"/>
107 <xsd:enumeration value="lastQuarter"/>
108 <xsd:enumeration value="nextYear"/>
109 <xsd:enumeration value="thisYear"/>
110 <xsd:enumeration value="lastYear"/>
111 <xsd:enumeration value="yearToDate"/>
112 <xsd:enumeration value="Q1"/>
113 <xsd:enumeration value="Q2"/>
114 <xsd:enumeration value="Q3"/>
115 <xsd:enumeration value="Q4"/>
116 <xsd:enumeration value="M1"/>
117 <xsd:enumeration value="M2"/>
118 <xsd:enumeration value="M3"/>
119 <xsd:enumeration value="M4"/>
120 <xsd:enumeration value="M5"/>
121 <xsd:enumeration value="M6"/>
122 <xsd:enumeration value="M7"/>
123 <xsd:enumeration value="M8"/>
124 <xsd:enumeration value="M9"/>
125 <xsd:enumeration value="M10"/>
126 <xsd:enumeration value="M11"/>
127 <xsd:enumeration value="M12"/>
128 </xsd:restriction>
129 </xsd:simpleType>
130 <xsd:simpleType name="ST_IconSetType">
131 <xsd:restriction base="xsd:string">
132 <xsd:enumeration value="3Arrows"/>
133 <xsd:enumeration value="3ArrowsGray"/>
134 <xsd:enumeration value="3Flags"/>
135 <xsd:enumeration value="3TrafficLights1"/>
136 <xsd:enumeration value="3TrafficLights2"/>
137 <xsd:enumeration value="3Signs"/>
138 <xsd:enumeration value="3Symbols"/>
139 <xsd:enumeration value="3Symbols2"/>
140 <xsd:enumeration value="4Arrows"/>
141 <xsd:enumeration value="4ArrowsGray"/>
142 <xsd:enumeration value="4RedToBlack"/>
143 <xsd:enumeration value="4Rating"/>
144 <xsd:enumeration value="4TrafficLights"/>
145 <xsd:enumeration value="5Arrows"/>
146 <xsd:enumeration value="5ArrowsGray"/>
147 <xsd:enumeration value="5Rating"/>
148 <xsd:enumeration value="5Quarters"/>
149 </xsd:restriction>
150 </xsd:simpleType>
151 <xsd:complexType name="CT_SortState">
152 <xsd:sequence>
153 <xsd:element name="sortCondition" minOccurs="0" maxOccurs="64" type="CT_SortCondition"/>
154 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
155 </xsd:sequence>
156 <xsd:attribute name="columnSort" type="xsd:boolean" use="optional" default="false"/>
157 <xsd:attribute name="caseSensitive" type="xsd:boolean" use="optional" default="false"/>
158 <xsd:attribute name="sortMethod" type="ST_SortMethod" use="optional" default="none"/>
159 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
160 </xsd:complexType>
161 <xsd:complexType name="CT_SortCondition">
162 <xsd:attribute name="descending" type="xsd:boolean" use="optional" default="false"/>
163 <xsd:attribute name="sortBy" type="ST_SortBy" use="optional" default="value"/>
164 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
165 <xsd:attribute name="customList" type="s:ST_Xstring" use="optional"/>
166 <xsd:attribute name="dxfId" type="ST_DxfId" use="optional"/>
167 <xsd:attribute name="iconSet" type="ST_IconSetType" use="optional" default="3Arrows"/>
168 <xsd:attribute name="iconId" type="xsd:unsignedInt" use="optional"/>
169 </xsd:complexType>
170 <xsd:simpleType name="ST_SortBy">
171 <xsd:restriction base="xsd:string">
172 <xsd:enumeration value="value"/>
173 <xsd:enumeration value="cellColor"/>
174 <xsd:enumeration value="fontColor"/>
175 <xsd:enumeration value="icon"/>
176 </xsd:restriction>
177 </xsd:simpleType>
178 <xsd:simpleType name="ST_SortMethod">
179 <xsd:restriction base="xsd:string">
180 <xsd:enumeration value="stroke"/>
181 <xsd:enumeration value="pinYin"/>
182 <xsd:enumeration value="none"/>
183 </xsd:restriction>
184 </xsd:simpleType>
185 <xsd:complexType name="CT_DateGroupItem">
186 <xsd:attribute name="year" type="xsd:unsignedShort" use="required"/>
187 <xsd:attribute name="month" type="xsd:unsignedShort" use="optional"/>
188 <xsd:attribute name="day" type="xsd:unsignedShort" use="optional"/>
189 <xsd:attribute name="hour" type="xsd:unsignedShort" use="optional"/>
190 <xsd:attribute name="minute" type="xsd:unsignedShort" use="optional"/>
191 <xsd:attribute name="second" type="xsd:unsignedShort" use="optional"/>
192 <xsd:attribute name="dateTimeGrouping" type="ST_DateTimeGrouping" use="required"/>
193 </xsd:complexType>
194 <xsd:simpleType name="ST_DateTimeGrouping">
195 <xsd:restriction base="xsd:string">
196 <xsd:enumeration value="year"/>
197 <xsd:enumeration value="month"/>
198 <xsd:enumeration value="day"/>
199 <xsd:enumeration value="hour"/>
200 <xsd:enumeration value="minute"/>
201 <xsd:enumeration value="second"/>
202 </xsd:restriction>
203 </xsd:simpleType>
204 <xsd:simpleType name="ST_CellRef">
205 <xsd:restriction base="xsd:string"/>
206 </xsd:simpleType>
207 <xsd:simpleType name="ST_Ref">
208 <xsd:restriction base="xsd:string"/>
209 </xsd:simpleType>
210 <xsd:simpleType name="ST_RefA">
211 <xsd:restriction base="xsd:string"/>
212 </xsd:simpleType>
213 <xsd:simpleType name="ST_Sqref">
214 <xsd:list itemType="ST_Ref"/>
215 </xsd:simpleType>
216 <xsd:simpleType name="ST_Formula">
217 <xsd:restriction base="s:ST_Xstring"/>
218 </xsd:simpleType>
219 <xsd:simpleType name="ST_UnsignedIntHex">
220 <xsd:restriction base="xsd:hexBinary">
221 <xsd:length value="4"/>
222 </xsd:restriction>
223 </xsd:simpleType>
224 <xsd:simpleType name="ST_UnsignedShortHex">
225 <xsd:restriction base="xsd:hexBinary">
226 <xsd:length value="2"/>
227 </xsd:restriction>
228 </xsd:simpleType>
229 <xsd:complexType name="CT_XStringElement">
230 <xsd:attribute name="v" type="s:ST_Xstring" use="required"/>
231 </xsd:complexType>
232 <xsd:complexType name="CT_Extension">
233 <xsd:sequence>
234 <xsd:any processContents="lax"/>
235 </xsd:sequence>
236 <xsd:attribute name="uri" type="xsd:token"/>
237 </xsd:complexType>
238 <xsd:complexType name="CT_ObjectAnchor">
239 <xsd:sequence>
240 <xsd:element ref="xdr:from" minOccurs="1" maxOccurs="1"/>
241 <xsd:element ref="xdr:to" minOccurs="1" maxOccurs="1"/>
242 </xsd:sequence>
243 <xsd:attribute name="moveWithCells" type="xsd:boolean" use="optional" default="false"/>
244 <xsd:attribute name="sizeWithCells" type="xsd:boolean" use="optional" default="false"/>
245 </xsd:complexType>
246 <xsd:group name="EG_ExtensionList">
247 <xsd:sequence>
248 <xsd:element name="ext" type="CT_Extension" minOccurs="0" maxOccurs="unbounded"/>
249 </xsd:sequence>
250 </xsd:group>
251 <xsd:complexType name="CT_ExtensionList">
252 <xsd:sequence>
253 <xsd:group ref="EG_ExtensionList" minOccurs="0"/>
254 </xsd:sequence>
255 </xsd:complexType>
256 <xsd:element name="calcChain" type="CT_CalcChain"/>
257 <xsd:complexType name="CT_CalcChain">
258 <xsd:sequence>
259 <xsd:element name="c" type="CT_CalcCell" minOccurs="1" maxOccurs="unbounded"/>
260 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
261 </xsd:sequence>
262 </xsd:complexType>
263 <xsd:complexType name="CT_CalcCell">
264 <xsd:attribute name="r" type="ST_CellRef" use="optional"/>
265 <xsd:attribute name="ref" type="ST_CellRef" use="optional"/>
266 <xsd:attribute name="i" type="xsd:int" use="optional" default="0"/>
267 <xsd:attribute name="s" type="xsd:boolean" use="optional" default="false"/>
268 <xsd:attribute name="l" type="xsd:boolean" use="optional" default="false"/>
269 <xsd:attribute name="t" type="xsd:boolean" use="optional" default="false"/>
270 <xsd:attribute name="a" type="xsd:boolean" use="optional" default="false"/>
271 </xsd:complexType>
272 <xsd:element name="comments" type="CT_Comments"/>
273 <xsd:complexType name="CT_Comments">
274 <xsd:sequence>
275 <xsd:element name="authors" type="CT_Authors" minOccurs="1" maxOccurs="1"/>
276 <xsd:element name="commentList" type="CT_CommentList" minOccurs="1" maxOccurs="1"/>
277 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
278 </xsd:sequence>
279 </xsd:complexType>
280 <xsd:complexType name="CT_Authors">
281 <xsd:sequence>
282 <xsd:element name="author" type="s:ST_Xstring" minOccurs="0" maxOccurs="unbounded"/>
283 </xsd:sequence>
284 </xsd:complexType>
285 <xsd:complexType name="CT_CommentList">
286 <xsd:sequence>
287 <xsd:element name="comment" type="CT_Comment" minOccurs="0" maxOccurs="unbounded"/>
288 </xsd:sequence>
289 </xsd:complexType>
290 <xsd:complexType name="CT_Comment">
291 <xsd:sequence>
292 <xsd:element name="text" type="CT_Rst" minOccurs="1" maxOccurs="1"/>
293 <xsd:element name="commentPr" type="CT_CommentPr" minOccurs="0" maxOccurs="1"/>
294 </xsd:sequence>
295 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
296 <xsd:attribute name="authorId" type="xsd:unsignedInt" use="required"/>
297 <xsd:attribute name="guid" type="s:ST_Guid" use="optional"/>
298 <xsd:attribute name="shapeId" type="xsd:unsignedInt" use="optional"/>
299 </xsd:complexType>
300 <xsd:complexType name="CT_CommentPr">
301 <xsd:sequence>
302 <xsd:element name="anchor" type="CT_ObjectAnchor" minOccurs="1" maxOccurs="1"/>
303 </xsd:sequence>
304 <xsd:attribute name="locked" type="xsd:boolean" use="optional" default="true"/>
305 <xsd:attribute name="defaultSize" type="xsd:boolean" use="optional" default="true"/>
306 <xsd:attribute name="print" type="xsd:boolean" use="optional" default="true"/>
307 <xsd:attribute name="disabled" type="xsd:boolean" use="optional" default="false"/>
308 <xsd:attribute name="autoFill" type="xsd:boolean" use="optional" default="true"/>
309 <xsd:attribute name="autoLine" type="xsd:boolean" use="optional" default="true"/>
310 <xsd:attribute name="altText" type="s:ST_Xstring" use="optional"/>
311 <xsd:attribute name="textHAlign" type="ST_TextHAlign" use="optional" default="left"/>
312 <xsd:attribute name="textVAlign" type="ST_TextVAlign" use="optional" default="top"/>
313 <xsd:attribute name="lockText" type="xsd:boolean" use="optional" default="true"/>
314 <xsd:attribute name="justLastX" type="xsd:boolean" use="optional" default="false"/>
315 <xsd:attribute name="autoScale" type="xsd:boolean" use="optional" default="false"/>
316 </xsd:complexType>
317 <xsd:simpleType name="ST_TextHAlign">
318 <xsd:restriction base="xsd:string">
319 <xsd:enumeration value="left"/>
320 <xsd:enumeration value="center"/>
321 <xsd:enumeration value="right"/>
322 <xsd:enumeration value="justify"/>
323 <xsd:enumeration value="distributed"/>
324 </xsd:restriction>
325 </xsd:simpleType>
326 <xsd:simpleType name="ST_TextVAlign">
327 <xsd:restriction base="xsd:string">
328 <xsd:enumeration value="top"/>
329 <xsd:enumeration value="center"/>
330 <xsd:enumeration value="bottom"/>
331 <xsd:enumeration value="justify"/>
332 <xsd:enumeration value="distributed"/>
333 </xsd:restriction>
334 </xsd:simpleType>
335 <xsd:element name="MapInfo" type="CT_MapInfo"/>
336 <xsd:complexType name="CT_MapInfo">
337 <xsd:sequence>
338 <xsd:element name="Schema" type="CT_Schema" minOccurs="1" maxOccurs="unbounded"/>
339 <xsd:element name="Map" type="CT_Map" minOccurs="1" maxOccurs="unbounded"/>
340 </xsd:sequence>
341 <xsd:attribute name="SelectionNamespaces" type="xsd:string" use="required"/>
342 </xsd:complexType>
343 <xsd:complexType name="CT_Schema" mixed="true">
344 <xsd:sequence>
345 <xsd:any/>
346 </xsd:sequence>
347 <xsd:attribute name="ID" type="xsd:string" use="required"/>
348 <xsd:attribute name="SchemaRef" type="xsd:string" use="optional"/>
349 <xsd:attribute name="Namespace" type="xsd:string" use="optional"/>
350 <xsd:attribute name="SchemaLanguage" type="xsd:token" use="optional"/>
351 </xsd:complexType>
352 <xsd:complexType name="CT_Map">
353 <xsd:sequence>
354 <xsd:element name="DataBinding" type="CT_DataBinding" minOccurs="0" maxOccurs="1"/>
355 </xsd:sequence>
356 <xsd:attribute name="ID" type="xsd:unsignedInt" use="required"/>
357 <xsd:attribute name="Name" type="xsd:string" use="required"/>
358 <xsd:attribute name="RootElement" type="xsd:string" use="required"/>
359 <xsd:attribute name="SchemaID" type="xsd:string" use="required"/>
360 <xsd:attribute name="ShowImportExportValidationErrors" type="xsd:boolean" use="required"/>
361 <xsd:attribute name="AutoFit" type="xsd:boolean" use="required"/>
362 <xsd:attribute name="Append" type="xsd:boolean" use="required"/>
363 <xsd:attribute name="PreserveSortAFLayout" type="xsd:boolean" use="required"/>
364 <xsd:attribute name="PreserveFormat" type="xsd:boolean" use="required"/>
365 </xsd:complexType>
366 <xsd:complexType name="CT_DataBinding">
367 <xsd:sequence>
368 <xsd:any/>
369 </xsd:sequence>
370 <xsd:attribute name="DataBindingName" type="xsd:string" use="optional"/>
371 <xsd:attribute name="FileBinding" type="xsd:boolean" use="optional"/>
372 <xsd:attribute name="ConnectionID" type="xsd:unsignedInt" use="optional"/>
373 <xsd:attribute name="FileBindingName" type="xsd:string" use="optional"/>
374 <xsd:attribute name="DataBindingLoadMode" type="xsd:unsignedInt" use="required"/>
375 </xsd:complexType>
376 <xsd:element name="connections" type="CT_Connections"/>
377 <xsd:complexType name="CT_Connections">
378 <xsd:sequence>
379 <xsd:element name="connection" minOccurs="1" maxOccurs="unbounded" type="CT_Connection"/>
380 </xsd:sequence>
381 </xsd:complexType>
382 <xsd:complexType name="CT_Connection">
383 <xsd:sequence>
384 <xsd:element name="dbPr" minOccurs="0" maxOccurs="1" type="CT_DbPr"/>
385 <xsd:element name="olapPr" minOccurs="0" maxOccurs="1" type="CT_OlapPr"/>
386 <xsd:element name="webPr" minOccurs="0" maxOccurs="1" type="CT_WebPr"/>
387 <xsd:element name="textPr" minOccurs="0" maxOccurs="1" type="CT_TextPr"/>
388 <xsd:element name="parameters" minOccurs="0" maxOccurs="1" type="CT_Parameters"/>
389 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
390 </xsd:sequence>
391 <xsd:attribute name="id" use="required" type="xsd:unsignedInt"/>
392 <xsd:attribute name="sourceFile" use="optional" type="s:ST_Xstring"/>
393 <xsd:attribute name="odcFile" use="optional" type="s:ST_Xstring"/>
394 <xsd:attribute name="keepAlive" use="optional" type="xsd:boolean" default="false"/>
395 <xsd:attribute name="interval" use="optional" type="xsd:unsignedInt" default="0"/>
396 <xsd:attribute name="name" use="optional" type="s:ST_Xstring"/>
397 <xsd:attribute name="description" use="optional" type="s:ST_Xstring"/>
398 <xsd:attribute name="type" use="optional" type="xsd:unsignedInt"/>
399 <xsd:attribute name="reconnectionMethod" use="optional" type="xsd:unsignedInt" default="1"/>
400 <xsd:attribute name="refreshedVersion" use="required" type="xsd:unsignedByte"/>
401 <xsd:attribute name="minRefreshableVersion" use="optional" type="xsd:unsignedByte" default="0"/>
402 <xsd:attribute name="savePassword" use="optional" type="xsd:boolean" default="false"/>
403 <xsd:attribute name="new" use="optional" type="xsd:boolean" default="false"/>
404 <xsd:attribute name="deleted" use="optional" type="xsd:boolean" default="false"/>
405 <xsd:attribute name="onlyUseConnectionFile" use="optional" type="xsd:boolean" default="false"/>
406 <xsd:attribute name="background" use="optional" type="xsd:boolean" default="false"/>
407 <xsd:attribute name="refreshOnLoad" use="optional" type="xsd:boolean" default="false"/>
408 <xsd:attribute name="saveData" use="optional" type="xsd:boolean" default="false"/>
409 <xsd:attribute name="credentials" use="optional" type="ST_CredMethod" default="integrated"/>
410 <xsd:attribute name="singleSignOnId" use="optional" type="s:ST_Xstring"/>
411 </xsd:complexType>
412 <xsd:simpleType name="ST_CredMethod">
413 <xsd:restriction base="xsd:string">
414 <xsd:enumeration value="integrated"/>
415 <xsd:enumeration value="none"/>
416 <xsd:enumeration value="stored"/>
417 <xsd:enumeration value="prompt"/>
418 </xsd:restriction>
419 </xsd:simpleType>
420 <xsd:complexType name="CT_DbPr">
421 <xsd:attribute name="connection" use="required" type="s:ST_Xstring"/>
422 <xsd:attribute name="command" use="optional" type="s:ST_Xstring"/>
423 <xsd:attribute name="serverCommand" use="optional" type="s:ST_Xstring"/>
424 <xsd:attribute name="commandType" use="optional" type="xsd:unsignedInt" default="2"/>
425 </xsd:complexType>
426 <xsd:complexType name="CT_OlapPr">
427 <xsd:attribute name="local" use="optional" type="xsd:boolean" default="false"/>
428 <xsd:attribute name="localConnection" use="optional" type="s:ST_Xstring"/>
429 <xsd:attribute name="localRefresh" use="optional" type="xsd:boolean" default="true"/>
430 <xsd:attribute name="sendLocale" use="optional" type="xsd:boolean" default="false"/>
431 <xsd:attribute name="rowDrillCount" use="optional" type="xsd:unsignedInt"/>
432 <xsd:attribute name="serverFill" use="optional" type="xsd:boolean" default="true"/>
433 <xsd:attribute name="serverNumberFormat" use="optional" type="xsd:boolean" default="true"/>
434 <xsd:attribute name="serverFont" use="optional" type="xsd:boolean" default="true"/>
435 <xsd:attribute name="serverFontColor" use="optional" type="xsd:boolean" default="true"/>
436 </xsd:complexType>
437 <xsd:complexType name="CT_WebPr">
438 <xsd:sequence>
439 <xsd:element name="tables" minOccurs="0" maxOccurs="1" type="CT_Tables"/>
440 </xsd:sequence>
441 <xsd:attribute name="xml" use="optional" type="xsd:boolean" default="false"/>
442 <xsd:attribute name="sourceData" use="optional" type="xsd:boolean" default="false"/>
443 <xsd:attribute name="parsePre" use="optional" type="xsd:boolean" default="false"/>
444 <xsd:attribute name="consecutive" use="optional" type="xsd:boolean" default="false"/>
445 <xsd:attribute name="firstRow" use="optional" type="xsd:boolean" default="false"/>
446 <xsd:attribute name="xl97" use="optional" type="xsd:boolean" default="false"/>
447 <xsd:attribute name="textDates" use="optional" type="xsd:boolean" default="false"/>
448 <xsd:attribute name="xl2000" use="optional" type="xsd:boolean" default="false"/>
449 <xsd:attribute name="url" use="optional" type="s:ST_Xstring"/>
450 <xsd:attribute name="post" use="optional" type="s:ST_Xstring"/>
451 <xsd:attribute name="htmlTables" use="optional" type="xsd:boolean" default="false"/>
452 <xsd:attribute name="htmlFormat" use="optional" type="ST_HtmlFmt" default="none"/>
453 <xsd:attribute name="editPage" use="optional" type="s:ST_Xstring"/>
454 </xsd:complexType>
455 <xsd:simpleType name="ST_HtmlFmt">
456 <xsd:restriction base="xsd:string">
457 <xsd:enumeration value="none"/>
458 <xsd:enumeration value="rtf"/>
459 <xsd:enumeration value="all"/>
460 </xsd:restriction>
461 </xsd:simpleType>
462 <xsd:complexType name="CT_Parameters">
463 <xsd:sequence>
464 <xsd:element name="parameter" minOccurs="1" maxOccurs="unbounded" type="CT_Parameter"/>
465 </xsd:sequence>
466 <xsd:attribute name="count" use="optional" type="xsd:unsignedInt"/>
467 </xsd:complexType>
468 <xsd:complexType name="CT_Parameter">
469 <xsd:attribute name="name" use="optional" type="s:ST_Xstring"/>
470 <xsd:attribute name="sqlType" use="optional" type="xsd:int" default="0"/>
471 <xsd:attribute name="parameterType" use="optional" type="ST_ParameterType" default="prompt"/>
472 <xsd:attribute name="refreshOnChange" use="optional" type="xsd:boolean" default="false"/>
473 <xsd:attribute name="prompt" use="optional" type="s:ST_Xstring"/>
474 <xsd:attribute name="boolean" use="optional" type="xsd:boolean"/>
475 <xsd:attribute name="double" use="optional" type="xsd:double"/>
476 <xsd:attribute name="integer" use="optional" type="xsd:int"/>
477 <xsd:attribute name="string" use="optional" type="s:ST_Xstring"/>
478 <xsd:attribute name="cell" use="optional" type="s:ST_Xstring"/>
479 </xsd:complexType>
480 <xsd:simpleType name="ST_ParameterType">
481 <xsd:restriction base="xsd:string">
482 <xsd:enumeration value="prompt"/>
483 <xsd:enumeration value="value"/>
484 <xsd:enumeration value="cell"/>
485 </xsd:restriction>
486 </xsd:simpleType>
487 <xsd:complexType name="CT_Tables">
488 <xsd:choice minOccurs="1" maxOccurs="unbounded">
489 <xsd:element name="m" type="CT_TableMissing"/>
490 <xsd:element name="s" type="CT_XStringElement"/>
491 <xsd:element name="x" type="CT_Index"/>
492 </xsd:choice>
493 <xsd:attribute name="count" use="optional" type="xsd:unsignedInt"/>
494 </xsd:complexType>
495 <xsd:complexType name="CT_TableMissing"/>
496 <xsd:complexType name="CT_TextPr">
497 <xsd:sequence>
498 <xsd:element name="textFields" minOccurs="0" maxOccurs="1" type="CT_TextFields"/>
499 </xsd:sequence>
500 <xsd:attribute name="prompt" use="optional" type="xsd:boolean" default="true"/>
501 <xsd:attribute name="fileType" use="optional" type="ST_FileType" default="win"/>
502 <xsd:attribute name="codePage" use="optional" type="xsd:unsignedInt" default="1252"/>
503 <xsd:attribute name="characterSet" use="optional" type="xsd:string"/>
504 <xsd:attribute name="firstRow" use="optional" type="xsd:unsignedInt" default="1"/>
505 <xsd:attribute name="sourceFile" use="optional" type="s:ST_Xstring" default=""/>
506 <xsd:attribute name="delimited" use="optional" type="xsd:boolean" default="true"/>
507 <xsd:attribute name="decimal" use="optional" type="s:ST_Xstring" default="."/>
508 <xsd:attribute name="thousands" use="optional" type="s:ST_Xstring" default=","/>
509 <xsd:attribute name="tab" use="optional" type="xsd:boolean" default="true"/>
510 <xsd:attribute name="space" use="optional" type="xsd:boolean" default="false"/>
511 <xsd:attribute name="comma" use="optional" type="xsd:boolean" default="false"/>
512 <xsd:attribute name="semicolon" use="optional" type="xsd:boolean" default="false"/>
513 <xsd:attribute name="consecutive" use="optional" type="xsd:boolean" default="false"/>
514 <xsd:attribute name="qualifier" use="optional" type="ST_Qualifier" default="doubleQuote"/>
515 <xsd:attribute name="delimiter" use="optional" type="s:ST_Xstring"/>
516 </xsd:complexType>
517 <xsd:simpleType name="ST_FileType">
518 <xsd:restriction base="xsd:string">
519 <xsd:enumeration value="mac"/>
520 <xsd:enumeration value="win"/>
521 <xsd:enumeration value="dos"/>
522 <xsd:enumeration value="lin"/>
523 <xsd:enumeration value="other"/>
524 </xsd:restriction>
525 </xsd:simpleType>
526 <xsd:simpleType name="ST_Qualifier">
527 <xsd:restriction base="xsd:string">
528 <xsd:enumeration value="doubleQuote"/>
529 <xsd:enumeration value="singleQuote"/>
530 <xsd:enumeration value="none"/>
531 </xsd:restriction>
532 </xsd:simpleType>
533 <xsd:complexType name="CT_TextFields">
534 <xsd:sequence>
535 <xsd:element name="textField" minOccurs="1" maxOccurs="unbounded" type="CT_TextField"/>
536 </xsd:sequence>
537 <xsd:attribute name="count" use="optional" type="xsd:unsignedInt" default="1"/>
538 </xsd:complexType>
539 <xsd:complexType name="CT_TextField">
540 <xsd:attribute name="type" use="optional" type="ST_ExternalConnectionType" default="general"/>
541 <xsd:attribute name="position" use="optional" type="xsd:unsignedInt" default="0"/>
542 </xsd:complexType>
543 <xsd:simpleType name="ST_ExternalConnectionType">
544 <xsd:restriction base="xsd:string">
545 <xsd:enumeration value="general"/>
546 <xsd:enumeration value="text"/>
547 <xsd:enumeration value="MDY"/>
548 <xsd:enumeration value="DMY"/>
549 <xsd:enumeration value="YMD"/>
550 <xsd:enumeration value="MYD"/>
551 <xsd:enumeration value="DYM"/>
552 <xsd:enumeration value="YDM"/>
553 <xsd:enumeration value="skip"/>
554 <xsd:enumeration value="EMD"/>
555 </xsd:restriction>
556 </xsd:simpleType>
557 <xsd:element name="pivotCacheDefinition" type="CT_PivotCacheDefinition"/>
558 <xsd:element name="pivotCacheRecords" type="CT_PivotCacheRecords"/>
559 <xsd:element name="pivotTableDefinition" type="CT_pivotTableDefinition"/>
560 <xsd:complexType name="CT_PivotCacheDefinition">
561 <xsd:sequence>
562 <xsd:element name="cacheSource" type="CT_CacheSource" minOccurs="1" maxOccurs="1"/>
563 <xsd:element name="cacheFields" type="CT_CacheFields" minOccurs="1" maxOccurs="1"/>
564 <xsd:element name="cacheHierarchies" minOccurs="0" type="CT_CacheHierarchies"/>
565 <xsd:element name="kpis" minOccurs="0" type="CT_PCDKPIs"/>
566 <xsd:element name="tupleCache" minOccurs="0" type="CT_TupleCache"/>
567 <xsd:element name="calculatedItems" minOccurs="0" type="CT_CalculatedItems"/>
568 <xsd:element name="calculatedMembers" type="CT_CalculatedMembers" minOccurs="0"/>
569 <xsd:element name="dimensions" type="CT_Dimensions" minOccurs="0"/>
570 <xsd:element name="measureGroups" type="CT_MeasureGroups" minOccurs="0"/>
571 <xsd:element name="maps" type="CT_MeasureDimensionMaps" minOccurs="0"/>
572 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
573 </xsd:sequence>
574 <xsd:attribute ref="r:id" use="optional"/>
575 <xsd:attribute name="invalid" type="xsd:boolean" use="optional" default="false"/>
576 <xsd:attribute name="saveData" type="xsd:boolean" use="optional" default="true"/>
577 <xsd:attribute name="refreshOnLoad" type="xsd:boolean" use="optional" default="false"/>
578 <xsd:attribute name="optimizeMemory" type="xsd:boolean" use="optional" default="false"/>
579 <xsd:attribute name="enableRefresh" type="xsd:boolean" use="optional" default="true"/>
580 <xsd:attribute name="refreshedBy" type="s:ST_Xstring" use="optional"/>
581 <xsd:attribute name="refreshedDate" type="xsd:double" use="optional"/>
582 <xsd:attribute name="refreshedDateIso" type="xsd:dateTime" use="optional"/>
583 <xsd:attribute name="backgroundQuery" type="xsd:boolean" default="false"/>
584 <xsd:attribute name="missingItemsLimit" type="xsd:unsignedInt" use="optional"/>
585 <xsd:attribute name="createdVersion" type="xsd:unsignedByte" use="optional" default="0"/>
586 <xsd:attribute name="refreshedVersion" type="xsd:unsignedByte" use="optional" default="0"/>
587 <xsd:attribute name="minRefreshableVersion" type="xsd:unsignedByte" use="optional" default="0"/>
588 <xsd:attribute name="recordCount" type="xsd:unsignedInt" use="optional"/>
589 <xsd:attribute name="upgradeOnRefresh" type="xsd:boolean" use="optional" default="false"/>
590 <xsd:attribute name="tupleCache" type="xsd:boolean" use="optional" default="false"/>
591 <xsd:attribute name="supportSubquery" type="xsd:boolean" use="optional" default="false"/>
592 <xsd:attribute name="supportAdvancedDrill" type="xsd:boolean" use="optional" default="false"/>
593 </xsd:complexType>
594 <xsd:complexType name="CT_CacheFields">
595 <xsd:sequence>
596 <xsd:element name="cacheField" type="CT_CacheField" minOccurs="0" maxOccurs="unbounded"/>
597 </xsd:sequence>
598 <xsd:attribute name="count" type="xsd:unsignedInt"/>
599 </xsd:complexType>
600 <xsd:complexType name="CT_CacheField">
601 <xsd:sequence>
602 <xsd:element name="sharedItems" type="CT_SharedItems" minOccurs="0" maxOccurs="1"/>
603 <xsd:element name="fieldGroup" minOccurs="0" type="CT_FieldGroup"/>
604 <xsd:element name="mpMap" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
605 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
606 </xsd:sequence>
607 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
608 <xsd:attribute name="caption" type="s:ST_Xstring" use="optional"/>
609 <xsd:attribute name="propertyName" type="s:ST_Xstring" use="optional"/>
610 <xsd:attribute name="serverField" type="xsd:boolean" use="optional" default="false"/>
611 <xsd:attribute name="uniqueList" type="xsd:boolean" use="optional" default="true"/>
612 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
613 <xsd:attribute name="formula" type="s:ST_Xstring" use="optional"/>
614 <xsd:attribute name="sqlType" type="xsd:int" use="optional" default="0"/>
615 <xsd:attribute name="hierarchy" type="xsd:int" use="optional" default="0"/>
616 <xsd:attribute name="level" type="xsd:unsignedInt" use="optional" default="0"/>
617 <xsd:attribute name="databaseField" type="xsd:boolean" default="true"/>
618 <xsd:attribute name="mappingCount" type="xsd:unsignedInt" use="optional"/>
619 <xsd:attribute name="memberPropertyField" type="xsd:boolean" use="optional" default="false"/>
620 </xsd:complexType>
621 <xsd:complexType name="CT_CacheSource">
622 <xsd:choice minOccurs="0" maxOccurs="1">
623 <xsd:element name="worksheetSource" type="CT_WorksheetSource" minOccurs="1" maxOccurs="1"/>
624 <xsd:element name="consolidation" type="CT_Consolidation" minOccurs="1" maxOccurs="1"/>
625 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0"/>
626 </xsd:choice>
627 <xsd:attribute name="type" type="ST_SourceType" use="required"/>
628 <xsd:attribute name="connectionId" type="xsd:unsignedInt" default="0" use="optional"/>
629 </xsd:complexType>
630 <xsd:simpleType name="ST_SourceType">
631 <xsd:restriction base="xsd:string">
632 <xsd:enumeration value="worksheet"/>
633 <xsd:enumeration value="external"/>
634 <xsd:enumeration value="consolidation"/>
635 <xsd:enumeration value="scenario"/>
636 </xsd:restriction>
637 </xsd:simpleType>
638 <xsd:complexType name="CT_WorksheetSource">
639 <xsd:attribute name="ref" type="ST_Ref" use="optional"/>
640 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
641 <xsd:attribute name="sheet" type="s:ST_Xstring" use="optional"/>
642 <xsd:attribute ref="r:id" use="optional"/>
643 </xsd:complexType>
644 <xsd:complexType name="CT_Consolidation">
645 <xsd:sequence>
646 <xsd:element name="pages" type="CT_Pages" minOccurs="0" maxOccurs="1"/>
647 <xsd:element name="rangeSets" type="CT_RangeSets" minOccurs="1" maxOccurs="1"/>
648 </xsd:sequence>
649 <xsd:attribute name="autoPage" type="xsd:boolean" default="true" use="optional"/>
650 </xsd:complexType>
651 <xsd:complexType name="CT_Pages">
652 <xsd:sequence>
653 <xsd:element name="page" type="CT_PCDSCPage" minOccurs="1" maxOccurs="4"/>
654 </xsd:sequence>
655 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
656 </xsd:complexType>
657 <xsd:complexType name="CT_PCDSCPage">
658 <xsd:sequence>
659 <xsd:element name="pageItem" type="CT_PageItem" minOccurs="0" maxOccurs="unbounded"/>
660 </xsd:sequence>
661 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
662 </xsd:complexType>
663 <xsd:complexType name="CT_PageItem">
664 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
665 </xsd:complexType>
666 <xsd:complexType name="CT_RangeSets">
667 <xsd:sequence>
668 <xsd:element name="rangeSet" type="CT_RangeSet" minOccurs="1" maxOccurs="unbounded"/>
669 </xsd:sequence>
670 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
671 </xsd:complexType>
672 <xsd:complexType name="CT_RangeSet">
673 <xsd:attribute name="i1" type="xsd:unsignedInt" use="optional"/>
674 <xsd:attribute name="i2" type="xsd:unsignedInt" use="optional"/>
675 <xsd:attribute name="i3" type="xsd:unsignedInt" use="optional"/>
676 <xsd:attribute name="i4" type="xsd:unsignedInt" use="optional"/>
677 <xsd:attribute name="ref" type="ST_Ref" use="optional"/>
678 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
679 <xsd:attribute name="sheet" type="s:ST_Xstring" use="optional"/>
680 <xsd:attribute ref="r:id" use="optional"/>
681 </xsd:complexType>
682 <xsd:complexType name="CT_SharedItems">
683 <xsd:choice minOccurs="0" maxOccurs="unbounded">
684 <xsd:element name="m" type="CT_Missing" minOccurs="1" maxOccurs="1"/>
685 <xsd:element name="n" type="CT_Number" minOccurs="1" maxOccurs="1"/>
686 <xsd:element name="b" type="CT_Boolean" minOccurs="1" maxOccurs="1"/>
687 <xsd:element name="e" type="CT_Error" minOccurs="1" maxOccurs="1"/>
688 <xsd:element name="s" type="CT_String" minOccurs="1" maxOccurs="1"/>
689 <xsd:element name="d" type="CT_DateTime" minOccurs="1" maxOccurs="1"/>
690 </xsd:choice>
691 <xsd:attribute name="containsSemiMixedTypes" type="xsd:boolean" use="optional" default="true"/>
692 <xsd:attribute name="containsNonDate" type="xsd:boolean" use="optional" default="true"/>
693 <xsd:attribute name="containsDate" type="xsd:boolean" use="optional" default="false"/>
694 <xsd:attribute name="containsString" type="xsd:boolean" use="optional" default="true"/>
695 <xsd:attribute name="containsBlank" type="xsd:boolean" use="optional" default="false"/>
696 <xsd:attribute name="containsMixedTypes" type="xsd:boolean" use="optional" default="false"/>
697 <xsd:attribute name="containsNumber" type="xsd:boolean" use="optional" default="false"/>
698 <xsd:attribute name="containsInteger" type="xsd:boolean" use="optional" default="false"/>
699 <xsd:attribute name="minValue" type="xsd:double" use="optional"/>
700 <xsd:attribute name="maxValue" type="xsd:double" use="optional"/>
701 <xsd:attribute name="minDate" type="xsd:dateTime" use="optional"/>
702 <xsd:attribute name="maxDate" type="xsd:dateTime" use="optional"/>
703 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
704 <xsd:attribute name="longText" type="xsd:boolean" use="optional" default="false"/>
705 </xsd:complexType>
706 <xsd:complexType name="CT_Missing">
707 <xsd:sequence>
708 <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples"/>
709 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
710 </xsd:sequence>
711 <xsd:attribute name="u" type="xsd:boolean"/>
712 <xsd:attribute name="f" type="xsd:boolean"/>
713 <xsd:attribute name="c" type="s:ST_Xstring"/>
714 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
715 <xsd:attribute name="in" type="xsd:unsignedInt" use="optional"/>
716 <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
717 <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
718 <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>
719 <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false"/>
720 <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>
721 <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>
722 </xsd:complexType>
723 <xsd:complexType name="CT_Number">
724 <xsd:sequence>
725 <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples"/>
726 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
727 </xsd:sequence>
728 <xsd:attribute name="v" use="required" type="xsd:double"/>
729 <xsd:attribute name="u" type="xsd:boolean"/>
730 <xsd:attribute name="f" type="xsd:boolean"/>
731 <xsd:attribute name="c" type="s:ST_Xstring"/>
732 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
733 <xsd:attribute name="in" type="xsd:unsignedInt" use="optional"/>
734 <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
735 <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
736 <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>
737 <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false"/>
738 <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>
739 <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>
740 </xsd:complexType>
741 <xsd:complexType name="CT_Boolean">
742 <xsd:sequence>
743 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
744 </xsd:sequence>
745 <xsd:attribute name="v" use="required" type="xsd:boolean"/>
746 <xsd:attribute name="u" type="xsd:boolean"/>
747 <xsd:attribute name="f" type="xsd:boolean"/>
748 <xsd:attribute name="c" type="s:ST_Xstring"/>
749 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
750 </xsd:complexType>
751 <xsd:complexType name="CT_Error">
752 <xsd:sequence>
753 <xsd:element name="tpls" minOccurs="0" type="CT_Tuples"/>
754 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
755 </xsd:sequence>
756 <xsd:attribute name="v" use="required" type="s:ST_Xstring"/>
757 <xsd:attribute name="u" type="xsd:boolean"/>
758 <xsd:attribute name="f" type="xsd:boolean"/>
759 <xsd:attribute name="c" type="s:ST_Xstring"/>
760 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
761 <xsd:attribute name="in" type="xsd:unsignedInt" use="optional"/>
762 <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
763 <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
764 <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>
765 <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false"/>
766 <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>
767 <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>
768 </xsd:complexType>
769 <xsd:complexType name="CT_String">
770 <xsd:sequence>
771 <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples"/>
772 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
773 </xsd:sequence>
774 <xsd:attribute name="v" use="required" type="s:ST_Xstring"/>
775 <xsd:attribute name="u" type="xsd:boolean"/>
776 <xsd:attribute name="f" type="xsd:boolean"/>
777 <xsd:attribute name="c" type="s:ST_Xstring"/>
778 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
779 <xsd:attribute name="in" type="xsd:unsignedInt" use="optional"/>
780 <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
781 <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
782 <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>
783 <xsd:attribute name="un" type="xsd:boolean" use="optional" default="false"/>
784 <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>
785 <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>
786 </xsd:complexType>
787 <xsd:complexType name="CT_DateTime">
788 <xsd:sequence>
789 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
790 </xsd:sequence>
791 <xsd:attribute name="v" use="required" type="xsd:dateTime"/>
792 <xsd:attribute name="u" type="xsd:boolean"/>
793 <xsd:attribute name="f" type="xsd:boolean"/>
794 <xsd:attribute name="c" type="s:ST_Xstring"/>
795 <xsd:attribute name="cp" type="xsd:unsignedInt"/>
796 </xsd:complexType>
797 <xsd:complexType name="CT_FieldGroup">
798 <xsd:sequence>
799 <xsd:element name="rangePr" minOccurs="0" type="CT_RangePr"/>
800 <xsd:element name="discretePr" minOccurs="0" type="CT_DiscretePr"/>
801 <xsd:element name="groupItems" minOccurs="0" type="CT_GroupItems"/>
802 </xsd:sequence>
803 <xsd:attribute name="par" type="xsd:unsignedInt" use="optional"/>
804 <xsd:attribute name="base" type="xsd:unsignedInt" use="optional"/>
805 </xsd:complexType>
806 <xsd:complexType name="CT_RangePr">
807 <xsd:attribute name="autoStart" type="xsd:boolean" default="true"/>
808 <xsd:attribute name="autoEnd" type="xsd:boolean" default="true"/>
809 <xsd:attribute name="groupBy" type="ST_GroupBy" default="range"/>
810 <xsd:attribute name="startNum" type="xsd:double"/>
811 <xsd:attribute name="endNum" type="xsd:double"/>
812 <xsd:attribute name="startDate" type="xsd:dateTime"/>
813 <xsd:attribute name="endDate" type="xsd:dateTime"/>
814 <xsd:attribute name="groupInterval" type="xsd:double" default="1"/>
815 </xsd:complexType>
816 <xsd:simpleType name="ST_GroupBy">
817 <xsd:restriction base="xsd:string">
818 <xsd:enumeration value="range"/>
819 <xsd:enumeration value="seconds"/>
820 <xsd:enumeration value="minutes"/>
821 <xsd:enumeration value="hours"/>
822 <xsd:enumeration value="days"/>
823 <xsd:enumeration value="months"/>
824 <xsd:enumeration value="quarters"/>
825 <xsd:enumeration value="years"/>
826 </xsd:restriction>
827 </xsd:simpleType>
828 <xsd:complexType name="CT_DiscretePr">
829 <xsd:sequence>
830 <xsd:element name="x" maxOccurs="unbounded" type="CT_Index"/>
831 </xsd:sequence>
832 <xsd:attribute name="count" type="xsd:unsignedInt"/>
833 </xsd:complexType>
834 <xsd:complexType name="CT_GroupItems">
835 <xsd:choice maxOccurs="unbounded">
836 <xsd:element name="m" type="CT_Missing"/>
837 <xsd:element name="n" type="CT_Number"/>
838 <xsd:element name="b" type="CT_Boolean"/>
839 <xsd:element name="e" type="CT_Error"/>
840 <xsd:element name="s" type="CT_String"/>
841 <xsd:element name="d" type="CT_DateTime"/>
842 </xsd:choice>
843 <xsd:attribute name="count" type="xsd:unsignedInt"/>
844 </xsd:complexType>
845 <xsd:complexType name="CT_PivotCacheRecords">
846 <xsd:sequence>
847 <xsd:element name="r" minOccurs="0" maxOccurs="unbounded" type="CT_Record"/>
848 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
849 </xsd:sequence>
850 <xsd:attribute name="count" type="xsd:unsignedInt"/>
851 </xsd:complexType>
852 <xsd:complexType name="CT_Record">
853 <xsd:choice maxOccurs="unbounded">
854 <xsd:element name="m" type="CT_Missing"/>
855 <xsd:element name="n" type="CT_Number"/>
856 <xsd:element name="b" type="CT_Boolean"/>
857 <xsd:element name="e" type="CT_Error"/>
858 <xsd:element name="s" type="CT_String"/>
859 <xsd:element name="d" type="CT_DateTime"/>
860 <xsd:element name="x" type="CT_Index"/>
861 </xsd:choice>
862 </xsd:complexType>
863 <xsd:complexType name="CT_PCDKPIs">
864 <xsd:sequence>
865 <xsd:element name="kpi" minOccurs="0" maxOccurs="unbounded" type="CT_PCDKPI"/>
866 </xsd:sequence>
867 <xsd:attribute name="count" type="xsd:unsignedInt"/>
868 </xsd:complexType>
869 <xsd:complexType name="CT_PCDKPI">
870 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
871 <xsd:attribute name="caption" use="optional" type="s:ST_Xstring"/>
872 <xsd:attribute name="displayFolder" type="s:ST_Xstring"/>
873 <xsd:attribute name="measureGroup" type="s:ST_Xstring"/>
874 <xsd:attribute name="parent" type="s:ST_Xstring"/>
875 <xsd:attribute name="value" use="required" type="s:ST_Xstring"/>
876 <xsd:attribute name="goal" type="s:ST_Xstring"/>
877 <xsd:attribute name="status" type="s:ST_Xstring"/>
878 <xsd:attribute name="trend" type="s:ST_Xstring"/>
879 <xsd:attribute name="weight" type="s:ST_Xstring"/>
880 <xsd:attribute name="time" type="s:ST_Xstring"/>
881 </xsd:complexType>
882 <xsd:complexType name="CT_CacheHierarchies">
883 <xsd:sequence>
884 <xsd:element name="cacheHierarchy" minOccurs="0" maxOccurs="unbounded"
885 type="CT_CacheHierarchy"/>
886 </xsd:sequence>
887 <xsd:attribute name="count" type="xsd:unsignedInt"/>
888 </xsd:complexType>
889 <xsd:complexType name="CT_CacheHierarchy">
890 <xsd:sequence>
891 <xsd:element name="fieldsUsage" minOccurs="0" type="CT_FieldsUsage"/>
892 <xsd:element name="groupLevels" minOccurs="0" type="CT_GroupLevels"/>
893 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
894 </xsd:sequence>
895 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
896 <xsd:attribute name="caption" use="optional" type="s:ST_Xstring"/>
897 <xsd:attribute name="measure" type="xsd:boolean" default="false"/>
898 <xsd:attribute name="set" type="xsd:boolean" default="false"/>
899 <xsd:attribute name="parentSet" type="xsd:unsignedInt" use="optional"/>
900 <xsd:attribute name="iconSet" type="xsd:int" default="0"/>
901 <xsd:attribute name="attribute" type="xsd:boolean" default="false"/>
902 <xsd:attribute name="time" type="xsd:boolean" default="false"/>
903 <xsd:attribute name="keyAttribute" type="xsd:boolean" default="false"/>
904 <xsd:attribute name="defaultMemberUniqueName" type="s:ST_Xstring"/>
905 <xsd:attribute name="allUniqueName" type="s:ST_Xstring"/>
906 <xsd:attribute name="allCaption" type="s:ST_Xstring"/>
907 <xsd:attribute name="dimensionUniqueName" type="s:ST_Xstring"/>
908 <xsd:attribute name="displayFolder" type="s:ST_Xstring"/>
909 <xsd:attribute name="measureGroup" type="s:ST_Xstring"/>
910 <xsd:attribute name="measures" type="xsd:boolean" default="false"/>
911 <xsd:attribute name="count" use="required" type="xsd:unsignedInt"/>
912 <xsd:attribute name="oneField" type="xsd:boolean" default="false"/>
913 <xsd:attribute name="memberValueDatatype" use="optional" type="xsd:unsignedShort"/>
914 <xsd:attribute name="unbalanced" use="optional" type="xsd:boolean"/>
915 <xsd:attribute name="unbalancedGroup" use="optional" type="xsd:boolean"/>
916 <xsd:attribute name="hidden" type="xsd:boolean" default="false"/>
917 </xsd:complexType>
918 <xsd:complexType name="CT_FieldsUsage">
919 <xsd:sequence>
920 <xsd:element name="fieldUsage" minOccurs="0" maxOccurs="unbounded" type="CT_FieldUsage"/>
921 </xsd:sequence>
922 <xsd:attribute name="count" type="xsd:unsignedInt"/>
923 </xsd:complexType>
924 <xsd:complexType name="CT_FieldUsage">
925 <xsd:attribute name="x" use="required" type="xsd:int"/>
926 </xsd:complexType>
927 <xsd:complexType name="CT_GroupLevels">
928 <xsd:sequence>
929 <xsd:element name="groupLevel" maxOccurs="unbounded" type="CT_GroupLevel"/>
930 </xsd:sequence>
931 <xsd:attribute name="count" type="xsd:unsignedInt"/>
932 </xsd:complexType>
933 <xsd:complexType name="CT_GroupLevel">
934 <xsd:sequence>
935 <xsd:element name="groups" minOccurs="0" type="CT_Groups"/>
936 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
937 </xsd:sequence>
938 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
939 <xsd:attribute name="caption" use="required" type="s:ST_Xstring"/>
940 <xsd:attribute name="user" type="xsd:boolean" default="false"/>
941 <xsd:attribute name="customRollUp" type="xsd:boolean" default="false"/>
942 </xsd:complexType>
943 <xsd:complexType name="CT_Groups">
944 <xsd:sequence>
945 <xsd:element name="group" maxOccurs="unbounded" type="CT_LevelGroup"/>
946 </xsd:sequence>
947 <xsd:attribute name="count" type="xsd:unsignedInt"/>
948 </xsd:complexType>
949 <xsd:complexType name="CT_LevelGroup">
950 <xsd:sequence>
951 <xsd:element name="groupMembers" type="CT_GroupMembers"/>
952 </xsd:sequence>
953 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
954 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
955 <xsd:attribute name="caption" use="required" type="s:ST_Xstring"/>
956 <xsd:attribute name="uniqueParent" type="s:ST_Xstring"/>
957 <xsd:attribute name="id" type="xsd:int"/>
958 </xsd:complexType>
959 <xsd:complexType name="CT_GroupMembers">
960 <xsd:sequence>
961 <xsd:element name="groupMember" maxOccurs="unbounded" type="CT_GroupMember"/>
962 </xsd:sequence>
963 <xsd:attribute name="count" type="xsd:unsignedInt"/>
964 </xsd:complexType>
965 <xsd:complexType name="CT_GroupMember">
966 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
967 <xsd:attribute name="group" type="xsd:boolean" default="false"/>
968 </xsd:complexType>
969 <xsd:complexType name="CT_TupleCache">
970 <xsd:sequence>
971 <xsd:element name="entries" minOccurs="0" type="CT_PCDSDTCEntries"/>
972 <xsd:element name="sets" minOccurs="0" type="CT_Sets"/>
973 <xsd:element name="queryCache" minOccurs="0" type="CT_QueryCache"/>
974 <xsd:element name="serverFormats" minOccurs="0" maxOccurs="1" type="CT_ServerFormats"/>
975 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
976 </xsd:sequence>
977 </xsd:complexType>
978 <xsd:complexType name="CT_ServerFormat">
979 <xsd:attribute name="culture" use="optional" type="s:ST_Xstring"/>
980 <xsd:attribute name="format" use="optional" type="s:ST_Xstring"/>
981 </xsd:complexType>
982 <xsd:complexType name="CT_ServerFormats">
983 <xsd:sequence>
984 <xsd:element name="serverFormat" type="CT_ServerFormat" minOccurs="0" maxOccurs="unbounded"/>
985 </xsd:sequence>
986 <xsd:attribute name="count" type="xsd:unsignedInt"/>
987 </xsd:complexType>
988 <xsd:complexType name="CT_PCDSDTCEntries">
989 <xsd:choice maxOccurs="unbounded">
990 <xsd:element name="m" type="CT_Missing"/>
991 <xsd:element name="n" type="CT_Number"/>
992 <xsd:element name="e" type="CT_Error"/>
993 <xsd:element name="s" type="CT_String"/>
994 </xsd:choice>
995 <xsd:attribute name="count" type="xsd:unsignedInt"/>
996 </xsd:complexType>
997 <xsd:complexType name="CT_Tuples">
998 <xsd:sequence>
999 <xsd:element name="tpl" type="CT_Tuple" minOccurs="1" maxOccurs="unbounded"/>
1000 </xsd:sequence>
1001 <xsd:attribute name="c" type="xsd:unsignedInt" use="optional"/>
1002 </xsd:complexType>
1003 <xsd:complexType name="CT_Tuple">
1004 <xsd:attribute name="fld" type="xsd:unsignedInt"/>
1005 <xsd:attribute name="hier" type="xsd:unsignedInt"/>
1006 <xsd:attribute name="item" type="xsd:unsignedInt" use="required"/>
1007 </xsd:complexType>
1008 <xsd:complexType name="CT_Sets">
1009 <xsd:sequence>
1010 <xsd:element name="set" maxOccurs="unbounded" type="CT_Set"/>
1011 </xsd:sequence>
1012 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1013 </xsd:complexType>
1014 <xsd:complexType name="CT_Set">
1015 <xsd:sequence>
1016 <xsd:element name="tpls" minOccurs="0" maxOccurs="unbounded" type="CT_Tuples"/>
1017 <xsd:element name="sortByTuple" minOccurs="0" type="CT_Tuples"/>
1018 </xsd:sequence>
1019 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1020 <xsd:attribute name="maxRank" use="required" type="xsd:int"/>
1021 <xsd:attribute name="setDefinition" use="required" type="s:ST_Xstring"/>
1022 <xsd:attribute name="sortType" type="ST_SortType" default="none"/>
1023 <xsd:attribute name="queryFailed" type="xsd:boolean" default="false"/>
1024 </xsd:complexType>
1025 <xsd:simpleType name="ST_SortType">
1026 <xsd:restriction base="xsd:string">
1027 <xsd:enumeration value="none"/>
1028 <xsd:enumeration value="ascending"/>
1029 <xsd:enumeration value="descending"/>
1030 <xsd:enumeration value="ascendingAlpha"/>
1031 <xsd:enumeration value="descendingAlpha"/>
1032 <xsd:enumeration value="ascendingNatural"/>
1033 <xsd:enumeration value="descendingNatural"/>
1034 </xsd:restriction>
1035 </xsd:simpleType>
1036 <xsd:complexType name="CT_QueryCache">
1037 <xsd:sequence>
1038 <xsd:element name="query" maxOccurs="unbounded" type="CT_Query"/>
1039 </xsd:sequence>
1040 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1041 </xsd:complexType>
1042 <xsd:complexType name="CT_Query">
1043 <xsd:sequence>
1044 <xsd:element name="tpls" minOccurs="0" type="CT_Tuples"/>
1045 </xsd:sequence>
1046 <xsd:attribute name="mdx" use="required" type="s:ST_Xstring"/>
1047 </xsd:complexType>
1048 <xsd:complexType name="CT_CalculatedItems">
1049 <xsd:sequence>
1050 <xsd:element name="calculatedItem" maxOccurs="unbounded" type="CT_CalculatedItem"/>
1051 </xsd:sequence>
1052 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1053 </xsd:complexType>
1054 <xsd:complexType name="CT_CalculatedItem">
1055 <xsd:sequence>
1056 <xsd:element name="pivotArea" type="CT_PivotArea"/>
1057 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1058 </xsd:sequence>
1059 <xsd:attribute name="field" type="xsd:unsignedInt" use="optional"/>
1060 <xsd:attribute name="formula" type="s:ST_Xstring"/>
1061 </xsd:complexType>
1062 <xsd:complexType name="CT_CalculatedMembers">
1063 <xsd:sequence>
1064 <xsd:element name="calculatedMember" maxOccurs="unbounded" type="CT_CalculatedMember"/>
1065 </xsd:sequence>
1066 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1067 </xsd:complexType>
1068 <xsd:complexType name="CT_CalculatedMember">
1069 <xsd:sequence minOccurs="0">
1070 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1071 </xsd:sequence>
1072 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
1073 <xsd:attribute name="mdx" use="required" type="s:ST_Xstring"/>
1074 <xsd:attribute name="memberName" type="s:ST_Xstring"/>
1075 <xsd:attribute name="hierarchy" type="s:ST_Xstring"/>
1076 <xsd:attribute name="parent" type="s:ST_Xstring"/>
1077 <xsd:attribute name="solveOrder" type="xsd:int" default="0"/>
1078 <xsd:attribute name="set" type="xsd:boolean" default="false"/>
1079 </xsd:complexType>
1080 <xsd:complexType name="CT_pivotTableDefinition">
1081 <xsd:sequence>
1082 <xsd:element name="location" type="CT_Location"/>
1083 <xsd:element name="pivotFields" type="CT_PivotFields" minOccurs="0"/>
1084 <xsd:element name="rowFields" type="CT_RowFields" minOccurs="0"/>
1085 <xsd:element name="rowItems" type="CT_rowItems" minOccurs="0"/>
1086 <xsd:element name="colFields" type="CT_ColFields" minOccurs="0"/>
1087 <xsd:element name="colItems" type="CT_colItems" minOccurs="0"/>
1088 <xsd:element name="pageFields" type="CT_PageFields" minOccurs="0"/>
1089 <xsd:element name="dataFields" type="CT_DataFields" minOccurs="0"/>
1090 <xsd:element name="formats" type="CT_Formats" minOccurs="0"/>
1091 <xsd:element name="conditionalFormats" type="CT_ConditionalFormats" minOccurs="0"/>
1092 <xsd:element name="chartFormats" type="CT_ChartFormats" minOccurs="0"/>
1093 <xsd:element name="pivotHierarchies" type="CT_PivotHierarchies" minOccurs="0"/>
1094 <xsd:element name="pivotTableStyleInfo" minOccurs="0" maxOccurs="1" type="CT_PivotTableStyle"/>
1095 <xsd:element name="filters" minOccurs="0" maxOccurs="1" type="CT_PivotFilters"/>
1096 <xsd:element name="rowHierarchiesUsage" type="CT_RowHierarchiesUsage" minOccurs="0"
1097 maxOccurs="1"/>
1098 <xsd:element name="colHierarchiesUsage" type="CT_ColHierarchiesUsage" minOccurs="0"
1099 maxOccurs="1"/>
1100 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1101 </xsd:sequence>
1102 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
1103 <xsd:attribute name="cacheId" use="required" type="xsd:unsignedInt"/>
1104 <xsd:attribute name="dataOnRows" type="xsd:boolean" default="false"/>
1105 <xsd:attribute name="dataPosition" type="xsd:unsignedInt" use="optional"/>
1106 <xsd:attributeGroup ref="AG_AutoFormat"/>
1107 <xsd:attribute name="dataCaption" use="required" type="s:ST_Xstring"/>
1108 <xsd:attribute name="grandTotalCaption" type="s:ST_Xstring"/>
1109 <xsd:attribute name="errorCaption" type="s:ST_Xstring"/>
1110 <xsd:attribute name="showError" type="xsd:boolean" default="false"/>
1111 <xsd:attribute name="missingCaption" type="s:ST_Xstring"/>
1112 <xsd:attribute name="showMissing" type="xsd:boolean" default="true"/>
1113 <xsd:attribute name="pageStyle" type="s:ST_Xstring"/>
1114 <xsd:attribute name="pivotTableStyle" type="s:ST_Xstring"/>
1115 <xsd:attribute name="vacatedStyle" type="s:ST_Xstring"/>
1116 <xsd:attribute name="tag" type="s:ST_Xstring"/>
1117 <xsd:attribute name="updatedVersion" type="xsd:unsignedByte" default="0"/>
1118 <xsd:attribute name="minRefreshableVersion" type="xsd:unsignedByte" default="0"/>
1119 <xsd:attribute name="asteriskTotals" type="xsd:boolean" default="false"/>
1120 <xsd:attribute name="showItems" type="xsd:boolean" default="true"/>
1121 <xsd:attribute name="editData" type="xsd:boolean" default="false"/>
1122 <xsd:attribute name="disableFieldList" type="xsd:boolean" default="false"/>
1123 <xsd:attribute name="showCalcMbrs" type="xsd:boolean" default="true"/>
1124 <xsd:attribute name="visualTotals" type="xsd:boolean" default="true"/>
1125 <xsd:attribute name="showMultipleLabel" type="xsd:boolean" default="true"/>
1126 <xsd:attribute name="showDataDropDown" type="xsd:boolean" default="true"/>
1127 <xsd:attribute name="showDrill" type="xsd:boolean" default="true"/>
1128 <xsd:attribute name="printDrill" type="xsd:boolean" default="false"/>
1129 <xsd:attribute name="showMemberPropertyTips" type="xsd:boolean" default="true"/>
1130 <xsd:attribute name="showDataTips" type="xsd:boolean" default="true"/>
1131 <xsd:attribute name="enableWizard" type="xsd:boolean" default="true"/>
1132 <xsd:attribute name="enableDrill" type="xsd:boolean" default="true"/>
1133 <xsd:attribute name="enableFieldProperties" type="xsd:boolean" default="true"/>
1134 <xsd:attribute name="preserveFormatting" type="xsd:boolean" default="true"/>
1135 <xsd:attribute name="useAutoFormatting" type="xsd:boolean" default="false"/>
1136 <xsd:attribute name="pageWrap" type="xsd:unsignedInt" default="0"/>
1137 <xsd:attribute name="pageOverThenDown" type="xsd:boolean" default="false"/>
1138 <xsd:attribute name="subtotalHiddenItems" type="xsd:boolean" default="false"/>
1139 <xsd:attribute name="rowGrandTotals" type="xsd:boolean" default="true"/>
1140 <xsd:attribute name="colGrandTotals" type="xsd:boolean" default="true"/>
1141 <xsd:attribute name="fieldPrintTitles" type="xsd:boolean" default="false"/>
1142 <xsd:attribute name="itemPrintTitles" type="xsd:boolean" default="false"/>
1143 <xsd:attribute name="mergeItem" type="xsd:boolean" default="false"/>
1144 <xsd:attribute name="showDropZones" type="xsd:boolean" default="true"/>
1145 <xsd:attribute name="createdVersion" type="xsd:unsignedByte" default="0"/>
1146 <xsd:attribute name="indent" type="xsd:unsignedInt" default="1"/>
1147 <xsd:attribute name="showEmptyRow" type="xsd:boolean" default="false"/>
1148 <xsd:attribute name="showEmptyCol" type="xsd:boolean" default="false"/>
1149 <xsd:attribute name="showHeaders" type="xsd:boolean" default="true"/>
1150 <xsd:attribute name="compact" type="xsd:boolean" default="true"/>
1151 <xsd:attribute name="outline" type="xsd:boolean" default="false"/>
1152 <xsd:attribute name="outlineData" type="xsd:boolean" default="false"/>
1153 <xsd:attribute name="compactData" type="xsd:boolean" default="true"/>
1154 <xsd:attribute name="published" type="xsd:boolean" default="false"/>
1155 <xsd:attribute name="gridDropZones" type="xsd:boolean" default="false"/>
1156 <xsd:attribute name="immersive" type="xsd:boolean" default="true"/>
1157 <xsd:attribute name="multipleFieldFilters" type="xsd:boolean" default="true"/>
1158 <xsd:attribute name="chartFormat" type="xsd:unsignedInt" default="0"/>
1159 <xsd:attribute name="rowHeaderCaption" type="s:ST_Xstring"/>
1160 <xsd:attribute name="colHeaderCaption" type="s:ST_Xstring"/>
1161 <xsd:attribute name="fieldListSortAscending" type="xsd:boolean" default="false"/>
1162 <xsd:attribute name="mdxSubqueries" type="xsd:boolean" default="false"/>
1163 <xsd:attribute name="customListSort" type="xsd:boolean" use="optional" default="true"/>
1164 </xsd:complexType>
1165 <xsd:complexType name="CT_Location">
1166 <xsd:attribute name="ref" use="required" type="ST_Ref"/>
1167 <xsd:attribute name="firstHeaderRow" use="required" type="xsd:unsignedInt"/>
1168 <xsd:attribute name="firstDataRow" use="required" type="xsd:unsignedInt"/>
1169 <xsd:attribute name="firstDataCol" use="required" type="xsd:unsignedInt"/>
1170 <xsd:attribute name="rowPageCount" type="xsd:unsignedInt" default="0"/>
1171 <xsd:attribute name="colPageCount" type="xsd:unsignedInt" default="0"/>
1172 </xsd:complexType>
1173 <xsd:complexType name="CT_PivotFields">
1174 <xsd:sequence>
1175 <xsd:element name="pivotField" maxOccurs="unbounded" type="CT_PivotField"/>
1176 </xsd:sequence>
1177 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1178 </xsd:complexType>
1179 <xsd:complexType name="CT_PivotField">
1180 <xsd:sequence>
1181 <xsd:element name="items" minOccurs="0" type="CT_Items"/>
1182 <xsd:element name="autoSortScope" minOccurs="0" type="CT_AutoSortScope"/>
1183 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1184 </xsd:sequence>
1185 <xsd:attribute name="name" type="s:ST_Xstring"/>
1186 <xsd:attribute name="axis" use="optional" type="ST_Axis"/>
1187 <xsd:attribute name="dataField" type="xsd:boolean" default="false"/>
1188 <xsd:attribute name="subtotalCaption" type="s:ST_Xstring"/>
1189 <xsd:attribute name="showDropDowns" type="xsd:boolean" default="true"/>
1190 <xsd:attribute name="hiddenLevel" type="xsd:boolean" default="false"/>
1191 <xsd:attribute name="uniqueMemberProperty" type="s:ST_Xstring"/>
1192 <xsd:attribute name="compact" type="xsd:boolean" default="true"/>
1193 <xsd:attribute name="allDrilled" type="xsd:boolean" default="false"/>
1194 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
1195 <xsd:attribute name="outline" type="xsd:boolean" default="true"/>
1196 <xsd:attribute name="subtotalTop" type="xsd:boolean" default="true"/>
1197 <xsd:attribute name="dragToRow" type="xsd:boolean" default="true"/>
1198 <xsd:attribute name="dragToCol" type="xsd:boolean" default="true"/>
1199 <xsd:attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false"/>
1200 <xsd:attribute name="dragToPage" type="xsd:boolean" default="true"/>
1201 <xsd:attribute name="dragToData" type="xsd:boolean" default="true"/>
1202 <xsd:attribute name="dragOff" type="xsd:boolean" default="true"/>
1203 <xsd:attribute name="showAll" type="xsd:boolean" default="true"/>
1204 <xsd:attribute name="insertBlankRow" type="xsd:boolean" default="false"/>
1205 <xsd:attribute name="serverField" type="xsd:boolean" default="false"/>
1206 <xsd:attribute name="insertPageBreak" type="xsd:boolean" default="false"/>
1207 <xsd:attribute name="autoShow" type="xsd:boolean" default="false"/>
1208 <xsd:attribute name="topAutoShow" type="xsd:boolean" default="true"/>
1209 <xsd:attribute name="hideNewItems" type="xsd:boolean" default="false"/>
1210 <xsd:attribute name="measureFilter" type="xsd:boolean" default="false"/>
1211 <xsd:attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false"/>
1212 <xsd:attribute name="itemPageCount" type="xsd:unsignedInt" default="10"/>
1213 <xsd:attribute name="sortType" type="ST_FieldSortType" default="manual"/>
1214 <xsd:attribute name="dataSourceSort" type="xsd:boolean" use="optional"/>
1215 <xsd:attribute name="nonAutoSortDefault" type="xsd:boolean" default="false"/>
1216 <xsd:attribute name="rankBy" type="xsd:unsignedInt" use="optional"/>
1217 <xsd:attribute name="defaultSubtotal" type="xsd:boolean" default="true"/>
1218 <xsd:attribute name="sumSubtotal" type="xsd:boolean" default="false"/>
1219 <xsd:attribute name="countASubtotal" type="xsd:boolean" default="false"/>
1220 <xsd:attribute name="avgSubtotal" type="xsd:boolean" default="false"/>
1221 <xsd:attribute name="maxSubtotal" type="xsd:boolean" default="false"/>
1222 <xsd:attribute name="minSubtotal" type="xsd:boolean" default="false"/>
1223 <xsd:attribute name="productSubtotal" type="xsd:boolean" default="false"/>
1224 <xsd:attribute name="countSubtotal" type="xsd:boolean" default="false"/>
1225 <xsd:attribute name="stdDevSubtotal" type="xsd:boolean" default="false"/>
1226 <xsd:attribute name="stdDevPSubtotal" type="xsd:boolean" default="false"/>
1227 <xsd:attribute name="varSubtotal" type="xsd:boolean" default="false"/>
1228 <xsd:attribute name="varPSubtotal" type="xsd:boolean" default="false"/>
1229 <xsd:attribute name="showPropCell" type="xsd:boolean" use="optional" default="false"/>
1230 <xsd:attribute name="showPropTip" type="xsd:boolean" use="optional" default="false"/>
1231 <xsd:attribute name="showPropAsCaption" type="xsd:boolean" use="optional" default="false"/>
1232 <xsd:attribute name="defaultAttributeDrillState" type="xsd:boolean" use="optional"
1233 default="false"/>
1234 </xsd:complexType>
1235 <xsd:complexType name="CT_AutoSortScope">
1236 <xsd:sequence>
1237 <xsd:element name="pivotArea" type="CT_PivotArea"/>
1238 </xsd:sequence>
1239 </xsd:complexType>
1240 <xsd:complexType name="CT_Items">
1241 <xsd:sequence>
1242 <xsd:element name="item" maxOccurs="unbounded" type="CT_Item"/>
1243 </xsd:sequence>
1244 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1245 </xsd:complexType>
1246 <xsd:complexType name="CT_Item">
1247 <xsd:attribute name="n" type="s:ST_Xstring"/>
1248 <xsd:attribute name="t" type="ST_ItemType" default="data"/>
1249 <xsd:attribute name="h" type="xsd:boolean" default="false"/>
1250 <xsd:attribute name="s" type="xsd:boolean" default="false"/>
1251 <xsd:attribute name="sd" type="xsd:boolean" default="true"/>
1252 <xsd:attribute name="f" type="xsd:boolean" default="false"/>
1253 <xsd:attribute name="m" type="xsd:boolean" default="false"/>
1254 <xsd:attribute name="c" type="xsd:boolean" default="false"/>
1255 <xsd:attribute name="x" type="xsd:unsignedInt" use="optional"/>
1256 <xsd:attribute name="d" type="xsd:boolean" default="false"/>
1257 <xsd:attribute name="e" type="xsd:boolean" default="true"/>
1258 </xsd:complexType>
1259 <xsd:complexType name="CT_PageFields">
1260 <xsd:sequence>
1261 <xsd:element name="pageField" maxOccurs="unbounded" type="CT_PageField"/>
1262 </xsd:sequence>
1263 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1264 </xsd:complexType>
1265 <xsd:complexType name="CT_PageField">
1266 <xsd:sequence minOccurs="0">
1267 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1268 </xsd:sequence>
1269 <xsd:attribute name="fld" use="required" type="xsd:int"/>
1270 <xsd:attribute name="item" use="optional" type="xsd:unsignedInt"/>
1271 <xsd:attribute name="hier" type="xsd:int"/>
1272 <xsd:attribute name="name" type="s:ST_Xstring"/>
1273 <xsd:attribute name="cap" type="s:ST_Xstring"/>
1274 </xsd:complexType>
1275 <xsd:complexType name="CT_DataFields">
1276 <xsd:sequence>
1277 <xsd:element name="dataField" maxOccurs="unbounded" type="CT_DataField"/>
1278 </xsd:sequence>
1279 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1280 </xsd:complexType>
1281 <xsd:complexType name="CT_DataField">
1282 <xsd:sequence>
1283 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1284 </xsd:sequence>
1285 <xsd:attribute name="name" use="optional" type="s:ST_Xstring"/>
1286 <xsd:attribute name="fld" type="xsd:unsignedInt" use="required"/>
1287 <xsd:attribute name="subtotal" type="ST_DataConsolidateFunction" default="sum"/>
1288 <xsd:attribute name="showDataAs" type="ST_ShowDataAs" default="normal"/>
1289 <xsd:attribute name="baseField" type="xsd:int" default="-1"/>
1290 <xsd:attribute name="baseItem" type="xsd:unsignedInt" default="1048832"/>
1291 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
1292 </xsd:complexType>
1293 <xsd:complexType name="CT_rowItems">
1294 <xsd:sequence>
1295 <xsd:element name="i" maxOccurs="unbounded" type="CT_I"/>
1296 </xsd:sequence>
1297 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1298 </xsd:complexType>
1299 <xsd:complexType name="CT_colItems">
1300 <xsd:sequence>
1301 <xsd:element name="i" maxOccurs="unbounded" type="CT_I"/>
1302 </xsd:sequence>
1303 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1304 </xsd:complexType>
1305 <xsd:complexType name="CT_I">
1306 <xsd:sequence>
1307 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_X"/>
1308 </xsd:sequence>
1309 <xsd:attribute name="t" type="ST_ItemType" default="data"/>
1310 <xsd:attribute name="r" type="xsd:unsignedInt" default="0"/>
1311 <xsd:attribute name="i" type="xsd:unsignedInt" default="0"/>
1312 </xsd:complexType>
1313 <xsd:complexType name="CT_X">
1314 <xsd:attribute name="v" type="xsd:int" default="0"/>
1315 </xsd:complexType>
1316 <xsd:complexType name="CT_RowFields">
1317 <xsd:sequence>
1318 <xsd:element name="field" maxOccurs="unbounded" type="CT_Field"/>
1319 </xsd:sequence>
1320 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1321 </xsd:complexType>
1322 <xsd:complexType name="CT_ColFields">
1323 <xsd:sequence>
1324 <xsd:element name="field" maxOccurs="unbounded" type="CT_Field"/>
1325 </xsd:sequence>
1326 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1327 </xsd:complexType>
1328 <xsd:complexType name="CT_Field">
1329 <xsd:attribute name="x" type="xsd:int" use="required"/>
1330 </xsd:complexType>
1331 <xsd:complexType name="CT_Formats">
1332 <xsd:sequence>
1333 <xsd:element name="format" maxOccurs="unbounded" type="CT_Format"/>
1334 </xsd:sequence>
1335 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1336 </xsd:complexType>
1337 <xsd:complexType name="CT_Format">
1338 <xsd:sequence>
1339 <xsd:element name="pivotArea" type="CT_PivotArea"/>
1340 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1341 </xsd:sequence>
1342 <xsd:attribute name="action" type="ST_FormatAction" default="formatting"/>
1343 <xsd:attribute name="dxfId" type="ST_DxfId" use="optional"/>
1344 </xsd:complexType>
1345 <xsd:complexType name="CT_ConditionalFormats">
1346 <xsd:sequence>
1347 <xsd:element name="conditionalFormat" maxOccurs="unbounded" type="CT_ConditionalFormat"/>
1348 </xsd:sequence>
1349 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1350 </xsd:complexType>
1351 <xsd:complexType name="CT_ConditionalFormat">
1352 <xsd:sequence>
1353 <xsd:element name="pivotAreas" type="CT_PivotAreas"/>
1354 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1355 </xsd:sequence>
1356 <xsd:attribute name="scope" type="ST_Scope" default="selection"/>
1357 <xsd:attribute name="type" type="ST_Type" default="none"/>
1358 <xsd:attribute name="priority" use="required" type="xsd:unsignedInt"/>
1359 </xsd:complexType>
1360 <xsd:complexType name="CT_PivotAreas">
1361 <xsd:sequence>
1362 <xsd:element name="pivotArea" minOccurs="0" maxOccurs="unbounded" type="CT_PivotArea"/>
1363 </xsd:sequence>
1364 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1365 </xsd:complexType>
1366 <xsd:simpleType name="ST_Scope">
1367 <xsd:restriction base="xsd:string">
1368 <xsd:enumeration value="selection"/>
1369 <xsd:enumeration value="data"/>
1370 <xsd:enumeration value="field"/>
1371 </xsd:restriction>
1372 </xsd:simpleType>
1373 <xsd:simpleType name="ST_Type">
1374 <xsd:restriction base="xsd:string">
1375 <xsd:enumeration value="none"/>
1376 <xsd:enumeration value="all"/>
1377 <xsd:enumeration value="row"/>
1378 <xsd:enumeration value="column"/>
1379 </xsd:restriction>
1380 </xsd:simpleType>
1381 <xsd:complexType name="CT_ChartFormats">
1382 <xsd:sequence>
1383 <xsd:element name="chartFormat" maxOccurs="unbounded" type="CT_ChartFormat"/>
1384 </xsd:sequence>
1385 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1386 </xsd:complexType>
1387 <xsd:complexType name="CT_ChartFormat">
1388 <xsd:sequence>
1389 <xsd:element name="pivotArea" type="CT_PivotArea"/>
1390 </xsd:sequence>
1391 <xsd:attribute name="chart" use="required" type="xsd:unsignedInt"/>
1392 <xsd:attribute name="format" use="required" type="xsd:unsignedInt"/>
1393 <xsd:attribute name="series" type="xsd:boolean" default="false"/>
1394 </xsd:complexType>
1395 <xsd:complexType name="CT_PivotHierarchies">
1396 <xsd:sequence>
1397 <xsd:element name="pivotHierarchy" maxOccurs="unbounded" type="CT_PivotHierarchy"/>
1398 </xsd:sequence>
1399 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1400 </xsd:complexType>
1401 <xsd:complexType name="CT_PivotHierarchy">
1402 <xsd:sequence>
1403 <xsd:element name="mps" minOccurs="0" type="CT_MemberProperties"/>
1404 <xsd:element name="members" minOccurs="0" maxOccurs="unbounded" type="CT_Members"/>
1405 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1406 </xsd:sequence>
1407 <xsd:attribute name="outline" type="xsd:boolean" default="false"/>
1408 <xsd:attribute name="multipleItemSelectionAllowed" type="xsd:boolean" default="false"/>
1409 <xsd:attribute name="subtotalTop" type="xsd:boolean" default="false"/>
1410 <xsd:attribute name="showInFieldList" type="xsd:boolean" default="true"/>
1411 <xsd:attribute name="dragToRow" type="xsd:boolean" default="true"/>
1412 <xsd:attribute name="dragToCol" type="xsd:boolean" default="true"/>
1413 <xsd:attribute name="dragToPage" type="xsd:boolean" default="true"/>
1414 <xsd:attribute name="dragToData" type="xsd:boolean" default="false"/>
1415 <xsd:attribute name="dragOff" type="xsd:boolean" default="true"/>
1416 <xsd:attribute name="includeNewItemsInFilter" type="xsd:boolean" default="false"/>
1417 <xsd:attribute name="caption" type="s:ST_Xstring" use="optional"/>
1418 </xsd:complexType>
1419 <xsd:complexType name="CT_RowHierarchiesUsage">
1420 <xsd:sequence>
1421 <xsd:element name="rowHierarchyUsage" minOccurs="1" maxOccurs="unbounded"
1422 type="CT_HierarchyUsage"/>
1423 </xsd:sequence>
1424 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1425 </xsd:complexType>
1426 <xsd:complexType name="CT_ColHierarchiesUsage">
1427 <xsd:sequence>
1428 <xsd:element name="colHierarchyUsage" minOccurs="1" maxOccurs="unbounded"
1429 type="CT_HierarchyUsage"/>
1430 </xsd:sequence>
1431 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1432 </xsd:complexType>
1433 <xsd:complexType name="CT_HierarchyUsage">
1434 <xsd:attribute name="hierarchyUsage" type="xsd:int" use="required"/>
1435 </xsd:complexType>
1436 <xsd:complexType name="CT_MemberProperties">
1437 <xsd:sequence>
1438 <xsd:element name="mp" maxOccurs="unbounded" type="CT_MemberProperty"/>
1439 </xsd:sequence>
1440 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1441 </xsd:complexType>
1442 <xsd:complexType name="CT_MemberProperty">
1443 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
1444 <xsd:attribute name="showCell" type="xsd:boolean" use="optional" default="false"/>
1445 <xsd:attribute name="showTip" type="xsd:boolean" use="optional" default="false"/>
1446 <xsd:attribute name="showAsCaption" type="xsd:boolean" use="optional" default="false"/>
1447 <xsd:attribute name="nameLen" type="xsd:unsignedInt" use="optional"/>
1448 <xsd:attribute name="pPos" type="xsd:unsignedInt" use="optional"/>
1449 <xsd:attribute name="pLen" type="xsd:unsignedInt" use="optional"/>
1450 <xsd:attribute name="level" type="xsd:unsignedInt" use="optional"/>
1451 <xsd:attribute name="field" use="required" type="xsd:unsignedInt"/>
1452 </xsd:complexType>
1453 <xsd:complexType name="CT_Members">
1454 <xsd:sequence>
1455 <xsd:element name="member" maxOccurs="unbounded" type="CT_Member"/>
1456 </xsd:sequence>
1457 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1458 <xsd:attribute name="level" use="optional" type="xsd:unsignedInt"/>
1459 </xsd:complexType>
1460 <xsd:complexType name="CT_Member">
1461 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
1462 </xsd:complexType>
1463 <xsd:complexType name="CT_Dimensions">
1464 <xsd:sequence>
1465 <xsd:element name="dimension" minOccurs="0" maxOccurs="unbounded" type="CT_PivotDimension"/>
1466 </xsd:sequence>
1467 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1468 </xsd:complexType>
1469 <xsd:complexType name="CT_PivotDimension">
1470 <xsd:attribute name="measure" type="xsd:boolean" default="false"/>
1471 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
1472 <xsd:attribute name="uniqueName" use="required" type="s:ST_Xstring"/>
1473 <xsd:attribute name="caption" use="required" type="s:ST_Xstring"/>
1474 </xsd:complexType>
1475 <xsd:complexType name="CT_MeasureGroups">
1476 <xsd:sequence>
1477 <xsd:element name="measureGroup" minOccurs="0" maxOccurs="unbounded" type="CT_MeasureGroup"/>
1478 </xsd:sequence>
1479 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1480 </xsd:complexType>
1481 <xsd:complexType name="CT_MeasureDimensionMaps">
1482 <xsd:sequence>
1483 <xsd:element name="map" minOccurs="0" maxOccurs="unbounded" type="CT_MeasureDimensionMap"/>
1484 </xsd:sequence>
1485 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1486 </xsd:complexType>
1487 <xsd:complexType name="CT_MeasureGroup">
1488 <xsd:attribute name="name" use="required" type="s:ST_Xstring"/>
1489 <xsd:attribute name="caption" use="required" type="s:ST_Xstring"/>
1490 </xsd:complexType>
1491 <xsd:complexType name="CT_MeasureDimensionMap">
1492 <xsd:attribute name="measureGroup" use="optional" type="xsd:unsignedInt"/>
1493 <xsd:attribute name="dimension" use="optional" type="xsd:unsignedInt"/>
1494 </xsd:complexType>
1495 <xsd:complexType name="CT_PivotTableStyle">
1496 <xsd:attribute name="name" type="xsd:string"/>
1497 <xsd:attribute name="showRowHeaders" type="xsd:boolean"/>
1498 <xsd:attribute name="showColHeaders" type="xsd:boolean"/>
1499 <xsd:attribute name="showRowStripes" type="xsd:boolean"/>
1500 <xsd:attribute name="showColStripes" type="xsd:boolean"/>
1501 <xsd:attribute name="showLastColumn" type="xsd:boolean" use="optional"/>
1502 </xsd:complexType>
1503 <xsd:complexType name="CT_PivotFilters">
1504 <xsd:sequence>
1505 <xsd:element name="filter" minOccurs="0" maxOccurs="unbounded" type="CT_PivotFilter"/>
1506 </xsd:sequence>
1507 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
1508 </xsd:complexType>
1509 <xsd:complexType name="CT_PivotFilter">
1510 <xsd:sequence>
1511 <xsd:element name="autoFilter" minOccurs="1" maxOccurs="1" type="CT_AutoFilter"/>
1512 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1513 </xsd:sequence>
1514 <xsd:attribute name="fld" use="required" type="xsd:unsignedInt"/>
1515 <xsd:attribute name="mpFld" type="xsd:unsignedInt" use="optional"/>
1516 <xsd:attribute name="type" use="required" type="ST_PivotFilterType"/>
1517 <xsd:attribute name="evalOrder" use="optional" type="xsd:int" default="0"/>
1518 <xsd:attribute name="id" use="required" type="xsd:unsignedInt"/>
1519 <xsd:attribute name="iMeasureHier" use="optional" type="xsd:unsignedInt"/>
1520 <xsd:attribute name="iMeasureFld" use="optional" type="xsd:unsignedInt"/>
1521 <xsd:attribute name="name" type="s:ST_Xstring"/>
1522 <xsd:attribute name="description" type="s:ST_Xstring"/>
1523 <xsd:attribute name="stringValue1" type="s:ST_Xstring"/>
1524 <xsd:attribute name="stringValue2" type="s:ST_Xstring"/>
1525 </xsd:complexType>
1526 <xsd:simpleType name="ST_ShowDataAs">
1527 <xsd:restriction base="xsd:string">
1528 <xsd:enumeration value="normal"/>
1529 <xsd:enumeration value="difference"/>
1530 <xsd:enumeration value="percent"/>
1531 <xsd:enumeration value="percentDiff"/>
1532 <xsd:enumeration value="runTotal"/>
1533 <xsd:enumeration value="percentOfRow"/>
1534 <xsd:enumeration value="percentOfCol"/>
1535 <xsd:enumeration value="percentOfTotal"/>
1536 <xsd:enumeration value="index"/>
1537 </xsd:restriction>
1538 </xsd:simpleType>
1539 <xsd:simpleType name="ST_ItemType">
1540 <xsd:restriction base="xsd:string">
1541 <xsd:enumeration value="data"/>
1542 <xsd:enumeration value="default"/>
1543 <xsd:enumeration value="sum"/>
1544 <xsd:enumeration value="countA"/>
1545 <xsd:enumeration value="avg"/>
1546 <xsd:enumeration value="max"/>
1547 <xsd:enumeration value="min"/>
1548 <xsd:enumeration value="product"/>
1549 <xsd:enumeration value="count"/>
1550 <xsd:enumeration value="stdDev"/>
1551 <xsd:enumeration value="stdDevP"/>
1552 <xsd:enumeration value="var"/>
1553 <xsd:enumeration value="varP"/>
1554 <xsd:enumeration value="grand"/>
1555 <xsd:enumeration value="blank"/>
1556 </xsd:restriction>
1557 </xsd:simpleType>
1558 <xsd:simpleType name="ST_FormatAction">
1559 <xsd:restriction base="xsd:string">
1560 <xsd:enumeration value="blank"/>
1561 <xsd:enumeration value="formatting"/>
1562 <xsd:enumeration value="drill"/>
1563 <xsd:enumeration value="formula"/>
1564 </xsd:restriction>
1565 </xsd:simpleType>
1566 <xsd:simpleType name="ST_FieldSortType">
1567 <xsd:restriction base="xsd:string">
1568 <xsd:enumeration value="manual"/>
1569 <xsd:enumeration value="ascending"/>
1570 <xsd:enumeration value="descending"/>
1571 </xsd:restriction>
1572 </xsd:simpleType>
1573 <xsd:simpleType name="ST_PivotFilterType">
1574 <xsd:restriction base="xsd:string">
1575 <xsd:enumeration value="unknown"/>
1576 <xsd:enumeration value="count"/>
1577 <xsd:enumeration value="percent"/>
1578 <xsd:enumeration value="sum"/>
1579 <xsd:enumeration value="captionEqual"/>
1580 <xsd:enumeration value="captionNotEqual"/>
1581 <xsd:enumeration value="captionBeginsWith"/>
1582 <xsd:enumeration value="captionNotBeginsWith"/>
1583 <xsd:enumeration value="captionEndsWith"/>
1584 <xsd:enumeration value="captionNotEndsWith"/>
1585 <xsd:enumeration value="captionContains"/>
1586 <xsd:enumeration value="captionNotContains"/>
1587 <xsd:enumeration value="captionGreaterThan"/>
1588 <xsd:enumeration value="captionGreaterThanOrEqual"/>
1589 <xsd:enumeration value="captionLessThan"/>
1590 <xsd:enumeration value="captionLessThanOrEqual"/>
1591 <xsd:enumeration value="captionBetween"/>
1592 <xsd:enumeration value="captionNotBetween"/>
1593 <xsd:enumeration value="valueEqual"/>
1594 <xsd:enumeration value="valueNotEqual"/>
1595 <xsd:enumeration value="valueGreaterThan"/>
1596 <xsd:enumeration value="valueGreaterThanOrEqual"/>
1597 <xsd:enumeration value="valueLessThan"/>
1598 <xsd:enumeration value="valueLessThanOrEqual"/>
1599 <xsd:enumeration value="valueBetween"/>
1600 <xsd:enumeration value="valueNotBetween"/>
1601 <xsd:enumeration value="dateEqual"/>
1602 <xsd:enumeration value="dateNotEqual"/>
1603 <xsd:enumeration value="dateOlderThan"/>
1604 <xsd:enumeration value="dateOlderThanOrEqual"/>
1605 <xsd:enumeration value="dateNewerThan"/>
1606 <xsd:enumeration value="dateNewerThanOrEqual"/>
1607 <xsd:enumeration value="dateBetween"/>
1608 <xsd:enumeration value="dateNotBetween"/>
1609 <xsd:enumeration value="tomorrow"/>
1610 <xsd:enumeration value="today"/>
1611 <xsd:enumeration value="yesterday"/>
1612 <xsd:enumeration value="nextWeek"/>
1613 <xsd:enumeration value="thisWeek"/>
1614 <xsd:enumeration value="lastWeek"/>
1615 <xsd:enumeration value="nextMonth"/>
1616 <xsd:enumeration value="thisMonth"/>
1617 <xsd:enumeration value="lastMonth"/>
1618 <xsd:enumeration value="nextQuarter"/>
1619 <xsd:enumeration value="thisQuarter"/>
1620 <xsd:enumeration value="lastQuarter"/>
1621 <xsd:enumeration value="nextYear"/>
1622 <xsd:enumeration value="thisYear"/>
1623 <xsd:enumeration value="lastYear"/>
1624 <xsd:enumeration value="yearToDate"/>
1625 <xsd:enumeration value="Q1"/>
1626 <xsd:enumeration value="Q2"/>
1627 <xsd:enumeration value="Q3"/>
1628 <xsd:enumeration value="Q4"/>
1629 <xsd:enumeration value="M1"/>
1630 <xsd:enumeration value="M2"/>
1631 <xsd:enumeration value="M3"/>
1632 <xsd:enumeration value="M4"/>
1633 <xsd:enumeration value="M5"/>
1634 <xsd:enumeration value="M6"/>
1635 <xsd:enumeration value="M7"/>
1636 <xsd:enumeration value="M8"/>
1637 <xsd:enumeration value="M9"/>
1638 <xsd:enumeration value="M10"/>
1639 <xsd:enumeration value="M11"/>
1640 <xsd:enumeration value="M12"/>
1641 </xsd:restriction>
1642 </xsd:simpleType>
1643 <xsd:complexType name="CT_PivotArea">
1644 <xsd:sequence>
1645 <xsd:element name="references" minOccurs="0" type="CT_PivotAreaReferences"/>
1646 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1647 </xsd:sequence>
1648 <xsd:attribute name="field" use="optional" type="xsd:int"/>
1649 <xsd:attribute name="type" type="ST_PivotAreaType" default="normal"/>
1650 <xsd:attribute name="dataOnly" type="xsd:boolean" default="true"/>
1651 <xsd:attribute name="labelOnly" type="xsd:boolean" default="false"/>
1652 <xsd:attribute name="grandRow" type="xsd:boolean" default="false"/>
1653 <xsd:attribute name="grandCol" type="xsd:boolean" default="false"/>
1654 <xsd:attribute name="cacheIndex" type="xsd:boolean" default="false"/>
1655 <xsd:attribute name="outline" type="xsd:boolean" default="true"/>
1656 <xsd:attribute name="offset" type="ST_Ref"/>
1657 <xsd:attribute name="collapsedLevelsAreSubtotals" type="xsd:boolean" default="false"/>
1658 <xsd:attribute name="axis" type="ST_Axis" use="optional"/>
1659 <xsd:attribute name="fieldPosition" type="xsd:unsignedInt" use="optional"/>
1660 </xsd:complexType>
1661 <xsd:simpleType name="ST_PivotAreaType">
1662 <xsd:restriction base="xsd:string">
1663 <xsd:enumeration value="none"/>
1664 <xsd:enumeration value="normal"/>
1665 <xsd:enumeration value="data"/>
1666 <xsd:enumeration value="all"/>
1667 <xsd:enumeration value="origin"/>
1668 <xsd:enumeration value="button"/>
1669 <xsd:enumeration value="topEnd"/>
1670 <xsd:enumeration value="topRight"/>
1671 </xsd:restriction>
1672 </xsd:simpleType>
1673 <xsd:complexType name="CT_PivotAreaReferences">
1674 <xsd:sequence>
1675 <xsd:element name="reference" maxOccurs="unbounded" type="CT_PivotAreaReference"/>
1676 </xsd:sequence>
1677 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1678 </xsd:complexType>
1679 <xsd:complexType name="CT_PivotAreaReference">
1680 <xsd:sequence>
1681 <xsd:element name="x" minOccurs="0" maxOccurs="unbounded" type="CT_Index"/>
1682 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1683 </xsd:sequence>
1684 <xsd:attribute name="field" use="optional" type="xsd:unsignedInt"/>
1685 <xsd:attribute name="count" type="xsd:unsignedInt"/>
1686 <xsd:attribute name="selected" type="xsd:boolean" default="true"/>
1687 <xsd:attribute name="byPosition" type="xsd:boolean" default="false"/>
1688 <xsd:attribute name="relative" type="xsd:boolean" default="false"/>
1689 <xsd:attribute name="defaultSubtotal" type="xsd:boolean" default="false"/>
1690 <xsd:attribute name="sumSubtotal" type="xsd:boolean" default="false"/>
1691 <xsd:attribute name="countASubtotal" type="xsd:boolean" default="false"/>
1692 <xsd:attribute name="avgSubtotal" type="xsd:boolean" default="false"/>
1693 <xsd:attribute name="maxSubtotal" type="xsd:boolean" default="false"/>
1694 <xsd:attribute name="minSubtotal" type="xsd:boolean" default="false"/>
1695 <xsd:attribute name="productSubtotal" type="xsd:boolean" default="false"/>
1696 <xsd:attribute name="countSubtotal" type="xsd:boolean" default="false"/>
1697 <xsd:attribute name="stdDevSubtotal" type="xsd:boolean" default="false"/>
1698 <xsd:attribute name="stdDevPSubtotal" type="xsd:boolean" default="false"/>
1699 <xsd:attribute name="varSubtotal" type="xsd:boolean" default="false"/>
1700 <xsd:attribute name="varPSubtotal" type="xsd:boolean" default="false"/>
1701 </xsd:complexType>
1702 <xsd:complexType name="CT_Index">
1703 <xsd:attribute name="v" use="required" type="xsd:unsignedInt"/>
1704 </xsd:complexType>
1705 <xsd:simpleType name="ST_Axis">
1706 <xsd:restriction base="xsd:string">
1707 <xsd:enumeration value="axisRow"/>
1708 <xsd:enumeration value="axisCol"/>
1709 <xsd:enumeration value="axisPage"/>
1710 <xsd:enumeration value="axisValues"/>
1711 </xsd:restriction>
1712 </xsd:simpleType>
1713 <xsd:element name="queryTable" type="CT_QueryTable"/>
1714 <xsd:complexType name="CT_QueryTable">
1715 <xsd:sequence>
1716 <xsd:element name="queryTableRefresh" type="CT_QueryTableRefresh" minOccurs="0" maxOccurs="1"/>
1717 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
1718 </xsd:sequence>
1719 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
1720 <xsd:attribute name="headers" type="xsd:boolean" use="optional" default="true"/>
1721 <xsd:attribute name="rowNumbers" type="xsd:boolean" use="optional" default="false"/>
1722 <xsd:attribute name="disableRefresh" type="xsd:boolean" use="optional" default="false"/>
1723 <xsd:attribute name="backgroundRefresh" type="xsd:boolean" use="optional" default="true"/>
1724 <xsd:attribute name="firstBackgroundRefresh" type="xsd:boolean" use="optional" default="false"/>
1725 <xsd:attribute name="refreshOnLoad" type="xsd:boolean" use="optional" default="false"/>
1726 <xsd:attribute name="growShrinkType" type="ST_GrowShrinkType" use="optional"
1727 default="insertDelete"/>
1728 <xsd:attribute name="fillFormulas" type="xsd:boolean" use="optional" default="false"/>
1729 <xsd:attribute name="removeDataOnSave" type="xsd:boolean" use="optional" default="false"/>
1730 <xsd:attribute name="disableEdit" type="xsd:boolean" use="optional" default="false"/>
1731 <xsd:attribute name="preserveFormatting" type="xsd:boolean" use="optional" default="true"/>
1732 <xsd:attribute name="adjustColumnWidth" type="xsd:boolean" use="optional" default="true"/>
1733 <xsd:attribute name="intermediate" type="xsd:boolean" use="optional" default="false"/>
1734 <xsd:attribute name="connectionId" type="xsd:unsignedInt" use="required"/>
1735 <xsd:attributeGroup ref="AG_AutoFormat"/>
1736 </xsd:complexType>
1737 <xsd:complexType name="CT_QueryTableRefresh">
1738 <xsd:sequence>
1739 <xsd:element name="queryTableFields" type="CT_QueryTableFields" minOccurs="1" maxOccurs="1"/>
1740 <xsd:element name="queryTableDeletedFields" type="CT_QueryTableDeletedFields" minOccurs="0"
1741 maxOccurs="1"/>
1742 <xsd:element name="sortState" minOccurs="0" maxOccurs="1" type="CT_SortState"/>
1743 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
1744 </xsd:sequence>
1745 <xsd:attribute name="preserveSortFilterLayout" type="xsd:boolean" use="optional" default="true"/>
1746 <xsd:attribute name="fieldIdWrapped" type="xsd:boolean" use="optional" default="false"/>
1747 <xsd:attribute name="headersInLastRefresh" type="xsd:boolean" use="optional" default="true"/>
1748 <xsd:attribute name="minimumVersion" type="xsd:unsignedByte" use="optional" default="0"/>
1749 <xsd:attribute name="nextId" type="xsd:unsignedInt" use="optional" default="1"/>
1750 <xsd:attribute name="unboundColumnsLeft" type="xsd:unsignedInt" use="optional" default="0"/>
1751 <xsd:attribute name="unboundColumnsRight" type="xsd:unsignedInt" use="optional" default="0"/>
1752 </xsd:complexType>
1753 <xsd:complexType name="CT_QueryTableDeletedFields">
1754 <xsd:sequence>
1755 <xsd:element name="deletedField" type="CT_DeletedField" minOccurs="1" maxOccurs="unbounded"/>
1756 </xsd:sequence>
1757 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
1758 </xsd:complexType>
1759 <xsd:complexType name="CT_DeletedField">
1760 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
1761 </xsd:complexType>
1762 <xsd:complexType name="CT_QueryTableFields">
1763 <xsd:sequence>
1764 <xsd:element name="queryTableField" type="CT_QueryTableField" minOccurs="0"
1765 maxOccurs="unbounded"/>
1766 </xsd:sequence>
1767 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
1768 </xsd:complexType>
1769 <xsd:complexType name="CT_QueryTableField">
1770 <xsd:sequence minOccurs="0">
1771 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
1772 </xsd:sequence>
1773 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
1774 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
1775 <xsd:attribute name="dataBound" type="xsd:boolean" use="optional" default="true"/>
1776 <xsd:attribute name="rowNumbers" type="xsd:boolean" use="optional" default="false"/>
1777 <xsd:attribute name="fillFormulas" type="xsd:boolean" use="optional" default="false"/>
1778 <xsd:attribute name="clipped" type="xsd:boolean" use="optional" default="false"/>
1779 <xsd:attribute name="tableColumnId" type="xsd:unsignedInt" default="0"/>
1780 </xsd:complexType>
1781 <xsd:simpleType name="ST_GrowShrinkType">
1782 <xsd:restriction base="xsd:string">
1783 <xsd:enumeration value="insertDelete"/>
1784 <xsd:enumeration value="insertClear"/>
1785 <xsd:enumeration value="overwriteClear"/>
1786 </xsd:restriction>
1787 </xsd:simpleType>
1788 <xsd:element name="sst" type="CT_Sst"/>
1789 <xsd:complexType name="CT_Sst">
1790 <xsd:sequence>
1791 <xsd:element name="si" type="CT_Rst" minOccurs="0" maxOccurs="unbounded"/>
1792 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1793 </xsd:sequence>
1794 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
1795 <xsd:attribute name="uniqueCount" type="xsd:unsignedInt" use="optional"/>
1796 </xsd:complexType>
1797 <xsd:simpleType name="ST_PhoneticType">
1798 <xsd:restriction base="xsd:string">
1799 <xsd:enumeration value="halfwidthKatakana"/>
1800 <xsd:enumeration value="fullwidthKatakana"/>
1801 <xsd:enumeration value="Hiragana"/>
1802 <xsd:enumeration value="noConversion"/>
1803 </xsd:restriction>
1804 </xsd:simpleType>
1805 <xsd:simpleType name="ST_PhoneticAlignment">
1806 <xsd:restriction base="xsd:string">
1807 <xsd:enumeration value="noControl"/>
1808 <xsd:enumeration value="left"/>
1809 <xsd:enumeration value="center"/>
1810 <xsd:enumeration value="distributed"/>
1811 </xsd:restriction>
1812 </xsd:simpleType>
1813 <xsd:complexType name="CT_PhoneticRun">
1814 <xsd:sequence>
1815 <xsd:element name="t" type="s:ST_Xstring" minOccurs="1" maxOccurs="1"/>
1816 </xsd:sequence>
1817 <xsd:attribute name="sb" type="xsd:unsignedInt" use="required"/>
1818 <xsd:attribute name="eb" type="xsd:unsignedInt" use="required"/>
1819 </xsd:complexType>
1820 <xsd:complexType name="CT_RElt">
1821 <xsd:sequence>
1822 <xsd:element name="rPr" type="CT_RPrElt" minOccurs="0" maxOccurs="1"/>
1823 <xsd:element name="t" type="s:ST_Xstring" minOccurs="1" maxOccurs="1"/>
1824 </xsd:sequence>
1825 </xsd:complexType>
1826 <xsd:complexType name="CT_RPrElt">
1827 <xsd:choice maxOccurs="unbounded">
1828 <xsd:element name="rFont" type="CT_FontName" minOccurs="0" maxOccurs="1"/>
1829 <xsd:element name="charset" type="CT_IntProperty" minOccurs="0" maxOccurs="1"/>
1830 <xsd:element name="family" type="CT_IntProperty" minOccurs="0" maxOccurs="1"/>
1831 <xsd:element name="b" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1832 <xsd:element name="i" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1833 <xsd:element name="strike" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1834 <xsd:element name="outline" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1835 <xsd:element name="shadow" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1836 <xsd:element name="condense" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1837 <xsd:element name="extend" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
1838 <xsd:element name="color" type="CT_Color" minOccurs="0" maxOccurs="1"/>
1839 <xsd:element name="sz" type="CT_FontSize" minOccurs="0" maxOccurs="1"/>
1840 <xsd:element name="u" type="CT_UnderlineProperty" minOccurs="0" maxOccurs="1"/>
1841 <xsd:element name="vertAlign" type="CT_VerticalAlignFontProperty" minOccurs="0" maxOccurs="1"/>
1842 <xsd:element name="scheme" type="CT_FontScheme" minOccurs="0" maxOccurs="1"/>
1843 </xsd:choice>
1844 </xsd:complexType>
1845 <xsd:complexType name="CT_Rst">
1846 <xsd:sequence>
1847 <xsd:element name="t" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
1848 <xsd:element name="r" type="CT_RElt" minOccurs="0" maxOccurs="unbounded"/>
1849 <xsd:element name="rPh" type="CT_PhoneticRun" minOccurs="0" maxOccurs="unbounded"/>
1850 <xsd:element name="phoneticPr" minOccurs="0" maxOccurs="1" type="CT_PhoneticPr"/>
1851 </xsd:sequence>
1852 </xsd:complexType>
1853 <xsd:complexType name="CT_PhoneticPr">
1854 <xsd:attribute name="fontId" type="ST_FontId" use="required"/>
1855 <xsd:attribute name="type" type="ST_PhoneticType" use="optional" default="fullwidthKatakana"/>
1856 <xsd:attribute name="alignment" type="ST_PhoneticAlignment" use="optional" default="left"/>
1857 </xsd:complexType>
1858 <xsd:element name="headers" type="CT_RevisionHeaders"/>
1859 <xsd:element name="revisions" type="CT_Revisions"/>
1860 <xsd:complexType name="CT_RevisionHeaders">
1861 <xsd:sequence>
1862 <xsd:element name="header" type="CT_RevisionHeader" minOccurs="1" maxOccurs="unbounded"/>
1863 </xsd:sequence>
1864 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
1865 <xsd:attribute name="lastGuid" type="s:ST_Guid" use="optional"/>
1866 <xsd:attribute name="shared" type="xsd:boolean" default="true"/>
1867 <xsd:attribute name="diskRevisions" type="xsd:boolean" default="false"/>
1868 <xsd:attribute name="history" type="xsd:boolean" default="true"/>
1869 <xsd:attribute name="trackRevisions" type="xsd:boolean" default="true"/>
1870 <xsd:attribute name="exclusive" type="xsd:boolean" default="false"/>
1871 <xsd:attribute name="revisionId" type="xsd:unsignedInt" default="0"/>
1872 <xsd:attribute name="version" type="xsd:int" default="1"/>
1873 <xsd:attribute name="keepChangeHistory" type="xsd:boolean" use="optional" default="true"/>
1874 <xsd:attribute name="protected" type="xsd:boolean" use="optional" default="false"/>
1875 <xsd:attribute name="preserveHistory" type="xsd:unsignedInt" default="30"/>
1876 </xsd:complexType>
1877 <xsd:complexType name="CT_Revisions">
1878 <xsd:choice maxOccurs="unbounded">
1879 <xsd:element name="rrc" type="CT_RevisionRowColumn" minOccurs="0" maxOccurs="unbounded"/>
1880 <xsd:element name="rm" type="CT_RevisionMove" minOccurs="0" maxOccurs="unbounded"/>
1881 <xsd:element name="rcv" type="CT_RevisionCustomView" minOccurs="0" maxOccurs="unbounded"/>
1882 <xsd:element name="rsnm" type="CT_RevisionSheetRename" minOccurs="0" maxOccurs="unbounded"/>
1883 <xsd:element name="ris" type="CT_RevisionInsertSheet" minOccurs="0" maxOccurs="unbounded"/>
1884 <xsd:element name="rcc" type="CT_RevisionCellChange" minOccurs="0" maxOccurs="unbounded"/>
1885 <xsd:element name="rfmt" type="CT_RevisionFormatting" minOccurs="0" maxOccurs="unbounded"/>
1886 <xsd:element name="raf" type="CT_RevisionAutoFormatting" minOccurs="0" maxOccurs="unbounded"/>
1887 <xsd:element name="rdn" type="CT_RevisionDefinedName" minOccurs="0" maxOccurs="unbounded"/>
1888 <xsd:element name="rcmt" type="CT_RevisionComment" minOccurs="0" maxOccurs="unbounded"/>
1889 <xsd:element name="rqt" type="CT_RevisionQueryTableField" minOccurs="0" maxOccurs="unbounded"/>
1890 <xsd:element name="rcft" type="CT_RevisionConflict" minOccurs="0" maxOccurs="unbounded"/>
1891 </xsd:choice>
1892 </xsd:complexType>
1893 <xsd:attributeGroup name="AG_RevData">
1894 <xsd:attribute name="rId" type="xsd:unsignedInt" use="required"/>
1895 <xsd:attribute name="ua" type="xsd:boolean" use="optional" default="false"/>
1896 <xsd:attribute name="ra" type="xsd:boolean" use="optional" default="false"/>
1897 </xsd:attributeGroup>
1898 <xsd:complexType name="CT_RevisionHeader">
1899 <xsd:sequence>
1900 <xsd:element name="sheetIdMap" minOccurs="1" maxOccurs="1" type="CT_SheetIdMap"/>
1901 <xsd:element name="reviewedList" minOccurs="0" maxOccurs="1" type="CT_ReviewedRevisions"/>
1902 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1903 </xsd:sequence>
1904 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
1905 <xsd:attribute name="dateTime" type="xsd:dateTime" use="required"/>
1906 <xsd:attribute name="maxSheetId" type="xsd:unsignedInt" use="required"/>
1907 <xsd:attribute name="userName" type="s:ST_Xstring" use="required"/>
1908 <xsd:attribute ref="r:id" use="required"/>
1909 <xsd:attribute name="minRId" type="xsd:unsignedInt" use="optional"/>
1910 <xsd:attribute name="maxRId" type="xsd:unsignedInt" use="optional"/>
1911 </xsd:complexType>
1912 <xsd:complexType name="CT_SheetIdMap">
1913 <xsd:sequence>
1914 <xsd:element name="sheetId" type="CT_SheetId" minOccurs="1" maxOccurs="unbounded"/>
1915 </xsd:sequence>
1916 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
1917 </xsd:complexType>
1918 <xsd:complexType name="CT_SheetId">
1919 <xsd:attribute name="val" type="xsd:unsignedInt" use="required"/>
1920 </xsd:complexType>
1921 <xsd:complexType name="CT_ReviewedRevisions">
1922 <xsd:sequence>
1923 <xsd:element name="reviewed" type="CT_Reviewed" minOccurs="1" maxOccurs="unbounded"/>
1924 </xsd:sequence>
1925 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
1926 </xsd:complexType>
1927 <xsd:complexType name="CT_Reviewed">
1928 <xsd:attribute name="rId" type="xsd:unsignedInt" use="required"/>
1929 </xsd:complexType>
1930 <xsd:complexType name="CT_UndoInfo">
1931 <xsd:attribute name="index" type="xsd:unsignedInt" use="required"/>
1932 <xsd:attribute name="exp" type="ST_FormulaExpression" use="required"/>
1933 <xsd:attribute name="ref3D" type="xsd:boolean" use="optional" default="false"/>
1934 <xsd:attribute name="array" type="xsd:boolean" use="optional" default="false"/>
1935 <xsd:attribute name="v" type="xsd:boolean" use="optional" default="false"/>
1936 <xsd:attribute name="nf" type="xsd:boolean" use="optional" default="false"/>
1937 <xsd:attribute name="cs" type="xsd:boolean" use="optional" default="false"/>
1938 <xsd:attribute name="dr" type="ST_RefA" use="required"/>
1939 <xsd:attribute name="dn" type="s:ST_Xstring" use="optional"/>
1940 <xsd:attribute name="r" type="ST_CellRef" use="optional"/>
1941 <xsd:attribute name="sId" type="xsd:unsignedInt" use="optional"/>
1942 </xsd:complexType>
1943 <xsd:complexType name="CT_RevisionRowColumn">
1944 <xsd:choice minOccurs="0" maxOccurs="unbounded">
1945 <xsd:element name="undo" type="CT_UndoInfo" minOccurs="0" maxOccurs="unbounded"/>
1946 <xsd:element name="rcc" type="CT_RevisionCellChange" minOccurs="0" maxOccurs="unbounded"/>
1947 <xsd:element name="rfmt" type="CT_RevisionFormatting" minOccurs="0" maxOccurs="unbounded"/>
1948 </xsd:choice>
1949 <xsd:attributeGroup ref="AG_RevData"/>
1950 <xsd:attribute name="sId" type="xsd:unsignedInt" use="required"/>
1951 <xsd:attribute name="eol" type="xsd:boolean" use="optional" default="false"/>
1952 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
1953 <xsd:attribute name="action" type="ST_rwColActionType" use="required"/>
1954 <xsd:attribute name="edge" type="xsd:boolean" use="optional" default="false"/>
1955 </xsd:complexType>
1956 <xsd:complexType name="CT_RevisionMove">
1957 <xsd:choice minOccurs="0" maxOccurs="unbounded">
1958 <xsd:element name="undo" type="CT_UndoInfo" minOccurs="0" maxOccurs="unbounded"/>
1959 <xsd:element name="rcc" type="CT_RevisionCellChange" minOccurs="0" maxOccurs="unbounded"/>
1960 <xsd:element name="rfmt" type="CT_RevisionFormatting" minOccurs="0" maxOccurs="unbounded"/>
1961 </xsd:choice>
1962 <xsd:attributeGroup ref="AG_RevData"/>
1963 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
1964 <xsd:attribute name="source" type="ST_Ref" use="required"/>
1965 <xsd:attribute name="destination" type="ST_Ref" use="required"/>
1966 <xsd:attribute name="sourceSheetId" type="xsd:unsignedInt" use="optional" default="0"/>
1967 </xsd:complexType>
1968 <xsd:complexType name="CT_RevisionCustomView">
1969 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
1970 <xsd:attribute name="action" type="ST_RevisionAction" use="required"/>
1971 </xsd:complexType>
1972 <xsd:complexType name="CT_RevisionSheetRename">
1973 <xsd:sequence>
1974 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1975 </xsd:sequence>
1976 <xsd:attributeGroup ref="AG_RevData"/>
1977 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
1978 <xsd:attribute name="oldName" type="s:ST_Xstring" use="required"/>
1979 <xsd:attribute name="newName" type="s:ST_Xstring" use="required"/>
1980 </xsd:complexType>
1981 <xsd:complexType name="CT_RevisionInsertSheet">
1982 <xsd:attributeGroup ref="AG_RevData"/>
1983 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
1984 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
1985 <xsd:attribute name="sheetPosition" type="xsd:unsignedInt" use="required"/>
1986 </xsd:complexType>
1987 <xsd:complexType name="CT_RevisionCellChange">
1988 <xsd:sequence>
1989 <xsd:element name="oc" type="CT_Cell" minOccurs="0" maxOccurs="1"/>
1990 <xsd:element name="nc" type="CT_Cell" minOccurs="1" maxOccurs="1"/>
1991 <xsd:element name="odxf" type="CT_Dxf" minOccurs="0" maxOccurs="1"/>
1992 <xsd:element name="ndxf" type="CT_Dxf" minOccurs="0" maxOccurs="1"/>
1993 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
1994 </xsd:sequence>
1995 <xsd:attributeGroup ref="AG_RevData"/>
1996 <xsd:attribute name="sId" type="xsd:unsignedInt" use="required"/>
1997 <xsd:attribute name="odxf" type="xsd:boolean" default="false"/>
1998 <xsd:attribute name="xfDxf" type="xsd:boolean" use="optional" default="false"/>
1999 <xsd:attribute name="s" type="xsd:boolean" use="optional" default="false"/>
2000 <xsd:attribute name="dxf" type="xsd:boolean" default="false"/>
2001 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
2002 <xsd:attribute name="quotePrefix" type="xsd:boolean" use="optional" default="false"/>
2003 <xsd:attribute name="oldQuotePrefix" type="xsd:boolean" use="optional" default="false"/>
2004 <xsd:attribute name="ph" type="xsd:boolean" default="false"/>
2005 <xsd:attribute name="oldPh" type="xsd:boolean" default="false"/>
2006 <xsd:attribute name="endOfListFormulaUpdate" type="xsd:boolean" default="false"/>
2007 </xsd:complexType>
2008 <xsd:complexType name="CT_RevisionFormatting">
2009 <xsd:sequence>
2010 <xsd:element name="dxf" type="CT_Dxf" minOccurs="0" maxOccurs="1"/>
2011 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2012 </xsd:sequence>
2013 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
2014 <xsd:attribute name="xfDxf" type="xsd:boolean" use="optional" default="false"/>
2015 <xsd:attribute name="s" type="xsd:boolean" use="optional" default="false"/>
2016 <xsd:attribute name="sqref" type="ST_Sqref" use="required"/>
2017 <xsd:attribute name="start" type="xsd:unsignedInt" use="optional"/>
2018 <xsd:attribute name="length" type="xsd:unsignedInt" use="optional"/>
2019 </xsd:complexType>
2020 <xsd:complexType name="CT_RevisionAutoFormatting">
2021 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
2022 <xsd:attributeGroup ref="AG_AutoFormat"/>
2023 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
2024 </xsd:complexType>
2025 <xsd:complexType name="CT_RevisionComment">
2026 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
2027 <xsd:attribute name="cell" type="ST_CellRef" use="required"/>
2028 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
2029 <xsd:attribute name="action" type="ST_RevisionAction" default="add"/>
2030 <xsd:attribute name="alwaysShow" type="xsd:boolean" use="optional" default="false"/>
2031 <xsd:attribute name="old" type="xsd:boolean" use="optional" default="false"/>
2032 <xsd:attribute name="hiddenRow" type="xsd:boolean" use="optional" default="false"/>
2033 <xsd:attribute name="hiddenColumn" type="xsd:boolean" use="optional" default="false"/>
2034 <xsd:attribute name="author" type="s:ST_Xstring" use="required"/>
2035 <xsd:attribute name="oldLength" type="xsd:unsignedInt" default="0"/>
2036 <xsd:attribute name="newLength" type="xsd:unsignedInt" default="0"/>
2037 </xsd:complexType>
2038 <xsd:complexType name="CT_RevisionDefinedName">
2039 <xsd:sequence>
2040 <xsd:element name="formula" type="ST_Formula" minOccurs="0" maxOccurs="1"/>
2041 <xsd:element name="oldFormula" type="ST_Formula" minOccurs="0" maxOccurs="1"/>
2042 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2043 </xsd:sequence>
2044 <xsd:attributeGroup ref="AG_RevData"/>
2045 <xsd:attribute name="localSheetId" type="xsd:unsignedInt" use="optional"/>
2046 <xsd:attribute name="customView" type="xsd:boolean" use="optional" default="false"/>
2047 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
2048 <xsd:attribute name="function" type="xsd:boolean" use="optional" default="false"/>
2049 <xsd:attribute name="oldFunction" type="xsd:boolean" default="false"/>
2050 <xsd:attribute name="functionGroupId" type="xsd:unsignedByte" use="optional"/>
2051 <xsd:attribute name="oldFunctionGroupId" type="xsd:unsignedByte" use="optional"/>
2052 <xsd:attribute name="shortcutKey" type="xsd:unsignedByte" use="optional"/>
2053 <xsd:attribute name="oldShortcutKey" type="xsd:unsignedByte" use="optional"/>
2054 <xsd:attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>
2055 <xsd:attribute name="oldHidden" type="xsd:boolean" use="optional" default="false"/>
2056 <xsd:attribute name="customMenu" type="s:ST_Xstring" use="optional"/>
2057 <xsd:attribute name="oldCustomMenu" type="s:ST_Xstring" use="optional"/>
2058 <xsd:attribute name="description" type="s:ST_Xstring" use="optional"/>
2059 <xsd:attribute name="oldDescription" type="s:ST_Xstring" use="optional"/>
2060 <xsd:attribute name="help" type="s:ST_Xstring" use="optional"/>
2061 <xsd:attribute name="oldHelp" type="s:ST_Xstring" use="optional"/>
2062 <xsd:attribute name="statusBar" type="s:ST_Xstring" use="optional"/>
2063 <xsd:attribute name="oldStatusBar" type="s:ST_Xstring" use="optional"/>
2064 <xsd:attribute name="comment" type="s:ST_Xstring" use="optional"/>
2065 <xsd:attribute name="oldComment" type="s:ST_Xstring" use="optional"/>
2066 </xsd:complexType>
2067 <xsd:complexType name="CT_RevisionConflict">
2068 <xsd:attributeGroup ref="AG_RevData"/>
2069 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="optional"/>
2070 </xsd:complexType>
2071 <xsd:complexType name="CT_RevisionQueryTableField">
2072 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
2073 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
2074 <xsd:attribute name="fieldId" type="xsd:unsignedInt" use="required"/>
2075 </xsd:complexType>
2076 <xsd:simpleType name="ST_rwColActionType">
2077 <xsd:restriction base="xsd:string">
2078 <xsd:enumeration value="insertRow"/>
2079 <xsd:enumeration value="deleteRow"/>
2080 <xsd:enumeration value="insertCol"/>
2081 <xsd:enumeration value="deleteCol"/>
2082 </xsd:restriction>
2083 </xsd:simpleType>
2084 <xsd:simpleType name="ST_RevisionAction">
2085 <xsd:restriction base="xsd:string">
2086 <xsd:enumeration value="add"/>
2087 <xsd:enumeration value="delete"/>
2088 </xsd:restriction>
2089 </xsd:simpleType>
2090 <xsd:simpleType name="ST_FormulaExpression">
2091 <xsd:restriction base="xsd:string">
2092 <xsd:enumeration value="ref"/>
2093 <xsd:enumeration value="refError"/>
2094 <xsd:enumeration value="area"/>
2095 <xsd:enumeration value="areaError"/>
2096 <xsd:enumeration value="computedArea"/>
2097 </xsd:restriction>
2098 </xsd:simpleType>
2099 <xsd:element name="users" type="CT_Users"/>
2100 <xsd:complexType name="CT_Users">
2101 <xsd:sequence>
2102 <xsd:element name="userInfo" minOccurs="0" maxOccurs="256" type="CT_SharedUser"/>
2103 </xsd:sequence>
2104 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
2105 </xsd:complexType>
2106 <xsd:complexType name="CT_SharedUser">
2107 <xsd:sequence>
2108 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2109 </xsd:sequence>
2110 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
2111 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
2112 <xsd:attribute name="id" type="xsd:int" use="required"/>
2113 <xsd:attribute name="dateTime" type="xsd:dateTime" use="required"/>
2114 </xsd:complexType>
2115 <xsd:element name="worksheet" type="CT_Worksheet"/>
2116 <xsd:element name="chartsheet" type="CT_Chartsheet"/>
2117 <xsd:element name="dialogsheet" type="CT_Dialogsheet"/>
2118 <xsd:complexType name="CT_Macrosheet">
2119 <xsd:sequence>
2120 <xsd:element name="sheetPr" type="CT_SheetPr" minOccurs="0" maxOccurs="1"/>
2121 <xsd:element name="dimension" type="CT_SheetDimension" minOccurs="0" maxOccurs="1"/>
2122 <xsd:element name="sheetViews" type="CT_SheetViews" minOccurs="0" maxOccurs="1"/>
2123 <xsd:element name="sheetFormatPr" type="CT_SheetFormatPr" minOccurs="0" maxOccurs="1"/>
2124 <xsd:element name="cols" type="CT_Cols" minOccurs="0" maxOccurs="unbounded"/>
2125 <xsd:element name="sheetData" type="CT_SheetData" minOccurs="1" maxOccurs="1"/>
2126 <xsd:element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1"/>
2127 <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1"/>
2128 <xsd:element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1"/>
2129 <xsd:element name="dataConsolidate" type="CT_DataConsolidate" minOccurs="0" maxOccurs="1"/>
2130 <xsd:element name="customSheetViews" type="CT_CustomSheetViews" minOccurs="0" maxOccurs="1"/>
2131 <xsd:element name="phoneticPr" type="CT_PhoneticPr" minOccurs="0" maxOccurs="1"/>
2132 <xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="0"
2133 maxOccurs="unbounded"/>
2134 <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1"/>
2135 <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>
2136 <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1"/>
2137 <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>
2138 <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2139 <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2140 <xsd:element name="customProperties" type="CT_CustomProperties" minOccurs="0" maxOccurs="1"/>
2141 <xsd:element name="drawing" type="CT_Drawing" minOccurs="0" maxOccurs="1"/>
2142 <xsd:element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2143 <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2144 <xsd:element name="drawingHF" type="CT_DrawingHF" minOccurs="0" maxOccurs="1"/>
2145 <xsd:element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1"/>
2146 <xsd:element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1"/>
2147 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2148 </xsd:sequence>
2149 </xsd:complexType>
2150 <xsd:complexType name="CT_Dialogsheet">
2151 <xsd:sequence>
2152 <xsd:element name="sheetPr" minOccurs="0" type="CT_SheetPr"/>
2153 <xsd:element name="sheetViews" minOccurs="0" type="CT_SheetViews"/>
2154 <xsd:element name="sheetFormatPr" minOccurs="0" type="CT_SheetFormatPr"/>
2155 <xsd:element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1"/>
2156 <xsd:element name="customSheetViews" minOccurs="0" type="CT_CustomSheetViews"/>
2157 <xsd:element name="printOptions" minOccurs="0" type="CT_PrintOptions"/>
2158 <xsd:element name="pageMargins" minOccurs="0" type="CT_PageMargins"/>
2159 <xsd:element name="pageSetup" minOccurs="0" type="CT_PageSetup"/>
2160 <xsd:element name="headerFooter" minOccurs="0" type="CT_HeaderFooter"/>
2161 <xsd:element name="drawing" minOccurs="0" type="CT_Drawing"/>
2162 <xsd:element name="legacyDrawing" minOccurs="0" type="CT_LegacyDrawing"/>
2163 <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2164 <xsd:element name="drawingHF" type="CT_DrawingHF" minOccurs="0" maxOccurs="1"/>
2165 <xsd:element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1"/>
2166 <xsd:element name="controls" type="CT_Controls" minOccurs="0" maxOccurs="1"/>
2167 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2168 </xsd:sequence>
2169 </xsd:complexType>
2170 <xsd:complexType name="CT_Worksheet">
2171 <xsd:sequence>
2172 <xsd:element name="sheetPr" type="CT_SheetPr" minOccurs="0" maxOccurs="1"/>
2173 <xsd:element name="dimension" type="CT_SheetDimension" minOccurs="0" maxOccurs="1"/>
2174 <xsd:element name="sheetViews" type="CT_SheetViews" minOccurs="0" maxOccurs="1"/>
2175 <xsd:element name="sheetFormatPr" type="CT_SheetFormatPr" minOccurs="0" maxOccurs="1"/>
2176 <xsd:element name="cols" type="CT_Cols" minOccurs="0" maxOccurs="unbounded"/>
2177 <xsd:element name="sheetData" type="CT_SheetData" minOccurs="1" maxOccurs="1"/>
2178 <xsd:element name="sheetCalcPr" type="CT_SheetCalcPr" minOccurs="0" maxOccurs="1"/>
2179 <xsd:element name="sheetProtection" type="CT_SheetProtection" minOccurs="0" maxOccurs="1"/>
2180 <xsd:element name="protectedRanges" type="CT_ProtectedRanges" minOccurs="0" maxOccurs="1"/>
2181 <xsd:element name="scenarios" type="CT_Scenarios" minOccurs="0" maxOccurs="1"/>
2182 <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1"/>
2183 <xsd:element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1"/>
2184 <xsd:element name="dataConsolidate" type="CT_DataConsolidate" minOccurs="0" maxOccurs="1"/>
2185 <xsd:element name="customSheetViews" type="CT_CustomSheetViews" minOccurs="0" maxOccurs="1"/>
2186 <xsd:element name="mergeCells" type="CT_MergeCells" minOccurs="0" maxOccurs="1"/>
2187 <xsd:element name="phoneticPr" type="CT_PhoneticPr" minOccurs="0" maxOccurs="1"/>
2188 <xsd:element name="conditionalFormatting" type="CT_ConditionalFormatting" minOccurs="0"
2189 maxOccurs="unbounded"/>
2190 <xsd:element name="dataValidations" type="CT_DataValidations" minOccurs="0" maxOccurs="1"/>
2191 <xsd:element name="hyperlinks" type="CT_Hyperlinks" minOccurs="0" maxOccurs="1"/>
2192 <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1"/>
2193 <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>
2194 <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1"/>
2195 <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>
2196 <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2197 <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2198 <xsd:element name="customProperties" type="CT_CustomProperties" minOccurs="0" maxOccurs="1"/>
2199 <xsd:element name="cellWatches" type="CT_CellWatches" minOccurs="0" maxOccurs="1"/>
2200 <xsd:element name="ignoredErrors" type="CT_IgnoredErrors" minOccurs="0" maxOccurs="1"/>
2201 <xsd:element name="smartTags" type="CT_SmartTags" minOccurs="0" maxOccurs="1"/>
2202 <xsd:element name="drawing" type="CT_Drawing" minOccurs="0" maxOccurs="1"/>
2203 <xsd:element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2204 <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2205 <xsd:element name="drawingHF" type="CT_DrawingHF" minOccurs="0" maxOccurs="1"/>
2206 <xsd:element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1"/>
2207 <xsd:element name="oleObjects" type="CT_OleObjects" minOccurs="0" maxOccurs="1"/>
2208 <xsd:element name="controls" type="CT_Controls" minOccurs="0" maxOccurs="1"/>
2209 <xsd:element name="webPublishItems" type="CT_WebPublishItems" minOccurs="0" maxOccurs="1"/>
2210 <xsd:element name="tableParts" type="CT_TableParts" minOccurs="0" maxOccurs="1"/>
2211 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2212 </xsd:sequence>
2213 </xsd:complexType>
2214 <xsd:complexType name="CT_SheetData">
2215 <xsd:sequence>
2216 <xsd:element name="row" type="CT_Row" minOccurs="0" maxOccurs="unbounded"/>
2217 </xsd:sequence>
2218 </xsd:complexType>
2219 <xsd:complexType name="CT_SheetCalcPr">
2220 <xsd:attribute name="fullCalcOnLoad" type="xsd:boolean" use="optional" default="false"/>
2221 </xsd:complexType>
2222 <xsd:complexType name="CT_SheetFormatPr">
2223 <xsd:attribute name="baseColWidth" type="xsd:unsignedInt" use="optional" default="8"/>
2224 <xsd:attribute name="defaultColWidth" type="xsd:double" use="optional"/>
2225 <xsd:attribute name="defaultRowHeight" type="xsd:double" use="required"/>
2226 <xsd:attribute name="customHeight" type="xsd:boolean" use="optional" default="false"/>
2227 <xsd:attribute name="zeroHeight" type="xsd:boolean" use="optional" default="false"/>
2228 <xsd:attribute name="thickTop" type="xsd:boolean" use="optional" default="false"/>
2229 <xsd:attribute name="thickBottom" type="xsd:boolean" use="optional" default="false"/>
2230 <xsd:attribute name="outlineLevelRow" type="xsd:unsignedByte" use="optional" default="0"/>
2231 <xsd:attribute name="outlineLevelCol" type="xsd:unsignedByte" use="optional" default="0"/>
2232 </xsd:complexType>
2233 <xsd:complexType name="CT_Cols">
2234 <xsd:sequence>
2235 <xsd:element name="col" type="CT_Col" minOccurs="1" maxOccurs="unbounded"/>
2236 </xsd:sequence>
2237 </xsd:complexType>
2238 <xsd:complexType name="CT_Col">
2239 <xsd:attribute name="min" type="xsd:unsignedInt" use="required"/>
2240 <xsd:attribute name="max" type="xsd:unsignedInt" use="required"/>
2241 <xsd:attribute name="width" type="xsd:double" use="optional"/>
2242 <xsd:attribute name="style" type="xsd:unsignedInt" use="optional" default="0"/>
2243 <xsd:attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>
2244 <xsd:attribute name="bestFit" type="xsd:boolean" use="optional" default="false"/>
2245 <xsd:attribute name="customWidth" type="xsd:boolean" use="optional" default="false"/>
2246 <xsd:attribute name="phonetic" type="xsd:boolean" use="optional" default="false"/>
2247 <xsd:attribute name="outlineLevel" type="xsd:unsignedByte" use="optional" default="0"/>
2248 <xsd:attribute name="collapsed" type="xsd:boolean" use="optional" default="false"/>
2249 </xsd:complexType>
2250 <xsd:simpleType name="ST_CellSpan">
2251 <xsd:restriction base="xsd:string"/>
2252 </xsd:simpleType>
2253 <xsd:simpleType name="ST_CellSpans">
2254 <xsd:list itemType="ST_CellSpan"/>
2255 </xsd:simpleType>
2256 <xsd:complexType name="CT_Row">
2257 <xsd:sequence>
2258 <xsd:element name="c" type="CT_Cell" minOccurs="0" maxOccurs="unbounded"/>
2259 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2260 </xsd:sequence>
2261 <xsd:attribute name="r" type="xsd:unsignedInt" use="optional"/>
2262 <xsd:attribute name="spans" type="ST_CellSpans" use="optional"/>
2263 <xsd:attribute name="s" type="xsd:unsignedInt" use="optional" default="0"/>
2264 <xsd:attribute name="customFormat" type="xsd:boolean" use="optional" default="false"/>
2265 <xsd:attribute name="ht" type="xsd:double" use="optional"/>
2266 <xsd:attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>
2267 <xsd:attribute name="customHeight" type="xsd:boolean" use="optional" default="false"/>
2268 <xsd:attribute name="outlineLevel" type="xsd:unsignedByte" use="optional" default="0"/>
2269 <xsd:attribute name="collapsed" type="xsd:boolean" use="optional" default="false"/>
2270 <xsd:attribute name="thickTop" type="xsd:boolean" use="optional" default="false"/>
2271 <xsd:attribute name="thickBot" type="xsd:boolean" use="optional" default="false"/>
2272 <xsd:attribute name="ph" type="xsd:boolean" use="optional" default="false"/>
2273 </xsd:complexType>
2274 <xsd:complexType name="CT_Cell">
2275 <xsd:sequence>
2276 <xsd:element name="f" type="CT_CellFormula" minOccurs="0" maxOccurs="1"/>
2277 <xsd:element name="v" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2278 <xsd:element name="is" type="CT_Rst" minOccurs="0" maxOccurs="1"/>
2279 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2280 </xsd:sequence>
2281 <xsd:attribute name="r" type="ST_CellRef" use="optional"/>
2282 <xsd:attribute name="s" type="xsd:unsignedInt" use="optional" default="0"/>
2283 <xsd:attribute name="t" type="ST_CellType" use="optional" default="n"/>
2284 <xsd:attribute name="cm" type="xsd:unsignedInt" use="optional" default="0"/>
2285 <xsd:attribute name="vm" type="xsd:unsignedInt" use="optional" default="0"/>
2286 <xsd:attribute name="ph" type="xsd:boolean" use="optional" default="false"/>
2287 </xsd:complexType>
2288 <xsd:simpleType name="ST_CellType">
2289 <xsd:restriction base="xsd:string">
2290 <xsd:enumeration value="b"/>
2291 <xsd:enumeration value="n"/>
2292 <xsd:enumeration value="e"/>
2293 <xsd:enumeration value="s"/>
2294 <xsd:enumeration value="str"/>
2295 <xsd:enumeration value="inlineStr"/>
2296 </xsd:restriction>
2297 </xsd:simpleType>
2298 <xsd:simpleType name="ST_CellFormulaType">
2299 <xsd:restriction base="xsd:string">
2300 <xsd:enumeration value="normal"/>
2301 <xsd:enumeration value="array"/>
2302 <xsd:enumeration value="dataTable"/>
2303 <xsd:enumeration value="shared"/>
2304 </xsd:restriction>
2305 </xsd:simpleType>
2306 <xsd:complexType name="CT_SheetPr">
2307 <xsd:sequence>
2308 <xsd:element name="tabColor" type="CT_Color" minOccurs="0" maxOccurs="1"/>
2309 <xsd:element name="outlinePr" type="CT_OutlinePr" minOccurs="0" maxOccurs="1"/>
2310 <xsd:element name="pageSetUpPr" type="CT_PageSetUpPr" minOccurs="0" maxOccurs="1"/>
2311 </xsd:sequence>
2312 <xsd:attribute name="syncHorizontal" type="xsd:boolean" use="optional" default="false"/>
2313 <xsd:attribute name="syncVertical" type="xsd:boolean" use="optional" default="false"/>
2314 <xsd:attribute name="syncRef" type="ST_Ref" use="optional"/>
2315 <xsd:attribute name="transitionEvaluation" type="xsd:boolean" use="optional" default="false"/>
2316 <xsd:attribute name="transitionEntry" type="xsd:boolean" use="optional" default="false"/>
2317 <xsd:attribute name="published" type="xsd:boolean" use="optional" default="true"/>
2318 <xsd:attribute name="codeName" type="xsd:string" use="optional"/>
2319 <xsd:attribute name="filterMode" type="xsd:boolean" use="optional" default="false"/>
2320 <xsd:attribute name="enableFormatConditionsCalculation" type="xsd:boolean" use="optional"
2321 default="true"/>
2322 </xsd:complexType>
2323 <xsd:complexType name="CT_SheetDimension">
2324 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
2325 </xsd:complexType>
2326 <xsd:complexType name="CT_SheetViews">
2327 <xsd:sequence>
2328 <xsd:element name="sheetView" type="CT_SheetView" minOccurs="1" maxOccurs="unbounded"/>
2329 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2330 </xsd:sequence>
2331 </xsd:complexType>
2332 <xsd:complexType name="CT_SheetView">
2333 <xsd:sequence>
2334 <xsd:element name="pane" type="CT_Pane" minOccurs="0" maxOccurs="1"/>
2335 <xsd:element name="selection" type="CT_Selection" minOccurs="0" maxOccurs="4"/>
2336 <xsd:element name="pivotSelection" type="CT_PivotSelection" minOccurs="0" maxOccurs="4"/>
2337 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
2338 </xsd:sequence>
2339 <xsd:attribute name="windowProtection" type="xsd:boolean" use="optional" default="false"/>
2340 <xsd:attribute name="showFormulas" type="xsd:boolean" use="optional" default="false"/>
2341 <xsd:attribute name="showGridLines" type="xsd:boolean" use="optional" default="true"/>
2342 <xsd:attribute name="showRowColHeaders" type="xsd:boolean" use="optional" default="true"/>
2343 <xsd:attribute name="showZeros" type="xsd:boolean" use="optional" default="true"/>
2344 <xsd:attribute name="rightToLeft" type="xsd:boolean" use="optional" default="false"/>
2345 <xsd:attribute name="tabSelected" type="xsd:boolean" use="optional" default="false"/>
2346 <xsd:attribute name="showRuler" type="xsd:boolean" use="optional" default="true"/>
2347 <xsd:attribute name="showOutlineSymbols" type="xsd:boolean" use="optional" default="true"/>
2348 <xsd:attribute name="defaultGridColor" type="xsd:boolean" use="optional" default="true"/>
2349 <xsd:attribute name="showWhiteSpace" type="xsd:boolean" use="optional" default="true"/>
2350 <xsd:attribute name="view" type="ST_SheetViewType" use="optional" default="normal"/>
2351 <xsd:attribute name="topLeftCell" type="ST_CellRef" use="optional"/>
2352 <xsd:attribute name="colorId" type="xsd:unsignedInt" use="optional" default="64"/>
2353 <xsd:attribute name="zoomScale" type="xsd:unsignedInt" use="optional" default="100"/>
2354 <xsd:attribute name="zoomScaleNormal" type="xsd:unsignedInt" use="optional" default="0"/>
2355 <xsd:attribute name="zoomScaleSheetLayoutView" type="xsd:unsignedInt" use="optional" default="0"/>
2356 <xsd:attribute name="zoomScalePageLayoutView" type="xsd:unsignedInt" use="optional" default="0"/>
2357 <xsd:attribute name="workbookViewId" type="xsd:unsignedInt" use="required"/>
2358 </xsd:complexType>
2359 <xsd:complexType name="CT_Pane">
2360 <xsd:attribute name="xSplit" type="xsd:double" use="optional" default="0"/>
2361 <xsd:attribute name="ySplit" type="xsd:double" use="optional" default="0"/>
2362 <xsd:attribute name="topLeftCell" type="ST_CellRef" use="optional"/>
2363 <xsd:attribute name="activePane" type="ST_Pane" use="optional" default="topLeft"/>
2364 <xsd:attribute name="state" type="ST_PaneState" use="optional" default="split"/>
2365 </xsd:complexType>
2366 <xsd:complexType name="CT_PivotSelection">
2367 <xsd:sequence>
2368 <xsd:element name="pivotArea" type="CT_PivotArea"/>
2369 </xsd:sequence>
2370 <xsd:attribute name="pane" type="ST_Pane" use="optional" default="topLeft"/>
2371 <xsd:attribute name="showHeader" type="xsd:boolean" default="false"/>
2372 <xsd:attribute name="label" type="xsd:boolean" default="false"/>
2373 <xsd:attribute name="data" type="xsd:boolean" default="false"/>
2374 <xsd:attribute name="extendable" type="xsd:boolean" default="false"/>
2375 <xsd:attribute name="count" type="xsd:unsignedInt" default="0"/>
2376 <xsd:attribute name="axis" type="ST_Axis" use="optional"/>
2377 <xsd:attribute name="dimension" type="xsd:unsignedInt" default="0"/>
2378 <xsd:attribute name="start" type="xsd:unsignedInt" default="0"/>
2379 <xsd:attribute name="min" type="xsd:unsignedInt" default="0"/>
2380 <xsd:attribute name="max" type="xsd:unsignedInt" default="0"/>
2381 <xsd:attribute name="activeRow" type="xsd:unsignedInt" default="0"/>
2382 <xsd:attribute name="activeCol" type="xsd:unsignedInt" default="0"/>
2383 <xsd:attribute name="previousRow" type="xsd:unsignedInt" default="0"/>
2384 <xsd:attribute name="previousCol" type="xsd:unsignedInt" default="0"/>
2385 <xsd:attribute name="click" type="xsd:unsignedInt" default="0"/>
2386 <xsd:attribute ref="r:id" use="optional"/>
2387 </xsd:complexType>
2388 <xsd:complexType name="CT_Selection">
2389 <xsd:attribute name="pane" type="ST_Pane" use="optional" default="topLeft"/>
2390 <xsd:attribute name="activeCell" type="ST_CellRef" use="optional"/>
2391 <xsd:attribute name="activeCellId" type="xsd:unsignedInt" use="optional" default="0"/>
2392 <xsd:attribute name="sqref" type="ST_Sqref" use="optional" default="A1"/>
2393 </xsd:complexType>
2394 <xsd:simpleType name="ST_Pane">
2395 <xsd:restriction base="xsd:string">
2396 <xsd:enumeration value="bottomRight"/>
2397 <xsd:enumeration value="topRight"/>
2398 <xsd:enumeration value="bottomLeft"/>
2399 <xsd:enumeration value="topLeft"/>
2400 </xsd:restriction>
2401 </xsd:simpleType>
2402 <xsd:complexType name="CT_PageBreak">
2403 <xsd:sequence>
2404 <xsd:element name="brk" type="CT_Break" minOccurs="0" maxOccurs="unbounded"/>
2405 </xsd:sequence>
2406 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
2407 <xsd:attribute name="manualBreakCount" type="xsd:unsignedInt" use="optional" default="0"/>
2408 </xsd:complexType>
2409 <xsd:complexType name="CT_Break">
2410 <xsd:attribute name="id" type="xsd:unsignedInt" use="optional" default="0"/>
2411 <xsd:attribute name="min" type="xsd:unsignedInt" use="optional" default="0"/>
2412 <xsd:attribute name="max" type="xsd:unsignedInt" use="optional" default="0"/>
2413 <xsd:attribute name="man" type="xsd:boolean" use="optional" default="false"/>
2414 <xsd:attribute name="pt" type="xsd:boolean" use="optional" default="false"/>
2415 </xsd:complexType>
2416 <xsd:simpleType name="ST_SheetViewType">
2417 <xsd:restriction base="xsd:string">
2418 <xsd:enumeration value="normal"/>
2419 <xsd:enumeration value="pageBreakPreview"/>
2420 <xsd:enumeration value="pageLayout"/>
2421 </xsd:restriction>
2422 </xsd:simpleType>
2423 <xsd:complexType name="CT_OutlinePr">
2424 <xsd:attribute name="applyStyles" type="xsd:boolean" use="optional" default="false"/>
2425 <xsd:attribute name="summaryBelow" type="xsd:boolean" use="optional" default="true"/>
2426 <xsd:attribute name="summaryRight" type="xsd:boolean" use="optional" default="true"/>
2427 <xsd:attribute name="showOutlineSymbols" type="xsd:boolean" use="optional" default="true"/>
2428 </xsd:complexType>
2429 <xsd:complexType name="CT_PageSetUpPr">
2430 <xsd:attribute name="autoPageBreaks" type="xsd:boolean" use="optional" default="true"/>
2431 <xsd:attribute name="fitToPage" type="xsd:boolean" use="optional" default="false"/>
2432 </xsd:complexType>
2433 <xsd:complexType name="CT_DataConsolidate">
2434 <xsd:sequence>
2435 <xsd:element name="dataRefs" type="CT_DataRefs" minOccurs="0" maxOccurs="1"/>
2436 </xsd:sequence>
2437 <xsd:attribute name="function" type="ST_DataConsolidateFunction" use="optional" default="sum"/>
2438 <xsd:attribute name="startLabels" type="xsd:boolean" use="optional" default="false"/>
2439 <xsd:attribute name="leftLabels" type="xsd:boolean" use="optional" default="false"/>
2440 <xsd:attribute name="topLabels" type="xsd:boolean" use="optional" default="false"/>
2441 <xsd:attribute name="link" type="xsd:boolean" use="optional" default="false"/>
2442 </xsd:complexType>
2443 <xsd:simpleType name="ST_DataConsolidateFunction">
2444 <xsd:restriction base="xsd:string">
2445 <xsd:enumeration value="average"/>
2446 <xsd:enumeration value="count"/>
2447 <xsd:enumeration value="countNums"/>
2448 <xsd:enumeration value="max"/>
2449 <xsd:enumeration value="min"/>
2450 <xsd:enumeration value="product"/>
2451 <xsd:enumeration value="stdDev"/>
2452 <xsd:enumeration value="stdDevp"/>
2453 <xsd:enumeration value="sum"/>
2454 <xsd:enumeration value="var"/>
2455 <xsd:enumeration value="varp"/>
2456 </xsd:restriction>
2457 </xsd:simpleType>
2458 <xsd:complexType name="CT_DataRefs">
2459 <xsd:sequence>
2460 <xsd:element name="dataRef" type="CT_DataRef" minOccurs="0" maxOccurs="unbounded"/>
2461 </xsd:sequence>
2462 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
2463 </xsd:complexType>
2464 <xsd:complexType name="CT_DataRef">
2465 <xsd:attribute name="ref" type="ST_Ref" use="optional"/>
2466 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
2467 <xsd:attribute name="sheet" type="s:ST_Xstring" use="optional"/>
2468 <xsd:attribute ref="r:id" use="optional"/>
2469 </xsd:complexType>
2470 <xsd:complexType name="CT_MergeCells">
2471 <xsd:sequence>
2472 <xsd:element name="mergeCell" type="CT_MergeCell" minOccurs="1" maxOccurs="unbounded"/>
2473 </xsd:sequence>
2474 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
2475 </xsd:complexType>
2476 <xsd:complexType name="CT_MergeCell">
2477 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
2478 </xsd:complexType>
2479 <xsd:complexType name="CT_SmartTags">
2480 <xsd:sequence>
2481 <xsd:element name="cellSmartTags" type="CT_CellSmartTags" minOccurs="1" maxOccurs="unbounded"
2482 />
2483 </xsd:sequence>
2484 </xsd:complexType>
2485 <xsd:complexType name="CT_CellSmartTags">
2486 <xsd:sequence>
2487 <xsd:element name="cellSmartTag" type="CT_CellSmartTag" minOccurs="1" maxOccurs="unbounded"/>
2488 </xsd:sequence>
2489 <xsd:attribute name="r" type="ST_CellRef" use="required"/>
2490 </xsd:complexType>
2491 <xsd:complexType name="CT_CellSmartTag">
2492 <xsd:sequence>
2493 <xsd:element name="cellSmartTagPr" minOccurs="0" maxOccurs="unbounded"
2494 type="CT_CellSmartTagPr"/>
2495 </xsd:sequence>
2496 <xsd:attribute name="type" type="xsd:unsignedInt" use="required"/>
2497 <xsd:attribute name="deleted" type="xsd:boolean" use="optional" default="false"/>
2498 <xsd:attribute name="xmlBased" type="xsd:boolean" use="optional" default="false"/>
2499 </xsd:complexType>
2500 <xsd:complexType name="CT_CellSmartTagPr">
2501 <xsd:attribute name="key" type="s:ST_Xstring" use="required"/>
2502 <xsd:attribute name="val" type="s:ST_Xstring" use="required"/>
2503 </xsd:complexType>
2504 <xsd:complexType name="CT_Drawing">
2505 <xsd:attribute ref="r:id" use="required"/>
2506 </xsd:complexType>
2507 <xsd:complexType name="CT_LegacyDrawing">
2508 <xsd:attribute ref="r:id" use="required"/>
2509 </xsd:complexType>
2510 <xsd:complexType name="CT_DrawingHF">
2511 <xsd:attribute ref="r:id" use="required"/>
2512 <xsd:attribute name="lho" type="xsd:unsignedInt" use="optional"/>
2513 <xsd:attribute name="lhe" type="xsd:unsignedInt" use="optional"/>
2514 <xsd:attribute name="lhf" type="xsd:unsignedInt" use="optional"/>
2515 <xsd:attribute name="cho" type="xsd:unsignedInt" use="optional"/>
2516 <xsd:attribute name="che" type="xsd:unsignedInt" use="optional"/>
2517 <xsd:attribute name="chf" type="xsd:unsignedInt" use="optional"/>
2518 <xsd:attribute name="rho" type="xsd:unsignedInt" use="optional"/>
2519 <xsd:attribute name="rhe" type="xsd:unsignedInt" use="optional"/>
2520 <xsd:attribute name="rhf" type="xsd:unsignedInt" use="optional"/>
2521 <xsd:attribute name="lfo" type="xsd:unsignedInt" use="optional"/>
2522 <xsd:attribute name="lfe" type="xsd:unsignedInt" use="optional"/>
2523 <xsd:attribute name="lff" type="xsd:unsignedInt" use="optional"/>
2524 <xsd:attribute name="cfo" type="xsd:unsignedInt" use="optional"/>
2525 <xsd:attribute name="cfe" type="xsd:unsignedInt" use="optional"/>
2526 <xsd:attribute name="cff" type="xsd:unsignedInt" use="optional"/>
2527 <xsd:attribute name="rfo" type="xsd:unsignedInt" use="optional"/>
2528 <xsd:attribute name="rfe" type="xsd:unsignedInt" use="optional"/>
2529 <xsd:attribute name="rff" type="xsd:unsignedInt" use="optional"/>
2530 </xsd:complexType>
2531 <xsd:complexType name="CT_CustomSheetViews">
2532 <xsd:sequence>
2533 <xsd:element name="customSheetView" minOccurs="1" maxOccurs="unbounded"
2534 type="CT_CustomSheetView"/>
2535 </xsd:sequence>
2536 </xsd:complexType>
2537 <xsd:complexType name="CT_CustomSheetView">
2538 <xsd:sequence>
2539 <xsd:element name="pane" type="CT_Pane" minOccurs="0" maxOccurs="1"/>
2540 <xsd:element name="selection" type="CT_Selection" minOccurs="0" maxOccurs="1"/>
2541 <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2542 <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1"/>
2543 <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>
2544 <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1"/>
2545 <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1"/>
2546 <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>
2547 <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1"/>
2548 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2549 </xsd:sequence>
2550 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
2551 <xsd:attribute name="scale" type="xsd:unsignedInt" default="100"/>
2552 <xsd:attribute name="colorId" type="xsd:unsignedInt" default="64"/>
2553 <xsd:attribute name="showPageBreaks" type="xsd:boolean" use="optional" default="false"/>
2554 <xsd:attribute name="showFormulas" type="xsd:boolean" use="optional" default="false"/>
2555 <xsd:attribute name="showGridLines" type="xsd:boolean" use="optional" default="true"/>
2556 <xsd:attribute name="showRowCol" type="xsd:boolean" use="optional" default="true"/>
2557 <xsd:attribute name="outlineSymbols" type="xsd:boolean" use="optional" default="true"/>
2558 <xsd:attribute name="zeroValues" type="xsd:boolean" use="optional" default="true"/>
2559 <xsd:attribute name="fitToPage" type="xsd:boolean" use="optional" default="false"/>
2560 <xsd:attribute name="printArea" type="xsd:boolean" use="optional" default="false"/>
2561 <xsd:attribute name="filter" type="xsd:boolean" use="optional" default="false"/>
2562 <xsd:attribute name="showAutoFilter" type="xsd:boolean" use="optional" default="false"/>
2563 <xsd:attribute name="hiddenRows" type="xsd:boolean" use="optional" default="false"/>
2564 <xsd:attribute name="hiddenColumns" type="xsd:boolean" use="optional" default="false"/>
2565 <xsd:attribute name="state" type="ST_SheetState" default="visible"/>
2566 <xsd:attribute name="filterUnique" type="xsd:boolean" use="optional" default="false"/>
2567 <xsd:attribute name="view" type="ST_SheetViewType" default="normal"/>
2568 <xsd:attribute name="showRuler" type="xsd:boolean" use="optional" default="true"/>
2569 <xsd:attribute name="topLeftCell" type="ST_CellRef" use="optional"/>
2570 </xsd:complexType>
2571 <xsd:complexType name="CT_DataValidations">
2572 <xsd:sequence>
2573 <xsd:element name="dataValidation" type="CT_DataValidation" minOccurs="1"
2574 maxOccurs="unbounded"/>
2575 </xsd:sequence>
2576 <xsd:attribute name="disablePrompts" type="xsd:boolean" use="optional" default="false"/>
2577 <xsd:attribute name="xWindow" type="xsd:unsignedInt" use="optional"/>
2578 <xsd:attribute name="yWindow" type="xsd:unsignedInt" use="optional"/>
2579 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
2580 </xsd:complexType>
2581 <xsd:complexType name="CT_DataValidation">
2582 <xsd:sequence>
2583 <xsd:element name="formula1" type="ST_Formula" minOccurs="0" maxOccurs="1"/>
2584 <xsd:element name="formula2" type="ST_Formula" minOccurs="0" maxOccurs="1"/>
2585 </xsd:sequence>
2586 <xsd:attribute name="type" type="ST_DataValidationType" use="optional" default="none"/>
2587 <xsd:attribute name="errorStyle" type="ST_DataValidationErrorStyle" use="optional"
2588 default="stop"/>
2589 <xsd:attribute name="imeMode" type="ST_DataValidationImeMode" use="optional" default="noControl"/>
2590 <xsd:attribute name="operator" type="ST_DataValidationOperator" use="optional" default="between"/>
2591 <xsd:attribute name="allowBlank" type="xsd:boolean" use="optional" default="false"/>
2592 <xsd:attribute name="showDropDown" type="xsd:boolean" use="optional" default="false"/>
2593 <xsd:attribute name="showInputMessage" type="xsd:boolean" use="optional" default="false"/>
2594 <xsd:attribute name="showErrorMessage" type="xsd:boolean" use="optional" default="false"/>
2595 <xsd:attribute name="errorTitle" type="s:ST_Xstring" use="optional"/>
2596 <xsd:attribute name="error" type="s:ST_Xstring" use="optional"/>
2597 <xsd:attribute name="promptTitle" type="s:ST_Xstring" use="optional"/>
2598 <xsd:attribute name="prompt" type="s:ST_Xstring" use="optional"/>
2599 <xsd:attribute name="sqref" type="ST_Sqref" use="required"/>
2600 </xsd:complexType>
2601 <xsd:simpleType name="ST_DataValidationType">
2602 <xsd:restriction base="xsd:string">
2603 <xsd:enumeration value="none"/>
2604 <xsd:enumeration value="whole"/>
2605 <xsd:enumeration value="decimal"/>
2606 <xsd:enumeration value="list"/>
2607 <xsd:enumeration value="date"/>
2608 <xsd:enumeration value="time"/>
2609 <xsd:enumeration value="textLength"/>
2610 <xsd:enumeration value="custom"/>
2611 </xsd:restriction>
2612 </xsd:simpleType>
2613 <xsd:simpleType name="ST_DataValidationOperator">
2614 <xsd:restriction base="xsd:string">
2615 <xsd:enumeration value="between"/>
2616 <xsd:enumeration value="notBetween"/>
2617 <xsd:enumeration value="equal"/>
2618 <xsd:enumeration value="notEqual"/>
2619 <xsd:enumeration value="lessThan"/>
2620 <xsd:enumeration value="lessThanOrEqual"/>
2621 <xsd:enumeration value="greaterThan"/>
2622 <xsd:enumeration value="greaterThanOrEqual"/>
2623 </xsd:restriction>
2624 </xsd:simpleType>
2625 <xsd:simpleType name="ST_DataValidationErrorStyle">
2626 <xsd:restriction base="xsd:string">
2627 <xsd:enumeration value="stop"/>
2628 <xsd:enumeration value="warning"/>
2629 <xsd:enumeration value="information"/>
2630 </xsd:restriction>
2631 </xsd:simpleType>
2632 <xsd:simpleType name="ST_DataValidationImeMode">
2633 <xsd:restriction base="xsd:string">
2634 <xsd:enumeration value="noControl"/>
2635 <xsd:enumeration value="off"/>
2636 <xsd:enumeration value="on"/>
2637 <xsd:enumeration value="disabled"/>
2638 <xsd:enumeration value="hiragana"/>
2639 <xsd:enumeration value="fullKatakana"/>
2640 <xsd:enumeration value="halfKatakana"/>
2641 <xsd:enumeration value="fullAlpha"/>
2642 <xsd:enumeration value="halfAlpha"/>
2643 <xsd:enumeration value="fullHangul"/>
2644 <xsd:enumeration value="halfHangul"/>
2645 </xsd:restriction>
2646 </xsd:simpleType>
2647 <xsd:simpleType name="ST_CfType">
2648 <xsd:restriction base="xsd:string">
2649 <xsd:enumeration value="expression"/>
2650 <xsd:enumeration value="cellIs"/>
2651 <xsd:enumeration value="colorScale"/>
2652 <xsd:enumeration value="dataBar"/>
2653 <xsd:enumeration value="iconSet"/>
2654 <xsd:enumeration value="top10"/>
2655 <xsd:enumeration value="uniqueValues"/>
2656 <xsd:enumeration value="duplicateValues"/>
2657 <xsd:enumeration value="containsText"/>
2658 <xsd:enumeration value="notContainsText"/>
2659 <xsd:enumeration value="beginsWith"/>
2660 <xsd:enumeration value="endsWith"/>
2661 <xsd:enumeration value="containsBlanks"/>
2662 <xsd:enumeration value="notContainsBlanks"/>
2663 <xsd:enumeration value="containsErrors"/>
2664 <xsd:enumeration value="notContainsErrors"/>
2665 <xsd:enumeration value="timePeriod"/>
2666 <xsd:enumeration value="aboveAverage"/>
2667 </xsd:restriction>
2668 </xsd:simpleType>
2669 <xsd:simpleType name="ST_TimePeriod">
2670 <xsd:restriction base="xsd:string">
2671 <xsd:enumeration value="today"/>
2672 <xsd:enumeration value="yesterday"/>
2673 <xsd:enumeration value="tomorrow"/>
2674 <xsd:enumeration value="last7Days"/>
2675 <xsd:enumeration value="thisMonth"/>
2676 <xsd:enumeration value="lastMonth"/>
2677 <xsd:enumeration value="nextMonth"/>
2678 <xsd:enumeration value="thisWeek"/>
2679 <xsd:enumeration value="lastWeek"/>
2680 <xsd:enumeration value="nextWeek"/>
2681 </xsd:restriction>
2682 </xsd:simpleType>
2683 <xsd:simpleType name="ST_ConditionalFormattingOperator">
2684 <xsd:restriction base="xsd:string">
2685 <xsd:enumeration value="lessThan"/>
2686 <xsd:enumeration value="lessThanOrEqual"/>
2687 <xsd:enumeration value="equal"/>
2688 <xsd:enumeration value="notEqual"/>
2689 <xsd:enumeration value="greaterThanOrEqual"/>
2690 <xsd:enumeration value="greaterThan"/>
2691 <xsd:enumeration value="between"/>
2692 <xsd:enumeration value="notBetween"/>
2693 <xsd:enumeration value="containsText"/>
2694 <xsd:enumeration value="notContains"/>
2695 <xsd:enumeration value="beginsWith"/>
2696 <xsd:enumeration value="endsWith"/>
2697 </xsd:restriction>
2698 </xsd:simpleType>
2699 <xsd:simpleType name="ST_CfvoType">
2700 <xsd:restriction base="xsd:string">
2701 <xsd:enumeration value="num"/>
2702 <xsd:enumeration value="percent"/>
2703 <xsd:enumeration value="max"/>
2704 <xsd:enumeration value="min"/>
2705 <xsd:enumeration value="formula"/>
2706 <xsd:enumeration value="percentile"/>
2707 </xsd:restriction>
2708 </xsd:simpleType>
2709 <xsd:complexType name="CT_ConditionalFormatting">
2710 <xsd:sequence>
2711 <xsd:element name="cfRule" type="CT_CfRule" minOccurs="1" maxOccurs="unbounded"/>
2712 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2713 </xsd:sequence>
2714 <xsd:attribute name="pivot" type="xsd:boolean" default="false"/>
2715 <xsd:attribute name="sqref" type="ST_Sqref"/>
2716 </xsd:complexType>
2717 <xsd:complexType name="CT_CfRule">
2718 <xsd:sequence>
2719 <xsd:element name="formula" type="ST_Formula" minOccurs="0" maxOccurs="3"/>
2720 <xsd:element name="colorScale" type="CT_ColorScale" minOccurs="0" maxOccurs="1"/>
2721 <xsd:element name="dataBar" type="CT_DataBar" minOccurs="0" maxOccurs="1"/>
2722 <xsd:element name="iconSet" type="CT_IconSet" minOccurs="0" maxOccurs="1"/>
2723 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
2724 </xsd:sequence>
2725 <xsd:attribute name="type" type="ST_CfType"/>
2726 <xsd:attribute name="dxfId" type="ST_DxfId" use="optional"/>
2727 <xsd:attribute name="priority" type="xsd:int" use="required"/>
2728 <xsd:attribute name="stopIfTrue" type="xsd:boolean" use="optional" default="false"/>
2729 <xsd:attribute name="aboveAverage" type="xsd:boolean" use="optional" default="true"/>
2730 <xsd:attribute name="percent" type="xsd:boolean" use="optional" default="false"/>
2731 <xsd:attribute name="bottom" type="xsd:boolean" use="optional" default="false"/>
2732 <xsd:attribute name="operator" type="ST_ConditionalFormattingOperator" use="optional"/>
2733 <xsd:attribute name="text" type="xsd:string" use="optional"/>
2734 <xsd:attribute name="timePeriod" type="ST_TimePeriod" use="optional"/>
2735 <xsd:attribute name="rank" type="xsd:unsignedInt" use="optional"/>
2736 <xsd:attribute name="stdDev" type="xsd:int" use="optional"/>
2737 <xsd:attribute name="equalAverage" type="xsd:boolean" use="optional" default="false"/>
2738 </xsd:complexType>
2739 <xsd:complexType name="CT_Hyperlinks">
2740 <xsd:sequence>
2741 <xsd:element name="hyperlink" type="CT_Hyperlink" minOccurs="1" maxOccurs="unbounded"/>
2742 </xsd:sequence>
2743 </xsd:complexType>
2744 <xsd:complexType name="CT_Hyperlink">
2745 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
2746 <xsd:attribute ref="r:id" use="optional"/>
2747 <xsd:attribute name="location" type="s:ST_Xstring" use="optional"/>
2748 <xsd:attribute name="tooltip" type="s:ST_Xstring" use="optional"/>
2749 <xsd:attribute name="display" type="s:ST_Xstring" use="optional"/>
2750 </xsd:complexType>
2751 <xsd:complexType name="CT_CellFormula">
2752 <xsd:simpleContent>
2753 <xsd:extension base="ST_Formula">
2754 <xsd:attribute name="t" type="ST_CellFormulaType" use="optional" default="normal"/>
2755 <xsd:attribute name="aca" type="xsd:boolean" use="optional" default="false"/>
2756 <xsd:attribute name="ref" type="ST_Ref" use="optional"/>
2757 <xsd:attribute name="dt2D" type="xsd:boolean" use="optional" default="false"/>
2758 <xsd:attribute name="dtr" type="xsd:boolean" use="optional" default="false"/>
2759 <xsd:attribute name="del1" type="xsd:boolean" use="optional" default="false"/>
2760 <xsd:attribute name="del2" type="xsd:boolean" use="optional" default="false"/>
2761 <xsd:attribute name="r1" type="ST_CellRef" use="optional"/>
2762 <xsd:attribute name="r2" type="ST_CellRef" use="optional"/>
2763 <xsd:attribute name="ca" type="xsd:boolean" use="optional" default="false"/>
2764 <xsd:attribute name="si" type="xsd:unsignedInt" use="optional"/>
2765 <xsd:attribute name="bx" type="xsd:boolean" use="optional" default="false"/>
2766 </xsd:extension>
2767 </xsd:simpleContent>
2768 </xsd:complexType>
2769 <xsd:complexType name="CT_ColorScale">
2770 <xsd:sequence>
2771 <xsd:element name="cfvo" type="CT_Cfvo" minOccurs="2" maxOccurs="unbounded"/>
2772 <xsd:element name="color" type="CT_Color" minOccurs="2" maxOccurs="unbounded"/>
2773 </xsd:sequence>
2774 </xsd:complexType>
2775 <xsd:complexType name="CT_DataBar">
2776 <xsd:sequence>
2777 <xsd:element name="cfvo" type="CT_Cfvo" minOccurs="2" maxOccurs="2"/>
2778 <xsd:element name="color" type="CT_Color" minOccurs="1" maxOccurs="1"/>
2779 </xsd:sequence>
2780 <xsd:attribute name="minLength" type="xsd:unsignedInt" use="optional" default="10"/>
2781 <xsd:attribute name="maxLength" type="xsd:unsignedInt" use="optional" default="90"/>
2782 <xsd:attribute name="showValue" type="xsd:boolean" use="optional" default="true"/>
2783 </xsd:complexType>
2784 <xsd:complexType name="CT_IconSet">
2785 <xsd:sequence>
2786 <xsd:element name="cfvo" type="CT_Cfvo" minOccurs="2" maxOccurs="unbounded"/>
2787 </xsd:sequence>
2788 <xsd:attribute name="iconSet" type="ST_IconSetType" use="optional" default="3TrafficLights1"/>
2789 <xsd:attribute name="showValue" type="xsd:boolean" use="optional" default="true"/>
2790 <xsd:attribute name="percent" type="xsd:boolean" default="true"/>
2791 <xsd:attribute name="reverse" type="xsd:boolean" use="optional" default="false"/>
2792 </xsd:complexType>
2793 <xsd:complexType name="CT_Cfvo">
2794 <xsd:sequence>
2795 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2796 </xsd:sequence>
2797 <xsd:attribute name="type" type="ST_CfvoType" use="required"/>
2798 <xsd:attribute name="val" type="s:ST_Xstring" use="optional"/>
2799 <xsd:attribute name="gte" type="xsd:boolean" use="optional" default="true"/>
2800 </xsd:complexType>
2801 <xsd:complexType name="CT_PageMargins">
2802 <xsd:attribute name="left" type="xsd:double" use="required"/>
2803 <xsd:attribute name="right" type="xsd:double" use="required"/>
2804 <xsd:attribute name="top" type="xsd:double" use="required"/>
2805 <xsd:attribute name="bottom" type="xsd:double" use="required"/>
2806 <xsd:attribute name="header" type="xsd:double" use="required"/>
2807 <xsd:attribute name="footer" type="xsd:double" use="required"/>
2808 </xsd:complexType>
2809 <xsd:complexType name="CT_PrintOptions">
2810 <xsd:attribute name="horizontalCentered" type="xsd:boolean" use="optional" default="false"/>
2811 <xsd:attribute name="verticalCentered" type="xsd:boolean" use="optional" default="false"/>
2812 <xsd:attribute name="headings" type="xsd:boolean" use="optional" default="false"/>
2813 <xsd:attribute name="gridLines" type="xsd:boolean" use="optional" default="false"/>
2814 <xsd:attribute name="gridLinesSet" type="xsd:boolean" use="optional" default="true"/>
2815 </xsd:complexType>
2816 <xsd:complexType name="CT_PageSetup">
2817 <xsd:attribute name="paperSize" type="xsd:unsignedInt" use="optional" default="1"/>
2818 <xsd:attribute name="paperHeight" type="s:ST_PositiveUniversalMeasure" use="optional"/>
2819 <xsd:attribute name="paperWidth" type="s:ST_PositiveUniversalMeasure" use="optional"/>
2820 <xsd:attribute name="scale" type="xsd:unsignedInt" use="optional" default="100"/>
2821 <xsd:attribute name="firstPageNumber" type="xsd:unsignedInt" use="optional" default="1"/>
2822 <xsd:attribute name="fitToWidth" type="xsd:unsignedInt" use="optional" default="1"/>
2823 <xsd:attribute name="fitToHeight" type="xsd:unsignedInt" use="optional" default="1"/>
2824 <xsd:attribute name="pageOrder" type="ST_PageOrder" use="optional" default="downThenOver"/>
2825 <xsd:attribute name="orientation" type="ST_Orientation" use="optional" default="default"/>
2826 <xsd:attribute name="usePrinterDefaults" type="xsd:boolean" use="optional" default="true"/>
2827 <xsd:attribute name="blackAndWhite" type="xsd:boolean" use="optional" default="false"/>
2828 <xsd:attribute name="draft" type="xsd:boolean" use="optional" default="false"/>
2829 <xsd:attribute name="cellComments" type="ST_CellComments" use="optional" default="none"/>
2830 <xsd:attribute name="useFirstPageNumber" type="xsd:boolean" use="optional" default="false"/>
2831 <xsd:attribute name="errors" type="ST_PrintError" use="optional" default="displayed"/>
2832 <xsd:attribute name="horizontalDpi" type="xsd:unsignedInt" use="optional" default="600"/>
2833 <xsd:attribute name="verticalDpi" type="xsd:unsignedInt" use="optional" default="600"/>
2834 <xsd:attribute name="copies" type="xsd:unsignedInt" use="optional" default="1"/>
2835 <xsd:attribute ref="r:id" use="optional"/>
2836 </xsd:complexType>
2837 <xsd:simpleType name="ST_PageOrder">
2838 <xsd:restriction base="xsd:string">
2839 <xsd:enumeration value="downThenOver"/>
2840 <xsd:enumeration value="overThenDown"/>
2841 </xsd:restriction>
2842 </xsd:simpleType>
2843 <xsd:simpleType name="ST_Orientation">
2844 <xsd:restriction base="xsd:string">
2845 <xsd:enumeration value="default"/>
2846 <xsd:enumeration value="portrait"/>
2847 <xsd:enumeration value="landscape"/>
2848 </xsd:restriction>
2849 </xsd:simpleType>
2850 <xsd:simpleType name="ST_CellComments">
2851 <xsd:restriction base="xsd:string">
2852 <xsd:enumeration value="none"/>
2853 <xsd:enumeration value="asDisplayed"/>
2854 <xsd:enumeration value="atEnd"/>
2855 </xsd:restriction>
2856 </xsd:simpleType>
2857 <xsd:complexType name="CT_HeaderFooter">
2858 <xsd:sequence>
2859 <xsd:element name="oddHeader" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2860 <xsd:element name="oddFooter" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2861 <xsd:element name="evenHeader" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2862 <xsd:element name="evenFooter" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2863 <xsd:element name="firstHeader" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2864 <xsd:element name="firstFooter" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
2865 </xsd:sequence>
2866 <xsd:attribute name="differentOddEven" type="xsd:boolean" default="false"/>
2867 <xsd:attribute name="differentFirst" type="xsd:boolean" default="false"/>
2868 <xsd:attribute name="scaleWithDoc" type="xsd:boolean" default="true"/>
2869 <xsd:attribute name="alignWithMargins" type="xsd:boolean" default="true"/>
2870 </xsd:complexType>
2871 <xsd:simpleType name="ST_PrintError">
2872 <xsd:restriction base="xsd:string">
2873 <xsd:enumeration value="displayed"/>
2874 <xsd:enumeration value="blank"/>
2875 <xsd:enumeration value="dash"/>
2876 <xsd:enumeration value="NA"/>
2877 </xsd:restriction>
2878 </xsd:simpleType>
2879 <xsd:complexType name="CT_Scenarios">
2880 <xsd:sequence>
2881 <xsd:element name="scenario" type="CT_Scenario" minOccurs="1" maxOccurs="unbounded"/>
2882 </xsd:sequence>
2883 <xsd:attribute name="current" type="xsd:unsignedInt" use="optional"/>
2884 <xsd:attribute name="show" type="xsd:unsignedInt" use="optional"/>
2885 <xsd:attribute name="sqref" type="ST_Sqref" use="optional"/>
2886 </xsd:complexType>
2887 <xsd:complexType name="CT_SheetProtection">
2888 <xsd:attribute name="password" type="ST_UnsignedShortHex" use="optional"/>
2889 <xsd:attribute name="algorithmName" type="s:ST_Xstring" use="optional"/>
2890 <xsd:attribute name="hashValue" type="xsd:base64Binary" use="optional"/>
2891 <xsd:attribute name="saltValue" type="xsd:base64Binary" use="optional"/>
2892 <xsd:attribute name="spinCount" type="xsd:unsignedInt" use="optional"/>
2893 <xsd:attribute name="sheet" type="xsd:boolean" use="optional" default="false"/>
2894 <xsd:attribute name="objects" type="xsd:boolean" use="optional" default="false"/>
2895 <xsd:attribute name="scenarios" type="xsd:boolean" use="optional" default="false"/>
2896 <xsd:attribute name="formatCells" type="xsd:boolean" use="optional" default="true"/>
2897 <xsd:attribute name="formatColumns" type="xsd:boolean" use="optional" default="true"/>
2898 <xsd:attribute name="formatRows" type="xsd:boolean" use="optional" default="true"/>
2899 <xsd:attribute name="insertColumns" type="xsd:boolean" use="optional" default="true"/>
2900 <xsd:attribute name="insertRows" type="xsd:boolean" use="optional" default="true"/>
2901 <xsd:attribute name="insertHyperlinks" type="xsd:boolean" use="optional" default="true"/>
2902 <xsd:attribute name="deleteColumns" type="xsd:boolean" use="optional" default="true"/>
2903 <xsd:attribute name="deleteRows" type="xsd:boolean" use="optional" default="true"/>
2904 <xsd:attribute name="selectLockedCells" type="xsd:boolean" use="optional" default="false"/>
2905 <xsd:attribute name="sort" type="xsd:boolean" use="optional" default="true"/>
2906 <xsd:attribute name="autoFilter" type="xsd:boolean" use="optional" default="true"/>
2907 <xsd:attribute name="pivotTables" type="xsd:boolean" use="optional" default="true"/>
2908 <xsd:attribute name="selectUnlockedCells" type="xsd:boolean" use="optional" default="false"/>
2909 </xsd:complexType>
2910 <xsd:complexType name="CT_ProtectedRanges">
2911 <xsd:sequence>
2912 <xsd:element name="protectedRange" type="CT_ProtectedRange" minOccurs="1"
2913 maxOccurs="unbounded"/>
2914 </xsd:sequence>
2915 </xsd:complexType>
2916 <xsd:complexType name="CT_ProtectedRange">
2917 <xsd:sequence>
2918 <xsd:element name="securityDescriptor" type="xsd:string" minOccurs="0" maxOccurs="unbounded"/>
2919 </xsd:sequence>
2920 <xsd:attribute name="password" type="ST_UnsignedShortHex" use="optional"/>
2921 <xsd:attribute name="sqref" type="ST_Sqref" use="required"/>
2922 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
2923 <xsd:attribute name="securityDescriptor" type="xsd:string" use="optional"/>
2924 <xsd:attribute name="algorithmName" type="s:ST_Xstring" use="optional"/>
2925 <xsd:attribute name="hashValue" type="xsd:base64Binary" use="optional"/>
2926 <xsd:attribute name="saltValue" type="xsd:base64Binary" use="optional"/>
2927 <xsd:attribute name="spinCount" type="xsd:unsignedInt" use="optional"/>
2928 </xsd:complexType>
2929 <xsd:complexType name="CT_Scenario">
2930 <xsd:sequence>
2931 <xsd:element name="inputCells" type="CT_InputCells" minOccurs="1" maxOccurs="unbounded"/>
2932 </xsd:sequence>
2933 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
2934 <xsd:attribute name="locked" type="xsd:boolean" use="optional" default="false"/>
2935 <xsd:attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>
2936 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
2937 <xsd:attribute name="user" type="s:ST_Xstring" use="optional"/>
2938 <xsd:attribute name="comment" type="s:ST_Xstring" use="optional"/>
2939 </xsd:complexType>
2940 <xsd:complexType name="CT_InputCells">
2941 <xsd:attribute name="r" type="ST_CellRef" use="required"/>
2942 <xsd:attribute name="deleted" type="xsd:boolean" use="optional" default="false"/>
2943 <xsd:attribute name="undone" type="xsd:boolean" use="optional" default="false"/>
2944 <xsd:attribute name="val" type="s:ST_Xstring" use="required"/>
2945 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
2946 </xsd:complexType>
2947 <xsd:complexType name="CT_CellWatches">
2948 <xsd:sequence>
2949 <xsd:element name="cellWatch" type="CT_CellWatch" minOccurs="1" maxOccurs="unbounded"/>
2950 </xsd:sequence>
2951 </xsd:complexType>
2952 <xsd:complexType name="CT_CellWatch">
2953 <xsd:attribute name="r" type="ST_CellRef" use="required"/>
2954 </xsd:complexType>
2955 <xsd:complexType name="CT_Chartsheet">
2956 <xsd:sequence>
2957 <xsd:element name="sheetPr" type="CT_ChartsheetPr" minOccurs="0" maxOccurs="1"/>
2958 <xsd:element name="sheetViews" type="CT_ChartsheetViews" minOccurs="1" maxOccurs="1"/>
2959 <xsd:element name="sheetProtection" type="CT_ChartsheetProtection" minOccurs="0" maxOccurs="1"/>
2960 <xsd:element name="customSheetViews" type="CT_CustomChartsheetViews" minOccurs="0"
2961 maxOccurs="1"/>
2962 <xsd:element name="pageMargins" minOccurs="0" type="CT_PageMargins"/>
2963 <xsd:element name="pageSetup" type="CT_CsPageSetup" minOccurs="0" maxOccurs="1"/>
2964 <xsd:element name="headerFooter" minOccurs="0" type="CT_HeaderFooter"/>
2965 <xsd:element name="drawing" type="CT_Drawing" minOccurs="1" maxOccurs="1"/>
2966 <xsd:element name="legacyDrawing" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2967 <xsd:element name="legacyDrawingHF" type="CT_LegacyDrawing" minOccurs="0" maxOccurs="1"/>
2968 <xsd:element name="drawingHF" type="CT_DrawingHF" minOccurs="0" maxOccurs="1"/>
2969 <xsd:element name="picture" type="CT_SheetBackgroundPicture" minOccurs="0" maxOccurs="1"/>
2970 <xsd:element name="webPublishItems" type="CT_WebPublishItems" minOccurs="0" maxOccurs="1"/>
2971 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2972 </xsd:sequence>
2973 </xsd:complexType>
2974 <xsd:complexType name="CT_ChartsheetPr">
2975 <xsd:sequence>
2976 <xsd:element name="tabColor" type="CT_Color" minOccurs="0" maxOccurs="1"/>
2977 </xsd:sequence>
2978 <xsd:attribute name="published" type="xsd:boolean" use="optional" default="true"/>
2979 <xsd:attribute name="codeName" type="xsd:string" use="optional"/>
2980 </xsd:complexType>
2981 <xsd:complexType name="CT_ChartsheetViews">
2982 <xsd:sequence>
2983 <xsd:element name="sheetView" type="CT_ChartsheetView" minOccurs="1" maxOccurs="unbounded"/>
2984 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2985 </xsd:sequence>
2986 </xsd:complexType>
2987 <xsd:complexType name="CT_ChartsheetView">
2988 <xsd:sequence>
2989 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
2990 </xsd:sequence>
2991 <xsd:attribute name="tabSelected" type="xsd:boolean" use="optional" default="false"/>
2992 <xsd:attribute name="zoomScale" type="xsd:unsignedInt" default="100" use="optional"/>
2993 <xsd:attribute name="workbookViewId" type="xsd:unsignedInt" use="required"/>
2994 <xsd:attribute name="zoomToFit" type="xsd:boolean" use="optional" default="false"/>
2995 </xsd:complexType>
2996 <xsd:complexType name="CT_ChartsheetProtection">
2997 <xsd:attribute name="password" type="ST_UnsignedShortHex" use="optional"/>
2998 <xsd:attribute name="algorithmName" type="s:ST_Xstring" use="optional"/>
2999 <xsd:attribute name="hashValue" type="xsd:base64Binary" use="optional"/>
3000 <xsd:attribute name="saltValue" type="xsd:base64Binary" use="optional"/>
3001 <xsd:attribute name="spinCount" type="xsd:unsignedInt" use="optional"/>
3002 <xsd:attribute name="content" type="xsd:boolean" use="optional" default="false"/>
3003 <xsd:attribute name="objects" type="xsd:boolean" use="optional" default="false"/>
3004 </xsd:complexType>
3005 <xsd:complexType name="CT_CsPageSetup">
3006 <xsd:attribute name="paperSize" type="xsd:unsignedInt" use="optional" default="1"/>
3007 <xsd:attribute name="paperHeight" type="s:ST_PositiveUniversalMeasure" use="optional"/>
3008 <xsd:attribute name="paperWidth" type="s:ST_PositiveUniversalMeasure" use="optional"/>
3009 <xsd:attribute name="firstPageNumber" type="xsd:unsignedInt" use="optional" default="1"/>
3010 <xsd:attribute name="orientation" type="ST_Orientation" use="optional" default="default"/>
3011 <xsd:attribute name="usePrinterDefaults" type="xsd:boolean" use="optional" default="true"/>
3012 <xsd:attribute name="blackAndWhite" type="xsd:boolean" use="optional" default="false"/>
3013 <xsd:attribute name="draft" type="xsd:boolean" use="optional" default="false"/>
3014 <xsd:attribute name="useFirstPageNumber" type="xsd:boolean" use="optional" default="false"/>
3015 <xsd:attribute name="horizontalDpi" type="xsd:unsignedInt" use="optional" default="600"/>
3016 <xsd:attribute name="verticalDpi" type="xsd:unsignedInt" use="optional" default="600"/>
3017 <xsd:attribute name="copies" type="xsd:unsignedInt" use="optional" default="1"/>
3018 <xsd:attribute ref="r:id" use="optional"/>
3019 </xsd:complexType>
3020 <xsd:complexType name="CT_CustomChartsheetViews">
3021 <xsd:sequence>
3022 <xsd:element name="customSheetView" minOccurs="0" maxOccurs="unbounded"
3023 type="CT_CustomChartsheetView"/>
3024 </xsd:sequence>
3025 </xsd:complexType>
3026 <xsd:complexType name="CT_CustomChartsheetView">
3027 <xsd:sequence>
3028 <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>
3029 <xsd:element name="pageSetup" type="CT_CsPageSetup" minOccurs="0" maxOccurs="1"/>
3030 <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>
3031 </xsd:sequence>
3032 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
3033 <xsd:attribute name="scale" type="xsd:unsignedInt" default="100"/>
3034 <xsd:attribute name="state" type="ST_SheetState" default="visible"/>
3035 <xsd:attribute name="zoomToFit" type="xsd:boolean" use="optional" default="false"/>
3036 </xsd:complexType>
3037 <xsd:complexType name="CT_CustomProperties">
3038 <xsd:sequence>
3039 <xsd:element name="customPr" type="CT_CustomProperty" minOccurs="1" maxOccurs="unbounded"/>
3040 </xsd:sequence>
3041 </xsd:complexType>
3042 <xsd:complexType name="CT_CustomProperty">
3043 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
3044 <xsd:attribute ref="r:id" use="required"/>
3045 </xsd:complexType>
3046 <xsd:complexType name="CT_OleObjects">
3047 <xsd:sequence>
3048 <xsd:element name="oleObject" type="CT_OleObject" minOccurs="1" maxOccurs="unbounded"/>
3049 </xsd:sequence>
3050 </xsd:complexType>
3051 <xsd:complexType name="CT_OleObject">
3052 <xsd:sequence>
3053 <xsd:element name="objectPr" type="CT_ObjectPr" minOccurs="0" maxOccurs="1"/>
3054 </xsd:sequence>
3055 <xsd:attribute name="progId" type="xsd:string" use="optional"/>
3056 <xsd:attribute name="dvAspect" type="ST_DvAspect" use="optional" default="DVASPECT_CONTENT"/>
3057 <xsd:attribute name="link" type="s:ST_Xstring" use="optional"/>
3058 <xsd:attribute name="oleUpdate" type="ST_OleUpdate" use="optional"/>
3059 <xsd:attribute name="autoLoad" type="xsd:boolean" use="optional" default="false"/>
3060 <xsd:attribute name="shapeId" type="xsd:unsignedInt" use="required"/>
3061 <xsd:attribute ref="r:id" use="optional"/>
3062 </xsd:complexType>
3063 <xsd:complexType name="CT_ObjectPr">
3064 <xsd:sequence>
3065 <xsd:element name="anchor" type="CT_ObjectAnchor" minOccurs="1" maxOccurs="1"/>
3066 </xsd:sequence>
3067 <xsd:attribute name="locked" type="xsd:boolean" use="optional" default="true"/>
3068 <xsd:attribute name="defaultSize" type="xsd:boolean" use="optional" default="true"/>
3069 <xsd:attribute name="print" type="xsd:boolean" use="optional" default="true"/>
3070 <xsd:attribute name="disabled" type="xsd:boolean" use="optional" default="false"/>
3071 <xsd:attribute name="uiObject" type="xsd:boolean" use="optional" default="false"/>
3072 <xsd:attribute name="autoFill" type="xsd:boolean" use="optional" default="true"/>
3073 <xsd:attribute name="autoLine" type="xsd:boolean" use="optional" default="true"/>
3074 <xsd:attribute name="autoPict" type="xsd:boolean" use="optional" default="true"/>
3075 <xsd:attribute name="macro" type="ST_Formula" use="optional"/>
3076 <xsd:attribute name="altText" type="s:ST_Xstring" use="optional"/>
3077 <xsd:attribute name="dde" type="xsd:boolean" use="optional" default="false"/>
3078 <xsd:attribute ref="r:id" use="optional"/>
3079 </xsd:complexType>
3080 <xsd:simpleType name="ST_DvAspect">
3081 <xsd:restriction base="xsd:string">
3082 <xsd:enumeration value="DVASPECT_CONTENT"/>
3083 <xsd:enumeration value="DVASPECT_ICON"/>
3084 </xsd:restriction>
3085 </xsd:simpleType>
3086 <xsd:simpleType name="ST_OleUpdate">
3087 <xsd:restriction base="xsd:string">
3088 <xsd:enumeration value="OLEUPDATE_ALWAYS"/>
3089 <xsd:enumeration value="OLEUPDATE_ONCALL"/>
3090 </xsd:restriction>
3091 </xsd:simpleType>
3092 <xsd:complexType name="CT_WebPublishItems">
3093 <xsd:sequence>
3094 <xsd:element name="webPublishItem" type="CT_WebPublishItem" minOccurs="1"
3095 maxOccurs="unbounded"/>
3096 </xsd:sequence>
3097 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3098 </xsd:complexType>
3099 <xsd:complexType name="CT_WebPublishItem">
3100 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
3101 <xsd:attribute name="divId" type="s:ST_Xstring" use="required"/>
3102 <xsd:attribute name="sourceType" type="ST_WebSourceType" use="required"/>
3103 <xsd:attribute name="sourceRef" type="ST_Ref" use="optional"/>
3104 <xsd:attribute name="sourceObject" type="s:ST_Xstring" use="optional"/>
3105 <xsd:attribute name="destinationFile" type="s:ST_Xstring" use="required"/>
3106 <xsd:attribute name="title" type="s:ST_Xstring" use="optional"/>
3107 <xsd:attribute name="autoRepublish" type="xsd:boolean" use="optional" default="false"/>
3108 </xsd:complexType>
3109 <xsd:complexType name="CT_Controls">
3110 <xsd:sequence>
3111 <xsd:element name="control" type="CT_Control" minOccurs="1" maxOccurs="unbounded"/>
3112 </xsd:sequence>
3113 </xsd:complexType>
3114 <xsd:complexType name="CT_Control">
3115 <xsd:sequence>
3116 <xsd:element name="controlPr" type="CT_ControlPr" minOccurs="0" maxOccurs="1"/>
3117 </xsd:sequence>
3118 <xsd:attribute name="shapeId" type="xsd:unsignedInt" use="required"/>
3119 <xsd:attribute ref="r:id" use="required"/>
3120 <xsd:attribute name="name" type="xsd:string" use="optional"/>
3121 </xsd:complexType>
3122 <xsd:complexType name="CT_ControlPr">
3123 <xsd:sequence>
3124 <xsd:element name="anchor" type="CT_ObjectAnchor" minOccurs="1" maxOccurs="1"/>
3125 </xsd:sequence>
3126 <xsd:attribute name="locked" type="xsd:boolean" use="optional" default="true"/>
3127 <xsd:attribute name="defaultSize" type="xsd:boolean" use="optional" default="true"/>
3128 <xsd:attribute name="print" type="xsd:boolean" use="optional" default="true"/>
3129 <xsd:attribute name="disabled" type="xsd:boolean" use="optional" default="false"/>
3130 <xsd:attribute name="recalcAlways" type="xsd:boolean" use="optional" default="false"/>
3131 <xsd:attribute name="uiObject" type="xsd:boolean" use="optional" default="false"/>
3132 <xsd:attribute name="autoFill" type="xsd:boolean" use="optional" default="true"/>
3133 <xsd:attribute name="autoLine" type="xsd:boolean" use="optional" default="true"/>
3134 <xsd:attribute name="autoPict" type="xsd:boolean" use="optional" default="true"/>
3135 <xsd:attribute name="macro" type="ST_Formula" use="optional"/>
3136 <xsd:attribute name="altText" type="s:ST_Xstring" use="optional"/>
3137 <xsd:attribute name="linkedCell" type="ST_Formula" use="optional"/>
3138 <xsd:attribute name="listFillRange" type="ST_Formula" use="optional"/>
3139 <xsd:attribute name="cf" type="s:ST_Xstring" use="optional" default="pict"/>
3140 <xsd:attribute ref="r:id" use="optional"/>
3141 </xsd:complexType>
3142 <xsd:simpleType name="ST_WebSourceType">
3143 <xsd:restriction base="xsd:string">
3144 <xsd:enumeration value="sheet"/>
3145 <xsd:enumeration value="printArea"/>
3146 <xsd:enumeration value="autoFilter"/>
3147 <xsd:enumeration value="range"/>
3148 <xsd:enumeration value="chart"/>
3149 <xsd:enumeration value="pivotTable"/>
3150 <xsd:enumeration value="query"/>
3151 <xsd:enumeration value="label"/>
3152 </xsd:restriction>
3153 </xsd:simpleType>
3154 <xsd:complexType name="CT_IgnoredErrors">
3155 <xsd:sequence>
3156 <xsd:element name="ignoredError" type="CT_IgnoredError" minOccurs="1" maxOccurs="unbounded"/>
3157 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3158 </xsd:sequence>
3159 </xsd:complexType>
3160 <xsd:complexType name="CT_IgnoredError">
3161 <xsd:attribute name="sqref" type="ST_Sqref" use="required"/>
3162 <xsd:attribute name="evalError" type="xsd:boolean" use="optional" default="false"/>
3163 <xsd:attribute name="twoDigitTextYear" type="xsd:boolean" use="optional" default="false"/>
3164 <xsd:attribute name="numberStoredAsText" type="xsd:boolean" use="optional" default="false"/>
3165 <xsd:attribute name="formula" type="xsd:boolean" use="optional" default="false"/>
3166 <xsd:attribute name="formulaRange" type="xsd:boolean" use="optional" default="false"/>
3167 <xsd:attribute name="unlockedFormula" type="xsd:boolean" use="optional" default="false"/>
3168 <xsd:attribute name="emptyCellReference" type="xsd:boolean" use="optional" default="false"/>
3169 <xsd:attribute name="listDataValidation" type="xsd:boolean" use="optional" default="false"/>
3170 <xsd:attribute name="calculatedColumn" type="xsd:boolean" use="optional" default="false"/>
3171 </xsd:complexType>
3172 <xsd:simpleType name="ST_PaneState">
3173 <xsd:restriction base="xsd:string">
3174 <xsd:enumeration value="split"/>
3175 <xsd:enumeration value="frozen"/>
3176 <xsd:enumeration value="frozenSplit"/>
3177 </xsd:restriction>
3178 </xsd:simpleType>
3179 <xsd:complexType name="CT_TableParts">
3180 <xsd:sequence>
3181 <xsd:element name="tablePart" type="CT_TablePart" minOccurs="0" maxOccurs="unbounded"/>
3182 </xsd:sequence>
3183 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3184 </xsd:complexType>
3185 <xsd:complexType name="CT_TablePart">
3186 <xsd:attribute ref="r:id" use="required"/>
3187 </xsd:complexType>
3188 <xsd:element name="metadata" type="CT_Metadata"/>
3189 <xsd:complexType name="CT_Metadata">
3190 <xsd:sequence>
3191 <xsd:element name="metadataTypes" type="CT_MetadataTypes" minOccurs="0" maxOccurs="1"/>
3192 <xsd:element name="metadataStrings" type="CT_MetadataStrings" minOccurs="0" maxOccurs="1"/>
3193 <xsd:element name="mdxMetadata" type="CT_MdxMetadata" minOccurs="0" maxOccurs="1"/>
3194 <xsd:element name="futureMetadata" type="CT_FutureMetadata" minOccurs="0"
3195 maxOccurs="unbounded"/>
3196 <xsd:element name="cellMetadata" type="CT_MetadataBlocks" minOccurs="0" maxOccurs="1"/>
3197 <xsd:element name="valueMetadata" type="CT_MetadataBlocks" minOccurs="0" maxOccurs="1"/>
3198 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
3199 </xsd:sequence>
3200 </xsd:complexType>
3201 <xsd:complexType name="CT_MetadataTypes">
3202 <xsd:sequence>
3203 <xsd:element name="metadataType" type="CT_MetadataType" minOccurs="1" maxOccurs="unbounded"/>
3204 </xsd:sequence>
3205 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
3206 </xsd:complexType>
3207 <xsd:complexType name="CT_MetadataType">
3208 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
3209 <xsd:attribute name="minSupportedVersion" type="xsd:unsignedInt" use="required"/>
3210 <xsd:attribute name="ghostRow" type="xsd:boolean" use="optional" default="false"/>
3211 <xsd:attribute name="ghostCol" type="xsd:boolean" use="optional" default="false"/>
3212 <xsd:attribute name="edit" type="xsd:boolean" use="optional" default="false"/>
3213 <xsd:attribute name="delete" type="xsd:boolean" use="optional" default="false"/>
3214 <xsd:attribute name="copy" type="xsd:boolean" use="optional" default="false"/>
3215 <xsd:attribute name="pasteAll" type="xsd:boolean" use="optional" default="false"/>
3216 <xsd:attribute name="pasteFormulas" type="xsd:boolean" use="optional" default="false"/>
3217 <xsd:attribute name="pasteValues" type="xsd:boolean" use="optional" default="false"/>
3218 <xsd:attribute name="pasteFormats" type="xsd:boolean" use="optional" default="false"/>
3219 <xsd:attribute name="pasteComments" type="xsd:boolean" use="optional" default="false"/>
3220 <xsd:attribute name="pasteDataValidation" type="xsd:boolean" use="optional" default="false"/>
3221 <xsd:attribute name="pasteBorders" type="xsd:boolean" use="optional" default="false"/>
3222 <xsd:attribute name="pasteColWidths" type="xsd:boolean" use="optional" default="false"/>
3223 <xsd:attribute name="pasteNumberFormats" type="xsd:boolean" use="optional" default="false"/>
3224 <xsd:attribute name="merge" type="xsd:boolean" use="optional" default="false"/>
3225 <xsd:attribute name="splitFirst" type="xsd:boolean" use="optional" default="false"/>
3226 <xsd:attribute name="splitAll" type="xsd:boolean" use="optional" default="false"/>
3227 <xsd:attribute name="rowColShift" type="xsd:boolean" use="optional" default="false"/>
3228 <xsd:attribute name="clearAll" type="xsd:boolean" default="false"/>
3229 <xsd:attribute name="clearFormats" type="xsd:boolean" use="optional" default="false"/>
3230 <xsd:attribute name="clearContents" type="xsd:boolean" use="optional" default="false"/>
3231 <xsd:attribute name="clearComments" type="xsd:boolean" use="optional" default="false"/>
3232 <xsd:attribute name="assign" type="xsd:boolean" use="optional" default="false"/>
3233 <xsd:attribute name="coerce" type="xsd:boolean" use="optional" default="false"/>
3234 <xsd:attribute name="adjust" type="xsd:boolean" use="optional" default="false"/>
3235 <xsd:attribute name="cellMeta" type="xsd:boolean" use="optional" default="false"/>
3236 </xsd:complexType>
3237 <xsd:complexType name="CT_MetadataBlocks">
3238 <xsd:sequence>
3239 <xsd:element name="bk" type="CT_MetadataBlock" minOccurs="1" maxOccurs="unbounded"/>
3240 </xsd:sequence>
3241 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
3242 </xsd:complexType>
3243 <xsd:complexType name="CT_MetadataBlock">
3244 <xsd:sequence>
3245 <xsd:element name="rc" type="CT_MetadataRecord" minOccurs="1" maxOccurs="unbounded"/>
3246 </xsd:sequence>
3247 </xsd:complexType>
3248 <xsd:complexType name="CT_MetadataRecord">
3249 <xsd:attribute name="t" type="xsd:unsignedInt" use="required"/>
3250 <xsd:attribute name="v" type="xsd:unsignedInt" use="required"/>
3251 </xsd:complexType>
3252 <xsd:complexType name="CT_FutureMetadata">
3253 <xsd:sequence>
3254 <xsd:element name="bk" type="CT_FutureMetadataBlock" minOccurs="0" maxOccurs="unbounded"/>
3255 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
3256 </xsd:sequence>
3257 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
3258 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
3259 </xsd:complexType>
3260 <xsd:complexType name="CT_FutureMetadataBlock">
3261 <xsd:sequence>
3262 <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList"/>
3263 </xsd:sequence>
3264 </xsd:complexType>
3265 <xsd:complexType name="CT_MdxMetadata">
3266 <xsd:sequence>
3267 <xsd:element name="mdx" type="CT_Mdx" minOccurs="1" maxOccurs="unbounded"/>
3268 </xsd:sequence>
3269 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
3270 </xsd:complexType>
3271 <xsd:complexType name="CT_Mdx">
3272 <xsd:choice minOccurs="1" maxOccurs="1">
3273 <xsd:element name="t" type="CT_MdxTuple"/>
3274 <xsd:element name="ms" type="CT_MdxSet"/>
3275 <xsd:element name="p" type="CT_MdxMemeberProp"/>
3276 <xsd:element name="k" type="CT_MdxKPI"/>
3277 </xsd:choice>
3278 <xsd:attribute name="n" type="xsd:unsignedInt" use="required"/>
3279 <xsd:attribute name="f" type="ST_MdxFunctionType" use="required"/>
3280 </xsd:complexType>
3281 <xsd:simpleType name="ST_MdxFunctionType">
3282 <xsd:restriction base="xsd:string">
3283 <xsd:enumeration value="m"/>
3284 <xsd:enumeration value="v"/>
3285 <xsd:enumeration value="s"/>
3286 <xsd:enumeration value="c"/>
3287 <xsd:enumeration value="r"/>
3288 <xsd:enumeration value="p"/>
3289 <xsd:enumeration value="k"/>
3290 </xsd:restriction>
3291 </xsd:simpleType>
3292 <xsd:complexType name="CT_MdxTuple">
3293 <xsd:sequence>
3294 <xsd:element name="n" type="CT_MetadataStringIndex" minOccurs="0" maxOccurs="unbounded"/>
3295 </xsd:sequence>
3296 <xsd:attribute name="c" type="xsd:unsignedInt" use="optional" default="0"/>
3297 <xsd:attribute name="ct" type="s:ST_Xstring" use="optional"/>
3298 <xsd:attribute name="si" type="xsd:unsignedInt" use="optional"/>
3299 <xsd:attribute name="fi" type="xsd:unsignedInt" use="optional"/>
3300 <xsd:attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
3301 <xsd:attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
3302 <xsd:attribute name="i" type="xsd:boolean" use="optional" default="false"/>
3303 <xsd:attribute name="u" type="xsd:boolean" use="optional" default="false"/>
3304 <xsd:attribute name="st" type="xsd:boolean" use="optional" default="false"/>
3305 <xsd:attribute name="b" type="xsd:boolean" use="optional" default="false"/>
3306 </xsd:complexType>
3307 <xsd:complexType name="CT_MdxSet">
3308 <xsd:sequence>
3309 <xsd:element name="n" type="CT_MetadataStringIndex" minOccurs="0" maxOccurs="unbounded"/>
3310 </xsd:sequence>
3311 <xsd:attribute name="ns" type="xsd:unsignedInt" use="required"/>
3312 <xsd:attribute name="c" type="xsd:unsignedInt" use="optional" default="0"/>
3313 <xsd:attribute name="o" type="ST_MdxSetOrder" use="optional" default="u"/>
3314 </xsd:complexType>
3315 <xsd:simpleType name="ST_MdxSetOrder">
3316 <xsd:restriction base="xsd:string">
3317 <xsd:enumeration value="u"/>
3318 <xsd:enumeration value="a"/>
3319 <xsd:enumeration value="d"/>
3320 <xsd:enumeration value="aa"/>
3321 <xsd:enumeration value="ad"/>
3322 <xsd:enumeration value="na"/>
3323 <xsd:enumeration value="nd"/>
3324 </xsd:restriction>
3325 </xsd:simpleType>
3326 <xsd:complexType name="CT_MdxMemeberProp">
3327 <xsd:attribute name="n" type="xsd:unsignedInt" use="required"/>
3328 <xsd:attribute name="np" type="xsd:unsignedInt" use="required"/>
3329 </xsd:complexType>
3330 <xsd:complexType name="CT_MdxKPI">
3331 <xsd:attribute name="n" type="xsd:unsignedInt" use="required"/>
3332 <xsd:attribute name="np" type="xsd:unsignedInt" use="required"/>
3333 <xsd:attribute name="p" type="ST_MdxKPIProperty" use="required"/>
3334 </xsd:complexType>
3335 <xsd:simpleType name="ST_MdxKPIProperty">
3336 <xsd:restriction base="xsd:string">
3337 <xsd:enumeration value="v"/>
3338 <xsd:enumeration value="g"/>
3339 <xsd:enumeration value="s"/>
3340 <xsd:enumeration value="t"/>
3341 <xsd:enumeration value="w"/>
3342 <xsd:enumeration value="m"/>
3343 </xsd:restriction>
3344 </xsd:simpleType>
3345 <xsd:complexType name="CT_MetadataStringIndex">
3346 <xsd:attribute name="x" type="xsd:unsignedInt" use="required"/>
3347 <xsd:attribute name="s" type="xsd:boolean" use="optional" default="false"/>
3348 </xsd:complexType>
3349 <xsd:complexType name="CT_MetadataStrings">
3350 <xsd:sequence>
3351 <xsd:element name="s" type="CT_XStringElement" minOccurs="1" maxOccurs="unbounded"/>
3352 </xsd:sequence>
3353 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional" default="0"/>
3354 </xsd:complexType>
3355 <xsd:element name="singleXmlCells" type="CT_SingleXmlCells"/>
3356 <xsd:complexType name="CT_SingleXmlCells">
3357 <xsd:sequence>
3358 <xsd:element name="singleXmlCell" type="CT_SingleXmlCell" maxOccurs="unbounded"/>
3359 </xsd:sequence>
3360 </xsd:complexType>
3361 <xsd:complexType name="CT_SingleXmlCell">
3362 <xsd:sequence>
3363 <xsd:element name="xmlCellPr" type="CT_XmlCellPr" minOccurs="1" maxOccurs="1"/>
3364 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3365 </xsd:sequence>
3366 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
3367 <xsd:attribute name="r" type="ST_CellRef" use="required"/>
3368 <xsd:attribute name="connectionId" type="xsd:unsignedInt" use="required"/>
3369 </xsd:complexType>
3370 <xsd:complexType name="CT_XmlCellPr">
3371 <xsd:sequence>
3372 <xsd:element name="xmlPr" type="CT_XmlPr" minOccurs="1" maxOccurs="1"/>
3373 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3374 </xsd:sequence>
3375 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
3376 <xsd:attribute name="uniqueName" type="s:ST_Xstring" use="optional"/>
3377 </xsd:complexType>
3378 <xsd:complexType name="CT_XmlPr">
3379 <xsd:sequence>
3380 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3381 </xsd:sequence>
3382 <xsd:attribute name="mapId" type="xsd:unsignedInt" use="required"/>
3383 <xsd:attribute name="xpath" type="s:ST_Xstring" use="required"/>
3384 <xsd:attribute name="xmlDataType" type="ST_XmlDataType" use="required"/>
3385 </xsd:complexType>
3386 <xsd:element name="styleSheet" type="CT_Stylesheet"/>
3387 <xsd:complexType name="CT_Stylesheet">
3388 <xsd:sequence>
3389 <xsd:element name="numFmts" type="CT_NumFmts" minOccurs="0" maxOccurs="1"/>
3390 <xsd:element name="fonts" type="CT_Fonts" minOccurs="0" maxOccurs="1"/>
3391 <xsd:element name="fills" type="CT_Fills" minOccurs="0" maxOccurs="1"/>
3392 <xsd:element name="borders" type="CT_Borders" minOccurs="0" maxOccurs="1"/>
3393 <xsd:element name="cellStyleXfs" type="CT_CellStyleXfs" minOccurs="0" maxOccurs="1"/>
3394 <xsd:element name="cellXfs" type="CT_CellXfs" minOccurs="0" maxOccurs="1"/>
3395 <xsd:element name="cellStyles" type="CT_CellStyles" minOccurs="0" maxOccurs="1"/>
3396 <xsd:element name="dxfs" type="CT_Dxfs" minOccurs="0" maxOccurs="1"/>
3397 <xsd:element name="tableStyles" type="CT_TableStyles" minOccurs="0" maxOccurs="1"/>
3398 <xsd:element name="colors" type="CT_Colors" minOccurs="0" maxOccurs="1"/>
3399 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3400 </xsd:sequence>
3401 </xsd:complexType>
3402 <xsd:complexType name="CT_CellAlignment">
3403 <xsd:attribute name="horizontal" type="ST_HorizontalAlignment" use="optional"/>
3404 <xsd:attribute name="vertical" type="ST_VerticalAlignment" default="bottom" use="optional"/>
3405 <xsd:attribute name="textRotation" type="ST_TextRotation" use="optional"/>
3406 <xsd:attribute name="wrapText" type="xsd:boolean" use="optional"/>
3407 <xsd:attribute name="indent" type="xsd:unsignedInt" use="optional"/>
3408 <xsd:attribute name="relativeIndent" type="xsd:int" use="optional"/>
3409 <xsd:attribute name="justifyLastLine" type="xsd:boolean" use="optional"/>
3410 <xsd:attribute name="shrinkToFit" type="xsd:boolean" use="optional"/>
3411 <xsd:attribute name="readingOrder" type="xsd:unsignedInt" use="optional"/>
3412 </xsd:complexType>
3413 <xsd:simpleType name="ST_TextRotation">
3414 <xsd:union>
3415 <xsd:simpleType>
3416 <xsd:restriction base="xsd:nonNegativeInteger">
3417 <xsd:maxInclusive value="180"/>
3418 </xsd:restriction>
3419 </xsd:simpleType>
3420 <xsd:simpleType>
3421 <xsd:restriction base="xsd:nonNegativeInteger">
3422 <xsd:enumeration value="255"/>
3423 </xsd:restriction>
3424 </xsd:simpleType>
3425 </xsd:union>
3426 </xsd:simpleType>
3427 <xsd:simpleType name="ST_BorderStyle">
3428 <xsd:restriction base="xsd:string">
3429 <xsd:enumeration value="none"/>
3430 <xsd:enumeration value="thin"/>
3431 <xsd:enumeration value="medium"/>
3432 <xsd:enumeration value="dashed"/>
3433 <xsd:enumeration value="dotted"/>
3434 <xsd:enumeration value="thick"/>
3435 <xsd:enumeration value="double"/>
3436 <xsd:enumeration value="hair"/>
3437 <xsd:enumeration value="mediumDashed"/>
3438 <xsd:enumeration value="dashDot"/>
3439 <xsd:enumeration value="mediumDashDot"/>
3440 <xsd:enumeration value="dashDotDot"/>
3441 <xsd:enumeration value="mediumDashDotDot"/>
3442 <xsd:enumeration value="slantDashDot"/>
3443 </xsd:restriction>
3444 </xsd:simpleType>
3445 <xsd:complexType name="CT_Borders">
3446 <xsd:sequence>
3447 <xsd:element name="border" type="CT_Border" minOccurs="0" maxOccurs="unbounded"/>
3448 </xsd:sequence>
3449 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3450 </xsd:complexType>
3451 <xsd:complexType name="CT_Border">
3452 <xsd:sequence>
3453 <xsd:element name="start" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3454 <xsd:element name="end" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3455 <xsd:element name="left" type="CT_BorderPr" minOccurs="0"/>
3456 <xsd:element name="right" type="CT_BorderPr" minOccurs="0"/>
3457 <xsd:element name="top" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3458 <xsd:element name="bottom" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3459 <xsd:element name="diagonal" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3460 <xsd:element name="vertical" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3461 <xsd:element name="horizontal" type="CT_BorderPr" minOccurs="0" maxOccurs="1"/>
3462 </xsd:sequence>
3463 <xsd:attribute name="diagonalUp" type="xsd:boolean" use="optional"/>
3464 <xsd:attribute name="diagonalDown" type="xsd:boolean" use="optional"/>
3465 <xsd:attribute name="outline" type="xsd:boolean" use="optional" default="true"/>
3466 </xsd:complexType>
3467 <xsd:complexType name="CT_BorderPr">
3468 <xsd:sequence>
3469 <xsd:element name="color" type="CT_Color" minOccurs="0" maxOccurs="1"/>
3470 </xsd:sequence>
3471 <xsd:attribute name="style" type="ST_BorderStyle" use="optional" default="none"/>
3472 </xsd:complexType>
3473 <xsd:complexType name="CT_CellProtection">
3474 <xsd:attribute name="locked" type="xsd:boolean" use="optional"/>
3475 <xsd:attribute name="hidden" type="xsd:boolean" use="optional"/>
3476 </xsd:complexType>
3477 <xsd:complexType name="CT_Fonts">
3478 <xsd:sequence>
3479 <xsd:element name="font" type="CT_Font" minOccurs="0" maxOccurs="unbounded"/>
3480 </xsd:sequence>
3481 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3482 </xsd:complexType>
3483 <xsd:complexType name="CT_Fills">
3484 <xsd:sequence>
3485 <xsd:element name="fill" type="CT_Fill" minOccurs="0" maxOccurs="unbounded"/>
3486 </xsd:sequence>
3487 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3488 </xsd:complexType>
3489 <xsd:complexType name="CT_Fill">
3490 <xsd:choice minOccurs="1" maxOccurs="1">
3491 <xsd:element name="patternFill" type="CT_PatternFill" minOccurs="0" maxOccurs="1"/>
3492 <xsd:element name="gradientFill" type="CT_GradientFill" minOccurs="0" maxOccurs="1"/>
3493 </xsd:choice>
3494 </xsd:complexType>
3495 <xsd:complexType name="CT_PatternFill">
3496 <xsd:sequence>
3497 <xsd:element name="fgColor" type="CT_Color" minOccurs="0" maxOccurs="1"/>
3498 <xsd:element name="bgColor" type="CT_Color" minOccurs="0" maxOccurs="1"/>
3499 </xsd:sequence>
3500 <xsd:attribute name="patternType" type="ST_PatternType" use="optional"/>
3501 </xsd:complexType>
3502 <xsd:complexType name="CT_Color">
3503 <xsd:attribute name="auto" type="xsd:boolean" use="optional"/>
3504 <xsd:attribute name="indexed" type="xsd:unsignedInt" use="optional"/>
3505 <xsd:attribute name="rgb" type="ST_UnsignedIntHex" use="optional"/>
3506 <xsd:attribute name="theme" type="xsd:unsignedInt" use="optional"/>
3507 <xsd:attribute name="tint" type="xsd:double" use="optional" default="0.0"/>
3508 </xsd:complexType>
3509 <xsd:simpleType name="ST_PatternType">
3510 <xsd:restriction base="xsd:string">
3511 <xsd:enumeration value="none"/>
3512 <xsd:enumeration value="solid"/>
3513 <xsd:enumeration value="mediumGray"/>
3514 <xsd:enumeration value="darkGray"/>
3515 <xsd:enumeration value="lightGray"/>
3516 <xsd:enumeration value="darkHorizontal"/>
3517 <xsd:enumeration value="darkVertical"/>
3518 <xsd:enumeration value="darkDown"/>
3519 <xsd:enumeration value="darkUp"/>
3520 <xsd:enumeration value="darkGrid"/>
3521 <xsd:enumeration value="darkTrellis"/>
3522 <xsd:enumeration value="lightHorizontal"/>
3523 <xsd:enumeration value="lightVertical"/>
3524 <xsd:enumeration value="lightDown"/>
3525 <xsd:enumeration value="lightUp"/>
3526 <xsd:enumeration value="lightGrid"/>
3527 <xsd:enumeration value="lightTrellis"/>
3528 <xsd:enumeration value="gray125"/>
3529 <xsd:enumeration value="gray0625"/>
3530 </xsd:restriction>
3531 </xsd:simpleType>
3532 <xsd:complexType name="CT_GradientFill">
3533 <xsd:sequence>
3534 <xsd:element name="stop" type="CT_GradientStop" minOccurs="0" maxOccurs="unbounded"/>
3535 </xsd:sequence>
3536 <xsd:attribute name="type" type="ST_GradientType" use="optional" default="linear"/>
3537 <xsd:attribute name="degree" type="xsd:double" use="optional" default="0"/>
3538 <xsd:attribute name="left" type="xsd:double" use="optional" default="0"/>
3539 <xsd:attribute name="right" type="xsd:double" use="optional" default="0"/>
3540 <xsd:attribute name="top" type="xsd:double" use="optional" default="0"/>
3541 <xsd:attribute name="bottom" type="xsd:double" use="optional" default="0"/>
3542 </xsd:complexType>
3543 <xsd:complexType name="CT_GradientStop">
3544 <xsd:sequence>
3545 <xsd:element name="color" type="CT_Color" minOccurs="1" maxOccurs="1"/>
3546 </xsd:sequence>
3547 <xsd:attribute name="position" type="xsd:double" use="required"/>
3548 </xsd:complexType>
3549 <xsd:simpleType name="ST_GradientType">
3550 <xsd:restriction base="xsd:string">
3551 <xsd:enumeration value="linear"/>
3552 <xsd:enumeration value="path"/>
3553 </xsd:restriction>
3554 </xsd:simpleType>
3555 <xsd:simpleType name="ST_HorizontalAlignment">
3556 <xsd:restriction base="xsd:string">
3557 <xsd:enumeration value="general"/>
3558 <xsd:enumeration value="left"/>
3559 <xsd:enumeration value="center"/>
3560 <xsd:enumeration value="right"/>
3561 <xsd:enumeration value="fill"/>
3562 <xsd:enumeration value="justify"/>
3563 <xsd:enumeration value="centerContinuous"/>
3564 <xsd:enumeration value="distributed"/>
3565 </xsd:restriction>
3566 </xsd:simpleType>
3567 <xsd:simpleType name="ST_VerticalAlignment">
3568 <xsd:restriction base="xsd:string">
3569 <xsd:enumeration value="top"/>
3570 <xsd:enumeration value="center"/>
3571 <xsd:enumeration value="bottom"/>
3572 <xsd:enumeration value="justify"/>
3573 <xsd:enumeration value="distributed"/>
3574 </xsd:restriction>
3575 </xsd:simpleType>
3576 <xsd:complexType name="CT_NumFmts">
3577 <xsd:sequence>
3578 <xsd:element name="numFmt" type="CT_NumFmt" minOccurs="0" maxOccurs="unbounded"/>
3579 </xsd:sequence>
3580 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3581 </xsd:complexType>
3582 <xsd:complexType name="CT_NumFmt">
3583 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="required"/>
3584 <xsd:attribute name="formatCode" type="s:ST_Xstring" use="required"/>
3585 </xsd:complexType>
3586 <xsd:complexType name="CT_CellStyleXfs">
3587 <xsd:sequence>
3588 <xsd:element name="xf" type="CT_Xf" minOccurs="1" maxOccurs="unbounded"/>
3589 </xsd:sequence>
3590 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3591 </xsd:complexType>
3592 <xsd:complexType name="CT_CellXfs">
3593 <xsd:sequence>
3594 <xsd:element name="xf" type="CT_Xf" minOccurs="1" maxOccurs="unbounded"/>
3595 </xsd:sequence>
3596 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3597 </xsd:complexType>
3598 <xsd:complexType name="CT_Xf">
3599 <xsd:sequence>
3600 <xsd:element name="alignment" type="CT_CellAlignment" minOccurs="0" maxOccurs="1"/>
3601 <xsd:element name="protection" type="CT_CellProtection" minOccurs="0" maxOccurs="1"/>
3602 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3603 </xsd:sequence>
3604 <xsd:attribute name="numFmtId" type="ST_NumFmtId" use="optional"/>
3605 <xsd:attribute name="fontId" type="ST_FontId" use="optional"/>
3606 <xsd:attribute name="fillId" type="ST_FillId" use="optional"/>
3607 <xsd:attribute name="borderId" type="ST_BorderId" use="optional"/>
3608 <xsd:attribute name="xfId" type="ST_CellStyleXfId" use="optional"/>
3609 <xsd:attribute name="quotePrefix" type="xsd:boolean" use="optional" default="false"/>
3610 <xsd:attribute name="pivotButton" type="xsd:boolean" use="optional" default="false"/>
3611 <xsd:attribute name="applyNumberFormat" type="xsd:boolean" use="optional"/>
3612 <xsd:attribute name="applyFont" type="xsd:boolean" use="optional"/>
3613 <xsd:attribute name="applyFill" type="xsd:boolean" use="optional"/>
3614 <xsd:attribute name="applyBorder" type="xsd:boolean" use="optional"/>
3615 <xsd:attribute name="applyAlignment" type="xsd:boolean" use="optional"/>
3616 <xsd:attribute name="applyProtection" type="xsd:boolean" use="optional"/>
3617 </xsd:complexType>
3618 <xsd:complexType name="CT_CellStyles">
3619 <xsd:sequence>
3620 <xsd:element name="cellStyle" type="CT_CellStyle" minOccurs="1" maxOccurs="unbounded"/>
3621 </xsd:sequence>
3622 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3623 </xsd:complexType>
3624 <xsd:complexType name="CT_CellStyle">
3625 <xsd:sequence>
3626 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3627 </xsd:sequence>
3628 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
3629 <xsd:attribute name="xfId" type="ST_CellStyleXfId" use="required"/>
3630 <xsd:attribute name="builtinId" type="xsd:unsignedInt" use="optional"/>
3631 <xsd:attribute name="iLevel" type="xsd:unsignedInt" use="optional"/>
3632 <xsd:attribute name="hidden" type="xsd:boolean" use="optional"/>
3633 <xsd:attribute name="customBuiltin" type="xsd:boolean" use="optional"/>
3634 </xsd:complexType>
3635 <xsd:complexType name="CT_Dxfs">
3636 <xsd:sequence>
3637 <xsd:element name="dxf" type="CT_Dxf" minOccurs="0" maxOccurs="unbounded"/>
3638 </xsd:sequence>
3639 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3640 </xsd:complexType>
3641 <xsd:complexType name="CT_Dxf">
3642 <xsd:sequence>
3643 <xsd:element name="font" type="CT_Font" minOccurs="0" maxOccurs="1"/>
3644 <xsd:element name="numFmt" type="CT_NumFmt" minOccurs="0" maxOccurs="1"/>
3645 <xsd:element name="fill" type="CT_Fill" minOccurs="0" maxOccurs="1"/>
3646 <xsd:element name="alignment" type="CT_CellAlignment" minOccurs="0" maxOccurs="1"/>
3647 <xsd:element name="border" type="CT_Border" minOccurs="0" maxOccurs="1"/>
3648 <xsd:element name="protection" type="CT_CellProtection" minOccurs="0" maxOccurs="1"/>
3649 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3650 </xsd:sequence>
3651 </xsd:complexType>
3652 <xsd:simpleType name="ST_NumFmtId">
3653 <xsd:restriction base="xsd:unsignedInt"/>
3654 </xsd:simpleType>
3655 <xsd:simpleType name="ST_FontId">
3656 <xsd:restriction base="xsd:unsignedInt"/>
3657 </xsd:simpleType>
3658 <xsd:simpleType name="ST_FillId">
3659 <xsd:restriction base="xsd:unsignedInt"/>
3660 </xsd:simpleType>
3661 <xsd:simpleType name="ST_BorderId">
3662 <xsd:restriction base="xsd:unsignedInt"/>
3663 </xsd:simpleType>
3664 <xsd:simpleType name="ST_CellStyleXfId">
3665 <xsd:restriction base="xsd:unsignedInt"/>
3666 </xsd:simpleType>
3667 <xsd:simpleType name="ST_DxfId">
3668 <xsd:restriction base="xsd:unsignedInt"/>
3669 </xsd:simpleType>
3670 <xsd:complexType name="CT_Colors">
3671 <xsd:sequence>
3672 <xsd:element name="indexedColors" type="CT_IndexedColors" minOccurs="0" maxOccurs="1"/>
3673 <xsd:element name="mruColors" type="CT_MRUColors" minOccurs="0" maxOccurs="1"/>
3674 </xsd:sequence>
3675 </xsd:complexType>
3676 <xsd:complexType name="CT_IndexedColors">
3677 <xsd:sequence>
3678 <xsd:element name="rgbColor" type="CT_RgbColor" minOccurs="1" maxOccurs="unbounded"/>
3679 </xsd:sequence>
3680 </xsd:complexType>
3681 <xsd:complexType name="CT_MRUColors">
3682 <xsd:sequence>
3683 <xsd:element name="color" type="CT_Color" minOccurs="1" maxOccurs="unbounded"/>
3684 </xsd:sequence>
3685 </xsd:complexType>
3686 <xsd:complexType name="CT_RgbColor">
3687 <xsd:attribute name="rgb" type="ST_UnsignedIntHex" use="optional"/>
3688 </xsd:complexType>
3689 <xsd:complexType name="CT_TableStyles">
3690 <xsd:sequence>
3691 <xsd:element name="tableStyle" type="CT_TableStyle" minOccurs="0" maxOccurs="unbounded"/>
3692 </xsd:sequence>
3693 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3694 <xsd:attribute name="defaultTableStyle" type="xsd:string" use="optional"/>
3695 <xsd:attribute name="defaultPivotStyle" type="xsd:string" use="optional"/>
3696 </xsd:complexType>
3697 <xsd:complexType name="CT_TableStyle">
3698 <xsd:sequence>
3699 <xsd:element name="tableStyleElement" type="CT_TableStyleElement" minOccurs="0"
3700 maxOccurs="unbounded"/>
3701 </xsd:sequence>
3702 <xsd:attribute name="name" type="xsd:string" use="required"/>
3703 <xsd:attribute name="pivot" type="xsd:boolean" use="optional" default="true"/>
3704 <xsd:attribute name="table" type="xsd:boolean" use="optional" default="true"/>
3705 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3706 </xsd:complexType>
3707 <xsd:complexType name="CT_TableStyleElement">
3708 <xsd:attribute name="type" type="ST_TableStyleType" use="required"/>
3709 <xsd:attribute name="size" type="xsd:unsignedInt" use="optional" default="1"/>
3710 <xsd:attribute name="dxfId" type="ST_DxfId" use="optional"/>
3711 </xsd:complexType>
3712 <xsd:simpleType name="ST_TableStyleType">
3713 <xsd:restriction base="xsd:string">
3714 <xsd:enumeration value="wholeTable"/>
3715 <xsd:enumeration value="headerRow"/>
3716 <xsd:enumeration value="totalRow"/>
3717 <xsd:enumeration value="firstColumn"/>
3718 <xsd:enumeration value="lastColumn"/>
3719 <xsd:enumeration value="firstRowStripe"/>
3720 <xsd:enumeration value="secondRowStripe"/>
3721 <xsd:enumeration value="firstColumnStripe"/>
3722 <xsd:enumeration value="secondColumnStripe"/>
3723 <xsd:enumeration value="firstHeaderCell"/>
3724 <xsd:enumeration value="lastHeaderCell"/>
3725 <xsd:enumeration value="firstTotalCell"/>
3726 <xsd:enumeration value="lastTotalCell"/>
3727 <xsd:enumeration value="firstSubtotalColumn"/>
3728 <xsd:enumeration value="secondSubtotalColumn"/>
3729 <xsd:enumeration value="thirdSubtotalColumn"/>
3730 <xsd:enumeration value="firstSubtotalRow"/>
3731 <xsd:enumeration value="secondSubtotalRow"/>
3732 <xsd:enumeration value="thirdSubtotalRow"/>
3733 <xsd:enumeration value="blankRow"/>
3734 <xsd:enumeration value="firstColumnSubheading"/>
3735 <xsd:enumeration value="secondColumnSubheading"/>
3736 <xsd:enumeration value="thirdColumnSubheading"/>
3737 <xsd:enumeration value="firstRowSubheading"/>
3738 <xsd:enumeration value="secondRowSubheading"/>
3739 <xsd:enumeration value="thirdRowSubheading"/>
3740 <xsd:enumeration value="pageFieldLabels"/>
3741 <xsd:enumeration value="pageFieldValues"/>
3742 </xsd:restriction>
3743 </xsd:simpleType>
3744 <xsd:complexType name="CT_BooleanProperty">
3745 <xsd:attribute name="val" type="xsd:boolean" use="optional" default="true"/>
3746 </xsd:complexType>
3747 <xsd:complexType name="CT_FontSize">
3748 <xsd:attribute name="val" type="xsd:double" use="required"/>
3749 </xsd:complexType>
3750 <xsd:complexType name="CT_IntProperty">
3751 <xsd:attribute name="val" type="xsd:int" use="required"/>
3752 </xsd:complexType>
3753 <xsd:complexType name="CT_FontName">
3754 <xsd:attribute name="val" type="s:ST_Xstring" use="required"/>
3755 </xsd:complexType>
3756 <xsd:complexType name="CT_VerticalAlignFontProperty">
3757 <xsd:attribute name="val" type="s:ST_VerticalAlignRun" use="required"/>
3758 </xsd:complexType>
3759 <xsd:complexType name="CT_FontScheme">
3760 <xsd:attribute name="val" type="ST_FontScheme" use="required"/>
3761 </xsd:complexType>
3762 <xsd:simpleType name="ST_FontScheme">
3763 <xsd:restriction base="xsd:string">
3764 <xsd:enumeration value="none"/>
3765 <xsd:enumeration value="major"/>
3766 <xsd:enumeration value="minor"/>
3767 </xsd:restriction>
3768 </xsd:simpleType>
3769 <xsd:complexType name="CT_UnderlineProperty">
3770 <xsd:attribute name="val" type="ST_UnderlineValues" use="optional" default="single"/>
3771 </xsd:complexType>
3772 <xsd:simpleType name="ST_UnderlineValues">
3773 <xsd:restriction base="xsd:string">
3774 <xsd:enumeration value="single"/>
3775 <xsd:enumeration value="double"/>
3776 <xsd:enumeration value="singleAccounting"/>
3777 <xsd:enumeration value="doubleAccounting"/>
3778 <xsd:enumeration value="none"/>
3779 </xsd:restriction>
3780 </xsd:simpleType>
3781 <xsd:complexType name="CT_Font">
3782 <xsd:choice maxOccurs="unbounded">
3783 <xsd:element name="name" type="CT_FontName" minOccurs="0" maxOccurs="1"/>
3784 <xsd:element name="charset" type="CT_IntProperty" minOccurs="0" maxOccurs="1"/>
3785 <xsd:element name="family" type="CT_FontFamily" minOccurs="0" maxOccurs="1"/>
3786 <xsd:element name="b" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3787 <xsd:element name="i" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3788 <xsd:element name="strike" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3789 <xsd:element name="outline" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3790 <xsd:element name="shadow" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3791 <xsd:element name="condense" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3792 <xsd:element name="extend" type="CT_BooleanProperty" minOccurs="0" maxOccurs="1"/>
3793 <xsd:element name="color" type="CT_Color" minOccurs="0" maxOccurs="1"/>
3794 <xsd:element name="sz" type="CT_FontSize" minOccurs="0" maxOccurs="1"/>
3795 <xsd:element name="u" type="CT_UnderlineProperty" minOccurs="0" maxOccurs="1"/>
3796 <xsd:element name="vertAlign" type="CT_VerticalAlignFontProperty" minOccurs="0" maxOccurs="1"/>
3797 <xsd:element name="scheme" type="CT_FontScheme" minOccurs="0" maxOccurs="1"/>
3798 </xsd:choice>
3799 </xsd:complexType>
3800 <xsd:complexType name="CT_FontFamily">
3801 <xsd:attribute name="val" type="ST_FontFamily" use="required"/>
3802 </xsd:complexType>
3803 <xsd:simpleType name="ST_FontFamily">
3804 <xsd:restriction base="xsd:integer">
3805 <xsd:minInclusive value="0"/>
3806 <xsd:maxInclusive value="14"/>
3807 </xsd:restriction>
3808 </xsd:simpleType>
3809 <xsd:attributeGroup name="AG_AutoFormat">
3810 <xsd:attribute name="autoFormatId" type="xsd:unsignedInt"/>
3811 <xsd:attribute name="applyNumberFormats" type="xsd:boolean"/>
3812 <xsd:attribute name="applyBorderFormats" type="xsd:boolean"/>
3813 <xsd:attribute name="applyFontFormats" type="xsd:boolean"/>
3814 <xsd:attribute name="applyPatternFormats" type="xsd:boolean"/>
3815 <xsd:attribute name="applyAlignmentFormats" type="xsd:boolean"/>
3816 <xsd:attribute name="applyWidthHeightFormats" type="xsd:boolean"/>
3817 </xsd:attributeGroup>
3818 <xsd:element name="externalLink" type="CT_ExternalLink"/>
3819 <xsd:complexType name="CT_ExternalLink">
3820 <xsd:sequence>
3821 <xsd:choice>
3822 <xsd:element name="externalBook" type="CT_ExternalBook" minOccurs="0" maxOccurs="1"/>
3823 <xsd:element name="ddeLink" type="CT_DdeLink" minOccurs="0" maxOccurs="1"/>
3824 <xsd:element name="oleLink" type="CT_OleLink" minOccurs="0" maxOccurs="1"/>
3825 </xsd:choice>
3826 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
3827 </xsd:sequence>
3828 </xsd:complexType>
3829 <xsd:complexType name="CT_ExternalBook">
3830 <xsd:sequence>
3831 <xsd:element name="sheetNames" type="CT_ExternalSheetNames" minOccurs="0" maxOccurs="1"/>
3832 <xsd:element name="definedNames" type="CT_ExternalDefinedNames" minOccurs="0" maxOccurs="1"/>
3833 <xsd:element name="sheetDataSet" type="CT_ExternalSheetDataSet" minOccurs="0" maxOccurs="1"/>
3834 </xsd:sequence>
3835 <xsd:attribute ref="r:id" use="required"/>
3836 </xsd:complexType>
3837 <xsd:complexType name="CT_ExternalSheetNames">
3838 <xsd:sequence>
3839 <xsd:element name="sheetName" minOccurs="1" maxOccurs="unbounded" type="CT_ExternalSheetName"
3840 />
3841 </xsd:sequence>
3842 </xsd:complexType>
3843 <xsd:complexType name="CT_ExternalSheetName">
3844 <xsd:attribute name="val" type="s:ST_Xstring"/>
3845 </xsd:complexType>
3846 <xsd:complexType name="CT_ExternalDefinedNames">
3847 <xsd:sequence>
3848 <xsd:element name="definedName" type="CT_ExternalDefinedName" minOccurs="0"
3849 maxOccurs="unbounded"/>
3850 </xsd:sequence>
3851 </xsd:complexType>
3852 <xsd:complexType name="CT_ExternalDefinedName">
3853 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
3854 <xsd:attribute name="refersTo" type="s:ST_Xstring" use="optional"/>
3855 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="optional"/>
3856 </xsd:complexType>
3857 <xsd:complexType name="CT_ExternalSheetDataSet">
3858 <xsd:sequence>
3859 <xsd:element name="sheetData" type="CT_ExternalSheetData" minOccurs="1" maxOccurs="unbounded"
3860 />
3861 </xsd:sequence>
3862 </xsd:complexType>
3863 <xsd:complexType name="CT_ExternalSheetData">
3864 <xsd:sequence>
3865 <xsd:element name="row" type="CT_ExternalRow" minOccurs="0" maxOccurs="unbounded"/>
3866 </xsd:sequence>
3867 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
3868 <xsd:attribute name="refreshError" type="xsd:boolean" use="optional" default="false"/>
3869 </xsd:complexType>
3870 <xsd:complexType name="CT_ExternalRow">
3871 <xsd:sequence>
3872 <xsd:element name="cell" type="CT_ExternalCell" minOccurs="0" maxOccurs="unbounded"/>
3873 </xsd:sequence>
3874 <xsd:attribute name="r" type="xsd:unsignedInt" use="required"/>
3875 </xsd:complexType>
3876 <xsd:complexType name="CT_ExternalCell">
3877 <xsd:sequence>
3878 <xsd:element name="v" type="s:ST_Xstring" minOccurs="0" maxOccurs="1"/>
3879 </xsd:sequence>
3880 <xsd:attribute name="r" type="ST_CellRef" use="optional"/>
3881 <xsd:attribute name="t" type="ST_CellType" use="optional" default="n"/>
3882 <xsd:attribute name="vm" type="xsd:unsignedInt" use="optional" default="0"/>
3883 </xsd:complexType>
3884 <xsd:complexType name="CT_DdeLink">
3885 <xsd:sequence>
3886 <xsd:element name="ddeItems" type="CT_DdeItems" minOccurs="0" maxOccurs="1"/>
3887 </xsd:sequence>
3888 <xsd:attribute name="ddeService" type="s:ST_Xstring" use="required"/>
3889 <xsd:attribute name="ddeTopic" type="s:ST_Xstring" use="required"/>
3890 </xsd:complexType>
3891 <xsd:complexType name="CT_DdeItems">
3892 <xsd:sequence>
3893 <xsd:element name="ddeItem" type="CT_DdeItem" minOccurs="0" maxOccurs="unbounded"/>
3894 </xsd:sequence>
3895 </xsd:complexType>
3896 <xsd:complexType name="CT_DdeItem">
3897 <xsd:sequence>
3898 <xsd:element name="values" type="CT_DdeValues" minOccurs="0" maxOccurs="1"/>
3899 </xsd:sequence>
3900 <xsd:attribute name="name" type="s:ST_Xstring" default="0"/>
3901 <xsd:attribute name="ole" type="xsd:boolean" use="optional" default="false"/>
3902 <xsd:attribute name="advise" type="xsd:boolean" use="optional" default="false"/>
3903 <xsd:attribute name="preferPic" type="xsd:boolean" use="optional" default="false"/>
3904 </xsd:complexType>
3905 <xsd:complexType name="CT_DdeValues">
3906 <xsd:sequence>
3907 <xsd:element name="value" minOccurs="1" maxOccurs="unbounded" type="CT_DdeValue"/>
3908 </xsd:sequence>
3909 <xsd:attribute name="rows" type="xsd:unsignedInt" use="optional" default="1"/>
3910 <xsd:attribute name="cols" type="xsd:unsignedInt" use="optional" default="1"/>
3911 </xsd:complexType>
3912 <xsd:complexType name="CT_DdeValue">
3913 <xsd:sequence>
3914 <xsd:element name="val" type="s:ST_Xstring" minOccurs="1" maxOccurs="1"/>
3915 </xsd:sequence>
3916 <xsd:attribute name="t" type="ST_DdeValueType" use="optional" default="n"/>
3917 </xsd:complexType>
3918 <xsd:simpleType name="ST_DdeValueType">
3919 <xsd:restriction base="xsd:string">
3920 <xsd:enumeration value="nil"/>
3921 <xsd:enumeration value="b"/>
3922 <xsd:enumeration value="n"/>
3923 <xsd:enumeration value="e"/>
3924 <xsd:enumeration value="str"/>
3925 </xsd:restriction>
3926 </xsd:simpleType>
3927 <xsd:complexType name="CT_OleLink">
3928 <xsd:sequence>
3929 <xsd:element name="oleItems" type="CT_OleItems" minOccurs="0" maxOccurs="1"/>
3930 </xsd:sequence>
3931 <xsd:attribute ref="r:id" use="required"/>
3932 <xsd:attribute name="progId" type="s:ST_Xstring" use="required"/>
3933 </xsd:complexType>
3934 <xsd:complexType name="CT_OleItems">
3935 <xsd:sequence>
3936 <xsd:element name="oleItem" type="CT_OleItem" minOccurs="0" maxOccurs="unbounded"/>
3937 </xsd:sequence>
3938 </xsd:complexType>
3939 <xsd:complexType name="CT_OleItem">
3940 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
3941 <xsd:attribute name="icon" type="xsd:boolean" use="optional" default="false"/>
3942 <xsd:attribute name="advise" type="xsd:boolean" use="optional" default="false"/>
3943 <xsd:attribute name="preferPic" type="xsd:boolean" use="optional" default="false"/>
3944 </xsd:complexType>
3945 <xsd:element name="table" type="CT_Table"/>
3946 <xsd:complexType name="CT_Table">
3947 <xsd:sequence>
3948 <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1"/>
3949 <xsd:element name="sortState" type="CT_SortState" minOccurs="0" maxOccurs="1"/>
3950 <xsd:element name="tableColumns" type="CT_TableColumns" minOccurs="1" maxOccurs="1"/>
3951 <xsd:element name="tableStyleInfo" type="CT_TableStyleInfo" minOccurs="0" maxOccurs="1"/>
3952 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
3953 </xsd:sequence>
3954 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
3955 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
3956 <xsd:attribute name="displayName" type="s:ST_Xstring" use="required"/>
3957 <xsd:attribute name="comment" type="s:ST_Xstring" use="optional"/>
3958 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
3959 <xsd:attribute name="tableType" type="ST_TableType" use="optional" default="worksheet"/>
3960 <xsd:attribute name="headerRowCount" type="xsd:unsignedInt" use="optional" default="1"/>
3961 <xsd:attribute name="insertRow" type="xsd:boolean" use="optional" default="false"/>
3962 <xsd:attribute name="insertRowShift" type="xsd:boolean" use="optional" default="false"/>
3963 <xsd:attribute name="totalsRowCount" type="xsd:unsignedInt" use="optional" default="0"/>
3964 <xsd:attribute name="totalsRowShown" type="xsd:boolean" use="optional" default="true"/>
3965 <xsd:attribute name="published" type="xsd:boolean" use="optional" default="false"/>
3966 <xsd:attribute name="headerRowDxfId" type="ST_DxfId" use="optional"/>
3967 <xsd:attribute name="dataDxfId" type="ST_DxfId" use="optional"/>
3968 <xsd:attribute name="totalsRowDxfId" type="ST_DxfId" use="optional"/>
3969 <xsd:attribute name="headerRowBorderDxfId" type="ST_DxfId" use="optional"/>
3970 <xsd:attribute name="tableBorderDxfId" type="ST_DxfId" use="optional"/>
3971 <xsd:attribute name="totalsRowBorderDxfId" type="ST_DxfId" use="optional"/>
3972 <xsd:attribute name="headerRowCellStyle" type="s:ST_Xstring" use="optional"/>
3973 <xsd:attribute name="dataCellStyle" type="s:ST_Xstring" use="optional"/>
3974 <xsd:attribute name="totalsRowCellStyle" type="s:ST_Xstring" use="optional"/>
3975 <xsd:attribute name="connectionId" type="xsd:unsignedInt" use="optional"/>
3976 </xsd:complexType>
3977 <xsd:simpleType name="ST_TableType">
3978 <xsd:restriction base="xsd:string">
3979 <xsd:enumeration value="worksheet"/>
3980 <xsd:enumeration value="xml"/>
3981 <xsd:enumeration value="queryTable"/>
3982 </xsd:restriction>
3983 </xsd:simpleType>
3984 <xsd:complexType name="CT_TableStyleInfo">
3985 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
3986 <xsd:attribute name="showFirstColumn" type="xsd:boolean" use="optional"/>
3987 <xsd:attribute name="showLastColumn" type="xsd:boolean" use="optional"/>
3988 <xsd:attribute name="showRowStripes" type="xsd:boolean" use="optional"/>
3989 <xsd:attribute name="showColumnStripes" type="xsd:boolean" use="optional"/>
3990 </xsd:complexType>
3991 <xsd:complexType name="CT_TableColumns">
3992 <xsd:sequence>
3993 <xsd:element name="tableColumn" type="CT_TableColumn" minOccurs="1" maxOccurs="unbounded"/>
3994 </xsd:sequence>
3995 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
3996 </xsd:complexType>
3997 <xsd:complexType name="CT_TableColumn">
3998 <xsd:sequence>
3999 <xsd:element name="calculatedColumnFormula" type="CT_TableFormula" minOccurs="0" maxOccurs="1"/>
4000 <xsd:element name="totalsRowFormula" type="CT_TableFormula" minOccurs="0" maxOccurs="1"/>
4001 <xsd:element name="xmlColumnPr" type="CT_XmlColumnPr" minOccurs="0" maxOccurs="1"/>
4002 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
4003 </xsd:sequence>
4004 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
4005 <xsd:attribute name="uniqueName" type="s:ST_Xstring" use="optional"/>
4006 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
4007 <xsd:attribute name="totalsRowFunction" type="ST_TotalsRowFunction" use="optional"
4008 default="none"/>
4009 <xsd:attribute name="totalsRowLabel" type="s:ST_Xstring" use="optional"/>
4010 <xsd:attribute name="queryTableFieldId" type="xsd:unsignedInt" use="optional"/>
4011 <xsd:attribute name="headerRowDxfId" type="ST_DxfId" use="optional"/>
4012 <xsd:attribute name="dataDxfId" type="ST_DxfId" use="optional"/>
4013 <xsd:attribute name="totalsRowDxfId" type="ST_DxfId" use="optional"/>
4014 <xsd:attribute name="headerRowCellStyle" type="s:ST_Xstring" use="optional"/>
4015 <xsd:attribute name="dataCellStyle" type="s:ST_Xstring" use="optional"/>
4016 <xsd:attribute name="totalsRowCellStyle" type="s:ST_Xstring" use="optional"/>
4017 </xsd:complexType>
4018 <xsd:complexType name="CT_TableFormula">
4019 <xsd:simpleContent>
4020 <xsd:extension base="ST_Formula">
4021 <xsd:attribute name="array" type="xsd:boolean" default="false"/>
4022 </xsd:extension>
4023 </xsd:simpleContent>
4024 </xsd:complexType>
4025 <xsd:simpleType name="ST_TotalsRowFunction">
4026 <xsd:restriction base="xsd:string">
4027 <xsd:enumeration value="none"/>
4028 <xsd:enumeration value="sum"/>
4029 <xsd:enumeration value="min"/>
4030 <xsd:enumeration value="max"/>
4031 <xsd:enumeration value="average"/>
4032 <xsd:enumeration value="count"/>
4033 <xsd:enumeration value="countNums"/>
4034 <xsd:enumeration value="stdDev"/>
4035 <xsd:enumeration value="var"/>
4036 <xsd:enumeration value="custom"/>
4037 </xsd:restriction>
4038 </xsd:simpleType>
4039 <xsd:complexType name="CT_XmlColumnPr">
4040 <xsd:sequence>
4041 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
4042 </xsd:sequence>
4043 <xsd:attribute name="mapId" type="xsd:unsignedInt" use="required"/>
4044 <xsd:attribute name="xpath" type="s:ST_Xstring" use="required"/>
4045 <xsd:attribute name="denormalized" type="xsd:boolean" use="optional" default="false"/>
4046 <xsd:attribute name="xmlDataType" type="ST_XmlDataType" use="required"/>
4047 </xsd:complexType>
4048 <xsd:simpleType name="ST_XmlDataType">
4049 <xsd:restriction base="xsd:string"/>
4050 </xsd:simpleType>
4051 <xsd:element name="volTypes" type="CT_VolTypes"/>
4052 <xsd:complexType name="CT_VolTypes">
4053 <xsd:sequence>
4054 <xsd:element name="volType" type="CT_VolType" minOccurs="1" maxOccurs="unbounded"/>
4055 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
4056 </xsd:sequence>
4057 </xsd:complexType>
4058 <xsd:complexType name="CT_VolType">
4059 <xsd:sequence>
4060 <xsd:element name="main" type="CT_VolMain" minOccurs="1" maxOccurs="unbounded"/>
4061 </xsd:sequence>
4062 <xsd:attribute name="type" type="ST_VolDepType" use="required"/>
4063 </xsd:complexType>
4064 <xsd:complexType name="CT_VolMain">
4065 <xsd:sequence>
4066 <xsd:element name="tp" type="CT_VolTopic" minOccurs="1" maxOccurs="unbounded"/>
4067 </xsd:sequence>
4068 <xsd:attribute name="first" type="s:ST_Xstring" use="required"/>
4069 </xsd:complexType>
4070 <xsd:complexType name="CT_VolTopic">
4071 <xsd:sequence>
4072 <xsd:element name="v" type="s:ST_Xstring" minOccurs="1" maxOccurs="1"/>
4073 <xsd:element name="stp" type="s:ST_Xstring" minOccurs="0" maxOccurs="unbounded"/>
4074 <xsd:element name="tr" type="CT_VolTopicRef" minOccurs="1" maxOccurs="unbounded"/>
4075 </xsd:sequence>
4076 <xsd:attribute name="t" type="ST_VolValueType" use="optional" default="n"/>
4077 </xsd:complexType>
4078 <xsd:complexType name="CT_VolTopicRef">
4079 <xsd:attribute name="r" type="ST_CellRef" use="required"/>
4080 <xsd:attribute name="s" type="xsd:unsignedInt" use="required"/>
4081 </xsd:complexType>
4082 <xsd:simpleType name="ST_VolDepType">
4083 <xsd:restriction base="xsd:string">
4084 <xsd:enumeration value="realTimeData"/>
4085 <xsd:enumeration value="olapFunctions"/>
4086 </xsd:restriction>
4087 </xsd:simpleType>
4088 <xsd:simpleType name="ST_VolValueType">
4089 <xsd:restriction base="xsd:string">
4090 <xsd:enumeration value="b"/>
4091 <xsd:enumeration value="n"/>
4092 <xsd:enumeration value="e"/>
4093 <xsd:enumeration value="s"/>
4094 </xsd:restriction>
4095 </xsd:simpleType>
4096 <xsd:element name="workbook" type="CT_Workbook"/>
4097 <xsd:complexType name="CT_Workbook">
4098 <xsd:sequence>
4099 <xsd:element name="fileVersion" type="CT_FileVersion" minOccurs="0" maxOccurs="1"/>
4100 <xsd:element name="fileSharing" type="CT_FileSharing" minOccurs="0" maxOccurs="1"/>
4101 <xsd:element name="workbookPr" type="CT_WorkbookPr" minOccurs="0" maxOccurs="1"/>
4102 <xsd:element name="workbookProtection" type="CT_WorkbookProtection" minOccurs="0"
4103 maxOccurs="1"/>
4104 <xsd:element name="bookViews" type="CT_BookViews" minOccurs="0" maxOccurs="1"/>
4105 <xsd:element name="sheets" type="CT_Sheets" minOccurs="1" maxOccurs="1"/>
4106 <xsd:element name="functionGroups" type="CT_FunctionGroups" minOccurs="0" maxOccurs="1"/>
4107 <xsd:element name="externalReferences" type="CT_ExternalReferences" minOccurs="0"
4108 maxOccurs="1"/>
4109 <xsd:element name="definedNames" type="CT_DefinedNames" minOccurs="0" maxOccurs="1"/>
4110 <xsd:element name="calcPr" type="CT_CalcPr" minOccurs="0" maxOccurs="1"/>
4111 <xsd:element name="oleSize" type="CT_OleSize" minOccurs="0" maxOccurs="1"/>
4112 <xsd:element name="customWorkbookViews" type="CT_CustomWorkbookViews" minOccurs="0"
4113 maxOccurs="1"/>
4114 <xsd:element name="pivotCaches" type="CT_PivotCaches" minOccurs="0" maxOccurs="1"/>
4115 <xsd:element name="smartTagPr" type="CT_SmartTagPr" minOccurs="0" maxOccurs="1"/>
4116 <xsd:element name="smartTagTypes" type="CT_SmartTagTypes" minOccurs="0" maxOccurs="1"/>
4117 <xsd:element name="webPublishing" type="CT_WebPublishing" minOccurs="0" maxOccurs="1"/>
4118 <xsd:element name="fileRecoveryPr" type="CT_FileRecoveryPr" minOccurs="0"
4119 maxOccurs="unbounded"/>
4120 <xsd:element name="webPublishObjects" type="CT_WebPublishObjects" minOccurs="0" maxOccurs="1"/>
4121 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
4122 </xsd:sequence>
4123 <xsd:attribute name="conformance" type="s:ST_ConformanceClass"/>
4124 </xsd:complexType>
4125 <xsd:complexType name="CT_FileVersion">
4126 <xsd:attribute name="appName" type="xsd:string" use="optional"/>
4127 <xsd:attribute name="lastEdited" type="xsd:string" use="optional"/>
4128 <xsd:attribute name="lowestEdited" type="xsd:string" use="optional"/>
4129 <xsd:attribute name="rupBuild" type="xsd:string" use="optional"/>
4130 <xsd:attribute name="codeName" type="s:ST_Guid" use="optional"/>
4131 </xsd:complexType>
4132 <xsd:complexType name="CT_BookViews">
4133 <xsd:sequence>
4134 <xsd:element name="workbookView" type="CT_BookView" minOccurs="1" maxOccurs="unbounded"/>
4135 </xsd:sequence>
4136 </xsd:complexType>
4137 <xsd:complexType name="CT_BookView">
4138 <xsd:sequence>
4139 <xsd:element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
4140 </xsd:sequence>
4141 <xsd:attribute name="visibility" type="ST_Visibility" use="optional" default="visible"/>
4142 <xsd:attribute name="minimized" type="xsd:boolean" use="optional" default="false"/>
4143 <xsd:attribute name="showHorizontalScroll" type="xsd:boolean" use="optional" default="true"/>
4144 <xsd:attribute name="showVerticalScroll" type="xsd:boolean" use="optional" default="true"/>
4145 <xsd:attribute name="showSheetTabs" type="xsd:boolean" use="optional" default="true"/>
4146 <xsd:attribute name="xWindow" type="xsd:int" use="optional"/>
4147 <xsd:attribute name="yWindow" type="xsd:int" use="optional"/>
4148 <xsd:attribute name="windowWidth" type="xsd:unsignedInt" use="optional"/>
4149 <xsd:attribute name="windowHeight" type="xsd:unsignedInt" use="optional"/>
4150 <xsd:attribute name="tabRatio" type="xsd:unsignedInt" use="optional" default="600"/>
4151 <xsd:attribute name="firstSheet" type="xsd:unsignedInt" use="optional" default="0"/>
4152 <xsd:attribute name="activeTab" type="xsd:unsignedInt" use="optional" default="0"/>
4153 <xsd:attribute name="autoFilterDateGrouping" type="xsd:boolean" use="optional" default="true"/>
4154 </xsd:complexType>
4155 <xsd:simpleType name="ST_Visibility">
4156 <xsd:restriction base="xsd:string">
4157 <xsd:enumeration value="visible"/>
4158 <xsd:enumeration value="hidden"/>
4159 <xsd:enumeration value="veryHidden"/>
4160 </xsd:restriction>
4161 </xsd:simpleType>
4162 <xsd:complexType name="CT_CustomWorkbookViews">
4163 <xsd:sequence>
4164 <xsd:element name="customWorkbookView" minOccurs="1" maxOccurs="unbounded"
4165 type="CT_CustomWorkbookView"/>
4166 </xsd:sequence>
4167 </xsd:complexType>
4168 <xsd:complexType name="CT_CustomWorkbookView">
4169 <xsd:sequence>
4170 <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
4171 </xsd:sequence>
4172 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
4173 <xsd:attribute name="guid" type="s:ST_Guid" use="required"/>
4174 <xsd:attribute name="autoUpdate" type="xsd:boolean" use="optional" default="false"/>
4175 <xsd:attribute name="mergeInterval" type="xsd:unsignedInt" use="optional"/>
4176 <xsd:attribute name="changesSavedWin" type="xsd:boolean" use="optional" default="false"/>
4177 <xsd:attribute name="onlySync" type="xsd:boolean" use="optional" default="false"/>
4178 <xsd:attribute name="personalView" type="xsd:boolean" use="optional" default="false"/>
4179 <xsd:attribute name="includePrintSettings" type="xsd:boolean" use="optional" default="true"/>
4180 <xsd:attribute name="includeHiddenRowCol" type="xsd:boolean" use="optional" default="true"/>
4181 <xsd:attribute name="maximized" type="xsd:boolean" use="optional" default="false"/>
4182 <xsd:attribute name="minimized" type="xsd:boolean" use="optional" default="false"/>
4183 <xsd:attribute name="showHorizontalScroll" type="xsd:boolean" use="optional" default="true"/>
4184 <xsd:attribute name="showVerticalScroll" type="xsd:boolean" use="optional" default="true"/>
4185 <xsd:attribute name="showSheetTabs" type="xsd:boolean" use="optional" default="true"/>
4186 <xsd:attribute name="xWindow" type="xsd:int" use="optional" default="0"/>
4187 <xsd:attribute name="yWindow" type="xsd:int" use="optional" default="0"/>
4188 <xsd:attribute name="windowWidth" type="xsd:unsignedInt" use="required"/>
4189 <xsd:attribute name="windowHeight" type="xsd:unsignedInt" use="required"/>
4190 <xsd:attribute name="tabRatio" type="xsd:unsignedInt" use="optional" default="600"/>
4191 <xsd:attribute name="activeSheetId" type="xsd:unsignedInt" use="required"/>
4192 <xsd:attribute name="showFormulaBar" type="xsd:boolean" use="optional" default="true"/>
4193 <xsd:attribute name="showStatusbar" type="xsd:boolean" use="optional" default="true"/>
4194 <xsd:attribute name="showComments" type="ST_Comments" use="optional" default="commIndicator"/>
4195 <xsd:attribute name="showObjects" type="ST_Objects" use="optional" default="all"/>
4196 </xsd:complexType>
4197 <xsd:simpleType name="ST_Comments">
4198 <xsd:restriction base="xsd:string">
4199 <xsd:enumeration value="commNone"/>
4200 <xsd:enumeration value="commIndicator"/>
4201 <xsd:enumeration value="commIndAndComment"/>
4202 </xsd:restriction>
4203 </xsd:simpleType>
4204 <xsd:simpleType name="ST_Objects">
4205 <xsd:restriction base="xsd:string">
4206 <xsd:enumeration value="all"/>
4207 <xsd:enumeration value="placeholders"/>
4208 <xsd:enumeration value="none"/>
4209 </xsd:restriction>
4210 </xsd:simpleType>
4211 <xsd:complexType name="CT_Sheets">
4212 <xsd:sequence>
4213 <xsd:element name="sheet" type="CT_Sheet" minOccurs="1" maxOccurs="unbounded"/>
4214 </xsd:sequence>
4215 </xsd:complexType>
4216 <xsd:complexType name="CT_Sheet">
4217 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
4218 <xsd:attribute name="sheetId" type="xsd:unsignedInt" use="required"/>
4219 <xsd:attribute name="state" type="ST_SheetState" use="optional" default="visible"/>
4220 <xsd:attribute ref="r:id" use="required"/>
4221 </xsd:complexType>
4222 <xsd:simpleType name="ST_SheetState">
4223 <xsd:restriction base="xsd:string">
4224 <xsd:enumeration value="visible"/>
4225 <xsd:enumeration value="hidden"/>
4226 <xsd:enumeration value="veryHidden"/>
4227 </xsd:restriction>
4228 </xsd:simpleType>
4229 <xsd:complexType name="CT_WorkbookPr">
4230 <xsd:attribute name="date1904" type="xsd:boolean" use="optional" default="false"/>
4231 <xsd:attribute name="showObjects" type="ST_Objects" use="optional" default="all"/>
4232 <xsd:attribute name="showBorderUnselectedTables" type="xsd:boolean" use="optional"
4233 default="true"/>
4234 <xsd:attribute name="filterPrivacy" type="xsd:boolean" use="optional" default="false"/>
4235 <xsd:attribute name="promptedSolutions" type="xsd:boolean" use="optional" default="false"/>
4236 <xsd:attribute name="showInkAnnotation" type="xsd:boolean" use="optional" default="true"/>
4237 <xsd:attribute name="backupFile" type="xsd:boolean" use="optional" default="false"/>
4238 <xsd:attribute name="saveExternalLinkValues" type="xsd:boolean" use="optional" default="true"/>
4239 <xsd:attribute name="updateLinks" type="ST_UpdateLinks" use="optional" default="userSet"/>
4240 <xsd:attribute name="codeName" type="xsd:string" use="optional"/>
4241 <xsd:attribute name="hidePivotFieldList" type="xsd:boolean" use="optional" default="false"/>
4242 <xsd:attribute name="showPivotChartFilter" type="xsd:boolean" default="false"/>
4243 <xsd:attribute name="allowRefreshQuery" type="xsd:boolean" use="optional" default="false"/>
4244 <xsd:attribute name="publishItems" type="xsd:boolean" use="optional" default="false"/>
4245 <xsd:attribute name="checkCompatibility" type="xsd:boolean" use="optional" default="false"/>
4246 <xsd:attribute name="autoCompressPictures" type="xsd:boolean" use="optional" default="true"/>
4247 <xsd:attribute name="refreshAllConnections" type="xsd:boolean" use="optional" default="false"/>
4248 <xsd:attribute name="defaultThemeVersion" type="xsd:unsignedInt" use="optional"/>
4249 </xsd:complexType>
4250 <xsd:simpleType name="ST_UpdateLinks">
4251 <xsd:restriction base="xsd:string">
4252 <xsd:enumeration value="userSet"/>
4253 <xsd:enumeration value="never"/>
4254 <xsd:enumeration value="always"/>
4255 </xsd:restriction>
4256 </xsd:simpleType>
4257 <xsd:complexType name="CT_SmartTagPr">
4258 <xsd:attribute name="embed" type="xsd:boolean" use="optional" default="false"/>
4259 <xsd:attribute name="show" type="ST_SmartTagShow" use="optional" default="all"/>
4260 </xsd:complexType>
4261 <xsd:simpleType name="ST_SmartTagShow">
4262 <xsd:restriction base="xsd:string">
4263 <xsd:enumeration value="all"/>
4264 <xsd:enumeration value="none"/>
4265 <xsd:enumeration value="noIndicator"/>
4266 </xsd:restriction>
4267 </xsd:simpleType>
4268 <xsd:complexType name="CT_SmartTagTypes">
4269 <xsd:sequence>
4270 <xsd:element name="smartTagType" type="CT_SmartTagType" minOccurs="0" maxOccurs="unbounded"/>
4271 </xsd:sequence>
4272 </xsd:complexType>
4273 <xsd:complexType name="CT_SmartTagType">
4274 <xsd:attribute name="namespaceUri" type="s:ST_Xstring" use="optional"/>
4275 <xsd:attribute name="name" type="s:ST_Xstring" use="optional"/>
4276 <xsd:attribute name="url" type="s:ST_Xstring" use="optional"/>
4277 </xsd:complexType>
4278 <xsd:complexType name="CT_FileRecoveryPr">
4279 <xsd:attribute name="autoRecover" type="xsd:boolean" use="optional" default="true"/>
4280 <xsd:attribute name="crashSave" type="xsd:boolean" use="optional" default="false"/>
4281 <xsd:attribute name="dataExtractLoad" type="xsd:boolean" use="optional" default="false"/>
4282 <xsd:attribute name="repairLoad" type="xsd:boolean" use="optional" default="false"/>
4283 </xsd:complexType>
4284 <xsd:complexType name="CT_CalcPr">
4285 <xsd:attribute name="calcId" type="xsd:unsignedInt"/>
4286 <xsd:attribute name="calcMode" type="ST_CalcMode" use="optional" default="auto"/>
4287 <xsd:attribute name="fullCalcOnLoad" type="xsd:boolean" use="optional" default="false"/>
4288 <xsd:attribute name="refMode" type="ST_RefMode" use="optional" default="A1"/>
4289 <xsd:attribute name="iterate" type="xsd:boolean" use="optional" default="false"/>
4290 <xsd:attribute name="iterateCount" type="xsd:unsignedInt" use="optional" default="100"/>
4291 <xsd:attribute name="iterateDelta" type="xsd:double" use="optional" default="0.001"/>
4292 <xsd:attribute name="fullPrecision" type="xsd:boolean" use="optional" default="true"/>
4293 <xsd:attribute name="calcCompleted" type="xsd:boolean" use="optional" default="true"/>
4294 <xsd:attribute name="calcOnSave" type="xsd:boolean" use="optional" default="true"/>
4295 <xsd:attribute name="concurrentCalc" type="xsd:boolean" use="optional" default="true"/>
4296 <xsd:attribute name="concurrentManualCount" type="xsd:unsignedInt" use="optional"/>
4297 <xsd:attribute name="forceFullCalc" type="xsd:boolean" use="optional"/>
4298 </xsd:complexType>
4299 <xsd:simpleType name="ST_CalcMode">
4300 <xsd:restriction base="xsd:string">
4301 <xsd:enumeration value="manual"/>
4302 <xsd:enumeration value="auto"/>
4303 <xsd:enumeration value="autoNoTable"/>
4304 </xsd:restriction>
4305 </xsd:simpleType>
4306 <xsd:simpleType name="ST_RefMode">
4307 <xsd:restriction base="xsd:string">
4308 <xsd:enumeration value="A1"/>
4309 <xsd:enumeration value="R1C1"/>
4310 </xsd:restriction>
4311 </xsd:simpleType>
4312 <xsd:complexType name="CT_DefinedNames">
4313 <xsd:sequence>
4314 <xsd:element name="definedName" type="CT_DefinedName" minOccurs="0" maxOccurs="unbounded"/>
4315 </xsd:sequence>
4316 </xsd:complexType>
4317 <xsd:complexType name="CT_DefinedName">
4318 <xsd:simpleContent>
4319 <xsd:extension base="ST_Formula">
4320 <xsd:attribute name="name" type="s:ST_Xstring" use="required"/>
4321 <xsd:attribute name="comment" type="s:ST_Xstring" use="optional"/>
4322 <xsd:attribute name="customMenu" type="s:ST_Xstring" use="optional"/>
4323 <xsd:attribute name="description" type="s:ST_Xstring" use="optional"/>
4324 <xsd:attribute name="help" type="s:ST_Xstring" use="optional"/>
4325 <xsd:attribute name="statusBar" type="s:ST_Xstring" use="optional"/>
4326 <xsd:attribute name="localSheetId" type="xsd:unsignedInt" use="optional"/>
4327 <xsd:attribute name="hidden" type="xsd:boolean" use="optional" default="false"/>
4328 <xsd:attribute name="function" type="xsd:boolean" use="optional" default="false"/>
4329 <xsd:attribute name="vbProcedure" type="xsd:boolean" use="optional" default="false"/>
4330 <xsd:attribute name="xlm" type="xsd:boolean" use="optional" default="false"/>
4331 <xsd:attribute name="functionGroupId" type="xsd:unsignedInt" use="optional"/>
4332 <xsd:attribute name="shortcutKey" type="s:ST_Xstring" use="optional"/>
4333 <xsd:attribute name="publishToServer" type="xsd:boolean" use="optional" default="false"/>
4334 <xsd:attribute name="workbookParameter" type="xsd:boolean" use="optional" default="false"/>
4335 </xsd:extension>
4336 </xsd:simpleContent>
4337 </xsd:complexType>
4338 <xsd:complexType name="CT_ExternalReferences">
4339 <xsd:sequence>
4340 <xsd:element name="externalReference" type="CT_ExternalReference" minOccurs="1"
4341 maxOccurs="unbounded"/>
4342 </xsd:sequence>
4343 </xsd:complexType>
4344 <xsd:complexType name="CT_ExternalReference">
4345 <xsd:attribute ref="r:id" use="required"/>
4346 </xsd:complexType>
4347 <xsd:complexType name="CT_SheetBackgroundPicture">
4348 <xsd:attribute ref="r:id" use="required"/>
4349 </xsd:complexType>
4350 <xsd:complexType name="CT_PivotCaches">
4351 <xsd:sequence>
4352 <xsd:element name="pivotCache" type="CT_PivotCache" minOccurs="1" maxOccurs="unbounded"/>
4353 </xsd:sequence>
4354 </xsd:complexType>
4355 <xsd:complexType name="CT_PivotCache">
4356 <xsd:attribute name="cacheId" type="xsd:unsignedInt" use="required"/>
4357 <xsd:attribute ref="r:id" use="required"/>
4358 </xsd:complexType>
4359 <xsd:complexType name="CT_FileSharing">
4360 <xsd:attribute name="readOnlyRecommended" type="xsd:boolean" use="optional" default="false"/>
4361 <xsd:attribute name="userName" type="s:ST_Xstring"/>
4362 <xsd:attribute name="reservationPassword" type="ST_UnsignedShortHex"/>
4363 <xsd:attribute name="algorithmName" type="s:ST_Xstring" use="optional"/>
4364 <xsd:attribute name="hashValue" type="xsd:base64Binary" use="optional"/>
4365 <xsd:attribute name="saltValue" type="xsd:base64Binary" use="optional"/>
4366 <xsd:attribute name="spinCount" type="xsd:unsignedInt" use="optional"/>
4367 </xsd:complexType>
4368 <xsd:complexType name="CT_OleSize">
4369 <xsd:attribute name="ref" type="ST_Ref" use="required"/>
4370 </xsd:complexType>
4371 <xsd:complexType name="CT_WorkbookProtection">
4372 <xsd:attribute name="workbookPassword" type="ST_UnsignedShortHex" use="optional"/>
4373 <xsd:attribute name="workbookPasswordCharacterSet" type="xsd:string" use="optional"/>
4374 <xsd:attribute name="revisionsPassword" type="ST_UnsignedShortHex" use="optional"/>
4375 <xsd:attribute name="revisionsPasswordCharacterSet" type="xsd:string" use="optional"/>
4376 <xsd:attribute name="lockStructure" type="xsd:boolean" use="optional" default="false"/>
4377 <xsd:attribute name="lockWindows" type="xsd:boolean" use="optional" default="false"/>
4378 <xsd:attribute name="lockRevision" type="xsd:boolean" use="optional" default="false"/>
4379 <xsd:attribute name="revisionsAlgorithmName" type="s:ST_Xstring" use="optional"/>
4380 <xsd:attribute name="revisionsHashValue" type="xsd:base64Binary" use="optional"/>
4381 <xsd:attribute name="revisionsSaltValue" type="xsd:base64Binary" use="optional"/>
4382 <xsd:attribute name="revisionsSpinCount" type="xsd:unsignedInt" use="optional"/>
4383 <xsd:attribute name="workbookAlgorithmName" type="s:ST_Xstring" use="optional"/>
4384 <xsd:attribute name="workbookHashValue" type="xsd:base64Binary" use="optional"/>
4385 <xsd:attribute name="workbookSaltValue" type="xsd:base64Binary" use="optional"/>
4386 <xsd:attribute name="workbookSpinCount" type="xsd:unsignedInt" use="optional"/>
4387 </xsd:complexType>
4388 <xsd:complexType name="CT_WebPublishing">
4389 <xsd:attribute name="css" type="xsd:boolean" use="optional" default="true"/>
4390 <xsd:attribute name="thicket" type="xsd:boolean" use="optional" default="true"/>
4391 <xsd:attribute name="longFileNames" type="xsd:boolean" use="optional" default="true"/>
4392 <xsd:attribute name="vml" type="xsd:boolean" use="optional" default="false"/>
4393 <xsd:attribute name="allowPng" type="xsd:boolean" use="optional" default="false"/>
4394 <xsd:attribute name="targetScreenSize" type="ST_TargetScreenSize" use="optional"
4395 default="800x600"/>
4396 <xsd:attribute name="dpi" type="xsd:unsignedInt" use="optional" default="96"/>
4397 <xsd:attribute name="codePage" type="xsd:unsignedInt" use="optional"/>
4398 <xsd:attribute name="characterSet" type="xsd:string" use="optional"/>
4399 </xsd:complexType>
4400 <xsd:simpleType name="ST_TargetScreenSize">
4401 <xsd:restriction base="xsd:string">
4402 <xsd:enumeration value="544x376"/>
4403 <xsd:enumeration value="640x480"/>
4404 <xsd:enumeration value="720x512"/>
4405 <xsd:enumeration value="800x600"/>
4406 <xsd:enumeration value="1024x768"/>
4407 <xsd:enumeration value="1152x882"/>
4408 <xsd:enumeration value="1152x900"/>
4409 <xsd:enumeration value="1280x1024"/>
4410 <xsd:enumeration value="1600x1200"/>
4411 <xsd:enumeration value="1800x1440"/>
4412 <xsd:enumeration value="1920x1200"/>
4413 </xsd:restriction>
4414 </xsd:simpleType>
4415 <xsd:complexType name="CT_FunctionGroups">
4416 <xsd:sequence maxOccurs="unbounded">
4417 <xsd:element name="functionGroup" type="CT_FunctionGroup" minOccurs="0"/>
4418 </xsd:sequence>
4419 <xsd:attribute name="builtInGroupCount" type="xsd:unsignedInt" default="16" use="optional"/>
4420 </xsd:complexType>
4421 <xsd:complexType name="CT_FunctionGroup">
4422 <xsd:attribute name="name" type="s:ST_Xstring"/>
4423 </xsd:complexType>
4424 <xsd:complexType name="CT_WebPublishObjects">
4425 <xsd:sequence>
4426 <xsd:element name="webPublishObject" type="CT_WebPublishObject" minOccurs="1"
4427 maxOccurs="unbounded"/>
4428 </xsd:sequence>
4429 <xsd:attribute name="count" type="xsd:unsignedInt" use="optional"/>
4430 </xsd:complexType>
4431 <xsd:complexType name="CT_WebPublishObject">
4432 <xsd:attribute name="id" type="xsd:unsignedInt" use="required"/>
4433 <xsd:attribute name="divId" type="s:ST_Xstring" use="required"/>
4434 <xsd:attribute name="sourceObject" type="s:ST_Xstring" use="optional"/>
4435 <xsd:attribute name="destinationFile" type="s:ST_Xstring" use="required"/>
4436 <xsd:attribute name="title" type="s:ST_Xstring" use="optional"/>
4437 <xsd:attribute name="autoRepublish" type="xsd:boolean" use="optional" default="false"/>
4438 </xsd:complexType>
4439</xsd:schema>