xlsx-0.2.1.1: Simple and incomplete Excel file parser/writer

Safe HaskellNone
LanguageHaskell2010

Codec.Xlsx.Types.PageSetup

Contents

Synopsis

Main types

data PageSetup Source

Constructors

PageSetup 

Fields

_pageSetupBlackAndWhite :: Maybe Bool

Print black and white.

_pageSetupCellComments :: Maybe CellComments

This attribute specifies how to print cell comments.

_pageSetupCopies :: Maybe Int

Number of copies to print.

_pageSetupDraft :: Maybe Bool

Print without graphics.

_pageSetupErrors :: Maybe PrintErrors

Specifies how to print cell values for cells with errors.

_pageSetupFirstPageNumber :: Maybe Int

Page number for first printed page. If no value is specified, then automatic is assumed.

_pageSetupFitToHeight :: Maybe Int

Number of vertical pages to fit on.

_pageSetupFitToWidth :: Maybe Int

Number of horizontal pages to fit on.

_pageSetupHorizontalDpi :: Maybe Int

Horizontal print resolution of the device.

_pageSetupId :: Maybe Text

Relationship Id of the devMode printer settings part.

(Explicit reference to a parent XML element.)

See 22.8.2.1 "ST_RelationshipId (Explicit Relationship ID)" (p. 3784)

_pageSetupOrientation :: Maybe Orientation

Orientation of the page.

_pageSetupPageOrder :: Maybe PageOrder

Order of printed pages

_pageSetupPaperHeight :: Maybe Text

Height of custom paper as a number followed by a unit identifier.

When paperHeight and paperWidth are specified, paperSize shall be ignored. Examples: "297mm", "11in".

See 22.9.2.12 "ST_PositiveUniversalMeasure (Positive Universal Measurement)" (p. 3792)

_pageSetupPaperSize :: Maybe PaperSize

Pager size

When paperHeight, paperWidth, and paperUnits are specified, paperSize should be ignored.

_pageSetupPaperWidth :: Maybe Text

Width of custom paper as a number followed by a unit identifier

Examples: 21cm, 8.5in

When paperHeight and paperWidth are specified, paperSize shall be ignored.

_pageSetupScale :: Maybe Int

Print scaling.

This attribute is restricted to values ranging from 10 to 400. This setting is overridden when fitToWidth and/or fitToHeight are in use.

_pageSetupUseFirstPageNumber :: Maybe Bool

Use _pageSetupFirstPageNumber value for first page number, and do not auto number the pages.

_pageSetupUsePrinterDefaults :: Maybe Bool

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.

_pageSetupVerticalDpi :: Maybe Int

Vertical print resolution of the device.

Enumerations

data CellComments Source

Cell comments

These enumerations specify how cell comments shall be displayed for paper printing purposes.

See 18.18.5 "ST_CellComments (Cell Comments)" (p. 2441).

Constructors

CellCommentsAsDisplayed

Print cell comments as displayed

CellCommentsAtEnd

Print cell comments at end of document

CellCommentsNone

Do not print cell comments

Instances

data PrintErrors Source

Print errors

This enumeration specifies how to display cells with errors when printing the worksheet.

Constructors

PrintErrorsBlank

Display cell errors as blank

PrintErrorsDash

Display cell errors as dashes

PrintErrorsDisplayed

Display cell errors as displayed on screen

PrintErrorsNA

Display cell errors as #N/A

Instances

data Orientation Source

Print orientation for this sheet

Instances

data PageOrder Source

Specifies printed page order

Constructors

PageOrderDownThenOver

Order pages vertically first, then move horizontally

PageOrderOverThenDown

Order pages horizontally first, then move vertically

Instances

data PaperSize Source

Paper size

Constructors

PaperA2

A2 paper (420 mm by 594 mm)

PaperA3

A3 paper (297 mm by 420 mm)

PaperA3Extra

A3 extra paper (322 mm by 445 mm)

PaperA3ExtraTransverse

A3 extra transverse paper (322 mm by 445 mm)

PaperA3Transverse

A3 transverse paper (297 mm by 420 mm)

PaperA4

A4 paper (210 mm by 297 mm)

PaperA4Extra

A4 extra paper (236 mm by 322 mm)

PaperA4Plus

A4 plus paper (210 mm by 330 mm)

PaperA4Small

A4 small paper (210 mm by 297 mm)

PaperA4Transverse

A4 transverse paper (210 mm by 297 mm)

PaperA5

