<cellStyle>
(Cell Style)
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:
|
---|---|---|
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 |
---|
|
Child Elements |
Subclause |
---|---|
|
Attributes |
Description |
---|---|
|
The index of a built-in cell style: The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
|
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. |
|
If The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
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. |
|
The name of the cell style. The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
Zero-based index referencing an 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>