PageSetup Class
Page Setup Settings.When the object is serialized out as xml, its qualified name is x:pageSetup.
Inheritance Hierarchy
System.Object
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlLeafElement
DocumentFormat.OpenXml.Spreadsheet.PageSetup
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
Syntax
'Declaration
Public Class PageSetup _
Inherits OpenXmlLeafElement
'Usage
Dim instance As PageSetup
public class PageSetup : OpenXmlLeafElement
Remarks
[ISO/IEC 29500-1 1st Edition]
18.3.1.63 pageSetup (Page Setup Settings)
Page setup settings for the worksheet.
[Example: The following example shows the pageSetup element for ISO A0 paper, printed in black and white, with graphics:
<pageSetup blackAndWhite="true" draft="false" paperHeight="1189" paperWidth="841" paperUnits="mm" />
end example]
Parent Elements |
|---|
customSheetView (§18.3.1.25); dialogsheet (§18.3.1.34); worksheet (§18.3.1.99) |
Attributes |
Description |
|---|---|
blackAndWhite (Black And White) |
Print black and white. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
cellComments (Print Cell Comments) |
This attribute specifies how to print cell comments. The possible values for this attribute are defined by the ST_CellComments simple type (§18.18.5). |
copies (Number Of Copies) |
Number of copies to print. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
draft (Draft) |
Print without graphics. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
errors (Print Error Handling) |
Specifies how to print cell values for cells with errors. The possible values for this attribute are defined by the ST_PrintError simple type (§18.18.60). |
firstPageNumber (First Page Number) |
Page number for first printed page. If no value is specified, then 'automatic' is assumed. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
fitToHeight (Fit To Height) |
Number of vertical pages to fit on. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
fitToWidth (Fit To Width) |
Number of horizontal pages to fit on. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
horizontalDpi (Horizontal DPI) |
Horizontal print resolution of the device. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
id (Id) Namespace: .../officeDocument/2006/relationships |
Relationship Id of the devMode printer settings part. The possible values for this attribute are defined by the ST_RelationshipId simple type (§22.8.2.1). |
orientation (Orientation) |
Orientation of the page. The possible values for this attribute are defined by the ST_Orientation simple type (§18.18.50). |
pageOrder (Page Order) |
Order of printed pages. The possible values for this attribute are defined by the ST_PageOrder simple type (§18.18.51). |
paperHeight (Paper Height) |
Height of custom paper as a number followed by a unit identifier. [Example: 297mm, 11inend example] When paperHeight and paperWidth are specified, paperSize shall be ignored. The possible values for this attribute are defined by the ST_PositiveUniversalMeasure simple type (§22.9.2.12). |
paperSize (Paper Size) |
Paper size 1 = Letter paper (8.5 in. by 11 in.) 2 = Letter small paper (8.5 in. by 11 in.) 3 = Tabloid paper (11 in. by 17 in.) 4 = Ledger paper (17 in. by 11 in.) 5 = Legal paper (8.5 in. by 14 in.) 6 = Statement paper (5.5 in. by 8.5 in.) 7 = Executive paper (7.25 in. by 10.5 in.) 8 = A3 paper (297 mm by 420 mm) 9 = A4 paper (210 mm by 297 mm) 10 = A4 small paper (210 mm by 297 mm) 11 = A5 paper (148 mm by 210 mm) 12 = B4 paper (250 mm by 353 mm) 13 = B5 paper (176 mm by 250 mm) 14 = Folio paper (8.5 in. by 13 in.) 15 = Quarto paper (215 mm by 275 mm) 16 = Standard paper (10 in. by 14 in.) 17 = Standard paper (11 in. by 17 in.) 18 = Note paper (8.5 in. by 11 in.) 19 = #9 envelope (3.875 in. by 8.875 in.) 20 = #10 envelope (4.125 in. by 9.5 in.) 21 = #11 envelope (4.5 in. by 10.375 in.) 22 = #12 envelope (4.75 in. by 11 in.) 23 = #14 envelope (5 in. by 11.5 in.) 24 = C paper (17 in. by 22 in.) 25 = D paper (22 in. by 34 in.) 26 = E paper (34 in. by 44 in.) 27 = DL envelope (110 mm by 220 mm) 28 = C5 envelope (162 mm by 229 mm) 29 = C3 envelope (324 mm by 458 mm) 30 = C4 envelope (229 mm by 324 mm) 31 = C6 envelope (114 mm by 162 mm) 32 = C65 envelope (114 mm by 229 mm) 33 = B4 envelope (250 mm by 353 mm) 34 = B5 envelope (176 mm by 250 mm) 35 = B6 envelope (176 mm by 125 mm) 36 = Italy envelope (110 mm by 230 mm) 37 = Monarch envelope (3.875 in. by 7.5 in.). 38 = 6 3/4 envelope (3.625 in. by 6.5 in.) 39 = US standard fanfold (14.875 in. by 11 in.) 40 = German standard fanfold (8.5 in. by 12 in.) 41 = German legal fanfold (8.5 in. by 13 in.) 42 = ISO B4 (250 mm by 353 mm) 43 = Japanese double postcard (200 mm by 148 mm) 44 = Standard paper (9 in. by 11 in.) 45 = Standard paper (10 in. by 11 in.) 46 = Standard paper (15 in. by 11 in.) 47 = Invite envelope (220 mm by 220 mm) 50 = Letter extra paper (9.275 in. by 12 in.) 51 = Legal extra paper (9.275 in. by 15 in.) 52 = Tabloid extra paper (11.69 in. by 18 in.) 53 = A4 extra paper (236 mm by 322 mm) 54 = Letter transverse paper (8.275 in. by 11 in.) 55 = A4 transverse paper (210 mm by 297 mm) 56 = Letter extra transverse paper (9.275 in. by 12 in.) 57 = SuperA/SuperA/A4 paper (227 mm by 356 mm) 58 = SuperB/SuperB/A3 paper (305 mm by 487 mm) 59 = Letter plus paper (8.5 in. by 12.69 in.) 60 = A4 plus paper (210 mm by 330 mm) 61 = A5 transverse paper (148 mm by 210 mm) 62 = JIS B5 transverse paper (182 mm by 257 mm) 63 = A3 extra paper (322 mm by 445 mm) 64 = A5 extra paper (174 mm by 235 mm) 65 = ISO B5 extra paper (201 mm by 276 mm) 66 = A2 paper (420 mm by 594 mm) 67 = A3 transverse paper (297 mm by 420 mm) 68 = A3 extra transverse paper (322 mm by 445 mm) When paperHeight, paperWidth, and paperUnits are specified, paperSize should be ignored. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
paperWidth (Paper Width) |
Width of custom paper as a number followed by a unit identifier. [Example: 21cm, 8.5inend example] When paperHeight and paperWidth are specified, paperSize shall be ignored. The possible values for this attribute are defined by the ST_PositiveUniversalMeasure simple type (§22.9.2.12). |
scale (Print Scale) |
Print scaling. This attribute is restricted to values ranging from 10 to 400. [Example: 10 - 10% 20 - 20% … 100 - 100% … 400 - 400% end example] This setting is overridden when fitToWidth and/or fitToHeight are in use. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
useFirstPageNumber (Use First Page Number) |
Use firstPageNumber value for first page number, and do not auto number the pages. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
usePrinterDefaults (Use Printer Defaults) |
Use the printer’s defaults settings for page setup values and don't use the default values specified in the schema. [Example: If dpi is not present or specified in the XML, the application must not assume 600dpi as specified in the schema as a default and instead must let the printer specify the default dpi. end example] The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
verticalDpi (Vertical DPI) |
Vertical print resolution of the device. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
[Note: The W3C XML Schema definition of this element’s content model (CT_PageSetup) 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.