Codec.Xlsx.Types.StyleSheet

Support for writing (but not reading) style sheets

The main two types

data StyleSheet

StyleSheet for an XML document

Relevant parts of the EMCA standard (4th edition, part 1, http://www.ecma-international.org/publications/standards/Ecma-376.htm), page numbers refer to the page in the PDF rather than the page number as printed on the page):

• Chapter 12, SpreadsheetML (p. 74) In particular Section 12.3.20, "Styles Part" (p. 104)
• Chapter 18, "SpreadsheetML Reference Material" (p. 1528) In particular Section 18.8, Styles (p. 1754) and Section 18.8.39 "styleSheet" (Style Sheet)" (p. 1796); it is the latter section that specifies the top-level style sheet format.

TODO: the following child elements:

• cellStyles
• cellStyleXfs
• colors
• extLst
• tableStyles

NOTE: You will probably want to base your style sheet on minimalStyleSheet. See also:

• renderStyleSheet to translate a StyleSheet to Styles
• formatted for a higher level interface.
• parseStyleSheet to translate a raw StyleSheet into Styles

Constructors

StyleSheet

Fields

• _styleSheetBorders :: [Border]

  This element contains borders formatting information, specifying all border definitions for all cells in the workbook.

  Section 18.8.5, "borders (Borders)" (p. 1760)

• _styleSheetCellXfs :: [CellXf]

  Cell formats

  This element contains the master formatting records (xf) which define the formatting applied to cells in this workbook. These records are the starting point for determining the formatting for a cell. Cells in the Sheet Part reference the xf records by zero-based index.

  Section 18.8.10, "cellXfs (Cell Formats)" (p. 1764)

• _styleSheetFills :: [Fill]

  This element defines the cell fills portion of the Styles part, consisting of a sequence of fill records. A cell fill consists of a background color, foreground color, and pattern to be applied across the cell.

  Section 18.8.21, "fills (Fills)" (p. 1768)

• _styleSheetFonts :: [Font]

  This element contains all font definitions for this workbook.

  Section 18.8.23 "fonts (Fonts)" (p. 1769)

• _styleSheetDxfs :: [Dxf]

  Differential formatting

  This element contains the master differential formatting records (dxf's) which define formatting for all non-cell formatting in this workbook. Whereas xf records fully specify a particular aspect of formatting (e.g., cell borders) by referencing those formatting definitions elsewhere in the Styles part, dxf records specify incremental (or differential) aspects of formatting directly inline within the dxf element. The dxf formatting is to be applied on top of or in addition to any formatting already present on the object using the dxf record.

  Section 18.8.15, "dxfs (Formats)" (p. 1765)

• _styleSheetNumFmts :: Map Int FormatCode

  Number formats

  This element contains custom number formats defined in this style sheet

  Section 18.8.31, "numFmts (Number Formats)" (p. 1784)

Instances

Eq StyleSheet

Methods

(==) :: StyleSheet -> StyleSheet -> Bool

(/=) :: StyleSheet -> StyleSheet -> Bool

Ord StyleSheet

Methods

compare :: StyleSheet -> StyleSheet -> Ordering

(<) :: StyleSheet -> StyleSheet -> Bool

(<=) :: StyleSheet -> StyleSheet -> Bool

(>) :: StyleSheet -> StyleSheet -> Bool

(>=) :: StyleSheet -> StyleSheet -> Bool

max :: StyleSheet -> StyleSheet -> StyleSheet

min :: StyleSheet -> StyleSheet -> StyleSheet

Show StyleSheet

Methods

showsPrec :: Int -> StyleSheet -> ShowS

show :: StyleSheet -> String

showList :: [StyleSheet] -> ShowS

Generic StyleSheet

Associated Types

type Rep StyleSheet :: * -> *

Methods

from :: StyleSheet -> Rep StyleSheet x

to :: Rep StyleSheet x -> StyleSheet

Default StyleSheet

Methods

def :: StyleSheet

NFData StyleSheet

Methods

rnf :: StyleSheet -> ()

FromCursor StyleSheet

See CT_Stylesheet, p. 4482

Methods

fromCursor :: Cursor -> [StyleSheet]

ToElement StyleSheet

See CT_Stylesheet, p. 4482

Methods

toElement :: Name -> StyleSheet -> Element

ToDocument StyleSheet

Methods

toDocument :: StyleSheet -> Document

type Rep StyleSheet

type Rep StyleSheet = D1 * (MetaData "StyleSheet" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "StyleSheet" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_styleSheetBorders") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [Border])) ((:*:) * (S1 * (MetaSel (Just Symbol "_styleSheetCellXfs") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [CellXf])) (S1 * (MetaSel (Just Symbol "_styleSheetFills") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [Fill])))) ((:*:) * (S1 * (MetaSel (Just Symbol "_styleSheetFonts") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [Font])) ((:*:) * (S1 * (MetaSel (Just Symbol "_styleSheetDxfs") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * [Dxf])) (S1 * (MetaSel (Just Symbol "_styleSheetNumFmts") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Map Int FormatCode)))))))

data CellXf

Cell formatting

TODO: The extLst field is currently unsupported.

Section 18.8.45 "xf (Format)" (p. 1800)

Constructors

CellXf

Fields

• _cellXfApplyAlignment :: Maybe Bool

  A boolean value indicating whether the alignment formatting specified for this xf should be applied.

• _cellXfApplyBorder :: Maybe Bool

  A boolean value indicating whether the border formatting specified for this xf should be applied.

• _cellXfApplyFill :: Maybe Bool

  A boolean value indicating whether the fill formatting specified for this xf should be applied.

• _cellXfApplyFont :: Maybe Bool

  A boolean value indicating whether the font formatting specified for this xf should be applied.

• _cellXfApplyNumberFormat :: Maybe Bool

  A boolean value indicating whether the number formatting specified for this xf should be applied.

• _cellXfApplyProtection :: Maybe Bool

  A boolean value indicating whether the protection formatting specified for this xf should be applied.

• _cellXfBorderId :: Maybe Int

  Zero-based index of the border record used by this cell format.

  (18.18.2, p. 2437).

• _cellXfFillId :: Maybe Int

  Zero-based index of the fill record used by this cell format.

  (18.18.30, p. 2455)

• _cellXfFontId :: Maybe Int

  Zero-based index of the font record used by this cell format.

  An integer that represents a zero based index into the styleSheetFonts collection in the style sheet (18.18.32, p. 2456).

• _cellXfNumFmtId :: Maybe Int

  Id of the number format (numFmt) record used by this cell format.

  This simple type defines the identifier to a style sheet number format entry in CT_NumFmts. Number formats are written to the styles part (18.18.47, p. 2468). See also 18.8.31 (p. 1784) for more information on number formats.

• _cellXfPivotButton :: Maybe Bool

  A boolean value indicating whether the cell rendering includes a pivot table dropdown button.

• _cellXfQuotePrefix :: Maybe Bool

  A boolean value indicating whether the text string in a cell should be prefixed by a single quote mark (e.g., 'text). In these cases, the quote is not stored in the Shared Strings Part.

• _cellXfId :: Maybe Int

  For xf records contained in cellXfs this is the zero-based index of an xf record contained in cellStyleXfs corresponding to the cell style applied to the cell.

  Not present for xf records contained in cellStyleXfs.

  Used by xf records and cellStyle records to reference xf records defined in the cellStyleXfs collection. (18.18.10, p. 2442) TODO: the cellStyleXfs field of a style sheet not currently implemented.

• _cellXfAlignment :: Maybe Alignment

  Formatting information pertaining to text alignment in cells. There are a variety of choices for how text is aligned both horizontally and vertically, as well as indentation settings, and so on.

• _cellXfProtection :: Maybe Protection

  Contains protection properties associated with the cell. Each cell has protection properties that can be set. The cell protection properties do not take effect unless the sheet has been protected.

Instances

Eq CellXf

Methods

(==) :: CellXf -> CellXf -> Bool

(/=) :: CellXf -> CellXf -> Bool

Ord CellXf

Methods

compare :: CellXf -> CellXf -> Ordering

(<) :: CellXf -> CellXf -> Bool

(<=) :: CellXf -> CellXf -> Bool

(>) :: CellXf -> CellXf -> Bool

(>=) :: CellXf -> CellXf -> Bool

max :: CellXf -> CellXf -> CellXf

min :: CellXf -> CellXf -> CellXf

Show CellXf

Methods

showsPrec :: Int -> CellXf -> ShowS

show :: CellXf -> String

showList :: [CellXf] -> ShowS

Generic CellXf

Associated Types

type Rep CellXf :: * -> *

Methods

from :: CellXf -> Rep CellXf x

to :: Rep CellXf x -> CellXf

Default CellXf

Methods

def :: CellXf

NFData CellXf

Methods

rnf :: CellXf -> ()

FromCursor CellXf

See CT_Xf, p. 4486

Methods

fromCursor :: Cursor -> [CellXf]

ToElement CellXf

See CT_Xf, p. 4486

Methods

toElement :: Name -> CellXf -> Element

type Rep CellXf

type Rep CellXf = D1 * (MetaData "CellXf" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "CellXf" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfApplyAlignment") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfApplyBorder") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_cellXfApplyFill") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfApplyFont") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_cellXfApplyNumberFormat") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfApplyProtection") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_cellXfBorderId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int)))))) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfFillId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_cellXfFontId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfNumFmtId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_cellXfPivotButton") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfQuotePrefix") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_cellXfId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_cellXfAlignment") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Alignment))) (S1 * (MetaSel (Just Symbol "_cellXfProtection") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Protection))))))))

