[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
Print options for the sheet. Printer-specific settings are stored separately in the Printer Settings part as defined in Part 1.
Parent Elements |
customSheetView (§3.3.1.23); dialogsheet (§3.3.1.32); worksheet (§3.3.1.96) |
Attributes |
Description |
gridLines (Print Grid Lines) |
Used in conjunction with gridLinesSet. If both gridLines and gridlinesSet are true, then grid lines shall print. Otherwise, they shall not (i.e., one or both have false values).
The possible values for this attribute are defined by the XML Schema boolean datatype. |
gridLinesSet (Grid Lines Set) |
Used in conjunction with gridLines. If both gridLines and gridLinesSet are true, then grid lines shall print. Otherwise, they shall not (i.e., one or both have false values).
The possible values for this attribute are defined by the XML Schema boolean datatype. |
headings (Print Headings) |
Print row and column headings.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
horizontalCentered (Horizontal Centered) |
Center on page horizontally when printing.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
verticalCentered (Vertical Centered) |
Center on page vertically when printing.
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_PrintOptions">
<attribute name="horizontalCentered" type="xsd:boolean" use="optional" default="false"/>
<attribute name="verticalCentered" type="xsd:boolean" use="optional" default="false"/>
<attribute name="headings" type="xsd:boolean" use="optional" default="false"/>
<attribute name="gridLines" type="xsd:boolean" use="optional" default="false"/>
<attribute name="gridLinesSet" type="xsd:boolean" use="optional" default="true"/>
</complexType>