ssml:sheetPr
Sheet Properties
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Other elements with the same name: ssml:sheetPr, ssml:sheetPr
Type: ssml:CT_SheetPr
Properties: Local, Qualified
Content
- Sequence [1..1]
- ssml:tabColor [0..1] Sheet Tab Color
- ssml:outlinePr [0..1] Outline Properties
- ssml:pageSetUpPr [0..1] Page Setup Properties
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| syncHorizontal | [0..1] | xsd:boolean | Synch Horizontal | Default value is "false". |
| syncVertical | [0..1] | xsd:boolean | Synch Vertical | Default value is "false". |
| syncRef | [0..1] | ssml:ST_Ref | Synch Reference | |
| transitionEvaluation | [0..1] | xsd:boolean | Transition Formula Evaluation | Default value is "false". |
| transitionEntry | [0..1] | xsd:boolean | Transition Formula Entry | Default value is "false". |
| published | [0..1] | xsd:boolean | Published | Default value is "true". |
| codeName | [0..1] | xsd:string | Code Name | |
| filterMode | [0..1] | xsd:boolean | Filter Mode | Default value is "false". |
| enableFormatConditionsCalculation | [0..1] | xsd:boolean | Enable Conditional Formatting Calculations | Default value is "true". |
Used in
- Type ssml:CT_Macrosheet
- Type ssml:CT_Dialogsheet (Element ssml:dialogsheet)
Sample instance
<ssml:sheetPr> <ssml:tabColor/> <ssml:outlinePr/> <ssml:pageSetUpPr/> </ssml:sheetPr>