minimalStyleSheet :: StyleSheet

Minimal style sheet

Excel expects some minimal definitions in the stylesheet; you probably want to define your own stylesheets based on this one.

This more-or-less follows the recommendations at http://stackoverflow.com/questions/26050708/minimal-style-sheet-for-excel-open-xml-with-dates, but with some additions based on experimental evidence.

Supporting record types

data Alignment

Alignment

See 18.8.1 "alignment (Alignment)" (p. 1754)

Constructors

Alignment

Fields

• _alignmentHorizontal :: Maybe CellHorizontalAlignment

  Specifies the type of horizontal alignment in cells.

• _alignmentIndent :: Maybe Int

  An integer value, where an increment of 1 represents 3 spaces. Indicates the number of spaces (of the normal style font) of indentation for text in a cell.

• _alignmentJustifyLastLine :: Maybe Bool

  A boolean value indicating if the cells justified or distributed alignment should be used on the last line of text. (This is typical for East Asian alignments but not typical in other contexts.)

• _alignmentReadingOrder :: Maybe ReadingOrder

  An integer value indicating whether the reading order (bidirectionality) of the cell is leftto- right, right-to-left, or context dependent.

• _alignmentRelativeIndent :: Maybe Int

  An integer value (used only in a dxf element) to indicate the additional number of spaces of indentation to adjust for text in a cell.

• _alignmentShrinkToFit :: Maybe Bool

  A boolean value indicating if the displayed text in the cell should be shrunk to fit the cell width. Not applicable when a cell contains multiple lines of text.

• _alignmentTextRotation :: Maybe Int

  Text rotation in cells. Expressed in degrees. Values range from 0 to 180. The first letter of the text is considered the center-point of the arc.

• _alignmentVertical :: Maybe CellVerticalAlignment

  Vertical alignment in cells.

• _alignmentWrapText :: Maybe Bool

  A boolean value indicating if the text in a cell should be line-wrapped within the cell.

Instances

Eq Alignment

Methods

(==) :: Alignment -> Alignment -> Bool

(/=) :: Alignment -> Alignment -> Bool

Ord Alignment

Methods

compare :: Alignment -> Alignment -> Ordering

(<) :: Alignment -> Alignment -> Bool

(<=) :: Alignment -> Alignment -> Bool

(>) :: Alignment -> Alignment -> Bool

(>=) :: Alignment -> Alignment -> Bool

max :: Alignment -> Alignment -> Alignment

min :: Alignment -> Alignment -> Alignment

Show Alignment

Methods

showsPrec :: Int -> Alignment -> ShowS

show :: Alignment -> String

showList :: [Alignment] -> ShowS

Generic Alignment

Associated Types

type Rep Alignment :: * -> *

Methods

from :: Alignment -> Rep Alignment x

to :: Rep Alignment x -> Alignment

Default Alignment

Methods

def :: Alignment

NFData Alignment

Methods

rnf :: Alignment -> ()

FromCursor Alignment

See CT_CellAlignment, p. 4482

Methods

fromCursor :: Cursor -> [Alignment]

ToElement Alignment

See CT_CellAlignment, p. 4482

Methods

toElement :: Name -> Alignment -> Element

type Rep Alignment

type Rep Alignment = D1 * (MetaData "Alignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Alignment" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_alignmentHorizontal") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe CellHorizontalAlignment))) (S1 * (MetaSel (Just Symbol "_alignmentIndent") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_alignmentJustifyLastLine") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_alignmentReadingOrder") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe ReadingOrder))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_alignmentRelativeIndent") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_alignmentShrinkToFit") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_alignmentTextRotation") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) ((:*:) * (S1 * (MetaSel (Just Symbol "_alignmentVertical") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe CellVerticalAlignment))) (S1 * (MetaSel (Just Symbol "_alignmentWrapText") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))))))))

data Border

Expresses a single set of cell border formats (left, right, top, bottom, diagonal). Color is optional. When missing, automatic is implied.

See 18.8.4 "border (Border)" (p. 1759)

Constructors

Border

Fields

• _borderDiagonalDown :: Maybe Bool

  A boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the top left corner of the cell and moving down to the bottom right corner of the cell.

• _borderDiagonalUp :: Maybe Bool

  A boolean value indicating if the cell's diagonal border includes a diagonal line, starting at the bottom left corner of the cell and moving up to the top right corner of the cell.

• _borderOutline :: Maybe Bool

  A boolean value indicating if left, right, top, and bottom borders should be applied only to outside borders of a cell range.

• _borderBottom :: Maybe BorderStyle

  Bottom border

• _borderDiagonal :: Maybe BorderStyle

  Diagonal

• _borderEnd :: Maybe BorderStyle

  Trailing edge border

  See also borderRight

• _borderHorizontal :: Maybe BorderStyle

  Horizontal inner borders

• _borderLeft :: Maybe BorderStyle

  Left border

  NOTE: The spec does not formally list a left border element, but the examples do mention left and the scheme contains it too. See also borderStart.

• _borderRight :: Maybe BorderStyle

  Right border

  NOTE: The spec does not formally list a right border element, but the examples do mention right and the scheme contains it too. See also borderEnd.

• _borderStart :: Maybe BorderStyle

  Leading edge border

  See also borderLeft

• _borderTop :: Maybe BorderStyle

  Top border

• _borderVertical :: Maybe BorderStyle

  Vertical inner border

Instances

Eq Border

Methods

(==) :: Border -> Border -> Bool

(/=) :: Border -> Border -> Bool

Ord Border

Methods

compare :: Border -> Border -> Ordering

(<) :: Border -> Border -> Bool

(<=) :: Border -> Border -> Bool

(>) :: Border -> Border -> Bool

(>=) :: Border -> Border -> Bool

max :: Border -> Border -> Border

min :: Border -> Border -> Border

Show Border

Methods

showsPrec :: Int -> Border -> ShowS

show :: Border -> String

showList :: [Border] -> ShowS

Generic Border

Associated Types

type Rep Border :: * -> *

Methods

from :: Border -> Rep Border x

to :: Rep Border x -> Border

Default Border

Methods

def :: Border

NFData Border

Methods

rnf :: Border -> ()

FromCursor Border

See CT_Border, p. 4483

Methods

fromCursor :: Cursor -> [Border]

ToElement Border

See CT_Border, p. 4483

Methods

toElement :: Name -> Border -> Element

type Rep Border

type Rep Border = D1 * (MetaData "Border" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Border" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_borderDiagonalDown") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderDiagonalUp") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_borderOutline") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderBottom") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderDiagonal") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) (S1 * (MetaSel (Just Symbol "_borderEnd") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle)))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_borderHorizontal") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderLeft") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) (S1 * (MetaSel (Just Symbol "_borderRight") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderStart") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderTop") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))) (S1 * (MetaSel (Just Symbol "_borderVertical") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe BorderStyle))))))))

data BorderStyle

Border style See CT_BorderPr (p. 3934)

Constructors

BorderStyle

Fields

• _borderStyleColor :: Maybe Color
• _borderStyleLine :: Maybe LineStyle

Instances

Eq BorderStyle

Methods

(==) :: BorderStyle -> BorderStyle -> Bool

(/=) :: BorderStyle -> BorderStyle -> Bool

Ord BorderStyle

Methods

compare :: BorderStyle -> BorderStyle -> Ordering

(<) :: BorderStyle -> BorderStyle -> Bool

(<=) :: BorderStyle -> BorderStyle -> Bool

(>) :: BorderStyle -> BorderStyle -> Bool

(>=) :: BorderStyle -> BorderStyle -> Bool

