ssml:customSheetView

Custom Sheet View

Element information

Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main

Schema document: sml-sheet.xsd

Other elements with the same name: ssml:customSheetView

Type: ssml:CT_CustomSheetView

Properties: Local, Qualified

Content

Sequence [1..1]
1. ssml:pane [0..1] Pane Split Information
2. ssml:selection [0..1] Selection
3. ssml:rowBreaks [0..1] Horizontal Page Breaks
4. ssml:colBreaks [0..1] Vertical Page Breaks
5. ssml:pageMargins [0..1] Page Margins
6. ssml:printOptions [0..1] Print Options
7. ssml:pageSetup [0..1] Page Setup Settings
8. ssml:headerFooter [0..1] Header Footer Settings
9. ssml:autoFilter [0..1] AutoFilter Settings
10. 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 in

Type ssml:CT_CustomSheetViews (Element ssml:customSheetViews)

Sample instance

<ssml:customSheetView guid="token">
   <ssml:pane/>
   <ssml:selection sqref="A1 A1"/>
   <ssml:rowBreaks>
      <ssml:brk/>
   </ssml:rowBreaks>
   <ssml:colBreaks>
      <ssml:brk/>
   </ssml:colBreaks>
   <ssml:pageMargins left="1.0" right="1.0" top="1.0" bottom="1.0" header="1.0" footer="1.0"/>
   <ssml:printOptions/>
   <ssml:pageSetup/>
   <ssml:headerFooter>
      <ssml:oddHeader>string</ssml:oddHeader>
      <ssml:oddFooter>string</ssml:oddFooter>
      <ssml:evenHeader>string</ssml:evenHeader>
      <ssml:evenFooter>string</ssml:evenFooter>
      <ssml:firstHeader>string</ssml:firstHeader>
      <ssml:firstFooter>string</ssml:firstFooter>
   </ssml:headerFooter>
   <ssml:autoFilter>
      <ssml:filterColumn colId="1">
         <ssml:filters>...
         </ssml:filters>
      </ssml:filterColumn>
      <ssml:sortState ref="string">
         <ssml:sortCondition ref="string" iconSet="3Arrows"/>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:sortState>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:autoFilter>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:customSheetView>