ssml:sheetProtection
Sheet Protection Options
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Other elements with the same name: ssml:sheetProtection, ssml:sheetProtection
Type: ssml:CT_SheetProtection
Properties: Local, Qualified
Content
- Empty content
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| password | [0..1] | ssml:ST_UnsignedShortHex | Password | |
| sheet | [0..1] | xsd:boolean | Sheet Locked | Default value is "false". |
| objects | [0..1] | xsd:boolean | Objects Locked | Default value is "false". |
| scenarios | [0..1] | xsd:boolean | Scenarios Locked | Default value is "false". |
| formatCells | [0..1] | xsd:boolean | Format Cells Locked | Default value is "true". |
| formatColumns | [0..1] | xsd:boolean | Format Columns Locked | Default value is "true". |
| formatRows | [0..1] | xsd:boolean | Format Rows Locked | Default value is "true". |
| insertColumns | [0..1] | xsd:boolean | Insert Columns Locked | Default value is "true". |
| insertRows | [0..1] | xsd:boolean | Insert Rows Locked | Default value is "true". |
| insertHyperlinks | [0..1] | xsd:boolean | Insert Hyperlinks Locked | Default value is "true". |
| deleteColumns | [0..1] | xsd:boolean | Delete Columns Locked | Default value is "true". |
| deleteRows | [0..1] | xsd:boolean | Delete Rows Locked | Default value is "true". |
| selectLockedCells | [0..1] | xsd:boolean | Select Locked Cells Locked | Default value is "false". |
| sort | [0..1] | xsd:boolean | Sort Locked | Default value is "true". |
| autoFilter | [0..1] | xsd:boolean | AutoFilter Locked | Default value is "true". |
| pivotTables | [0..1] | xsd:boolean | Pivot Tables Locked | Default value is "true". |
| selectUnlockedCells | [0..1] | xsd:boolean | Select Unlocked Cells Locked | Default value is "false". |
Used in
- Type ssml:CT_Macrosheet
Sample instance
<ssml:sheetProtection/>