gnumeric.xsd 52.9 KB
Newer Older
Jody Goldberg's avatar
Jody Goldberg committed
1
<?xml version="1.0" encoding="UTF-8"?>
Jody Goldberg's avatar
Jody Goldberg committed
2
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
3
            xmlns:gnm="http://www.gnumeric.org/v10.dtd"
4
	    xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
5
            targetNamespace="http://www.gnumeric.org/v10.dtd"
Jody Goldberg's avatar
Jody Goldberg committed
6 7 8
            elementFormDefault="qualified"
            attributeFormDefault="unqualified">

Jody Goldberg's avatar
Jody Goldberg committed
9 10
    <xs:annotation>
        <xs:documentation xml:lang="en">
Jody Goldberg's avatar
Jody Goldberg committed
11
            Schema for gnumeric spreadsheet documents
12
            Created for Gnumeric 1.2.2,
13 14 15
            Based on gnumeric source code and sample gnumeric documents
            Author: Marc Johnson (marc_johnson27591@hotmail.com)

16 17
	    updated for 1.4.2 in Feb 2005
	    updated for 1.6.0 in Sept 2005
18
	    updated for 1.7.1 in Jun 2006
19
	    updated for 1.7.11 in Jun 2007	jody@gnome.org
20
	    updated for 1.7.91 in Nov 2007	jody@gnome.org
Jody Goldberg's avatar
Jody Goldberg committed
21 22
        </xs:documentation>
    </xs:annotation>
Jody Goldberg's avatar
Jody Goldberg committed
23
    
Jody Goldberg's avatar
Jody Goldberg committed
24
    <xs:element name="Workbook" type="gnm:Workbook"/>
Jody Goldberg's avatar
Jody Goldberg committed
25

Jody Goldberg's avatar
Jody Goldberg committed
26 27 28 29 30 31 32
    <xs:complexType name="Version">
	<xs:attribute name="Epoch"  type="xs:nonNegativeInteger" use="required"/>
	<xs:attribute name="Major"  type="xs:nonNegativeInteger" use="required"/>
	<xs:attribute name="Minor"  type="xs:nonNegativeInteger" use="required"/>
	<xs:attribute name="Full"   type="xs:string"	    use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
33

Jody Goldberg's avatar
Jody Goldberg committed
34 35 36 37 38 39 40 41
    <xs:complexType name="Workbook">
        <xs:sequence>
            <xs:element name="Version"		type="gnm:Version" minOccurs="0" maxOccurs="1"/>
            <xs:element name="Attributes"	type="gnm:Attributes"/>

	    <!-- ignore office:document-meta -->
	    <xs:any minOccurs="0" maxOccurs="unbounded"
		    namespace="##other" processContents="lax"/>
42 43

	    <!-- ancient files lack this, modern files require it -->
Jody Goldberg's avatar
Jody Goldberg committed
44
            <xs:element name="SheetNameIndex"	type="gnm:SheetNameIndex" minOccurs="0" maxOccurs="1"/>
45

Jody Goldberg's avatar
Jody Goldberg committed
46
            <xs:element name="Names"		type="gnm:Names" minOccurs="0" maxOccurs="1"/>
47 48 49

            <!-- Deprecated, moved to Calculation and expanded in 1.7.11
	         Valid value == 1904, anything else == Lotus:1900 -->
Jody Goldberg's avatar
Jody Goldberg committed
50
            <xs:element name="DateConvention"	type="xs:int" minOccurs="0" maxOccurs="1"/>
51

Jody Goldberg's avatar
Jody Goldberg committed
52
            <!-- preferred height and width -->
Jody Goldberg's avatar
Jody Goldberg committed
53 54 55 56 57 58 59 60
            <xs:element name="Geometry">
                <xs:complexType>
                    <xs:attribute name="Width"  type="xs:nonNegativeInteger" use="optional"/>
                    <xs:attribute name="Height" type="xs:nonNegativeInteger" use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="Sheets"         type="gnm:Sheets"/>
Jody Goldberg's avatar
Jody Goldberg committed
61
            <!-- which sheet was selected when the spreadsheet was saved? -->
Jody Goldberg's avatar
Jody Goldberg committed
62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78
            <xs:element name="UIData">
                <xs:complexType>
                    <xs:attribute name="SelectedTab" type="xs:nonNegativeInteger" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="Calculation" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:attribute name="ManualRecalc"	     type="xs:boolean"/>
                    <xs:attribute name="EnableIteration"    type="xs:boolean"/>
                    <xs:attribute name="MaxIterations"	     type="xs:nonNegativeInteger"/>
		    <xs:attribute name="IterationTolerance" type="xs:double"/>
		    <xs:attribute name="DateConvention"     type="gnm:DateConvention" use="optional" default="Lotus:1900"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
79
        <!-- version number should be v10 - - &gt;
Jody Goldberg's avatar
Jody Goldberg committed
80 81 82
        <xs:attribute name="gnm" type="gnm:namespace" use="required"/> -->
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
83 84

    <!-- How values are mapped to dates.   All date functions are affected -->
Jody Goldberg's avatar
Jody Goldberg committed
85 86 87 88
    <xs:simpleType name="DateConvention">
        <xs:restriction base="xs:string">
            <xs:enumeration value="Lotus:1900"/>
            <xs:enumeration value="Apple:1904"/>
89 90

<!-- future values. currently treated as Lotus:1900 -->
Jody Goldberg's avatar
Jody Goldberg committed
91 92 93 94 95 96 97 98 99 100 101 102 103 104 105
            <xs:enumeration value="ODF:1899"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="CellRef">
        <xs:restriction base="xs:string">
            <xs:pattern value="[A-Z]+\d+"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="Names">
        <xs:sequence>
            <xs:element name="Name" minOccurs="0" maxOccurs="unbounded">
		<xs:complexType>
		    <xs:sequence>
106 107 108
			<!-- an oversight in the sax exporter (fixed in 1.4.3)
			     leaves off the namespace.  Handle both formats.
			  -->
