ssml:customSheetViews

Custom Sheet Views

Element information

Content

• ssml:customSheetView [1..*]    Custom Sheet View

Attributes

None

Used in

• Type ssml:CT_Macrosheet
• Type ssml:CT_Dialogsheet (Element ssml:dialogsheet)
• Type ssml:CT_Worksheet (Element ssml:worksheet)

Sample instance

<ssml:customSheetViews>
   <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:filterColumn>
         <ssml:sortState ref="string">...
         </ssml:sortState>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:autoFilter>
      <ssml:extLst>
         <ssml:ext>
            <!--any element-->
         </ssml:ext>
      </ssml:extLst>
   </ssml:customSheetView>
</ssml:customSheetViews>