2.5.282 XFIndex
The XFIndex structure specifies the index of a XF record.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.