Jody Goldberg's avatar
Jody Goldberg committed
109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157
			<xs:choice>
			    <xs:element name="name"	type="xs:string"/>
			    <xs:element name="name"	type="xs:string" form="unqualified"/>
			</xs:choice>
			<xs:choice>
			    <xs:element name="value"	type="xs:string"/>
			    <xs:element name="value"	type="xs:string" form="unqualified"/>
			</xs:choice>
			<xs:choice>
			    <xs:element name="position" type="xs:string"/>
			    <xs:element name="position" type="xs:string" form="unqualified"/>
			</xs:choice>
		    </xs:sequence>
		</xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="Attributes">
        <xs:sequence>
            <xs:element name="Attribute" minOccurs="0" maxOccurs="unbounded">
		<xs:complexType>
                    <xs:sequence>
			<xs:element name="type"  minOccurs="0" maxOccurs="1" type="gnm:AttributeType"/><!-- must be 4 -->
			<xs:element name="name"  minOccurs="1" maxOccurs="1" type="xs:string"/>
			<xs:element name="value" minOccurs="1" maxOccurs="1" type="xs:string"/>
                    </xs:sequence>
		</xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>
    <xs:simpleType name="AttributeType">
        <xs:restriction base="xs:integer">
            <xs:minInclusive value="4"/>
            <xs:maxInclusive value="4"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="SheetNameIndex">
        <xs:sequence>
            <xs:element name="SheetName" minOccurs="0" maxOccurs="unbounded" type="xs:string"/>
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="Sheets">
        <xs:sequence>
            <xs:element name="Sheet" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                    <xs:sequence>
Jody Goldberg's avatar
Jody Goldberg committed
158
                        <!-- name of the sheet -->
Jody Goldberg's avatar
Jody Goldberg committed
159
                        <xs:element name="Name"             type="xs:string"/>
Jody Goldberg's avatar
Jody Goldberg committed
160
                        <!-- maximum column used -->
Jody Goldberg's avatar
Jody Goldberg committed
161
                        <xs:element name="MaxCol"           type="xs:integer" minOccurs="0" maxOccurs="1"/>
Jody Goldberg's avatar
Jody Goldberg committed
162
                        <!-- maximum row used -->
Jody Goldberg's avatar
Jody Goldberg committed
163
                        <xs:element name="MaxRow"           type="xs:integer" minOccurs="0" maxOccurs="1"/>
Jody Goldberg's avatar
Jody Goldberg committed
164
                        <!-- most recently used zoom factor -->
Jody Goldberg's avatar
Jody Goldberg committed
165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196
                        <xs:element name="Zoom"             type="xs:double"/>
			<xs:element name="Names"	    type="gnm:Names" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="PrintInformation" type="gnm:PrintInformation"/>
                        <xs:element name="Styles"           type="gnm:Styles"/>
                        <xs:element name="Cols">
                            <xs:complexType>
                                <xs:sequence>
                                    <xs:element name="ColInfo" type="gnm:Col_Row" minOccurs="0" maxOccurs="unbounded"/>
                                </xs:sequence>
                                <xs:attribute name="DefaultSizePts" type="xs:double" use="required"/>
				<xs:anyAttribute namespace="##other" processContents="lax"/>
                            </xs:complexType>
                        </xs:element>
                        <xs:element name="Rows">
                            <xs:complexType>
                                <xs:sequence>
                                    <xs:element name="RowInfo" type="gnm:Col_Row" minOccurs="0" maxOccurs="unbounded"/>
                                </xs:sequence>
                                <xs:attribute name="DefaultSizePts" type="xs:double" use="required"/>
				<xs:anyAttribute namespace="##other" processContents="lax"/>
                            </xs:complexType>
                        </xs:element>
                        <xs:element name="Selections"      type="gnm:Selections"/>
                        <xs:element name="Objects"         type="gnm:Objects" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="Cells"           type="gnm:Cells"/>
                        <xs:element name="MergedRegions"   type="gnm:MergedRegions" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="SheetLayout"     type="gnm:SheetLayout" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="Filters"	   type="gnm:Filters" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="Solver"          type="gnm:Solver" minOccurs="0" maxOccurs="1"/>
                        <xs:element name="Scenarios"       type="gnm:Scenarios" minOccurs="0" maxOccurs="1"/>
                    </xs:sequence>
                        <!-- note: xs:boolean values can be true, false, 1, 0;
Jody Goldberg's avatar
Jody Goldberg committed
197 198 199
                             gnumeric, in this element, always generates 'true' or
                             'false' for its attributes
                        -->
Jody Goldberg's avatar
Jody Goldberg committed
200 201 202 203 204 205 206 207 208 209 210 211 212
                    <xs:attribute name="DisplayFormulas"     type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="HideZero"            type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="HideGrid"            type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="HideColHeader"       type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="HideRowHeader"       type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="DisplayOutlines"     type="xs:boolean" use="optional" default="true"/>
                    <xs:attribute name="OutlineSymbolsBelow" type="xs:boolean" use="optional" default="true"/>
                    <xs:attribute name="OutlineSymbolsRight" type="xs:boolean" use="optional" default="true"/>
                    <xs:attribute name="Visibility"	     type="gnm:SheetVisibility" use="optional" default="GNM_SHEET_VISIBILITY_VISIBLE"/>
                    <xs:attribute name="RTL_Layout"	     type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="Protected"	     type="xs:boolean" use="optional" default="false"/>
                    <xs:attribute name="TabColor"	     type="gnm:color"   use="optional"/>
                    <xs:attribute name="TabTextColor"	     type="gnm:color"   use="optional"/>
213
                    <xs:attribute name="GridColor"	     type="gnm:color"   use="optional"/>
Jody Goldberg's avatar
Jody Goldberg committed
214 215 216 217 218 219
		    <xs:attribute name="ExprConvention"      type="gnm:ExprConvention" use="optional" default="gnumeric:A1"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
220

221
    <!-- How expressions are _displayed_ no impact on evaluation -->
Jody Goldberg's avatar
Jody Goldberg committed
222 223 224 225
    <xs:simpleType name="ExprConvention">
        <xs:restriction base="xs:string">
            <xs:enumeration value="gnumeric:A1"/>
            <xs:enumeration value="gnumeric:R1C1"/>
226 227

<!-- future values, currently displayed as gnumeric:A1 -->
Jody Goldberg's avatar
Jody Goldberg committed
228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255
            <xs:enumeration value="ODF:A1"/>
            <xs:enumeration value="Lotus:A1"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="PrintInformation">
        <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="Margins">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="top"    type="gnm:margin"/>
                        <xs:element name="bottom" type="gnm:margin"/>
                        <xs:element name="left"   type="gnm:margin" minOccurs="0" maxOccurs="unbounded"/>
                        <xs:element name="right"  type="gnm:margin" minOccurs="0" maxOccurs="unbounded"/>
                        <xs:element name="header" type="gnm:margin" minOccurs="0" maxOccurs="unbounded"/>
                        <xs:element name="footer" type="gnm:margin" minOccurs="0" maxOccurs="unbounded"/>
                    </xs:sequence>
                </xs:complexType>
            </xs:element>
            <xs:element name="Scale">
                <xs:complexType>
                    <xs:attribute name="type" type="xs:string" use="required"/>
		    <xs:attribute name="percentage" type="xs:double" use="optional"/>
		    <xs:attribute name="cols" type="xs:integer" />
		    <xs:attribute name="rows" type="xs:integer" />
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
256
            <!-- center vertically -->
