Definition Type: ComplexType
Name: CT_CustomSheetView
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 autoFilter in schema sml-sheet_xsd Drilldown into headerFooter in schema sml-sheet_xsd Drilldown into pageSetup in schema sml-sheet_xsd Drilldown into printOptions in schema sml-sheet_xsd Drilldown into pageMargins in schema sml-sheet_xsd Drilldown into colBreaks in schema sml-sheet_xsd Drilldown into rowBreaks in schema sml-sheet_xsd Drilldown into selection in schema sml-sheet_xsd Drilldown into pane in schema sml-sheet_xsd Drilldown into topLeftCell in schema sml-sheet_xsd Drilldown into showRuler in schema sml-sheet_xsd Drilldown into view in schema sml-sheet_xsd Drilldown into filterUnique in schema sml-sheet_xsd Drilldown into state in schema sml-sheet_xsd Drilldown into hiddenColumns in schema sml-sheet_xsd Drilldown into hiddenRows in schema sml-sheet_xsd Drilldown into showAutoFilter in schema sml-sheet_xsd Drilldown into filter in schema sml-sheet_xsd Drilldown into printArea in schema sml-sheet_xsd Drilldown into fitToPage in schema sml-sheet_xsd Drilldown into zeroValues in schema sml-sheet_xsd Drilldown into outlineSymbols in schema sml-sheet_xsd Drilldown into showRowCol in schema sml-sheet_xsd Drilldown into showGridLines in schema sml-sheet_xsd Drilldown into showFormulas in schema sml-sheet_xsd Drilldown into showPageBreaks in schema sml-sheet_xsd Drilldown into colorId in schema sml-sheet_xsd Drilldown into scale in schema sml-sheet_xsd Drilldown into guid in schema sml-sheet_xsdXSD Diagram of CT_CustomSheetView in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_CustomSheetView">
    <xsd:sequence>
        <xsd:element name="pane" type="CT_Pane" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Pane Split Information</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="selection" type="CT_Selection" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Selection</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="rowBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Horizontal Page Breaks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="colBreaks" type="CT_PageBreak" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Vertical Page Breaks</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Margins</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="printOptions" type="CT_PrintOptions" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Print Options</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="pageSetup" type="CT_PageSetup" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Page Setup Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>Header Footer Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="autoFilter" type="CT_AutoFilter" minOccurs="0" maxOccurs="1">
            <xsd:annotation>
                <xsd:documentation>AutoFilter Settings</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="guid" type="ST_Guid" use="required">
        <xsd:annotation>
            <xsd:documentation>GUID</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="scale" type="xsd:unsignedInt" default="100">
        <xsd:annotation>
            <xsd:documentation>Print Scale</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="colorId" type="xsd:unsignedInt" default="64">
        <xsd:annotation>
            <xsd:documentation>Color Id</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showPageBreaks" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show Page Breaks</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="showRowCol" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Headers</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="outlineSymbols" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Outline Symbols</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="zeroValues" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Show Zero Values</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="fitToPage" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Fit To Page</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="printArea" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Print Area Defined</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="filter" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Filtered List</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="showAutoFilter" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Show AutoFitler Drop Down Controls</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hiddenRows" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Hidden Rows</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hiddenColumns" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Hidden Columns</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="state" type="ST_SheetState" default="visible">
        <xsd:annotation>
            <xsd:documentation>Visible State</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="filterUnique" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Filter</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="view" type="ST_SheetViewType" default="normal">
        <xsd:annotation>
            <xsd:documentation>View Type</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="topLeftCell" type="ST_CellRef" use="optional">
        <xsd:annotation>
            <xsd:documentation>Top Left Visible Cell</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 1
rowBreaks nsM:rowBreaks 0 1
colBreaks nsM:colBreaks 0 1
pageMargins nsM:pageMargins 0 1
printOptions nsM:printOptions 0 1
pageSetup nsM:pageSetup 0 1
headerFooter nsM:headerFooter 0 1
autoFilter nsM:autoFilter 0 1
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
guid nsM:guid Required
scale nsM:scale 100 (Optional)
colorId nsM:colorId 64 (Optional)
showPageBreaks nsM:showPageBreaks false Optional
showFormulas nsM:showFormulas false Optional
showGridLines nsM:showGridLines true Optional
showRowCol nsM:showRowCol true Optional
outlineSymbols nsM:outlineSymbols true Optional
zeroValues nsM:zeroValues true Optional
fitToPage nsM:fitToPage false Optional
printArea nsM:printArea false Optional
filter nsM:filter false Optional
showAutoFilter nsM:showAutoFilter false Optional
hiddenRows nsM:hiddenRows false Optional
hiddenColumns nsM:hiddenColumns false Optional
state nsM:state visible (Optional)
filterUnique nsM:filterUnique false Optional
view nsM:view normal (Optional)
showRuler nsM:showRuler true Optional
topLeftCell nsM:topLeftCell Optional
Collapse Derivation Tree:
Collapse References:
nsM:customSheetView