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)

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.

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.

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

Fields

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

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.

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
   

Fields

• _fillPattern :: Maybe FillPattern
   

Fields

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

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.

Fields

• _numFmtId :: Int
   
• _numFmtCode :: FormatCode
   

Fields

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