Jody Goldberg's avatar
Jody Goldberg committed
257 258 259 260 261 262
            <xs:element name="vcenter">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
263
            <!-- center horizontally -->
Jody Goldberg's avatar
Jody Goldberg committed
264 265 266 267 268 269
            <xs:element name="hcenter">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
270
            <!-- print grid lines -->
Jody Goldberg's avatar
Jody Goldberg committed
271 272 273 274 275 276
            <xs:element name="grid">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
277
            <!-- print even if only styles -->
Jody Goldberg's avatar
Jody Goldberg committed
278 279 280 281 282 283
            <xs:element name="even_if_only_styles">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
284
            <!-- print in monochrome -->
Jody Goldberg's avatar
Jody Goldberg committed
285 286 287 288 289 290
            <xs:element name="monochrome">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
291
            <!-- print in draft mode -->
Jody Goldberg's avatar
Jody Goldberg committed
292 293 294 295 296 297
            <xs:element name="draft">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
298
            <!-- print titles -->
Jody Goldberg's avatar
Jody Goldberg committed
299 300 301 302 303 304
            <xs:element name="titles">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:boolean" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
305

Jody Goldberg's avatar
Jody Goldberg committed
306
            <!-- repeat range -->
Jody Goldberg's avatar
Jody Goldberg committed
307 308 309 310 311 312
            <xs:element name="repeat_top" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:string" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
Jody Goldberg's avatar
Jody Goldberg committed
313
            <!-- repeat range -->
Jody Goldberg's avatar
Jody Goldberg committed
314 315 316 317 318 319 320 321 322 323
            <xs:element name="repeat_left" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:attribute name="value" type="xs:string" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="order"       type="gnm:print_ordering"/>
            <xs:element name="orientation" type="gnm:print_orientation"/>
            <xs:element name="Header"	    type="gnm:HeaderFooter"/>
            <xs:element name="Footer"	    type="gnm:HeaderFooter"/>
Jody Goldberg's avatar
Jody Goldberg committed
324
            <!-- typical values are A4, US-Letter -->
Jody Goldberg's avatar
Jody Goldberg committed
325
            <xs:element name="paper"       type="xs:string" minOccurs="0" maxOccurs="1"/>
326
	    <!-- do not print this sheet when "all" is selected in the job -->
Jody Goldberg's avatar
Jody Goldberg committed
327 328 329 330 331
	    <xs:element name="do_not_print"	minOccurs="0" maxOccurs="1">
	        <xs:complexType>
	            <xs:attribute name="value" type="xs:boolean" use="required"/>
	        </xs:complexType>
	    </xs:element>
332
            <xs:element name="print-to-uri" type="xs:string" minOccurs="0" maxOccurs="1"/>
Jody Goldberg's avatar
Jody Goldberg committed
333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371
            <xs:element name="vPageBreaks" type="gnm:PageBreaks" minOccurs="0" maxOccurs="1"/><!-- between rows -->
            <xs:element name="hPageBreaks" type="gnm:PageBreaks" minOccurs="0" maxOccurs="1"/><!-- between cols -->
        </xs:choice>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:complexType name="HeaderFooter">
	<xs:attribute name="Left"   type="xs:string" use="optional"/>
	<xs:attribute name="Middle" type="xs:string" use="optional"/>
	<xs:attribute name="Right"  type="xs:string" use="optional"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:complexType name="PageBreaks">
	<xs:sequence>
	    <xs:element name="break" minOccurs="0" maxOccurs="unbounded">
		<xs:complexType>
		    <xs:attribute name="pos"   type="xs:nonNegativeInteger"	use="required"/>
		    <xs:attribute name="type"  type="gnm:PageBreakType"	use="optional"		default="auto"/>
		</xs:complexType>
	    </xs:element>
	</xs:sequence>
	<xs:attribute name="count" type="xs:nonNegativeInteger" use="optional"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:simpleType name="PageBreakType">
        <xs:restriction base="xs:string">
            <xs:enumeration value="auto"/>
            <xs:enumeration value="manual"/>
            <xs:enumeration value="data-slice"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="margin">
        <xs:attribute name="Points"   type="xs:double"/>
        <xs:attribute name="PrefUnit" type="gnm:print_units"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
372
    
Jody Goldberg's avatar
Jody Goldberg committed
373 374 375 376 377 378 379 380 381 382 383 384 385
    <xs:simpleType name="print_units">
        <xs:restriction base="xs:string">
            <xs:enumeration value="mm"/>
            <xs:enumeration value="cm"/>
            <xs:enumeration value="in"/>
            <xs:enumeration value="Pt"/>
            <xs:enumeration value="Px"/>
            <xs:enumeration value="points"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="print_ordering">
        <xs:restriction base="xs:string">
Jody Goldberg's avatar
Jody Goldberg committed
386
            <!-- right, then down -->
Jody Goldberg's avatar
Jody Goldberg committed
387
            <xs:enumeration value="r_then_d"/>
Jody Goldberg's avatar
Jody Goldberg committed
388
            <!-- down, then right -->
