PrintOptions class

Office 2013 and later

Print Options. When the object is serialized out as xml, its qualified name is x:printOptions.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

No code example is currently available or this language may not be supported.

[ISO/IEC 29500-1 1st Edition]

printOptions (Print Options)

Print options for the sheet. Printer-specific settings are stored separately in the Printer Settings part as defined in §15.2.15.

Parent Elements

customSheetView (§18.3.1.25); dialogsheet (§18.3.1.34); worksheet (§18.3.1.99)

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 W3C 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 W3C XML Schema boolean datatype.

headings (Print Headings)

Print row and column headings.

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

horizontalCentered (Horizontal Centered)

Center on page horizontally when printing.

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

verticalCentered (Vertical Centered)

Center on page vertically when printing.

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

[Note: The W3C XML Schema definition of this element’s content model (CT_PrintOptions) is located in §A.2. end note]

© ISO/IEC29500: 2008.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Show: