Definition Type: ComplexType
Name: CT_SheetView
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-sheet_xsd Drilldown into pivotSelection in schema sml-sheet_xsd Drilldown into selection in schema sml-sheet_xsd Drilldown into pane in schema sml-sheet_xsd Drilldown into workbookViewId in schema sml-sheet_xsd Drilldown into zoomScalePageLayoutView in schema sml-sheet_xsd Drilldown into zoomScaleSheetLayoutView in schema sml-sheet_xsd Drilldown into zoomScaleNormal in schema sml-sheet_xsd Drilldown into zoomScale in schema sml-sheet_xsd Drilldown into colorId in schema sml-sheet_xsd Drilldown into topLeftCell in schema sml-sheet_xsd Drilldown into view in schema sml-sheet_xsd Drilldown into showWhiteSpace in schema sml-sheet_xsd Drilldown into defaultGridColor in schema sml-sheet_xsd Drilldown into showOutlineSymbols in schema sml-sheet_xsd Drilldown into showRuler in schema sml-sheet_xsd Drilldown into tabSelected in schema sml-sheet_xsd Drilldown into rightToLeft in schema sml-sheet_xsd Drilldown into showZeros in schema sml-sheet_xsd Drilldown into showRowColHeaders in schema sml-sheet_xsd Drilldown into showGridLines in schema sml-sheet_xsd Drilldown into showFormulas in schema sml-sheet_xsd Drilldown into windowProtection in schema sml-sheet_xsdXSD Diagram of CT_SheetView in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_SheetView">
    <xsd:sequence>
        <xsd:element name="pane" type="CT_Pane" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>View Pane</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="selection" type="CT_Selection" minOccurs="0" maxOccurs="4">
            <xsd:annotation>
                <xsd:documentation>Selection</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pivotSelection" type="CT_PivotSelection" minOccurs="0" maxOccurs="4">
            <xsd:annotation>
                <xsd:documentation>PivotTable Selection</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" maxOccurs="1" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="windowProtection" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Window Protection</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showFormulas" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Formulas</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showGridLines" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Grid Lines</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showRowColHeaders" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Headers</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showZeros" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Zero Values</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="rightToLeft" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Right To Left</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="tabSelected" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Sheet Tab Selected</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showRuler" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Ruler</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showOutlineSymbols" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Outline Symbols</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultGridColor" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Default Grid Color</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showWhiteSpace" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show White Space</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="view" type="ST_SheetViewType" use="optional" default="normal">
        <xsd:annotation>
            <xsd:documentation>View Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="topLeftCell" type="ST_CellRef" use="optional">
        <xsd:annotation>
            <xsd:documentation>Top Left Visible Cell</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colorId" type="xsd:unsignedInt" use="optional" default="64">
        <xsd:annotation>
            <xsd:documentation>Color Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="zoomScale" type="xsd:unsignedInt" use="optional" default="100">
        <xsd:annotation>
            <xsd:documentation>Zoom Scale</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="zoomScaleNormal" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Zoom Scale Normal View</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="zoomScaleSheetLayoutView" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Zoom Scale Page Break Preview</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="zoomScalePageLayoutView" type="xsd:unsignedInt" use="optional" default="0">
        <xsd:annotation>
            <xsd:documentation>Zoom Scale Page Layout View</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="workbookViewId" type="xsd:unsignedInt" use="required">
        <xsd:annotation>
            <xsd:documentation>Workbook View Index</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
pane nsM:pane 0 1
selection nsM:selection 0 4
pivotSelection nsM:pivotSelection 0 4
extLst nsM:extLst 0 1
Collapse Child Attributes:
Name Type Default Value Use
windowProtection nsM:windowProtection false Optional
showFormulas nsM:showFormulas false Optional
showGridLines nsM:showGridLines true Optional
showRowColHeaders nsM:showRowColHeaders true Optional
showZeros nsM:showZeros true Optional
rightToLeft nsM:rightToLeft false Optional
tabSelected nsM:tabSelected false Optional
showRuler nsM:showRuler true Optional
showOutlineSymbols nsM:showOutlineSymbols true Optional
defaultGridColor nsM:defaultGridColor true Optional
showWhiteSpace nsM:showWhiteSpace true Optional
view nsM:view normal Optional
topLeftCell nsM:topLeftCell Optional
colorId nsM:colorId 64 Optional
zoomScale nsM:zoomScale 100 Optional
zoomScaleNormal nsM:zoomScaleNormal 0 Optional
zoomScaleSheetLayoutView nsM:zoomScaleSheetLayoutView 0 Optional
zoomScalePageLayoutView nsM:zoomScalePageLayoutView 0 Optional
workbookViewId nsM:workbookViewId Required
Collapse Derivation Tree:
Collapse References:
nsM:sheetView