Jody Goldberg's avatar
Jody Goldberg committed
389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508
            <xs:enumeration value="d_then_r"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="print_orientation">
        <xs:restriction base="xs:string">
            <xs:enumeration value="landscape"/>
            <xs:enumeration value="portrait"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="Styles">
        <xs:sequence>
            <xs:element name="StyleRegion" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="Style" type="gnm:Style" minOccurs="1" maxOccurs="1"/>
                    </xs:sequence>
                    <xs:attribute name="startCol" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="startRow" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="endCol"   type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="endRow"   type="xs:nonNegativeInteger" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>

    <xs:complexType name="Style">
        <xs:sequence>
            <xs:element name="Font" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:simpleContent>
                        <xs:extension base="xs:string">
                            <xs:attribute name="Unit"          type="xs:double"	use="required"/>
                            <xs:attribute name="Bold"          type="xs:boolean"	use="required"/>
                            <xs:attribute name="Italic"        type="xs:boolean"	use="required"/>
                            <xs:attribute name="Underline"     type="gnm:underline"	use="required"/>
                            <xs:attribute name="StrikeThrough" type="xs:boolean"	use="required"/>
                            <xs:attribute name="Script"        type="gnm:script"	use="required"/>
			    <xs:anyAttribute namespace="##other" processContents="lax"/>
                        </xs:extension>
                    </xs:simpleContent>
                </xs:complexType>
            </xs:element>
            <xs:element name="HyperLink" minOccurs="0" maxOccurs="1">
                <xs:complexType>
		    <xs:attribute name="type"          type="xs:string"  use="required"/>
		    <xs:attribute name="target"        type="xs:string"  use="optional"/>
		    <xs:attribute name="tip"		type="xs:string"  use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="StyleBorder" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="Top"          type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                        <xs:element name="Bottom"       type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                        <xs:element name="Left"         type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                        <xs:element name="Right"        type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                        <xs:element name="Diagonal"     type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                        <xs:element name="Rev-Diagonal" type="gnm:StyleBorderElement"	minOccurs="0"	maxOccurs="1"/>
                    </xs:sequence>
                </xs:complexType>
            </xs:element>
            <xs:element name="Validation" minOccurs="0" maxOccurs="1">
                <xs:complexType>
                    <xs:sequence>
			<xs:element name="Expression0"	type="xs:string"   minOccurs="0"	maxOccurs="1"/>
			<xs:element name="Expression1"	type="xs:string"   minOccurs="0"	maxOccurs="1"/>
                    </xs:sequence>
		    <xs:attribute name="Style"		type="xs:integer"  use="required"/>
		    <xs:attribute name="Type"		type="xs:integer"  use="required"/>
		    <xs:attribute name="Operator"	type="xs:integer"  use="optional"/>
		    <xs:attribute name="AllowBlank"	type="xs:boolean"  use="optional"/>
		    <xs:attribute name="UseDropdown"	type="xs:boolean"  use="optional"/>
		    <xs:attribute name="Title"		type="xs:string"   use="optional"/>
		    <xs:attribute name="Message"	type="xs:string"   use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>

            <xs:element name="InputMessage" minOccurs="0" maxOccurs="1">
                <xs:complexType>
		    <xs:attribute name="Title"          type="xs:string"  use="optional"/>
		    <xs:attribute name="Message"        type="xs:string"  use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="Condition" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
		    <xs:sequence>
			<xs:element name="Expression0"	type="xs:string"  minOccurs="0" maxOccurs="1"/>
			<xs:element name="Expression1"	type="xs:string"  minOccurs="0" maxOccurs="1"/>
			<xs:element name="Style"	type="gnm:Style"  minOccurs="1" maxOccurs="1"/>
		    </xs:sequence>
		    <xs:attribute name="Operator"	type="gnm:CondOp" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
        <xs:attribute name="HAlign"	  type="gnm:horizontal_alignment"/>
        <xs:attribute name="VAlign"	  type="gnm:vertical_alignment"/>
        <xs:attribute name="WrapText"	  type="xs:boolean"	  />

	<!-- should be bool, but some files have odd truth values -->
        <xs:attribute name="ShrinkToFit"  type="xs:integer"	  />

        <xs:attribute name="Rotation"	  type="xs:integer"	use="optional"/>
        <xs:attribute name="Orient"	  type="xs:integer"	use="optional"/>
        <xs:attribute name="Shade"	  type="gnm:Stipple"	use="optional"/>
        <xs:attribute name="Indent"	  type="xs:integer"	use="optional"/>
        <xs:attribute name="Locked"	  type="xs:boolean"	use="optional"/>
        <xs:attribute name="Hidden"	  type="xs:boolean"	use="optional"/>
        <xs:attribute name="Fore"	  type="gnm:color"	use="optional"/>
        <xs:attribute name="Back"         type="gnm:color"	use="optional"/>
        <xs:attribute name="PatternColor" type="gnm:color"	use="optional"/>
        <xs:attribute name="Format"	  type="xs:string"	use="optional"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
509
    
Jody Goldberg's avatar
Jody Goldberg committed
510 511
    <xs:complexType name="StyleBorderElement">
        <xs:attribute name="Style" type="gnm:border_style" use="required"/>
Jody Goldberg's avatar
Jody Goldberg committed
512
        <!-- Color is present when Style is not 0 -->
Jody Goldberg's avatar
Jody Goldberg committed
513 514 515
        <xs:attribute name="Color" type="gnm:color"        use="optional"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
516
    
Jody Goldberg's avatar
Jody Goldberg committed
517 518
    <xs:simpleType name="border_style">
        <xs:restriction base="xs:integer">
Jody Goldberg's avatar
Jody Goldberg committed
519 520 521 522 523 524 525 526 527 528 529 530 531 532 533
            <!--  0 = NONE
                  1 = THIN
                  2 = MEDIUM
                  3 = DASHED
                  4 = DOTTED
                  5 = THICK
                  6 = DOUBLE
                  7 = HAIR
                  8 = MEDIUM_DASH
                  9 = DASH_DOT
                 10 = MEDIUM_DASH_DOT
                 11 = DASH_DOT_DOT
                 12 = MEDIUM_DASH_DOT_DOT
                 13 = SLANTED_DASH_DOT
            -->
Jody Goldberg's avatar
Jody Goldberg committed
534 535 536 537
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="13"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
538

Jody Goldberg's avatar
Jody Goldberg committed
539 540
    <xs:simpleType name="underline">
        <xs:restriction base="xs:integer">
Jody Goldberg's avatar
Jody Goldberg committed
541 542 543 544
            <!-- 0 = NONE
                 1 = SINGLE
                 2 = DOUBLE
            -->
Jody Goldberg's avatar
Jody Goldberg committed
545 546 547 548
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="2"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
549

Jody Goldberg's avatar
Jody Goldberg committed
550 551
    <xs:simpleType name="script">
        <xs:restriction base="xs:integer">
552 553 554 555
            <!-- GO_FONT_SCRIPT_SUB	 = -1,
	         GO_FONT_SCRIPT_STANDARD =  0,
		 GO_FONT_SCRIPT_SUPER	 =  1
            -->
Jody Goldberg's avatar
Jody Goldberg committed
556 557 558 559
            <xs:minInclusive value="-1"/>
            <xs:maxInclusive value="1"/>
        </xs:restriction>
    </xs:simpleType>
560

Jody Goldberg's avatar
Jody Goldberg committed
561 562
    <xs:simpleType name="horizontal_alignment">
        <xs:restriction base="xs:integer">
Jody Goldberg's avatar
Jody Goldberg committed
563 564 565 566 567 568 569 570
            <!-- this is a bit map as follows:
                  1 = GENERAL
                  2 = LEFT
                  4 = RIGHT
                  8 = CENTER
                 16 = FILL
                 32 = JUSTIFY
                 64 = CENTER ACROSS SELECTION
571
		128 = DISTRIBUTED
Jody Goldberg's avatar
Jody Goldberg committed
572
            -->