max :: BorderStyle -> BorderStyle -> BorderStyle

min :: BorderStyle -> BorderStyle -> BorderStyle

Show BorderStyle

Methods

showsPrec :: Int -> BorderStyle -> ShowS

show :: BorderStyle -> String

showList :: [BorderStyle] -> ShowS

Generic BorderStyle

Associated Types

type Rep BorderStyle :: * -> *

Methods

from :: BorderStyle -> Rep BorderStyle x

to :: Rep BorderStyle x -> BorderStyle

Default BorderStyle

Methods

def :: BorderStyle

NFData BorderStyle

Methods

rnf :: BorderStyle -> ()

FromCursor BorderStyle

Methods

fromCursor :: Cursor -> [BorderStyle]

ToElement BorderStyle

See CT_BorderPr, p. 4483

Methods

toElement :: Name -> BorderStyle -> Element

type Rep BorderStyle

type Rep BorderStyle = D1 * (MetaData "BorderStyle" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "BorderStyle" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_borderStyleColor") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Color))) (S1 * (MetaSel (Just Symbol "_borderStyleLine") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe LineStyle)))))

data Color

One of the colors associated with the data bar or color scale.

The indexed attribute (used for backwards compatibility only) is not modelled here.

See 18.3.1.15 "color (Data Bar Color)" (p. 1608)

Constructors

Color

Fields

• _colorAutomatic :: Maybe Bool

  A boolean value indicating the color is automatic and system color dependent.

• _colorARGB :: Maybe Text

  Standard Alpha Red Green Blue color value (ARGB).

  This simple type's contents have a length of exactly 8 hexadecimal digit(s); see "18.18.86 ST_UnsignedIntHex (Hex Unsigned Integer)" (p. 2511).

• _colorTheme :: Maybe Int

  A zero-based index into the clrScheme collection (20.1.6.2), referencing a particular sysClr or srgbClr value expressed in the Theme part.

• _colorTint :: Maybe Double

  Specifies the tint value applied to the color.

  If tint is supplied, then it is applied to the RGB value of the color to determine the final color applied.

  The tint value is stored as a double from -1.0 .. 1.0, where -1.0 means 100% darken and 1.0 means 100% lighten. Also, 0.0 means no change.

Instances

Eq Color

Methods

(==) :: Color -> Color -> Bool

(/=) :: Color -> Color -> Bool

Ord Color

Methods

compare :: Color -> Color -> Ordering

(<) :: Color -> Color -> Bool

(<=) :: Color -> Color -> Bool

(>) :: Color -> Color -> Bool

(>=) :: Color -> Color -> Bool

max :: Color -> Color -> Color

min :: Color -> Color -> Color

Show Color

Methods

showsPrec :: Int -> Color -> ShowS

show :: Color -> String

showList :: [Color] -> ShowS

Generic Color

Associated Types

type Rep Color :: * -> *

Methods

from :: Color -> Rep Color x

to :: Rep Color x -> Color

Default Color

Methods

def :: Color

NFData Color

Methods

rnf :: Color -> ()

FromXenoNode Color

Methods

fromXenoNode :: Node -> Either Text Color

FromCursor Color

See CT_Color, p. 4484

Methods

fromCursor :: Cursor -> [Color]

ToElement Color

See CT_Color, p. 4484

Methods

toElement :: Name -> Color -> Element

type Rep Color

type Rep Color = D1 * (MetaData "Color" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Color" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_colorAutomatic") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_colorARGB") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_colorTheme") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_colorTint") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Double))))))

data Dxf

A single dxf record, expressing incremental formatting to be applied.

Section 18.8.14, "dxf (Formatting)" (p. 1765)

Constructors

Dxf

Fields

• _dxfFont :: Maybe Font
• _dxfNumFmt :: Maybe NumFmt

  It seems to be required that this number format entry is duplicated in _styleSheetNumFmts of the style sheet, though the spec says nothing explicitly about it.

• _dxfFill :: Maybe Fill
• _dxfAlignment :: Maybe Alignment
• _dxfBorder :: Maybe Border
• _dxfProtection :: Maybe Protection

Instances

Eq Dxf

Methods

(==) :: Dxf -> Dxf -> Bool

(/=) :: Dxf -> Dxf -> Bool

Ord Dxf

Methods

compare :: Dxf -> Dxf -> Ordering

(<) :: Dxf -> Dxf -> Bool

(<=) :: Dxf -> Dxf -> Bool

(>) :: Dxf -> Dxf -> Bool

(>=) :: Dxf -> Dxf -> Bool

max :: Dxf -> Dxf -> Dxf

min :: Dxf -> Dxf -> Dxf

Show Dxf

Methods

showsPrec :: Int -> Dxf -> ShowS

show :: Dxf -> String

showList :: [Dxf] -> ShowS

Generic Dxf

Associated Types

type Rep Dxf :: * -> *

Methods

from :: Dxf -> Rep Dxf x

to :: Rep Dxf x -> Dxf

Default Dxf

Methods

def :: Dxf

NFData Dxf

Methods

rnf :: Dxf -> ()

FromCursor Dxf

See CT_Dxf, p. 3937

Methods

fromCursor :: Cursor -> [Dxf]

ToElement Dxf

See CT_Dxf, p. 3937

Methods

toElement :: Name -> Dxf -> Element

type Rep Dxf

type Rep Dxf = D1 * (MetaData "Dxf" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Dxf" PrefixI True) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_dxfFont") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Font))) ((:*:) * (S1 * (MetaSel (Just Symbol "_dxfNumFmt") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe NumFmt))) (S1 * (MetaSel (Just Symbol "_dxfFill") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Fill))))) ((:*:) * (S1 * (MetaSel (Just Symbol "_dxfAlignment") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Alignment))) ((:*:) * (S1 * (MetaSel (Just Symbol "_dxfBorder") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Border))) (S1 * (MetaSel (Just Symbol "_dxfProtection") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Protection)))))))

data Fill

This element specifies fill formatting.

TODO: Gradient fills (18.8.4) are currently unsupported. If we add them, then the spec says (CT_Fill, p. 3935), _either_ a gradient _or_ a solid fill pattern should be specified.

Section 18.8.20, "fill (Fill)" (p. 1768)

Constructors

Fill

Fields

• _fillPattern :: Maybe FillPattern

Instances

Eq Fill

Methods

(==) :: Fill -> Fill -> Bool

(/=) :: Fill -> Fill -> Bool

Ord Fill

Methods

compare :: Fill -> Fill -> Ordering

(<) :: Fill -> Fill -> Bool

(<=) :: Fill -> Fill -> Bool

(>) :: Fill -> Fill -> Bool

(>=) :: Fill -> Fill -> Bool

max :: Fill -> Fill -> Fill

min :: Fill -> Fill -> Fill

Show Fill

Methods

showsPrec :: Int -> Fill -> ShowS

show :: Fill -> String

showList :: [Fill] -> ShowS

Generic Fill

Associated Types

type Rep Fill :: * -> *

Methods

from :: Fill -> Rep Fill x

to :: Rep Fill x -> Fill

Default Fill

Methods

def :: Fill

NFData Fill

Methods

rnf :: Fill -> ()

FromCursor Fill

See CT_Fill, p. 4484

Methods

fromCursor :: Cursor -> [Fill]

ToElement Fill

See CT_Fill, p. 4484

Methods

toElement :: Name -> Fill -> Element

type Rep Fill

