[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 customSheetView (§3.3.1.23) for an example.
Parent Elements |
customSheetViews (§3.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>