Jody Goldberg's avatar
Jody Goldberg committed
573 574 575 576
            <xs:minInclusive value="1"/>
            <xs:maxInclusive value="128"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
577

Jody Goldberg's avatar
Jody Goldberg committed
578 579
    <xs:simpleType name="vertical_alignment">
        <xs:restriction base="xs:integer">
Jody Goldberg's avatar
Jody Goldberg committed
580 581 582 583 584
            <!-- this is a bit map as follows:
                 1 = TOP
                 2 = BOTTOM
                 4 = CENTER
                 8 = JUSTIFY
585
                16 = DISTRIBUTED
Jody Goldberg's avatar
Jody Goldberg committed
586
            -->
Jody Goldberg's avatar
Jody Goldberg committed
587 588 589 590
            <xs:minInclusive value="1"/>
            <xs:maxInclusive value="16"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
591

Jody Goldberg's avatar
Jody Goldberg committed
592 593
    <xs:simpleType name="Stipple">
        <xs:restriction base="xs:integer">
Jody Goldberg's avatar
Jody Goldberg committed
594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621
            <!-- the values are defined as follows:
                  0 = NONE
                  1 = Solid
                  2 = 75%
                  3 = 50%
                  4 = 25%
                  5 = 12.5%
                  6 = 6.25%
                  7 = Horizontal Stripe
                  8 = Vertical Stripe
                  9 = Reverse Diagonal Stripe
                 10 = Diagonal Stripe
                 11 = Diagonal Crosshatch
                 12 = Thick Diagonal Crosshatch
                 13 = Thin Horizontal Stripe
                 14 = Thin Vertical Stripe
                 15 = Thin Reverse Diagonal Stripe
                 16 = Thin Diagonal Stripe
                 17 = Thin Crosshatch
                 18 = Thin Diagonal Crosshatch
                 19 = Applix small circle
                 20 = Applix semicircle
                 21 = Applix small thatch
                 22 = Applix round thatch
                 23 = Applix Brick
                 24 = 100%
                 25 = 87.5%
            -->
Jody Goldberg's avatar
Jody Goldberg committed
622 623 624 625
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="25"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
626

Jody Goldberg's avatar
Jody Goldberg committed
627 628
    <xs:simpleType name="color">
        <xs:restriction base="xs:string">
Jody Goldberg's avatar
Jody Goldberg committed
629
            <!-- colors in hex, 16 bits red, green, then blue -->
Jody Goldberg's avatar
Jody Goldberg committed
630 631 632
            <xs:pattern value="[0-9A-F]{1,4}:[0-9A-F]{1,4}:[0-9A-F]{1,4}"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
633

Jody Goldberg's avatar
Jody Goldberg committed
634
    <xs:complexType name="Col_Row">
Jody Goldberg's avatar
Jody Goldberg committed
635
        <!-- column/row number -->
Jody Goldberg's avatar
Jody Goldberg committed
636
        <xs:attribute name="No"           type="xs:nonNegativeInteger" use="required"/>
Jody Goldberg's avatar
Jody Goldberg committed
637
        <!-- size in points -->
Jody Goldberg's avatar
Jody Goldberg committed
638
        <xs:attribute name="Unit"         type="xs:double"             use="required"/>
639
        <!-- DEPRECATED in 1.7.1 : top/left margin (no unit it does not scale) -->
Jody Goldberg's avatar
Jody Goldberg committed
640
        <xs:attribute name="MarginA"      type="gnm:col_row_margin"     use="optional"/>
641
        <!-- DEPRECATED in 1.7.1 : botton/right margin (no unit it does not scale) -->
Jody Goldberg's avatar
Jody Goldberg committed
642
        <xs:attribute name="MarginB"      type="gnm:col_row_margin"     use="optional"/>
Jody Goldberg's avatar
Jody Goldberg committed
643
        <!-- true if size is explicitly set -->
Jody Goldberg's avatar
Jody Goldberg committed
644 645 646 647
        <xs:attribute name="HardSize"     type="xs:boolean"            use="optional" default="0"/>
        <xs:attribute name="Hidden"       type="xs:boolean"            use="optional" default="0"/>
        <xs:attribute name="Collapsed"    type="xs:boolean"            use="optional" default="0"/>
        <xs:attribute name="OutlineLevel" type="xs:integer"            use="optional" default="0"/>
648
        <!-- The number of consequitive identically sized cols/rows -->
Jody Goldberg's avatar
Jody Goldberg committed
649 650 651
        <xs:attribute name="Count"        type="xs:integer"            use="optional" default="1"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
652
    
Jody Goldberg's avatar
Jody Goldberg committed
653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675
    <xs:simpleType name="col_row_margin">
        <xs:restriction base="xs:integer">
            <xs:minInclusive value="0"/>
            <xs:maxInclusive value="7"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="Selections">
        <xs:sequence>
            <xs:element name="Selection" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                    <xs:attribute name="startCol" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="startRow" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="endCol"   type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="endRow"   type="xs:nonNegativeInteger" use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
        <xs:attribute name="CursorCol" type="xs:nonNegativeInteger" use="required"/>
        <xs:attribute name="CursorRow" type="xs:nonNegativeInteger" use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
676
    
Jody Goldberg's avatar
Jody Goldberg committed
677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711
    <xs:attributeGroup name="ObjectAnchor">
	<xs:attribute name="ObjectBound"      type="xs:string"	use="required"/>
	<xs:attribute name="ObjectOffset"     type="gnm:offsets"	use="required"/>
	<xs:attribute name="ObjectAnchorType" type="gnm:anchor_type"	use="optional"/>
	<xs:attribute name="Direction"        type="gnm:direction"	use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:attributeGroup>

    <xs:attributeGroup name="ObjectAdjustmentProps">
	<xs:attribute name="Min"	type="xs:double"	use="required"/>
	<xs:attribute name="Max"	type="xs:double"	use="required"/>
	<xs:attribute name="Inc"	type="xs:double"	use="required"/>
	<xs:attribute name="Page"	type="xs:double"	use="required"/>
	<xs:attribute name="Value"	type="xs:double"	use="required"/>
	<xs:attribute name="Input"	type="xs:string"	use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:attributeGroup>

    <xs:complexType name="Objects">
        <xs:choice minOccurs="0" maxOccurs="unbounded">
            <xs:element name="CellComment">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                    <xs:attribute name="Author"           type="xs:string"  use="required"/>
                    <xs:attribute name="Text"             type="xs:string"  use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetObjectFilled">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                    <xs:attribute name="OutlineColor"     type="gnm:color"               use="required"/>
                    <xs:attribute name="FillColor"        type="gnm:color"               use="required"/>
                    <xs:attribute name="Type"             type="gnm:objectfilled"        use="required"/>
                    <xs:attribute name="Width"            type="xs:positiveInteger" use="required"/>
