[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

customSheetView (Custom Chart Sheet View)

This element defines custom view properties for chart sheets. See customSheetView3.3.1.23) for an example.

Parent Elements

customSheetViews3.3.1.24)

 

Child Elements

Subclause

headerFooter (Header Footer Settings)

§3.3.1.43

pageMargins (Page Margins)

§3.3.1.60

pageSetup (Chart Sheet Page Setup)

§3.3.1.62

 

Attributes

Description

guid (GUID)

Unique identifier of this custom view

 

The possible values for this attribute are defined by the ST_Guid simple type (§3.18.41).

scale (Print Scale)

Print scaling, 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.

state (Visible State)

Visibility state of the sheet.

 

The possible values for this attribute are defined by the ST_SheetState simple type (§3.18.70).

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_CustomChartsheetView">

   <sequence>

   <element name="pageMargins" type="CT_PageMargins" minOccurs="0" maxOccurs="1"/>

   <element name="pageSetup" type="CT_CsPageSetup" minOccurs="0" maxOccurs="1"/>

   <element name="headerFooter" type="CT_HeaderFooter" minOccurs="0" maxOccurs="1"/>

   </sequence>

   <attribute name="guid" type="ST_Guid" use="required"/>

   <attribute name="scale" type="xsd:unsignedInt" default="100"/>

   <attribute name="state" type="ST_SheetState" default="visible"/>

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

</complexType>