type Rep Fill = D1 * (MetaData "Fill" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Fill" PrefixI True) (S1 * (MetaSel (Just Symbol "_fillPattern") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe FillPattern))))

data FillPattern

This element is used to specify cell fill information for pattern and solid color cell fills. For solid cell fills (no pattern), fgColor is used. For cell fills with patterns specified, then the cell fill color is specified by the bgColor element.

Section 18.8.32 "patternFill (Pattern)" (p. 1793)

Constructors

FillPattern

Fields

• _fillPatternBgColor :: Maybe Color
• _fillPatternFgColor :: Maybe Color
• _fillPatternType :: Maybe PatternType

Instances

Eq FillPattern

Methods

(==) :: FillPattern -> FillPattern -> Bool

(/=) :: FillPattern -> FillPattern -> Bool

Ord FillPattern

Methods

compare :: FillPattern -> FillPattern -> Ordering

(<) :: FillPattern -> FillPattern -> Bool

(<=) :: FillPattern -> FillPattern -> Bool

(>) :: FillPattern -> FillPattern -> Bool

(>=) :: FillPattern -> FillPattern -> Bool

max :: FillPattern -> FillPattern -> FillPattern

min :: FillPattern -> FillPattern -> FillPattern

Show FillPattern

Methods

showsPrec :: Int -> FillPattern -> ShowS

show :: FillPattern -> String

showList :: [FillPattern] -> ShowS

Generic FillPattern

Associated Types

type Rep FillPattern :: * -> *

Methods

from :: FillPattern -> Rep FillPattern x

to :: Rep FillPattern x -> FillPattern

Default FillPattern

Methods

def :: FillPattern

NFData FillPattern

Methods

rnf :: FillPattern -> ()

FromCursor FillPattern

See CT_PatternFill, p. 4484

Methods

fromCursor :: Cursor -> [FillPattern]

ToElement FillPattern

See CT_PatternFill, p. 4484

Methods

toElement :: Name -> FillPattern -> Element

type Rep FillPattern

type Rep FillPattern = D1 * (MetaData "FillPattern" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "FillPattern" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_fillPatternBgColor") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Color))) ((:*:) * (S1 * (MetaSel (Just Symbol "_fillPatternFgColor") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Color))) (S1 * (MetaSel (Just Symbol "_fillPatternType") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe PatternType))))))

data Font

This element defines the properties for one of the fonts used in this workbook.

Section 18.2.22 "font (Font)" (p. 1769)

Constructors

Font

Fields

• _fontBold :: Maybe Bool

  Displays characters in bold face font style.

• _fontCharset :: Maybe Int

  This element defines the font character set of this font.

  This field is used in font creation and selection if a font of the given facename is not available on the system. Although it is not required to have around when resolving font facename, the information can be stored for when needed to help resolve which font face to use of all available fonts on a system.

  Charset represents the basic set of characters associated with a font (that it can display), and roughly corresponds to the ANSI codepage (8-bit or DBCS) of that character set used by a given language. Given more common use of Unicode where many fonts support more than one of the traditional charset categories, and the use of font linking, using charset to resolve font name is less and less common, but still can be useful.

  These are operating-system-dependent values.

  Section 18.4.1 "charset (Character Set)" provides some example values.

• _fontColor :: Maybe Color

  Color

• _fontCondense :: Maybe Bool

  Macintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to condense the text (squeeze it together). SpreadsheetML applications are not required to render according to this flag.

• _fontExtend :: Maybe Bool

  This element specifies a compatibility setting used for previous spreadsheet applications, resulting in special word/character rendering on those legacy applications, when this flag is set. The effect extends or stretches out the text. SpreadsheetML applications are not required to render according to this flag.

• _fontFamily :: Maybe FontFamily

  The font family this font belongs to. A font family is a set of fonts having common stroke width and serif characteristics. This is system level font information. The font name overrides when there are conflicting values.

• _fontItalic :: Maybe Bool

  Displays characters in italic font style. The italic style is defined by the font at a system level and is not specified by ECMA-376.

• _fontName :: Maybe Text

  This element specifies the face name of this font.

  A string representing the name of the font. If the font doesn't exist (because it isn't installed on the system), or the charset not supported by that font, then another font should be substituted.

  The string length for this attribute shall be 0 to 31 characters.

• _fontOutline :: Maybe Bool

  This element displays only the inner and outer borders of each character. This is very similar to Bold in behavior.

• _fontScheme :: Maybe FontScheme

  Defines the font scheme, if any, to which this font belongs. When a font definition is part of a theme definition, then the font is categorized as either a major or minor font scheme component. When a new theme is chosen, every font that is part of a theme definition is updated to use the new major or minor font definition for that theme. Usually major fonts are used for styles like headings, and minor fonts are used for body and paragraph text.

• _fontShadow :: Maybe Bool

  Macintosh compatibility setting. Represents special word/character rendering on Macintosh, when this flag is set. The effect is to render a shadow behind, beneath and to the right of the text. SpreadsheetML applications are not required to render according to this flag.

• _fontStrikeThrough :: Maybe Bool

  This element draws a strikethrough line through the horizontal middle of the text.

• _fontSize :: Maybe Double

  This element represents the point size (1/72 of an inch) of the Latin and East Asian text.

• _fontUnderline :: Maybe FontUnderline

  This element represents the underline formatting style.

• _fontVertAlign :: Maybe FontVerticalAlignment

  This element adjusts the vertical position of the text relative to the text's default appearance for this run. It is used to get superscript or subscript texts, and shall reduce the font size (if a smaller size is available) accordingly.

Instances

Eq Font

Methods

(==) :: Font -> Font -> Bool

(/=) :: Font -> Font -> Bool

Ord Font

Methods

compare :: Font -> Font -> Ordering

(<) :: Font -> Font -> Bool

(<=) :: Font -> Font -> Bool

(>) :: Font -> Font -> Bool

(>=) :: Font -> Font -> Bool

max :: Font -> Font -> Font

min :: Font -> Font -> Font

Show Font

Methods

showsPrec :: Int -> Font -> ShowS

show :: Font -> String

showList :: [Font] -> ShowS

Generic Font

Associated Types

type Rep Font :: * -> *

Methods

from :: Font -> Rep Font x

to :: Rep Font x -> Font

Default Font

Methods

def :: Font

NFData Font

Methods

rnf :: Font -> ()

FromCursor Font

See CT_Font, p. 4489

Methods

fromCursor :: Cursor -> [Font]

ToElement Font

See CT_Font, p. 4489

Methods

toElement :: Name -> Font -> Element

type Rep Font

type Rep Font = D1 * (MetaData "Font" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Font" PrefixI True) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_fontBold") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) ((:*:) * (S1 * (MetaSel (Just Symbol "_fontCharset") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Int))) (S1 * (MetaSel (Just Symbol "_fontColor") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Color))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_fontCondense") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_fontExtend") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_fontFamily") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe FontFamily))) (S1 * (MetaSel (Just Symbol "_fontItalic") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))))) ((:*:) * ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_fontName") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Text))) (S1 * (MetaSel (Just Symbol "_fontOutline") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_fontScheme") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe FontScheme))) (S1 * (MetaSel (Just Symbol "_fontShadow") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))))) ((:*:) * ((:*:) * (S1 * (MetaSel (Just Symbol "_fontStrikeThrough") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_fontSize") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Double)))) ((:*:) * (S1 * (MetaSel (Just Symbol "_fontUnderline") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe FontUnderline))) (S1 * (MetaSel (Just Symbol "_fontVertAlign") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe FontVerticalAlignment))))))))

data NumberFormat

This type gives a high-level version of representation of number format used in Format.

Constructors

StdNumberFormat ImpliedNumberFormat

UserNumberFormat FormatCode

Instances

Eq NumberFormat

Methods

(==) :: NumberFormat -> NumberFormat -> Bool

(/=) :: NumberFormat -> NumberFormat -> Bool

Ord NumberFormat

Methods

compare :: NumberFormat -> NumberFormat -> Ordering

(<) :: NumberFormat -> NumberFormat -> Bool

(<=) :: NumberFormat -> NumberFormat -> Bool

(>) :: NumberFormat -> NumberFormat -> Bool

(>=) :: NumberFormat -> NumberFormat -> Bool

max :: NumberFormat -> NumberFormat -> NumberFormat

min :: NumberFormat -> NumberFormat -> NumberFormat

Show NumberFormat

Methods

showsPrec :: Int -> NumberFormat -> ShowS

show :: NumberFormat -> String

showList :: [NumberFormat] -> ShowS

Generic NumberFormat

Associated Types

type Rep NumberFormat :: * -> *

Methods

from :: NumberFormat -> Rep NumberFormat x

to :: Rep NumberFormat x -> NumberFormat

NFData NumberFormat

Methods

rnf :: NumberFormat -> ()

type Rep NumberFormat

type Rep NumberFormat = D1 * (MetaData "NumberFormat" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * (C1 * (MetaCons "StdNumberFormat" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * ImpliedNumberFormat))) (C1 * (MetaCons "UserNumberFormat" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * FormatCode))))

data NumFmt

This element specifies number format properties which indicate how to format and render the numeric value of a cell.

Section 18.8.30 "numFmt (Number Format)" (p. 1777)

Constructors

NumFmt

Fields

• _numFmtId :: Int
• _numFmtCode :: FormatCode

Instances

Eq NumFmt

Methods

(==) :: NumFmt -> NumFmt -> Bool

(/=) :: NumFmt -> NumFmt -> Bool

Ord NumFmt

Methods

compare :: NumFmt -> NumFmt -> Ordering

(<) :: NumFmt -> NumFmt -> Bool

(<=) :: NumFmt -> NumFmt -> Bool

(>) :: NumFmt -> NumFmt -> Bool

