DocumentID: ECMA-376/Part1/12.3.20
Title: ECMA-376, Part1: 12.3.20 Styles Part
Extracted-From: ECMA-376 Office Open XML File Formats, 1st Edition / December 2006
Warning: Coverted to HTML format by a script known to have bugs

• Next: 12.3.21 Table Definition Part
• Up: 12.3 Part Summary
• Table of contents: Table of contents
• Previous: 12.3.19 Single Cell Table Definitions Part

12.3.20 Styles Part

An instance of this part type contains all the characteristics for all the cells in the workbook. Such information includes numeric and text formatting, alignment, font, color, and border.

A package shall contain no more than one Styles part, and that part shall be the target of an implicit relationship from the Workbook (§12.3.23) part.

[Example: The following Workbook part-relationship item contains a relationship to the Styles part, which is stored in the ZIP item styles.xml:

<Relationships xmlns="...">
  <Relationship Id="rId5" 
    Type="http://.../styles" Target="styles.xml"/>
</Relationships>

end example]

The root element for a part of this content type shall be styleSheet.

[Example:

<styleSheet xmlns="...">
  <numFmts count="5">
    <numFmt numFmtId="164" formatCode="&quot;$&quot;#,##0.00"/>
    <numFmt numFmtId="165" 
      formatCode="&quot;Yes&quot;;&quot;Yes&quot;;&quot;No&quot;"/>
    <numFmt numFmtId="166" 
      formatCode="&quot;True&quot;;&quot;True&quot;;&quot;False&quot;"/>
    <numFmt numFmtId="167" 
      formatCode="&quot;On&quot;;&quot;On&quot;;&quot;Off&quot;"/>
    <numFmt numFmtId="168" 
      formatCode="[$€-2]\ #,##0.00_);[Red]\([$€-2]\ #,##0.00\)"/>
  </numFmts>

  <fonts count="5">
    ...
  </fonts>

  <fills count="4">
    ...
  </fills>

  <borders count="1">
    ...
  </borders>

  ...

  <colors>
    ...
  </colors>
</styleSheet>

end example]

A Styles part shall be located within the package containing the source relationship (expressed syntactically, the TargetMode attribute of the Relationship element shall be Internal).

A Styles part shall not have implicit or explicit relationships to any other part defined by this Standard.