Jody Goldberg's avatar
Jody Goldberg committed
712
                    <!-- the arrow shape attributes are only used if the type is
713
                         arrow (type="gnm:2")
Jody Goldberg's avatar
Jody Goldberg committed
714
                    -->
Jody Goldberg's avatar
Jody Goldberg committed
715 716 717 718 719 720
                    <xs:attribute name="ArrowShapeA"      type="xs:double"          use="optional"/>
                    <xs:attribute name="ArrowShapeB"      type="xs:double"          use="optional"/>
                    <xs:attribute name="ArrowShapeC"      type="xs:double"          use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
721 722

<!-- widgets -->
Jody Goldberg's avatar
Jody Goldberg committed
723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833
            <xs:element name="SheetWidgetButton">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                    <xs:attribute name="Label"            type="xs:string"  use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetCheckbox">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                    <xs:attribute name="Label"            type="xs:string"  use="required"/>
                    <xs:attribute name="Value"            type="xs:integer" use="required"/>
                    <xs:attribute name="Input"            type="xs:string"  use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetToggleButton"		minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                    <xs:attribute name="Label"            type="xs:string"  use="required"/>
                    <xs:attribute name="Value"            type="xs:integer" use="required"/>
                    <xs:attribute name="Input"            type="xs:string"  use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>

            <xs:element name="SheetWidgetScrollbar">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:attributeGroup ref="gnm:ObjectAdjustmentProps"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetSpinbutton">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:attributeGroup ref="gnm:ObjectAdjustmentProps"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetSlider"		minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:attributeGroup ref="gnm:ObjectAdjustmentProps"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>

            <xs:element name="SheetObjectImage">
                <xs:complexType>
		    <xs:sequence>
			<xs:element name="Content" form="unqualified">
			    <xs:complexType mixed="true">
				<xs:attribute name="image-type" type="xs:string"	use="required"/>
				<xs:attribute name="size-bytes" type="xs:int"		use="optional"/>
				<xs:anyAttribute namespace="##other" processContents="lax"/>
			    </xs:complexType>
			</xs:element>
		    </xs:sequence>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:attribute name="crop-top"	type="xs:double"  use="required"/>
		    <xs:attribute name="crop-bottom"	type="xs:double"  use="required"/>
		    <xs:attribute name="crop-left"	type="xs:double"  use="required"/>
		    <xs:attribute name="crop-right"	type="xs:double"  use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetObjectGraph">
                <xs:complexType>
		    <xs:choice minOccurs="1" maxOccurs="1">
			<xs:element name="GogObject"	type="gnm:GogObject"/>
			<xs:element name="GogObject"	type="gnm:GogObject" form="unqualified"/>
		    </xs:choice>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetFrame">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
            <xs:element name="SheetWidgetLabel">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>

	    <!-- no longer supported -->
            <xs:element name="SheetObjectBonobo">
                <xs:complexType>
		    <xs:attributeGroup ref="gnm:ObjectAnchor"/>
                </xs:complexType>
            </xs:element>
        </xs:choice>
    </xs:complexType>

    <xs:complexType name="GogObject">
	<xs:choice minOccurs="0" maxOccurs="unbounded">
	    <xs:element name="property" type="gnm:GogProperty"/>
	    <xs:element name="property" type="gnm:GogProperty" form="unqualified"/>
	    <xs:element name="data" type="gnm:GOData"/>
	    <xs:element name="data" type="gnm:GOData" form="unqualified"/>
	    <xs:element name="GogObject" type="gnm:GogObject"/>
	    <xs:element name="GogObject" type="gnm:GogObject" form="unqualified"/>
       </xs:choice>
	<xs:attribute name="type" type="xs:string" use="optional"/>
	<xs:attribute name="role" type="xs:string" use="optional"/>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
834
    
Jody Goldberg's avatar
Jody Goldberg committed
835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 854 855 856 857 858 859 860
    <xs:complexType name="GogProperty" mixed="true">
	<xs:sequence>
	    <!-- children are unstructured -->
	    <xs:any minOccurs="0" maxOccurs="unbounded" processContents="lax"/>
	</xs:sequence>
	<xs:attribute name="name" type="xs:string" use="required"/>
	<xs:attribute name="type" type="xs:string" use="optional"/>
    </xs:complexType>

    <xs:complexType name="GOData">
	<xs:choice minOccurs="0" maxOccurs="unbounded">
           <xs:element name="dimension" type="gnm:GODimension"/>
           <xs:element name="dimension" type="gnm:GODimension" form="unqualified"/>
	</xs:choice>
    </xs:complexType>
    <xs:complexType name="GODimension">
	<xs:simpleContent>
	    <xs:extension base="xs:string">
		<xs:attribute name="id" type="xs:integer" use="required"/>
		<xs:attribute name="type" type="xs:string" use="required"/>
	    </xs:extension>
	</xs:simpleContent>
    </xs:complexType>

    <xs:simpleType name="offsets">
        <xs:restriction base="xs:string">
Jody Goldberg's avatar
Jody Goldberg committed
861 862 863
            <!-- if this seems hard to read, it purportedly describes 4
                 space-separated doubles
            -->
Jody Goldberg's avatar
Jody Goldberg committed
864 865 866
            <xs:pattern value="[+\-]?\d+(.\d+)?([Ee]([+\-])?\d+)? [+\-]?\d+(.\d+)?([Ee]([+\-])?\d+)? [+\-]?\d+(.\d+)?([Ee]([+\-])?\d+)? [+\-]?\d+(.\d+)?([Ee]([+\-])?\d+)?"/>
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
867

868
    <!-- As of 1.7.7 this is deprecated -->
Jody Goldberg's avatar
Jody Goldberg committed
869 870
    <xs:simpleType name="anchor_type">
        <xs:restriction base="xs:string">
Jody Goldberg's avatar
Jody Goldberg committed
871 872 873 874 875 876 877 878 879 880
            <!-- if this seems hard to read, it purportedly describes 4
                 space-separated positive numbers

                 each number needs to be one of the following:
                  0 = UNKNOWN
                 16 = PERCENTAGE_FROM_COLROW_START
                 32 = PTS_FROM_COLROW_START
                 33 = PTS_FROM_COLROW_END
                 48 = PTS_ABSOLUTE
            -->