(>=) :: NumFmt -> NumFmt -> Bool

max :: NumFmt -> NumFmt -> NumFmt

min :: NumFmt -> NumFmt -> NumFmt

Show NumFmt

Methods

showsPrec :: Int -> NumFmt -> ShowS

show :: NumFmt -> String

showList :: [NumFmt] -> ShowS

Generic NumFmt

Associated Types

type Rep NumFmt :: * -> *

Methods

from :: NumFmt -> Rep NumFmt x

to :: Rep NumFmt x -> NumFmt

NFData NumFmt

Methods

rnf :: NumFmt -> ()

FromCursor NumFmt

See CT_NumFmt, p. 3936

Methods

fromCursor :: Cursor -> [NumFmt]

ToElement NumFmt

See CT_NumFmt, p. 3936

Methods

toElement :: Name -> NumFmt -> Element

type Rep NumFmt

type Rep NumFmt = D1 * (MetaData "NumFmt" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "NumFmt" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_numFmtId") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int)) (S1 * (MetaSel (Just Symbol "_numFmtCode") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * FormatCode))))

data ImpliedNumberFormat

Implied number formats

Note: This only implements the predefined values for 18.2.30 "All Languages", other built-in format ids (with id < firstUserNumFmtId) are stored in NfOtherBuiltin

Constructors

NfGeneral

0 General

NfZero

1 0

Nf2Decimal

2 0.00

NfMax3Decimal

3 #,##0

NfThousandSeparator2Decimal

4 #,##0.00

NfPercent

9 0%

NfPercent2Decimal

10 0.00%

NfExponent2Decimal

11 0.00E+00

NfSingleSpacedFraction

12 # ?/?

NfDoubleSpacedFraction

13 # ??/??

NfMmDdYy

14 mm-dd-yy

NfDMmmYy

15 d-mmm-yy

NfDMmm

16 d-mmm

NfMmmYy

17 mmm-yy

NfHMm12Hr

18 h:mm AM/PM

NfHMmSs12Hr

19 h:mm:ss AM/PM

NfHMm

20 h:mm

NfHMmSs

21 h:mm:ss

NfMdyHMm

22 m/d/yy h:mm

NfThousandsNegativeParens

37 #,##0 ;(#,##0)

NfThousandsNegativeRed

38 #,##0 ;[Red](#,##0)

NfThousands2DecimalNegativeParens

39 #,##0.00;(#,##0.00)

NfThousands2DecimalNegativeRed

40 #,##0.00;[Red](#,##0.00)

NfMmSs

45 mm:ss

NfOptHMmSs

46 [h]:mm:ss

NfMmSs1Decimal

47 mmss.0

NfExponent1Decimal

48 ##0.0E+0

NfTextPlaceHolder

49 @

NfOtherImplied Int

other (non local-neutral?) built-in format (id < 164)

Instances

Eq ImpliedNumberFormat

Methods

(==) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

(/=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

Ord ImpliedNumberFormat

Methods

compare :: ImpliedNumberFormat -> ImpliedNumberFormat -> Ordering

(<) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

(<=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

(>) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

(>=) :: ImpliedNumberFormat -> ImpliedNumberFormat -> Bool

max :: ImpliedNumberFormat -> ImpliedNumberFormat -> ImpliedNumberFormat

min :: ImpliedNumberFormat -> ImpliedNumberFormat -> ImpliedNumberFormat

Show ImpliedNumberFormat

Methods

showsPrec :: Int -> ImpliedNumberFormat -> ShowS

show :: ImpliedNumberFormat -> String

showList :: [ImpliedNumberFormat] -> ShowS

Generic ImpliedNumberFormat

Associated Types

type Rep ImpliedNumberFormat :: * -> *

Methods

from :: ImpliedNumberFormat -> Rep ImpliedNumberFormat x

to :: Rep ImpliedNumberFormat x -> ImpliedNumberFormat

NFData ImpliedNumberFormat

Methods

rnf :: ImpliedNumberFormat -> ()

type Rep ImpliedNumberFormat

type Rep ImpliedNumberFormat = D1 * (MetaData "ImpliedNumberFormat" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "NfGeneral" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "NfZero" PrefixI False) (U1 *)) (C1 * (MetaCons "Nf2Decimal" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "NfMax3Decimal" PrefixI False) (U1 *)) (C1 * (MetaCons "NfThousandSeparator2Decimal" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "NfPercent" PrefixI False) (U1 *)) (C1 * (MetaCons "NfPercent2Decimal" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * (C1 * (MetaCons "NfExponent2Decimal" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "NfSingleSpacedFraction" PrefixI False) (U1 *)) (C1 * (MetaCons "NfDoubleSpacedFraction" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "NfMmDdYy" PrefixI False) (U1 *)) (C1 * (MetaCons "NfDMmmYy" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "NfDMmm" PrefixI False) (U1 *)) (C1 * (MetaCons "NfMmmYy" PrefixI False) (U1 *)))))) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "NfHMm12Hr" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "NfHMmSs12Hr" PrefixI False) (U1 *)) (C1 * (MetaCons "NfHMm" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "NfHMmSs" PrefixI False) (U1 *)) (C1 * (MetaCons "NfMdyHMm" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "NfThousandsNegativeParens" PrefixI False) (U1 *)) (C1 * (MetaCons "NfThousandsNegativeRed" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "NfThousands2DecimalNegativeParens" PrefixI False) (U1 *)) (C1 * (MetaCons "NfThousands2DecimalNegativeRed" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "NfMmSs" PrefixI False) (U1 *)) (C1 * (MetaCons "NfOptHMmSs" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "NfMmSs1Decimal" PrefixI False) (U1 *)) (C1 * (MetaCons "NfExponent1Decimal" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "NfTextPlaceHolder" PrefixI False) (U1 *)) (C1 * (MetaCons "NfOtherImplied" PrefixI False) (S1 * (MetaSel (Nothing Symbol) NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * Int))))))))

type FormatCode = Text

A number format code.

Section 18.8.30, "numFmt (Number Format)" (p. 1777)

data Protection

Protection properties

Contains protection properties associated with the cell. Each cell has protection properties that can be set. The cell protection properties do not take effect unless the sheet has been protected.

Section 18.8.33, "protection (Protection Properties)", p. 1793

Constructors

Protection

Fields

• _protectionHidden :: Maybe Bool
• _protectionLocked :: Maybe Bool

Instances

Eq Protection

Methods

(==) :: Protection -> Protection -> Bool

(/=) :: Protection -> Protection -> Bool

Ord Protection

Methods

compare :: Protection -> Protection -> Ordering

(<) :: Protection -> Protection -> Bool

(<=) :: Protection -> Protection -> Bool

(>) :: Protection -> Protection -> Bool

(>=) :: Protection -> Protection -> Bool

max :: Protection -> Protection -> Protection

min :: Protection -> Protection -> Protection

Show Protection

Methods

showsPrec :: Int -> Protection -> ShowS

show :: Protection -> String

showList :: [Protection] -> ShowS

Generic Protection

Associated Types

type Rep Protection :: * -> *

Methods

from :: Protection -> Rep Protection x

to :: Rep Protection x -> Protection

Default Protection

Methods

def :: Protection

NFData Protection

Methods

rnf :: Protection -> ()

FromCursor Protection

See CT_CellProtection, p. 4484

Methods

fromCursor :: Cursor -> [Protection]

ToElement Protection

See CT_CellProtection, p. 4484

Methods

toElement :: Name -> Protection -> Element

type Rep Protection

type Rep Protection = D1 * (MetaData "Protection" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) (C1 * (MetaCons "Protection" PrefixI True) ((:*:) * (S1 * (MetaSel (Just Symbol "_protectionHidden") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool))) (S1 * (MetaSel (Just Symbol "_protectionLocked") NoSourceUnpackedness NoSourceStrictness DecidedLazy) (Rec0 * (Maybe Bool)))))

Supporting enumerations

data CellHorizontalAlignment

Horizontal alignment in cells

See 18.18.40 "ST_HorizontalAlignment (Horizontal Alignment Type)" (p. 2459)

Constructors

CellHorizontalAlignmentCenter

CellHorizontalAlignmentCenterContinuous

CellHorizontalAlignmentDistributed

CellHorizontalAlignmentFill

CellHorizontalAlignmentGeneral

CellHorizontalAlignmentJustify

CellHorizontalAlignmentLeft

CellHorizontalAlignmentRight

Instances

Eq CellHorizontalAlignment

Methods

(==) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

