Schema Central > OOXML > sml-sheet.xsd > ssml:sheetProtection
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

ssml:sheetProtection

Sheet Protection Options

Element information

Type: ssml:CT_SheetProtection

Properties: Local, Qualified

Content

Attributes

NameOccTypeDescriptionNotes
password [0..1]ssml:ST_UnsignedShortHexPassword
sheet [0..1]xsd:booleanSheet LockedDefault value is "false".
objects [0..1]xsd:booleanObjects LockedDefault value is "false".
scenarios [0..1]xsd:booleanScenarios LockedDefault value is "false".
formatCells [0..1]xsd:booleanFormat Cells LockedDefault value is "true".
formatColumns [0..1]xsd:booleanFormat Columns LockedDefault value is "true".
formatRows [0..1]xsd:booleanFormat Rows LockedDefault value is "true".
insertColumns [0..1]xsd:booleanInsert Columns LockedDefault value is "true".
insertRows [0..1]xsd:booleanInsert Rows LockedDefault value is "true".
insertHyperlinks [0..1]xsd:booleanInsert Hyperlinks LockedDefault value is "true".
deleteColumns [0..1]xsd:booleanDelete Columns LockedDefault value is "true".
deleteRows [0..1]xsd:booleanDelete Rows LockedDefault value is "true".
selectLockedCells [0..1]xsd:booleanSelect Locked Cells LockedDefault value is "false".
sort [0..1]xsd:booleanSort LockedDefault value is "true".
autoFilter [0..1]xsd:booleanAutoFilter LockedDefault value is "true".
pivotTables [0..1]xsd:booleanPivot Tables LockedDefault value is "true".
selectUnlockedCells [0..1]xsd:booleanSelect Unlocked Cells LockedDefault value is "false".

Used in

Sample instance

<ssml:sheetProtection/>

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to contrib@functx.com