[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

sheetView (Chart Sheet View)

This element specifies a chart sheet view. See sheetView3.3.1.83) for an example.

Parent Elements

sheetViews3.3.1.86)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

 

Attributes

Description

tabSelected (Sheet Tab Selected)

Flag indicating whether the sheet tab is selected.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

workbookViewId (Workbook View Id)

Zero-based index of this workbook view, pointing to a workbookView element in the bookViews collection.

 

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

zoomScale (Window Zoom Scale)

Window zoom magnification, representing percent values. Valid values range from 10 to 400. Horizontal & Vertical scale together.

 

For example:

 

10 - 10%

20 - 20%

100 - 100%

400 - 400%

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

zoomToFit (Zoom To Fit)

Flag indicating whether chart sheet is zoom to fit window.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_ChartsheetView">

   <sequence>

   <element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="tabSelected" type="xsd:boolean" use="optional" default="false"/>

   <attribute name="zoomScale" type="xsd:unsignedInt" default="100" use="optional"/>

   <attribute name="workbookViewId" type="xsd:unsignedInt" use="required"/>

   <attribute name="zoomToFit" type="xsd:boolean" use="optional" default="false"/>

</complexType>