2.4.21 BOF

The BOF record specifies the beginning of the individual substreams as specified by the workbook section. It also specifies history information for the substreams.


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

vers

dt

rupBuild

rupYear

A

B

C

D

E

F

G

H

I

J

K

L

M

N

reserved1

verLowestBiff

O

reserved2

vers (2 bytes): An unsigned integer that specifies the BIFF version of the file. The value MUST be 0x0600.

dt (2 bytes): An unsigned integer that specifies the document type of the substream of records following this record. For more information about the layout of the sub-streams in the workbook stream see File Structure. MUST be a value from the following table:

Value

Meaning

0x0005

Specifies the workbook substream.

0x0010

Specifies the dialog sheet substream or the worksheet substream.

The sheet (1) substream that starts with this BOF record MUST contain one WsBool record. If the fDialog field in that WsBool is 1 then the sheet (1) is dialog sheet otherwise the sheet (1) is a worksheet.

0x0020

Specifies the chart sheet substream.

0x0040

Specifies the macro sheet substream.

rupBuild (2 bytes): An unsigned integer that specifies the build identifier.

rupYear (2 bytes): An unsigned integer that specifies the year when this BIFF version was first created. The value MUST be 0x07CC<27> or 0x07CD.

A - fWin (1 bit): A bit that specifies whether this file was last edited on a Windows platform. The value MUST be 1.

B - fRisc (1 bit): A bit that specifies whether the file was last edited on a Reduced Instruction Set Computing (RISC) platform. The value MUST be 0.

C - fBeta (1 bit): A bit that specifies whether this file was last edited by a beta version of the application. The value MUST be 0.

D - fWinAny (1 bit): A bit that specifies whether this file has ever been edited on a Windows platform. The value SHOULD<28> be 1.

E - fMacAny (1 bit): A bit that specifies whether this file has ever been edited on a Macintosh platform. The value MUST be 0.

F - fBetaAny (1 bit): A bit that specifies whether this file has ever been edited by a beta version of the application. The value MUST be 0.

G - unused1 (2 bits): Undefined and MUST be ignored.

H - fRiscAny (1 bit): A bit that specifies whether this file has ever been edited on a RISC platform. The value MUST be 0.

I - fOOM (1 bit): A bit that specifies whether this file had an out-of-memory failure.

J - fGlJmp (1 bit): A bit that specifies whether this file had an out-of-memory failure during rendering.

K - unused2 (2 bits): Undefined, and MUST be ignored.

L - fFontLimit (1 bit): A bit that specified that whether this file hit the 255 font limit<29>.

M - verXLHigh (4 bits): An unsigned integer that specifies the highest version of the application that once saved this file. MUST be a value from the following table:

Value

Meaning

0x0

Specifies the highest version of the application that has ever saved this file. <30>

0x1

Specifies the highest version of the application that has ever saved this file. <31>

0x2

Specifies the highest version of the application that has ever saved this file. <32>

0x3

Specifies the highest version of the application that has ever saved this file. <33>

0x4

Specifies the highest version of the application that has ever saved this file. <34>

0x6

Specifies the highest version of the application that has ever saved this file. <35>

0x7

Specifies the highest version of the application that has ever saved this file. <36>

N - unused3 (1 bit): Undefined, and MUST be ignored.

reserved1 (13 bits): MUST be zero, and MUST be ignored.

verLowestBiff (8 bits): An unsigned integer that specifies the BIFF version saved. The value MUST be 6. 

O - verLastXLSaved (4 bits): An unsigned integer that specifies the application that saved this file most recently. The value MUST be the value of field verXLHigh or less. MUST be a value from the following table:

Value

Meaning

0x0

Specifies the highest version of the application that has ever saved this file. <37>

0x1

Specifies the highest version of the application that has ever saved this file.<38>

0x2

Specifies the highest version of the application that has ever saved this file.<39>

0x3

Specifies the highest version of the application that has ever saved this file. <40>

0x4

Specifies the highest version of the application that has ever saved this file.<41>

0x6

Specifies the highest version of the application that has ever saved this file.<42>

0x7

Specifies the highest version of the application that has ever saved this file.<43>

reserved2 (20 bits): MUST be zero, and MUST be ignored.