[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
This element expresses the name and related formatting records for a named cell style in this workbook.
The built-in cell styles are written here by name, but the corresponding formatting records are assumed rather than explicitly written. Following is a listing of each of the built-in cell style definitions, whose normative definition is in Annex D. Also following is a table mapping the builtinId value to the cell style name.
For all built-in cell styles, the builtinId determines the style, not the name. For all cell styles, Normal is applied by default.
builtinId |
Cell Style Name |
[Example: (informative) |
0 |
Normal |
|
1 |
RowLevel_ + level # |
Depends on level: 1 = 2 = 3 = 4 = 5 = 6 = 7 = |
2 |
ColLevel_ + level # |
Depends on level: 1 = 2 = 3 = 4 = 5 = 6 = 7 = |
3 |
Comma |
|
4 |
Currency |
|
5 |
Percent |
|
6 |
Comma [0] |
|
7 |
Currency [0] |
|
8 |
Hyperlink |
|
9 |
Followed Hyperlink |
|
10 |
Note |
|
11 |
Warning Text |
|
15 |
Title |
|
16 |
Heading 1 |
|
17 |
Heading 2 |
|
18 |
Heading 3 |
|
19 |
Heading 4 |
|
20 |
Input |
|
21 |
Output |
|
22 |
Calculation |
|
23 |
Check Cell |
|
24 |
Linked Cell |
|
25 |
Total |
|
26 |
Good |
|
27 |
Bad |
|
28 |
Neutral |
|
29 |
Accent1 |
|
30 |
20% - Accent1 |
|
31 |
40% - Accent1 |
|
32 |
60% - Accent1 |
|
33 |
Accent2 |
|
34 |
20% - Accent2 |
|
35 |
40% - Accent2 |
|
36 |
60% - Accent2 |
|
37 |
Accent3 |
|
38 |
20% - Accent3 |
|
39 |
40% - Accent3 |
|
40 |
60% - Accent3 |
|
41 |
Accent4 |
|
42 |
20% - Accent4 |
|
43 |
40% - Accent4 |
|
44 |
60% - Accent4 |
|
45 |
Accent5 |
|
46 |
20% - Accent5 |
|
47 |
40% - Accent5 |
|
48 |
60% - Accent5 |
|
49 |
Accent6 |
|
50 |
20% - Accent6 |
|
51 |
40% - Accent6 |
|
52 |
60% - Accent6 |
|
53 |
Explanatory Text |
|
Parent Elements |
cellStyles (§3.8.8) |
Child Elements |
Subclause |
extLst (Future Feature Data Storage Area) |
§3.2.10 |
Attributes |
Description |
builtinId (Built-In Style Id) |
The index of a built-in cell style:
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
customBuiltin (Custom Built In) |
True indicates that this built-in cell style has been customized.
By default built-in styles are not persisted when not in use. This flag indicates that a built-in style has been modified, and therefore should be saved with the workbook, even if not currently in use.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
hidden (Hidden Style) |
If 'true' do not show this style in the application UI.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
iLevel (Outline Style) |
Indicates that this formatting is for an outline style . When styles are applied to outline levels (using the outline feature), this value is set and the formatting specified on this cell style is applied to the corresponding level of the outline.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
name (User Defined Cell Style) |
The name of the cell style.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
xfId (Format Id) |
Zero-based index referencing an xf record in the cellStyleXfs collection. This is used to determine the formatting defined for this named cell style.
The possible values for this attribute are defined by the ST_CellStyleXfId simple type (§3.18.11). |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_CellStyle">
<sequence>
<element name="extLst" type="CT_ExtensionList" minOccurs="0" maxOccurs="1"/>
</sequence>
<attribute name="name" type="ST_Xstring" use="optional"/>
<attribute name="xfId" type="ST_CellStyleXfId" use="required"/>
<attribute name="builtinId" type="xsd:unsignedInt" use="optional"/>
<attribute name="iLevel" type="xsd:unsignedInt" use="optional"/>
<attribute name="hidden" type="xsd:boolean" use="optional"/>
<attribute name="customBuiltin" type="xsd:boolean" use="optional"/>
</complexType>