Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
2.5.282 XFIndex
Collapse the table of content
Expand the table of content

2.5.282 XFIndex

Office

The XFIndex structure specifies the index of a XF record.


0

1

2

3

4

5

6

7

8

9
1
0

1

2

3

4

5

6

7

8

9
2
0

1

2

3

4

5

6

7

8

9
3
0

1

ixfe

ixfe (2 bytes): An unsigned integer that specifies a zero-based index of a XF record in the collection of XF records in the Globals Substream.

The XF records in the file refer to both and Cell Style XFs and Cell XFs. For more information, see Styles.

The XF records in the file can be divided into three sections. The first section contains the 16 built-in XF records that MUST exist and MUST be ordered as follows:

Index

XF specifies

fStyle value

0

Normal style

1

1

Row outline level 1

1

2

Row outline level 2

1

3

Row outline level 3

1

4

Row outline level 4

1

5

Row outline level 5

1

6

Row outline level 6

1

7

Row outline level 7

1

8

Column outline level 1

1

9

Column outline level 2

1

10

Column outline level 3

1

11

Column outline level 4

1

12

Column outline level 5

1

13

Column outline level 6

1

14

Column outline level 7

1

15

Default cell format

0

The second section contains XF records for both built-in and user-defined Cell Style XFs. These Cell Style XFs MUST be ordered alphabetically in the file based on their name. The name of the Cell Style XF is specified by the user field of the corresponding Style record. The corresponding Style record is the one with an ixfe field that specifies the XF record of the Cell Style XF. Note that the ordering depends on the localized name of the style and the language of the application that last saved the file.

For example, in a workbook created by a specific version of the application<189> with no user-defined cell styles the remainder of the table is:

Index

Name of Style

fStyle value

16

20% - Accent1

1

17

20% - Accent2

1

18

20% - Accent3

1

19

20% - Accent4

1

20

20% - Accent5

1

21

20% - Accent6

1

22

40% - Accent1

1

23

40% - Accent2

1

24

40% - Accent3

1

25

40% - Accent4

1

26

40% - Accent5

1

27

40% - Accent6

1

28

60% - Accent1

1

29

60% - Accent2

1

30

60% - Accent3

1

31

60% - Accent4

1

32

60% - Accent5

1

33

60% - Accent6

1

34

Accent1

1

35

Accent2

1

36

Accent3

1

37

Accent4

1

38

Accent5

1

39

Accent6

1

40

Bad

1

41

Calculation

1

42

Check Cell

1

43

Comma

1

44

Comma[0]

1

45

Currency

1

46

Currency[0]

1

47

Explanatory Text

1

48

Good

1

49

Heading 1

1

50

Heading 2

1

51

Heading 3

1

52

Heading 4

1

53

Input

1

54

Linked Cell

1

55

Neutral

1

56

Note

1

57

Output

1

58

Percent

1

59

Title

1

60

Total

1

61

Warning Text

1

The last section contains unordered XFs for any Cell XFs in the file.

Show:
© 2015 Microsoft