ssml:customWorkbookView
Custom Workbook View
Element information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-workbook.xsd
Type: ssml:CT_CustomWorkbookView
Properties: Local, Qualified
Content
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| name | [1..1] | ssml:ST_Xstring | Custom View Name | |
| guid | [1..1] | ssml:ST_Guid | Custom View GUID | |
| autoUpdate | [0..1] | xsd:boolean | Auto Update | Default value is "false". |
| mergeInterval | [0..1] | xsd:unsignedInt | Merge Interval | |
| changesSavedWin | [0..1] | xsd:boolean | Changes Saved Win | Default value is "false". |
| onlySync | [0..1] | xsd:boolean | Only Synch | Default value is "false". |
| personalView | [0..1] | xsd:boolean | Personal View | Default value is "false". |
| includePrintSettings | [0..1] | xsd:boolean | Include Print Settings | Default value is "true". |
| includeHiddenRowCol | [0..1] | xsd:boolean | Include Hidden Rows & Columns | Default value is "true". |
| maximized | [0..1] | xsd:boolean | Maximized | Default value is "false". |
| minimized | [0..1] | xsd:boolean | Minimized | Default value is "false". |
| showHorizontalScroll | [0..1] | xsd:boolean | Show Horizontal Scroll | Default value is "true". |
| showVerticalScroll | [0..1] | xsd:boolean | Show Vertical Scroll | Default value is "true". |
| showSheetTabs | [0..1] | xsd:boolean | Show Sheet Tabs | Default value is "true". |
| xWindow | [0..1] | xsd:int | Top Left Corner (X Coordinate) | Default value is "0". |
| yWindow | [0..1] | xsd:int | Top Left Corner (Y Coordinate) | Default value is "0". |
| windowWidth | [1..1] | xsd:unsignedInt | Window Width | |
| windowHeight | [1..1] | xsd:unsignedInt | Window Height | |
| tabRatio | [0..1] | xsd:unsignedInt | Sheet Tab Ratio | Default value is "600". |
| activeSheetId | [1..1] | xsd:unsignedInt | Active Sheet in Book View | |
| showFormulaBar | [0..1] | xsd:boolean | Show Formula Bar | Default value is "true". |
| showStatusbar | [0..1] | xsd:boolean | Show Status Bar | Default value is "true". |
| showComments | [0..1] | ssml:ST_Comments | Show Comments | Default value is "commIndicator". |
| showObjects | [0..1] | ssml:ST_Objects | Show Objects | Default value is "all". |
Used in
- Type ssml:CT_CustomWorkbookViews (Element ssml:customWorkbookViews)
Sample instance
<ssml:customWorkbookView name="string" guid="token" windowWidth="1" windowHeight="1" activeSheetId="1"> <ssml:extLst> <ssml:ext> <!--any element--> </ssml:ext> </ssml:extLst> </ssml:customWorkbookView>