ssml:CT_CustomSheetView
Complex type information
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Schema document: sml-sheet.xsd
Content
- Sequence [1..1]
- ssml:pane [0..1] Pane Split Information
- ssml:selection [0..1] Selection
- ssml:rowBreaks [0..1] Horizontal Page Breaks
- ssml:colBreaks [0..1] Vertical Page Breaks
- ssml:pageMargins [0..1] Page Margins
- ssml:printOptions [0..1] Print Options
- ssml:pageSetup [0..1] Page Setup Settings
- ssml:headerFooter [0..1] Header Footer Settings
- ssml:autoFilter [0..1] AutoFilter Settings
- ssml:extLst [0..1] Future Feature Storage Area
Attributes
| Name | Occ | Type | Description | Notes |
|---|---|---|---|---|
| guid | [1..1] | ssml:ST_Guid | GUID | |
| scale | [0..1] | xsd:unsignedInt | Print Scale | Default value is "100". |
| colorId | [0..1] | xsd:unsignedInt | Color Id | Default value is "64". |
| showPageBreaks | [0..1] | xsd:boolean | Show Page Breaks | Default value is "false". |
| showFormulas | [0..1] | xsd:boolean | Show Formulas | Default value is "false". |
| showGridLines | [0..1] | xsd:boolean | Show Grid Lines | Default value is "true". |
| showRowCol | [0..1] | xsd:boolean | Show Headers | Default value is "true". |
| outlineSymbols | [0..1] | xsd:boolean | Show Outline Symbols | Default value is "true". |
| zeroValues | [0..1] | xsd:boolean | Show Zero Values | Default value is "true". |
| fitToPage | [0..1] | xsd:boolean | Fit To Page | Default value is "false". |
| printArea | [0..1] | xsd:boolean | Print Area Defined | Default value is "false". |
| filter | [0..1] | xsd:boolean | Filtered List | Default value is "false". |
| showAutoFilter | [0..1] | xsd:boolean | Show AutoFitler Drop Down Controls | Default value is "false". |
| hiddenRows | [0..1] | xsd:boolean | Hidden Rows | Default value is "false". |
| hiddenColumns | [0..1] | xsd:boolean | Hidden Columns | Default value is "false". |
| state | [0..1] | ssml:ST_SheetState | Visible State | Default value is "visible". |
| filterUnique | [0..1] | xsd:boolean | Filter | Default value is "false". |
| view | [0..1] | ssml:ST_SheetViewType | View Type | Default value is "normal". |
| showRuler | [0..1] | xsd:boolean | Show Ruler | Default value is "true". |
| topLeftCell | [0..1] | ssml:ST_CellRef | Top Left Visible Cell |
Used by
- Element ssml:customSheetView