<xsd:complexType name="WorksheetOptionsType">
<xsd:annotation>
<xsd:documentation>Contains the properties of a worksheet.</xsd:documentation>
</xsd:annotation>
<xsd:all>
<xsd:element name="FitToPage" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies that the spreadsheet should be fit to the printed page.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayColHeaders" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether column headers are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayRowHeaders" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether row headers are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ViewableRange" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Selection" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element or attribute is not created or processed by Excel. It is designed to be used by external applications and components.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="GridlineColor" type="xsd:string" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies the color for gridlines that define cells in a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Name" type="xsd:string" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the user-defined name of an object, range, or reference to another workbook, the location and name of a text file, or the built-in name of a range.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ExcelWorksheetType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains a value that specifies the type of a worksheet.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="Worksheet" />
<xsd:enumeration value="Chart" />
<xsd:enumeration value="Macro" />
<xsd:enumeration value="Dialog" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="IntlMacro" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether a worksheet is an international macro worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Unsynced" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies if multiple windows of the same worksheet could be scrolled synchronously.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Selected" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether a worksheet is selected.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="CodeName" type="xsd:string" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the code name of a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="PageSetup" type="PageSetupType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains information related to settings for printing worksheets.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DisplayPageBreak" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether vertical and horizontal page breaks will be indicated by a dotted line in the spreadsheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="TransitionExpressionEvaluation" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether Excel uses Lotus 1-2-3 expression evaluation rules for a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="TransitionFormulaEntry" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether Excel uses Lotus 1-2-3 formula entry rules for a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Print" type="PrintType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains workbook and worksheet printing options.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Zoom" default="100" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains a value specifying the zoom level of a worksheet window.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:int">
<xsd:minInclusive value="10" />
<xsd:maxExclusive value="400" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="PageBreakZoom" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains a value specifying the zoom level used during page break preview.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:int">
<xsd:minInclusive value="10" />
<xsd:maxInclusive value="400" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="ShowPageBreakZoom" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether page break preview is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DefaultRowHeight" type="xsd:int" default="255" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the default height in points of a row in a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DefaultColumnWidth" type="xsd:int" default="8" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the default column width in points of a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="StandardWidth" type="xsd:int" default="0" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains an integer value specifying the default width of columns in a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Visible" default="SheetVisible" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains a value specifying whether a worksheet is visible.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="SheetVisible" />
<xsd:enumeration value="SheetHidden" />
<xsd:enumeration value="SheetVeryHidden" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="LeftColumnVisible" type="xsd:integer" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies the first column visible on the left.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DisplayRightToLeft" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies the display direction in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="GridlineColorIndex" type="xsd:int" default="64" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains a value specifying the index for the color of gridlines in a worksheet.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DisplayFormulas" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether formulas are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayGridlines" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether gridlines are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayHeadings" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether row and column headings are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayOutline" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether outline symbols are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ApplyAutomaticOutlineStyles" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether automatic outline styles are applied.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="NoSummaryRowsBelowDetail" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether summary rows are displayed below detail rows.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="NoSummaryColumnsRightDetail" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether summary columns are displayed to the right of detail columns.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="DoNotDisplayZeros" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether zero values are displayed in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ActiveRow" type="xsd:int" default="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the index number of a pane's active row in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ActiveColumn" type="xsd:int" default="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the index number of a pane's active column in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="FilterOn" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether AutoFilter is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="RangeSelection" type="xsd:string" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the selected range of a pane in a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="TopRowVisible" type="xsd:int" default="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the row number of the topmost visible row in the top pane of a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="TopRowBottomPane" type="xsd:int" default="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the row number of the topmost visible row in the bottom pane of a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="LeftColumnRightPane" type="xsd:int" default="1" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the column number of the leftmost visible column in the right pane of a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ActivePane" default="3" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the index number of the active pane in a worksheet window.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:int">
<xsd:minInclusive value="0" />
<xsd:maxInclusive value="3" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="SplitHorizontal" type="xsd:int" default="0" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the number of points from the top of the window that a worksheet is split horizontally.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="SplitVertical" type="xsd:int" default="0" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the number of points from the left of the window that a worksheet is split vertically.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="FreezePanes" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether the panes of a worksheet window are frozen.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="FrozenNoSplit" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether the frozen panes of a worksheet window are not split.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="TabColorIndex" type="xsd:integer" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies the index representing the color for tabs.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="Panes" type="PanesType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Contains the Pane elements corresponding to the panes of a worksheet window.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ProtectContents" type="TrueFalseType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether the contents of a worksheet are protected.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ProtectObjects" type="TrueFalseType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether the objects of a worksheet are protected.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ProtectScenarios" type="TrueFalseType" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether the scenarios of a worksheet are protected.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="EnableSelection" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies restrictions on selecting cells.</xsd:documentation>
</xsd:annotation>
<xsd:simpleType>
<xsd:restriction base="xsd:string">
<xsd:enumeration value="UnlockedCells" />
<xsd:enumeration value="NoSelection" />
</xsd:restriction>
</xsd:simpleType>
</xsd:element>
<xsd:element name="AllowFormatCells" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether cells can be formatted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowSizeCols" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether column widths can be adjusted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowSizeRows" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether row heights can be adjusted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowInsertCols" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether columns can be inserted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowInsertRows" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether rows can be inserted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowInsertHyperlinks" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether hyperlinks can inserted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowDeleteCols" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether columns can be deleted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowDeleteRows" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether rows can be deleted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowSort" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether data can be sorted when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowFilter" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether filters can be applied when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="AllowUsePivotTables" minOccurs="0">
<xsd:annotation>
<xsd:documentation>Specifies whether PivotTables views and reports can be used when worksheet protection is enabled.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="SpaceAbove" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element or attribute is reserved for internal use.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="SpaceBelow" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element or attribute is reserved for internal use.</xsd:documentation>
</xsd:annotation>
</xsd:element>
<xsd:element name="ZeroHeight" minOccurs="0">
<xsd:annotation>
<xsd:documentation>This element or attribute is reserved for internal use.</xsd:documentation>
</xsd:annotation>
</xsd:element>
</xsd:all>
</xsd:complexType>
|