Jody Goldberg's avatar
Jody Goldberg committed
881 882 883 884 885 886 887 888 889 890 891 892 893 894 895 896 897 898 899 900 901 902 903 904 905 906 907
            <xs:pattern value="\d+ \d+ \d+ \d+"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="direction">
        <xs:restriction base="xs:string">
            <xs:enumeration value="-1"/>	<!-- unknown    -->
            <xs:enumeration value="0"/>	<!-- up right   -->
            <xs:enumeration value="1"/>	<!-- up left    -->
            <xs:enumeration value="16"/>	<!-- down right -->
            <xs:enumeration value="17"/>	<!-- down left  -->
            <xs:enumeration value="255"/>	<!-- unknown    -->
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="objectfilled">
        <xs:restriction base="xs:string">
            <xs:enumeration value="1"/>   <!-- line  -->
            <xs:enumeration value="2"/>   <!-- arrow -->
            <xs:enumeration value="101"/> <!-- box   -->
            <xs:enumeration value="102"/> <!-- oval  -->
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="Cells">
       <xs:sequence>
           <xs:element name="Cell" minOccurs="0" maxOccurs="unbounded">
908 909 910 911 912 913
	       <!-- expressions are stored as entered, with a leading '='.
		    Once a shared expression has been defined, subsequent
		    Cell elements using that same shared expression simply
		    use the "ExprID" attribute to indicate which shared
		    expression is used, and no Content element is included
	       -->
Jody Goldberg's avatar
Jody Goldberg committed
914
		<xs:complexType mixed="true">
915
		<!-- Compatibility for ancient 0.x format -->
Jody Goldberg's avatar
Jody Goldberg committed
916 917 918
		    <xs:sequence>
			<xs:element name="Content"	     type="xs:string" minOccurs="0" maxOccurs="1"/>
		    </xs:sequence>
919 920 921

		    <!-- Col and Row are sufficient for a cell that is an element of
		         an array of cells as long as it's not the top left cell -->
Jody Goldberg's avatar
Jody Goldberg committed
922 923
		    <xs:attribute name="Col"         type="xs:nonNegativeInteger" use="required"/>
		    <xs:attribute name="Row"         type="xs:nonNegativeInteger" use="required"/>
924
		    <!-- ExprID is only used to refer to a shared expression -->
Jody Goldberg's avatar
Jody Goldberg committed
925
		    <xs:attribute name="ExprID"      type="xs:nonNegativeInteger" use="optional"/>
926
		    <!-- ValueType is not used if the cell contains an expression -->
Jody Goldberg's avatar
Jody Goldberg committed
927
		    <xs:attribute name="ValueType"   type="gnm:ValueType"           use="optional"/>
928
		    <!-- ValueFormat is apparently used only for cell-by-cell format overrides -->
Jody Goldberg's avatar
Jody Goldberg committed
929
		    <xs:attribute name="ValueFormat" type="xs:string"          use="optional"/>
930
		    <!-- Cols and Rows are used to define an array of cells -->
Jody Goldberg's avatar
Jody Goldberg committed
931 932 933 934 935 936 937
		    <xs:attribute name="Cols"        type="xs:positiveInteger" use="optional"/>
		    <xs:attribute name="Rows"        type="xs:positiveInteger" use="optional"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
		</xs:complexType>
	    </xs:element>
       </xs:sequence>
    </xs:complexType>
Jody Goldberg's avatar
Jody Goldberg committed
938
    
