PrintOptions Class

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

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Spreadsheet.PrintOptions

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

Syntax

'Declaration
Public Class PrintOptions _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As PrintOptions
public class PrintOptions : OpenXmlLeafElement

Remarks

[ISO/IEC 29500-1 1st Edition]

18.3.1.70 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.

Thread Safety

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

See Also

Reference

PrintOptions Members

DocumentFormat.OpenXml.Spreadsheet Namespace