2.4.345 Window1

The Window1 record specifies attributes of a window used to display a sheet (called "the window" within this record definition).  For each Window1 record in the Globals Substream there MUST be an associated Window2 record in each chart sheet, worksheet, macro sheet, and dialog sheet substream that exists in the workbook. The Window2 record in a given substream associated with a given Window1 record is the Window2 record whose ordinal position in the collection of Window2 records in the containing substream is equal to the ordinal position of the given Window1 record in the collection of Window1 records in the Globals Substream. Each Window2 record specifies extended properties of the associated Window1 record.


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

A

B

C

D

E

F

G

reserved

itabCur

itabFirst

ctabSel

wTabRatio

xWn (2 bytes):  A signed integer that specifies the horizontal position, in twips, of the window. The value is relative to the logical left edge of the client area of the window.

yWn (2 bytes):  A signed integer that specifies the vertical position, in twips, of the window. The value is relative to the top edge of the client area of the window.

dxWn (2 bytes):  A signed integer that specifies the width, in twips, of the window. MUST be greater than or equal to 1.

dyWn (2 bytes):  A signed integer that specifies the height, in twips, of the window. MUST be greater than or equal to 1.

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

B - fIconic (1 bit):  A bit that specifies whether the window is minimized.

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

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

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

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

G - fNoAFDateGroup (1 bit):  A bit that specifies whether dates are grouped hierarchically in the AutoFilter menu or listed chronologically in the AutoFilter menu.

Value

Meaning

0

Dates are grouped by year, month and day in the AutoFilter menu.

1

Dates are listed chronologically in the AutoFilter menu.

reserved (9 bits):  MUST be zero, and MUST be ignored.

itabCur (2 bytes):  A TabIndex structure that specifies the selected sheet tab.

itabFirst (2 bytes):  A TabIndex structure that specifies the first displayed sheet tab. 

ctabSel (2 bytes):  An unsigned integer that specifies the number of sheet tabs that are selected. The value MUST be less than or equal to the number of sheets in the workbook. Each sheet stream in the workbook stream specifies a sheet.

wTabRatio (2 bytes):  An unsigned integer that specifies the ratio of the width of the sheet tabs to the width of the horizontal scroll bar, multiplied by 1000. MUST be less than or equal to 1000.