2.4.310 BrtBookView

The BrtBookView record specifies a single workbook view.


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

xWn

yWn

dxWn

dyWn

iTabRatio

itabFirst

itabCur

A

B

C

D

E

F

G

H

xWn (4 bytes): A signed integer that specifies the X coordinate for the left side of the window that contains the workbook. The unit of measurement for this value is twips.

yWn (4 bytes): A signed integer that specifies the Y coordinate for the top of the window that contains the workbook. The unit of measurement for this value is twips.

dxWn (4 bytes): An unsigned integer that specifies the width of the window that contains the workbook. The value MUST be less than 2,147,483,647. The unit of measurement for this value is twips.

dyWn (4 bytes): An unsigned integer that specifies the height of the window that contains the workbook. The value MUST be less than 2,147,483,647. The unit of measurement for this value is twips.

iTabRatio (4 bytes):  An unsigned integer that specifies the ratio of the window area used for selecting sheets to the window area used for horizontal scrolling. The value of iTabRatio MUST be greater than or equal to 0 and less than or equal to 1,000, where 1,000 means the space is entirely used for sheet selection, and 0 means the space is entirely used for horizontal scrolling.

itabFirst (4 bytes):  An unsigned integer that specifies a zero-based index of a BrtBundleSh (section 2.4.313) record in the collection of all records directly following BrtBeginBundleShs (section 2.4.13). The referenced BrtBundleSh specifies the first sheet in this workbook view.

itabCur (4 bytes):  An unsigned integer that specifies a zero-based index of a BrtBundleSh record in the collection of all records directly following BrtBeginBundleShs. The referenced BrtBundleSh specifies the active sheet in this workbook view.

A - fHidden (1 bit):  A bit that specifies whether the window that contains the workbook is in the list of hidden windows.

B - fVeryHidden (1 bit):  A bit that specifies whether the window that contains the workbook has the properties of fHidden, and also that the user cannot see that the window that contains the workbook is in the list of hidden windows.

C - fIconic (1 bit):  A bit that specifies whether the window that contains the workbook is minimized in the workbook view.

D - fDspHScroll (1 bit):  A bit that specifies whether a horizontal scroll bar is displayed in the workbook view.

E - fDspVScroll (1 bit):  A bit that specifies whether a vertical scroll bar is displayed in the workbook view.

F - fBotAdornment (1 bit):  A bit that specifies whether the sheet tabs are displayed in the workbook view.

G - fAFDateGroup (1 bit):  A bit that specifies whether to group dates when presenting the user with filtering options in the user interface.

H - unused (1 bit):  This value is undefined, and MUST be ignored.