(/=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

Ord CellHorizontalAlignment

Methods

compare :: CellHorizontalAlignment -> CellHorizontalAlignment -> Ordering

(<) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

(<=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

(>) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

(>=) :: CellHorizontalAlignment -> CellHorizontalAlignment -> Bool

max :: CellHorizontalAlignment -> CellHorizontalAlignment -> CellHorizontalAlignment

min :: CellHorizontalAlignment -> CellHorizontalAlignment -> CellHorizontalAlignment

Show CellHorizontalAlignment

Methods

showsPrec :: Int -> CellHorizontalAlignment -> ShowS

show :: CellHorizontalAlignment -> String

showList :: [CellHorizontalAlignment] -> ShowS

Generic CellHorizontalAlignment

Associated Types

type Rep CellHorizontalAlignment :: * -> *

Methods

from :: CellHorizontalAlignment -> Rep CellHorizontalAlignment x

to :: Rep CellHorizontalAlignment x -> CellHorizontalAlignment

NFData CellHorizontalAlignment

Methods

rnf :: CellHorizontalAlignment -> ()

FromAttrVal CellHorizontalAlignment

Methods

fromAttrVal :: Reader CellHorizontalAlignment

ToAttrVal CellHorizontalAlignment

Methods

toAttrVal :: CellHorizontalAlignment -> Text

type Rep CellHorizontalAlignment

type Rep CellHorizontalAlignment = D1 * (MetaData "CellHorizontalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "CellHorizontalAlignmentCenter" PrefixI False) (U1 *)) (C1 * (MetaCons "CellHorizontalAlignmentCenterContinuous" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "CellHorizontalAlignmentDistributed" PrefixI False) (U1 *)) (C1 * (MetaCons "CellHorizontalAlignmentFill" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "CellHorizontalAlignmentGeneral" PrefixI False) (U1 *)) (C1 * (MetaCons "CellHorizontalAlignmentJustify" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "CellHorizontalAlignmentLeft" PrefixI False) (U1 *)) (C1 * (MetaCons "CellHorizontalAlignmentRight" PrefixI False) (U1 *)))))

data CellVerticalAlignment

Vertical alignment in cells

See 18.18.88 "ST_VerticalAlignment (Vertical Alignment Types)" (p. 2512)

Constructors

CellVerticalAlignmentBottom

CellVerticalAlignmentCenter

CellVerticalAlignmentDistributed

CellVerticalAlignmentJustify

CellVerticalAlignmentTop

Instances

Eq CellVerticalAlignment

Methods

(==) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

(/=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

Ord CellVerticalAlignment

Methods

compare :: CellVerticalAlignment -> CellVerticalAlignment -> Ordering

(<) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

(<=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

(>) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

(>=) :: CellVerticalAlignment -> CellVerticalAlignment -> Bool

max :: CellVerticalAlignment -> CellVerticalAlignment -> CellVerticalAlignment

min :: CellVerticalAlignment -> CellVerticalAlignment -> CellVerticalAlignment

Show CellVerticalAlignment

Methods

showsPrec :: Int -> CellVerticalAlignment -> ShowS

show :: CellVerticalAlignment -> String

showList :: [CellVerticalAlignment] -> ShowS

Generic CellVerticalAlignment

Associated Types

type Rep CellVerticalAlignment :: * -> *

Methods

from :: CellVerticalAlignment -> Rep CellVerticalAlignment x

to :: Rep CellVerticalAlignment x -> CellVerticalAlignment

NFData CellVerticalAlignment

Methods

rnf :: CellVerticalAlignment -> ()

FromAttrVal CellVerticalAlignment

Methods

fromAttrVal :: Reader CellVerticalAlignment

ToAttrVal CellVerticalAlignment

Methods

toAttrVal :: CellVerticalAlignment -> Text

type Rep CellVerticalAlignment

type Rep CellVerticalAlignment = D1 * (MetaData "CellVerticalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * (C1 * (MetaCons "CellVerticalAlignmentBottom" PrefixI False) (U1 *)) (C1 * (MetaCons "CellVerticalAlignmentCenter" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "CellVerticalAlignmentDistributed" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "CellVerticalAlignmentJustify" PrefixI False) (U1 *)) (C1 * (MetaCons "CellVerticalAlignmentTop" PrefixI False) (U1 *)))))

data FontFamily

Font family

See 18.8.18 "family (Font Family)" (p. 1766) and 17.18.30 "ST_FontFamily (Font Family Value)" (p. 1388)

Constructors

FontFamilyNotApplicable

Family is not applicable

FontFamilyRoman

Proportional font with serifs

FontFamilySwiss

Proportional font without serifs

FontFamilyModern

Monospace font with or without serifs

FontFamilyScript

Script font designed to mimic the appearance of handwriting

FontFamilyDecorative

Novelty font

Instances

Eq FontFamily

Methods

(==) :: FontFamily -> FontFamily -> Bool

(/=) :: FontFamily -> FontFamily -> Bool

Ord FontFamily

Methods

compare :: FontFamily -> FontFamily -> Ordering

(<) :: FontFamily -> FontFamily -> Bool

(<=) :: FontFamily -> FontFamily -> Bool

(>) :: FontFamily -> FontFamily -> Bool

(>=) :: FontFamily -> FontFamily -> Bool

max :: FontFamily -> FontFamily -> FontFamily

min :: FontFamily -> FontFamily -> FontFamily

Show FontFamily

Methods

showsPrec :: Int -> FontFamily -> ShowS

show :: FontFamily -> String

showList :: [FontFamily] -> ShowS

Generic FontFamily

Associated Types

type Rep FontFamily :: * -> *

Methods

from :: FontFamily -> Rep FontFamily x

to :: Rep FontFamily x -> FontFamily

NFData FontFamily

Methods

rnf :: FontFamily -> ()

FromAttrBs FontFamily

Methods

fromAttrBs :: ByteString -> Either Text FontFamily

FromAttrVal FontFamily

See 18.18.94 "ST_FontFamily (Font Family)" (p. 2517)

Methods

fromAttrVal :: Reader FontFamily

ToAttrVal FontFamily

Methods

toAttrVal :: FontFamily -> Text

type Rep FontFamily

type Rep FontFamily = D1 * (MetaData "FontFamily" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * (C1 * (MetaCons "FontFamilyNotApplicable" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "FontFamilyRoman" PrefixI False) (U1 *)) (C1 * (MetaCons "FontFamilySwiss" PrefixI False) (U1 *)))) ((:+:) * (C1 * (MetaCons "FontFamilyModern" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "FontFamilyScript" PrefixI False) (U1 *)) (C1 * (MetaCons "FontFamilyDecorative" PrefixI False) (U1 *)))))

data FontScheme

Font scheme

See 18.18.33 "ST_FontScheme (Font scheme Styles)" (p. 2456)

Constructors

FontSchemeMajor

This font is the major font for this theme.

FontSchemeMinor

This font is the minor font for this theme.

FontSchemeNone

This font is not a theme font.

Instances

Eq FontScheme

Methods

(==) :: FontScheme -> FontScheme -> Bool

(/=) :: FontScheme -> FontScheme -> Bool

Ord FontScheme

Methods

compare :: FontScheme -> FontScheme -> Ordering

(<) :: FontScheme -> FontScheme -> Bool

(<=) :: FontScheme -> FontScheme -> Bool

(>) :: FontScheme -> FontScheme -> Bool

(>=) :: FontScheme -> FontScheme -> Bool

max :: FontScheme -> FontScheme -> FontScheme

min :: FontScheme -> FontScheme -> FontScheme

Show FontScheme

Methods

showsPrec :: Int -> FontScheme -> ShowS

show :: FontScheme -> String

showList :: [FontScheme] -> ShowS

Generic FontScheme

Associated Types

type Rep FontScheme :: * -> *

Methods

from :: FontScheme -> Rep FontScheme x

to :: Rep FontScheme x -> FontScheme

NFData FontScheme

Methods

rnf :: FontScheme -> ()

FromAttrBs FontScheme

Methods

fromAttrBs :: ByteString -> Either Text FontScheme

FromAttrVal FontScheme

Methods

fromAttrVal :: Reader FontScheme

ToAttrVal FontScheme

Methods

toAttrVal :: FontScheme -> Text

type Rep FontScheme

type Rep FontScheme = D1 * (MetaData "FontScheme" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * (C1 * (MetaCons "FontSchemeMajor" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "FontSchemeMinor" PrefixI False) (U1 *)) (C1 * (MetaCons "FontSchemeNone" PrefixI False) (U1 *))))

data FontUnderline

Font underline property

See 18.4.13 "u (Underline)", p 1728

Constructors

FontUnderlineSingle

FontUnderlineDouble

FontUnderlineSingleAccounting

FontUnderlineDoubleAccounting

FontUnderlineNone

Instances

Eq FontUnderline

Methods

(==) :: FontUnderline -> FontUnderline -> Bool

(/=) :: FontUnderline -> FontUnderline -> Bool

Ord FontUnderline

Methods

compare :: FontUnderline -> FontUnderline -> Ordering

(<) :: FontUnderline -> FontUnderline -> Bool

(<=) :: FontUnderline -> FontUnderline -> Bool

(>) :: FontUnderline -> FontUnderline -> Bool

(>=) :: FontUnderline -> FontUnderline -> Bool

max :: FontUnderline -> FontUnderline -> FontUnderline

min :: FontUnderline -> FontUnderline -> FontUnderline

Show FontUnderline

Methods

showsPrec :: Int -> FontUnderline -> ShowS

show :: FontUnderline -> String

showList :: [FontUnderline] -> ShowS

Generic FontUnderline

Associated Types

type Rep FontUnderline :: * -> *

Methods

from :: FontUnderline -> Rep FontUnderline x

to :: Rep FontUnderline x -> FontUnderline

NFData FontUnderline

Methods

rnf :: FontUnderline -> ()

FromAttrBs FontUnderline

Methods

fromAttrBs :: ByteString -> Either Text FontUnderline

FromAttrVal FontUnderline

Methods

fromAttrVal :: Reader FontUnderline

ToAttrVal FontUnderline

Methods

toAttrVal :: FontUnderline -> Text

type Rep FontUnderline

type Rep FontUnderline = D1 * (MetaData "FontUnderline" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * (C1 * (MetaCons "FontUnderlineSingle" PrefixI False) (U1 *)) (C1 * (MetaCons "FontUnderlineDouble" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "FontUnderlineSingleAccounting" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "FontUnderlineDoubleAccounting" PrefixI False) (U1 *)) (C1 * (MetaCons "FontUnderlineNone" PrefixI False) (U1 *)))))

