2.4.28 BoundSheet8

The BoundSheet8 record specifies basic information about a sheet (1), including the sheet (1) name, hidden state, and type of sheet (1).


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

lbPlyPos

A

unused

dt

stName (variable)

...

lbPlyPos (4 bytes): A FilePointer as specified in [MS-OSHARED] section 2.2.1.5 that specifies the stream position of the start of the BOF record for the sheet (1).

A - hsState (2 bits): An unsigned integer that specifies the hidden state of the sheet (1). MUST be a value from the following table:

Value

Meaning

0x00

Visible

0x01

Hidden

0x02

Very Hidden; the sheet (1) is hidden and cannot be displayed using the user interface.

unused (6 bits): Undefined and MUST be ignored.

dt (8 bits): An unsigned integer that specifies the sheet (1) type. MUST be a value from the following table:

Value

Meaning

0x00

Worksheet or dialog sheet

The sheet substream that starts with the BOF record specified in lbPlyPos MUST contain one WsBool record. If the fDialog field in that WsBool is 1 then the sheet is dialog sheet. Otherwise, the sheet is a worksheet.

0x01

Macro sheet

0x02

Chart sheet

0x06

VBA module

stName (variable): A ShortXLUnicodeString structure that specifies the unique case-insensitive name of the sheet (1). The character count of this string, stName.cch, MUST be greater than or equal to 1 and less than or equal to 31. The string MUST NOT contain the any of the following characters:

  • 0x0000

  • 0x0003

  • colon (:)

  • backslash (\)

  • asterisk (*)

  • question mark (?)

  • forward slash (/)

  • opening square bracket ([)

  • closing square bracket (])

    The string MUST NOT begin or end with the single quote (') character.