Export (0) Print
Expand All
Expand Minimize

2.4.353 XF

Office

The XF record specifies formatting properties for a cell or a cell style.


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

ifnt

ifmt

A

B

C

D

ixfParent

Data (variable)

...

ifnt (2 bytes): A FontIndex structure that specifies a Font record.

ifmt (2 bytes): An IFmt structure that specifies a number format identifier.

A - fLocked (1 bit): A bit that specifies whether the locked protection property is set to true.

B - fHidden (1 bit): A bit that specifies whether the hidden protection property is set to true.

C - fStyle (1 bit): A bit that specifies whether this record specifies a cell XF or a cell style XF. If the value is 1, this record specifies a cell style XF.

D - f123Prefix (1 bit): A bit that specifies whether prefix characters are present in the cell. The possible prefix characters are single quote (0x27), double quote (0x22), caret (0x5E), and backslash (0x5C).<146> If fStyle equals 1, this field MUST equal 0.

ixfParent (12 bits): An unsigned integer that specifies the zero-based index of a cell style XF record in the collection of XF records in the Globals Substream that this cell format inherits properties from. Cell style XF records are the subset of XF records with an fStyle field equal to 1. See XFIndex for more information about the organization of XF records in the file.

If fStyle equals 1, this field SHOULD equal 0xFFF, indicating there is no inheritance from a cell style XF. <147>

Data (variable): If the value of fStyle equals 0, this field contains a CellXF that specifies additional properties of the cell XF. If the value of fStyle equals 1, this field contains a StyleXF that specifies additional properties of the cell style XF.

Show:
© 2014 Microsoft