data FontVerticalAlignment

Vertical alignment

See 22.9.2.17 "ST_VerticalAlignRun (Vertical Positioning Location)" (p. 3794)

Constructors

FontVerticalAlignmentBaseline

FontVerticalAlignmentSubscript

FontVerticalAlignmentSuperscript

Instances

Eq FontVerticalAlignment

Methods

(==) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

(/=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

Ord FontVerticalAlignment

Methods

compare :: FontVerticalAlignment -> FontVerticalAlignment -> Ordering

(<) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

(<=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

(>) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

(>=) :: FontVerticalAlignment -> FontVerticalAlignment -> Bool

max :: FontVerticalAlignment -> FontVerticalAlignment -> FontVerticalAlignment

min :: FontVerticalAlignment -> FontVerticalAlignment -> FontVerticalAlignment

Show FontVerticalAlignment

Methods

showsPrec :: Int -> FontVerticalAlignment -> ShowS

show :: FontVerticalAlignment -> String

showList :: [FontVerticalAlignment] -> ShowS

Generic FontVerticalAlignment

Associated Types

type Rep FontVerticalAlignment :: * -> *

Methods

from :: FontVerticalAlignment -> Rep FontVerticalAlignment x

to :: Rep FontVerticalAlignment x -> FontVerticalAlignment

NFData FontVerticalAlignment

Methods

rnf :: FontVerticalAlignment -> ()

FromAttrBs FontVerticalAlignment

Methods

fromAttrBs :: ByteString -> Either Text FontVerticalAlignment

FromAttrVal FontVerticalAlignment

Methods

fromAttrVal :: Reader FontVerticalAlignment

ToAttrVal FontVerticalAlignment

Methods

toAttrVal :: FontVerticalAlignment -> Text

type Rep FontVerticalAlignment

type Rep FontVerticalAlignment = D1 * (MetaData "FontVerticalAlignment" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * (C1 * (MetaCons "FontVerticalAlignmentBaseline" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "FontVerticalAlignmentSubscript" PrefixI False) (U1 *)) (C1 * (MetaCons "FontVerticalAlignmentSuperscript" PrefixI False) (U1 *))))

data LineStyle

Constructors

LineStyleDashDot

LineStyleDashDotDot

LineStyleDashed

LineStyleDotted

LineStyleDouble

LineStyleHair

LineStyleMedium

LineStyleMediumDashDot

LineStyleMediumDashDotDot

LineStyleMediumDashed

LineStyleNone

LineStyleSlantDashDot

LineStyleThick

LineStyleThin

Instances

Eq LineStyle

Methods

(==) :: LineStyle -> LineStyle -> Bool

(/=) :: LineStyle -> LineStyle -> Bool

Ord LineStyle

Methods

compare :: LineStyle -> LineStyle -> Ordering

(<) :: LineStyle -> LineStyle -> Bool

(<=) :: LineStyle -> LineStyle -> Bool

(>) :: LineStyle -> LineStyle -> Bool

(>=) :: LineStyle -> LineStyle -> Bool

max :: LineStyle -> LineStyle -> LineStyle

min :: LineStyle -> LineStyle -> LineStyle

Show LineStyle

Methods

showsPrec :: Int -> LineStyle -> ShowS

show :: LineStyle -> String

showList :: [LineStyle] -> ShowS

Generic LineStyle

Associated Types

type Rep LineStyle :: * -> *

Methods

from :: LineStyle -> Rep LineStyle x

to :: Rep LineStyle x -> LineStyle

NFData LineStyle

Methods

rnf :: LineStyle -> ()

FromAttrVal LineStyle

Methods

fromAttrVal :: Reader LineStyle

ToAttrVal LineStyle

Methods

toAttrVal :: LineStyle -> Text

type Rep LineStyle

type Rep LineStyle = D1 * (MetaData "LineStyle" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "LineStyleDashDot" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "LineStyleDashDotDot" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleDashed" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "LineStyleDotted" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleDouble" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "LineStyleHair" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleMedium" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * (C1 * (MetaCons "LineStyleMediumDashDot" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "LineStyleMediumDashDotDot" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleMediumDashed" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "LineStyleNone" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleSlantDashDot" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "LineStyleThick" PrefixI False) (U1 *)) (C1 * (MetaCons "LineStyleThin" PrefixI False) (U1 *))))))

data PatternType

Indicates the style of fill pattern being used for a cell format.

Section 18.18.55 "ST_PatternType (Pattern Type)" (p. 2472)

Constructors

PatternTypeDarkDown

PatternTypeDarkGray

PatternTypeDarkGrid

PatternTypeDarkHorizontal

PatternTypeDarkTrellis

PatternTypeDarkUp

PatternTypeDarkVertical

PatternTypeGray0625

PatternTypeGray125

PatternTypeLightDown

PatternTypeLightGray

PatternTypeLightGrid

PatternTypeLightHorizontal

PatternTypeLightTrellis

PatternTypeLightUp

PatternTypeLightVertical

PatternTypeMediumGray

PatternTypeNone

PatternTypeSolid

Instances

Eq PatternType

Methods

(==) :: PatternType -> PatternType -> Bool

(/=) :: PatternType -> PatternType -> Bool

Ord PatternType

Methods

compare :: PatternType -> PatternType -> Ordering

(<) :: PatternType -> PatternType -> Bool

(<=) :: PatternType -> PatternType -> Bool

(>) :: PatternType -> PatternType -> Bool

(>=) :: PatternType -> PatternType -> Bool

max :: PatternType -> PatternType -> PatternType

min :: PatternType -> PatternType -> PatternType

Show PatternType

Methods

showsPrec :: Int -> PatternType -> ShowS

show :: PatternType -> String

showList :: [PatternType] -> ShowS

Generic PatternType

Associated Types

type Rep PatternType :: * -> *

Methods

from :: PatternType -> Rep PatternType x

to :: Rep PatternType x -> PatternType

NFData PatternType

Methods

rnf :: PatternType -> ()

FromAttrVal PatternType

Methods

fromAttrVal :: Reader PatternType

ToAttrVal PatternType

Methods

toAttrVal :: PatternType -> Text

type Rep PatternType

type Rep PatternType = D1 * (MetaData "PatternType" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "PatternTypeDarkDown" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeDarkGray" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PatternTypeDarkGrid" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeDarkHorizontal" PrefixI False) (U1 *)))) ((:+:) * ((:+:) * (C1 * (MetaCons "PatternTypeDarkTrellis" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeDarkUp" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PatternTypeDarkVertical" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "PatternTypeGray0625" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeGray125" PrefixI False) (U1 *)))))) ((:+:) * ((:+:) * ((:+:) * (C1 * (MetaCons "PatternTypeLightDown" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeLightGray" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PatternTypeLightGrid" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "PatternTypeLightHorizontal" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeLightTrellis" PrefixI False) (U1 *))))) ((:+:) * ((:+:) * (C1 * (MetaCons "PatternTypeLightUp" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeLightVertical" PrefixI False) (U1 *))) ((:+:) * (C1 * (MetaCons "PatternTypeMediumGray" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "PatternTypeNone" PrefixI False) (U1 *)) (C1 * (MetaCons "PatternTypeSolid" PrefixI False) (U1 *)))))))

