[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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: (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

cellStyles3.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>