Schema Central > OOXML > sml-sheet.xsd > ssml:sheetView
Advanced search
Need XML Help?

Recommended Reading:

Definitive XML Schema

 

Web Service Contract Design and Versioning for SOA

 

Advanced XML Applications

 

ssml:sheetView

Worksheet View

Element information

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

Schema document: sml-sheet.xsd

Other elements with the same name: ssml:sheetView

Type: ssml:CT_SheetView

Properties: Local, Qualified

Content

Attributes

NameOccTypeDescriptionNotes
windowProtection [0..1]xsd:booleanWindow ProtectionDefault value is "false".
showFormulas [0..1]xsd:booleanShow FormulasDefault value is "false".
showGridLines [0..1]xsd:booleanShow Grid LinesDefault value is "true".
showRowColHeaders [0..1]xsd:booleanShow HeadersDefault value is "true".
showZeros [0..1]xsd:booleanShow Zero ValuesDefault value is "true".
rightToLeft [0..1]xsd:booleanRight To LeftDefault value is "false".
tabSelected [0..1]xsd:booleanSheet Tab SelectedDefault value is "false".
showRuler [0..1]xsd:booleanShow RulerDefault value is "true".
showOutlineSymbols [0..1]xsd:booleanShow Outline SymbolsDefault value is "true".
defaultGridColor [0..1]xsd:booleanDefault Grid ColorDefault value is "true".
showWhiteSpace [0..1]xsd:booleanShow White SpaceDefault value is "true".
view [0..1]ssml:ST_SheetViewTypeView TypeDefault value is "normal".
topLeftCell [0..1]ssml:ST_CellRefTop Left Visible Cell
colorId [0..1]xsd:unsignedIntColor IdDefault value is "64".
zoomScale [0..1]xsd:unsignedIntZoom ScaleDefault value is "100".
zoomScaleNormal [0..1]xsd:unsignedIntZoom Scale Normal ViewDefault value is "0".
zoomScaleSheetLayoutView [0..1]xsd:unsignedIntZoom Scale Page Break PreviewDefault value is "0".
zoomScalePageLayoutView [0..1]xsd:unsignedIntZoom Scale Page Layout ViewDefault value is "0".
workbookViewId [1..1]xsd:unsignedIntWorkbook View Index

Used in

Sample instance

<ssml:sheetView workbookViewId="1">
   <ssml:pane/>
   <ssml:selection sqref="A1 A1"/>
   <ssml:pivotSelection>
      <ssml:pivotArea>
         <ssml:references>...
         </ssml:references>
         <ssml:extLst>...
         </ssml:extLst>
      </ssml:pivotArea>
   </ssml:pivotSelection>
   <ssml:extLst>
      <ssml:ext>
         <!--any element-->
      </ssml:ext>
   </ssml:extLst>
</ssml:sheetView>

Site developed and hosted by Datypic, Inc.

Please report errors or comments about this site to contrib@functx.com