A5 paper (148 mm by 210 mm)

PaperA5Extra

A5 extra paper (174 mm by 235 mm)

PaperA5Transverse

A5 transverse paper (148 mm by 210 mm)

PaperB4

B4 paper (250 mm by 353 mm)

PaperB5

B5 paper (176 mm by 250 mm)

PaperC

C paper (17 in. by 22 in.)

PaperD

D paper (22 in. by 34 in.)

PaperE

E paper (34 in. by 44 in.)

PaperExecutive

Executive paper (7.25 in. by 10.5 in.)

PaperFanfoldGermanLegal

German legal fanfold (8.5 in. by 13 in.)

PaperFanfoldGermanStandard

German standard fanfold (8.5 in. by 12 in.)

PaperFanfoldUsStandard

US standard fanfold (14.875 in. by 11 in.)

PaperFolio

Folio paper (8.5 in. by 13 in.)

PaperIsoB4

ISO B4 (250 mm by 353 mm)

PaperIsoB5Extra

ISO B5 extra paper (201 mm by 276 mm)

PaperJapaneseDoublePostcard

Japanese double postcard (200 mm by 148 mm)

PaperJisB5Transverse

JIS B5 transverse paper (182 mm by 257 mm)

PaperLedger

Ledger paper (17 in. by 11 in.)

PaperLegal

Legal paper (8.5 in. by 14 in.)

PaperLegalExtra

Legal extra paper (9.275 in. by 15 in.)

PaperLetter

Letter paper (8.5 in. by 11 in.)

PaperLetterExtra

Letter extra paper (9.275 in. by 12 in.)

PaperLetterExtraTransverse

Letter extra transverse paper (9.275 in. by 12 in.)

PaperLetterPlus

Letter plus paper (8.5 in. by 12.69 in.)

PaperLetterSmall

Letter small paper (8.5 in. by 11 in.)

PaperLetterTransverse

Letter transverse paper (8.275 in. by 11 in.)

PaperNote

Note paper (8.5 in. by 11 in.)

PaperQuarto

Quarto paper (215 mm by 275 mm)

PaperStandard9_11

Standard paper (9 in. by 11 in.)

PaperStandard10_11

Standard paper (10 in. by 11 in.)

PaperStandard10_14

Standard paper (10 in. by 14 in.)

PaperStandard11_17

Standard paper (11 in. by 17 in.)

PaperStandard15_11

Standard paper (15 in. by 11 in.)

PaperStatement

Statement paper (5.5 in. by 8.5 in.)

PaperSuperA

SuperASuperAA4 paper (227 mm by 356 mm)

PaperSuperB

SuperBSuperBA3 paper (305 mm by 487 mm)

PaperTabloid

Tabloid paper (11 in. by 17 in.)

PaperTabloidExtra

Tabloid extra paper (11.69 in. by 18 in.)

Envelope6_3_4

6 3/4 envelope (3.625 in. by 6.5 in.)

Envelope9

#9 envelope (3.875 in. by 8.875 in.)

Envelope10

#10 envelope (4.125 in. by 9.5 in.)

Envelope11

#11 envelope (4.5 in. by 10.375 in.)

Envelope12

#12 envelope (4.75 in. by 11 in.)

Envelope14

#14 envelope (5 in. by 11.5 in.)

EnvelopeB4

B4 envelope (250 mm by 353 mm)

EnvelopeB5

B5 envelope (176 mm by 250 mm)

EnvelopeB6

B6 envelope (176 mm by 125 mm)

EnvelopeC3

C3 envelope (324 mm by 458 mm)

EnvelopeC4

C4 envelope (229 mm by 324 mm)

EnvelopeC5

C5 envelope (162 mm by 229 mm)

EnvelopeC6

C6 envelope (114 mm by 162 mm)

EnvelopeC65

C65 envelope (114 mm by 229 mm)

EnvelopeDL

DL envelope (110 mm by 220 mm)

EnvelopeInvite

Invite envelope (220 mm by 220 mm)

EnvelopeItaly

Italy envelope (110 mm by 230 mm)

EnvelopeMonarch

Monarch envelope (3.875 in. by 7.5 in.).

Instances

Eq PaperSize Source 
Ord PaperSize Source 
Show PaperSize Source 
ToAttrVal PaperSize Source

See paperSize (attribute of pageSetup), p. 1659

FromAttrVal PaperSize Source

See paperSize (attribute of pageSetup), p. 1659

Lenses

PageSetup