Jody Goldberg's avatar
Jody Goldberg committed
939 940 941 942 943 944 945 946 947 948 949 950 951 952 953 954 955 956 957 958 959 960 961 962 963 964 965 966 967 968 969 970 971 972 973 974 975 976 977 978 979 980 981 982 983 984 985 986 987 988 989 990 991 992 993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 1043 1044 1045 1046 1047 1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058 1059 1060 1061 1062 1063 1064 1065 1066 1067 1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079 1080 1081 1082 1083 1084 1085
    <xs:simpleType name="ValueType">
        <xs:restriction base="xs:string">
            <xs:enumeration value="10"/> <!-- empty     -->
            <xs:enumeration value="20"/> <!-- boolean   -->
            <xs:enumeration value="30"/> <!-- integer   -->
            <xs:enumeration value="40"/> <!-- float     -->
            <xs:enumeration value="50"/> <!-- error     -->
            <xs:enumeration value="60"/> <!-- string    -->
            <xs:enumeration value="70"/> <!-- cellrange -->
            <xs:enumeration value="80"/> <!-- array     -->
        </xs:restriction>
    </xs:simpleType>

    <xs:simpleType name="CondOp">
        <xs:restriction base="xs:nonNegativeInteger">
	    <xs:enumeration value="0"/> <!-- GNM_STYLE_COND_BETWEEN -->
	    <xs:enumeration value="1"/> <!-- GNM_STYLE_COND_NOT_BETWEEN -->
	    <xs:enumeration value="2"/> <!-- GNM_STYLE_COND_EQUAL -->
	    <xs:enumeration value="3"/> <!-- GNM_STYLE_COND_NOT_EQUAL -->
	    <xs:enumeration value="4"/> <!-- GNM_STYLE_COND_GT -->
	    <xs:enumeration value="5"/> <!-- GNM_STYLE_COND_LT -->
	    <xs:enumeration value="6"/> <!-- GNM_STYLE_COND_GTE -->
	    <xs:enumeration value="7"/> <!-- GNM_STYLE_COND_LTE -->

	    <!-- Arbitrary expr evaluated at EvalPos -->
	    <xs:enumeration value="8"/> <!-- GNM_STYLE_COND_CUSTOM -->

	    <!-- New in Gnumeric 1.8 -->
	    <xs:enumeration value="16"/> <!-- GNM_STYLE_COND_CONTAINS_STR -->
	    <xs:enumeration value="17"/> <!-- GNM_STYLE_COND_NOT_CONTAINS_STR -->
	    <xs:enumeration value="18"/> <!-- GNM_STYLE_COND_BEGINS_WITH_STR -->
	    <xs:enumeration value="19"/> <!-- GNM_STYLE_COND_NOT_BEGINS_WITH_STR -->
	    <xs:enumeration value="20"/> <!-- GNM_STYLE_COND_ENDS_WITH_STR -->
	    <xs:enumeration value="21"/> <!-- GNM_STYLE_COND_NOT_ENDS_WITH_STR -->

	    <xs:enumeration value="22"/> <!-- GNM_STYLE_COND_CONTAINS_ERR -->
	    <xs:enumeration value="23"/> <!-- GNM_STYLE_COND_NOT_CONTAINS_ERR -->

	    <xs:enumeration value="24"/> <!-- GNM_STYLE_COND_CONTAINS_BLANKS -->
	    <xs:enumeration value="25"/> <!-- GNM_STYLE_COND_NOT_CONTAINS_BLANK -->
        </xs:restriction>
    </xs:simpleType>
    <xs:simpleType name="FilterFieldType">
        <xs:restriction base="xs:string">
            <xs:enumeration value="expr"/>
            <xs:enumeration value="blanks"/>
            <xs:enumeration value="nonblanks"/>
            <xs:enumeration value="bucket"/>
        </xs:restriction>
    </xs:simpleType>
    <xs:simpleType name="FilterFieldOp">
        <xs:restriction base="xs:string">
            <xs:enumeration value="eq"/>
            <xs:enumeration value="gt"/>
            <xs:enumeration value="lt"/>
            <xs:enumeration value="gte"/>
            <xs:enumeration value="lte"/>
            <xs:enumeration value="ne"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="FilterField">
	<xs:attribute name="Index" type="xs:nonNegativeInteger" use="required"/>
	<xs:attribute name="Type"  type="gnm:FilterFieldType" use="required"/>

	<!-- WARNING WARNING WARNING
		Value and ValueType have their senses
		reversed due to an old typo -->
	<!-- Only valid for Type=expr -->
	<xs:attribute name="Value0"     type="gnm:ValueType"	  use="optional"/>
	<xs:attribute name="ValueType0" type="xs:string"	  use="optional"/>
	<xs:attribute name="Op0"	 type="gnm:FilterFieldOp" use="optional"/>
	<xs:attribute name="Value1"	 type="gnm:ValueType"	  use="optional"/>
	<xs:attribute name="ValueType1" type="xs:string"	  use="optional"/>
	<xs:attribute name="Op1"	 type="gnm:FilterFieldOp" use="optional"/>

	<!-- Only valid for Type=bucket -->
	<xs:attribute name="top"   type="xs:boolean" use="optional"/> <!-- top vs bottom -->
	<xs:attribute name="items" type="xs:boolean" use="optional"/> <!-- top n vs top n% -->
	<xs:attribute name="count" type="xs:double"  use="optional"/> <!-- top COUNT -->

	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:complexType name="Filters">
       <xs:sequence>
           <xs:element name="Filter" minOccurs="0" maxOccurs="unbounded">
		<xs:complexType>
		    <xs:sequence>
			<xs:element name="Field" type="gnm:FilterField" minOccurs="0" maxOccurs="unbounded"/>
		    </xs:sequence>
		    <xs:attribute name="Area"   type="xs:string" use="required"/>
		</xs:complexType>
            </xs:element>
       </xs:sequence>
    </xs:complexType>

    <xs:complexType name="MergedRegions">
       <xs:sequence>
           <xs:element name="Merge" type="xs:string" minOccurs="0" maxOccurs="unbounded"/>
       </xs:sequence>
       <xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:complexType name="Solver">
        <xs:sequence>
	    <xs:element name="Constr" minOccurs="0" maxOccurs="unbounded">
                <xs:complexType>
                    <xs:attribute name="Lcol" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Lrow" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Rcol" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Rrow" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Cols" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Rows" type="xs:nonNegativeInteger" use="required"/>
                    <xs:attribute name="Type" type="gnm:solver_constraint_t"    use="required"/>
		    <xs:anyAttribute namespace="##other" processContents="lax"/>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
        <xs:attribute name="TargetCol"   type="xs:integer"		use="optional"/>
        <xs:attribute name="TargetRow"   type="xs:integer"		use="optional"/>
        <xs:attribute name="ProblemType" type="gnm:solver_problem_t"	use="required"/>
        <xs:attribute name="Inputs"      type="xs:string"		use="required"/>
        <xs:attribute name="MaxTime"	  type="xs:integer"		use="required"/>
        <xs:attribute name="MaxIter"	  type="xs:integer"		use="required"/>
        <xs:attribute name="NonNeg"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="Discr"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="AutoScale"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="ShowIter"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="AnswerR"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="SensitivityR" type="xs:boolean"		use="required"/>
        <xs:attribute name="LimitsR"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="PerformR"	  type="xs:boolean"		use="required"/>
        <xs:attribute name="ProgramR"	  type="xs:boolean"		use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>

    <xs:simpleType name="solver_constraint_t">
        <xs:restriction base="xs:integer">
            <xs:enumeration value="0" /> <!-- none -->
            <xs:enumeration value="1" /> <!-- &lt;= -->
            <xs:enumeration value="2" /> <!-- &gt;= -->
            <xs:enumeration value="4" /> <!-- = -->
            <xs:enumeration value="8" /> <!-- Int -->
            <xs:enumeration value="16"/> <!-- boolean -->
        </xs:restriction>
    </xs:simpleType>
Jody Goldberg's avatar
Jody Goldberg committed
1086
    
Jody Goldberg's avatar
Jody Goldberg committed
1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105 1106 1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128
    <xs:simpleType name="solver_problem_t">
        <xs:restriction base="xs:integer">
            <xs:enumeration value="0" /> <!-- SolverMinimize -->
            <xs:enumeration value="1" /> <!-- SolverMaximize -->
            <xs:enumeration value="2" /> <!-- SolverEqualTo -->
        </xs:restriction>
    </xs:simpleType>
    <xs:simpleType name="SheetVisibility">
        <xs:restriction base="xs:string">
            <xs:enumeration value="GNM_SHEET_VISIBILITY_VISIBLE"/>
            <xs:enumeration value="GNM_SHEET_VISIBILITY_HIDDEN"/>
            <xs:enumeration value="GNM_SHEET_VISIBILITY_VERY_HIDDEN"/>
        </xs:restriction>
    </xs:simpleType>

    <xs:complexType name="Scenarios">
	<xs:sequence>
            <xs:element name="Scenario" minOccurs="0" maxOccurs="unbounded">
		<xs:complexType>
		    <xs:sequence>
		       <xs:element name="Name" type="xs:string"/>
		       <xs:element name="Comment" type="xs:string"/>
		       <xs:element name="CellsStr" type="xs:string"/>
		    </xs:sequence>
		</xs:complexType>
            </xs:element>
	</xs:sequence>
    </xs:complexType>

    <xs:complexType name="SheetLayout">
	<xs:sequence>
	    <xs:element name="FreezePanes" minOccurs="0" maxOccurs="1">
		<xs:complexType>
		    <xs:attribute name="FrozenTopLeft"   type="xs:string" use="required"/>
		    <xs:attribute name="UnfrozenTopLeft" type="xs:string" use="required"/>
		</xs:complexType>
	    </xs:element>
	</xs:sequence>
	<xs:attribute name="TopLeft"   type="xs:string" use="required"/>
	<xs:anyAttribute namespace="##other" processContents="lax"/>
    </xs:complexType>
</xs:schema>