data ReadingOrder

Reading order

See 18.8.1 "alignment (Alignment)" (p. 1754, esp. p. 1755)

Constructors

ReadingOrderContextDependent

ReadingOrderLeftToRight

ReadingOrderRightToLeft

Instances

Eq ReadingOrder

Methods

(==) :: ReadingOrder -> ReadingOrder -> Bool

(/=) :: ReadingOrder -> ReadingOrder -> Bool

Ord ReadingOrder

Methods

compare :: ReadingOrder -> ReadingOrder -> Ordering

(<) :: ReadingOrder -> ReadingOrder -> Bool

(<=) :: ReadingOrder -> ReadingOrder -> Bool

(>) :: ReadingOrder -> ReadingOrder -> Bool

(>=) :: ReadingOrder -> ReadingOrder -> Bool

max :: ReadingOrder -> ReadingOrder -> ReadingOrder

min :: ReadingOrder -> ReadingOrder -> ReadingOrder

Show ReadingOrder

Methods

showsPrec :: Int -> ReadingOrder -> ShowS

show :: ReadingOrder -> String

showList :: [ReadingOrder] -> ShowS

Generic ReadingOrder

Associated Types

type Rep ReadingOrder :: * -> *

Methods

from :: ReadingOrder -> Rep ReadingOrder x

to :: Rep ReadingOrder x -> ReadingOrder

NFData ReadingOrder

Methods

rnf :: ReadingOrder -> ()

FromAttrVal ReadingOrder

Methods

fromAttrVal :: Reader ReadingOrder

ToAttrVal ReadingOrder

Methods

toAttrVal :: ReadingOrder -> Text

type Rep ReadingOrder

type Rep ReadingOrder = D1 * (MetaData "ReadingOrder" "Codec.Xlsx.Types.StyleSheet" "xlsx-0.7.2-Bllq6ZS7v593hEJpIAxkWW" False) ((:+:) * (C1 * (MetaCons "ReadingOrderContextDependent" PrefixI False) (U1 *)) ((:+:) * (C1 * (MetaCons "ReadingOrderLeftToRight" PrefixI False) (U1 *)) (C1 * (MetaCons "ReadingOrderRightToLeft" PrefixI False) (U1 *))))

Lenses

StyleSheet

styleSheetBorders :: Lens' StyleSheet [Border]

styleSheetFonts :: Lens' StyleSheet [Font]

styleSheetFills :: Lens' StyleSheet [Fill]

styleSheetCellXfs :: Lens' StyleSheet [CellXf]

styleSheetDxfs :: Lens' StyleSheet [Dxf]

styleSheetNumFmts :: Lens' StyleSheet (Map Int FormatCode)

CellXf

cellXfApplyAlignment :: Lens' CellXf (Maybe Bool)

cellXfApplyBorder :: Lens' CellXf (Maybe Bool)

cellXfApplyFill :: Lens' CellXf (Maybe Bool)

cellXfApplyFont :: Lens' CellXf (Maybe Bool)

cellXfApplyNumberFormat :: Lens' CellXf (Maybe Bool)

cellXfApplyProtection :: Lens' CellXf (Maybe Bool)

cellXfBorderId :: Lens' CellXf (Maybe Int)

cellXfFillId :: Lens' CellXf (Maybe Int)

cellXfFontId :: Lens' CellXf (Maybe Int)

cellXfNumFmtId :: Lens' CellXf (Maybe Int)

cellXfPivotButton :: Lens' CellXf (Maybe Bool)

cellXfQuotePrefix :: Lens' CellXf (Maybe Bool)

cellXfId :: Lens' CellXf (Maybe Int)

cellXfAlignment :: Lens' CellXf (Maybe Alignment)

cellXfProtection :: Lens' CellXf (Maybe Protection)

Dxf

dxfAlignment :: Lens' Dxf (Maybe Alignment)

dxfBorder :: Lens' Dxf (Maybe Border)

dxfFill :: Lens' Dxf (Maybe Fill)

dxfFont :: Lens' Dxf (Maybe Font)

dxfNumFmt :: Lens' Dxf (Maybe NumFmt)

dxfProtection :: Lens' Dxf (Maybe Protection)

Alignment

alignmentHorizontal :: Lens' Alignment (Maybe CellHorizontalAlignment)

alignmentIndent :: Lens' Alignment (Maybe Int)

alignmentJustifyLastLine :: Lens' Alignment (Maybe Bool)

alignmentReadingOrder :: Lens' Alignment (Maybe ReadingOrder)

alignmentRelativeIndent :: Lens' Alignment (Maybe Int)

alignmentShrinkToFit :: Lens' Alignment (Maybe Bool)

alignmentTextRotation :: Lens' Alignment (Maybe Int)

alignmentVertical :: Lens' Alignment (Maybe CellVerticalAlignment)

alignmentWrapText :: Lens' Alignment (Maybe Bool)

Border

borderDiagonalDown :: Lens' Border (Maybe Bool)

borderDiagonalUp :: Lens' Border (Maybe Bool)

borderOutline :: Lens' Border (Maybe Bool)

borderBottom :: Lens' Border (Maybe BorderStyle)

borderDiagonal :: Lens' Border (Maybe BorderStyle)

borderEnd :: Lens' Border (Maybe BorderStyle)

borderHorizontal :: Lens' Border (Maybe BorderStyle)

borderStart :: Lens' Border (Maybe BorderStyle)

borderTop :: Lens' Border (Maybe BorderStyle)

borderVertical :: Lens' Border (Maybe BorderStyle)

borderLeft :: Lens' Border (Maybe BorderStyle)

borderRight :: Lens' Border (Maybe BorderStyle)

BorderStyle

borderStyleColor :: Lens' BorderStyle (Maybe Color)

borderStyleLine :: Lens' BorderStyle (Maybe LineStyle)

Color

colorAutomatic :: Lens' Color (Maybe Bool)

colorARGB :: Lens' Color (Maybe Text)

colorTheme :: Lens' Color (Maybe Int)

colorTint :: Lens' Color (Maybe Double)

Fill

fillPattern :: Iso' Fill (Maybe FillPattern)

FillPattern

fillPatternBgColor :: Lens' FillPattern (Maybe Color)

fillPatternFgColor :: Lens' FillPattern (Maybe Color)

fillPatternType :: Lens' FillPattern (Maybe PatternType)

Font

fontBold :: Lens' Font (Maybe Bool)

fontCharset :: Lens' Font (Maybe Int)

fontColor :: Lens' Font (Maybe Color)

fontCondense :: Lens' Font (Maybe Bool)

fontExtend :: Lens' Font (Maybe Bool)

fontFamily :: Lens' Font (Maybe FontFamily)

fontItalic :: Lens' Font (Maybe Bool)

fontName :: Lens' Font (Maybe Text)

fontOutline :: Lens' Font (Maybe Bool)

fontScheme :: Lens' Font (Maybe FontScheme)

fontShadow :: Lens' Font (Maybe Bool)

fontStrikeThrough :: Lens' Font (Maybe Bool)

fontSize :: Lens' Font (Maybe Double)

fontUnderline :: Lens' Font (Maybe FontUnderline)

fontVertAlign :: Lens' Font (Maybe FontVerticalAlignment)

Protection

protectionHidden :: Lens' Protection (Maybe Bool)

protectionLocked :: Lens' Protection (Maybe Bool)

Helpers

Number formats

fmtDecimals :: Int -> NumberFormat

Basic number format with predefined number of decimals as format code of number format in xlsx should be less than 255 characters number of decimals shouldn't be more than 253

fmtDecimalsZeroes :: Int -> NumberFormat

Basic number format with predefined number of decimals. Works like fmtDecimals with the only difference that extra zeroes are displayed when number of digits after the point is less than the number of digits specified in the format

stdNumberFormatId :: ImpliedNumberFormat -> Int

idToStdNumberFormat :: Int -> Maybe ImpliedNumberFormat

firstUserNumFmtId :: Int