Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)
Definition Type: ComplexType
Name: CT_SheetProtection
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-sheet.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into selectUnlockedCells in schema sml-sheet_xsd Drilldown into pivotTables in schema sml-sheet_xsd Drilldown into autoFilter in schema sml-sheet_xsd Drilldown into sort in schema sml-sheet_xsd Drilldown into selectLockedCells in schema sml-sheet_xsd Drilldown into deleteRows in schema sml-sheet_xsd Drilldown into deleteColumns in schema sml-sheet_xsd Drilldown into insertHyperlinks in schema sml-sheet_xsd Drilldown into insertRows in schema sml-sheet_xsd Drilldown into insertColumns in schema sml-sheet_xsd Drilldown into formatRows in schema sml-sheet_xsd Drilldown into formatColumns in schema sml-sheet_xsd Drilldown into formatCells in schema sml-sheet_xsd Drilldown into scenarios in schema sml-sheet_xsd Drilldown into objects in schema sml-sheet_xsd Drilldown into sheet in schema sml-sheet_xsd Drilldown into password in schema sml-sheet_xsdXSD Diagram of CT_SheetProtection in schema sml-sheet_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code: 
<xsd:complexType name="CT_SheetProtection">
    <xsd:attribute name="password" type="ST_UnsignedShortHex" use="optional">
        <xsd:annotation>
            <xsd:documentation>Password</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sheet" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Sheet Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="objects" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Objects Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="scenarios" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Scenarios Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formatCells" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Format Cells Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formatColumns" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Format Columns Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="formatRows" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Format Rows Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertColumns" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Insert Columns Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertRows" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Insert Rows Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="insertHyperlinks" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Insert Hyperlinks Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="deleteColumns" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Delete Columns Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="deleteRows" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Delete Rows Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="selectLockedCells" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Select Locked Cells Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="sort" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Sort Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="autoFilter" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>AutoFilter Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="pivotTables" type="xsd:boolean" use="optional" default="true">
        <xsd:annotation>
            <xsd:documentation>Pivot Tables Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="selectUnlockedCells" type="xsd:boolean" use="optional" default="false">
        <xsd:annotation>
            <xsd:documentation>Select Unlocked Cells Locked</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Attributes:
Name Type Default Value Use
password nsM:password Optional
sheet nsM:sheet false Optional
objects nsM:objects false Optional
scenarios nsM:scenarios false Optional
formatCells nsM:formatCells true Optional
formatColumns nsM:formatColumns true Optional
formatRows nsM:formatRows true Optional
insertColumns nsM:insertColumns true Optional
insertRows nsM:insertRows true Optional
insertHyperlinks nsM:insertHyperlinks true Optional
deleteColumns nsM:deleteColumns true Optional
deleteRows nsM:deleteRows true Optional
selectLockedCells nsM:selectLockedCells false Optional
sort nsM:sort true Optional
autoFilter nsM:autoFilter true Optional
pivotTables nsM:pivotTables true Optional
selectUnlockedCells nsM:selectUnlockedCells false Optional
Collapse Derivation Tree:
Collapse References:
nsM:sheetProtection, nsM:sheetProtection, nsM:sheetProtection
Documentation for Office Open XML (OOXML / OpenXML / Ecma 376)

Generated using Liquid Studio - Developer Bundle 21.0.0.0