WINDOW2: Sheet Window Information (23Eh)

The WINDOW2 record contains window attributes for a sheet in a workbook.

Record Data — BIFF8

Offset	Name	Size	Contents

4	grbit	2	Option flags
6	rwTop	2	Top row visible in the window
8	colLeft	2	Leftmost column visible in the window
10	icvHdr	4	Index to color value for row/column headings and gridlines
14	wScaleSLV	2	Zoom magnification in page break preview
16	wScaleNormal	2	Zoom magnification in normal view
18	(Reserved)	4

The grbit field contains the option flags shown in the following table.

Offset	Bits	Mask	Name	Contents

0	0	01h	fDspFmla	= 1 if the window should display formulas = 0 if the window should display value
	1	02h	fDspGrid	= 1 if the window should display gridlines
	2	04h	fDspRwCol	= 1 if the window should display row and column headings
	3	08h	fFrozen	= 1 if the panes in the window should be frozen
	4	10h	fDspZeros	= 1 if the window should display 0 (zero) values = 0 if the window should suppress display of 0 (zero) values
	5	20h	fDefaultHdr	= 1 (see the following explanation) = 0 use rgbHdr color
	6	40h	fArabic	= 1 for the Arabic version of Microsoft Excel
	7	80h	fDspGuts	= 1 if outline symbols are displayed

Offset	Bits	Mask	Name	Contents

1	0	01h	fFrozenNoSplit	= 1 if the panes in the window are frozen but there is no split
	1	02h	fSelected	= 1 if the sheet tab is selected
	2	04h	fPaged	= 1 if the sheet is currently being displayed in the workbook window
	3	08h	fSLV	= 1 if the sheet was saved while in page break preview
	7–4	F0h	(Reserved)

fDefaultHdr is 1 if the window's row and column headings and gridlines should be drawn in the window's default foreground color. If this field is 0, the color index in the icvHdr field is used instead.

Record Data — BIFF7 and earlier

Offset	Name	Size	Contents

4	grbit	2	Option flags
6	rwTop	2	Top row visible in the window
8	colLeft	2	Leftmost column visible in the window
10	rgbHdr	4	Row/column heading and gridline color

The grbit field contains the option flags shown in the following table.

Offset	Bits	Mask	Name	Contents

0	0	01h	fDspFmla	= 1 if the window should display formulas = 0 if the window should display value
	1	02h	fDspGrid	= 1 if the window should display gridlines
	2	04h	fDspRwCol	= 1 if the window should display row and column headings
	3	08h	fFrozen	= 1 if the panes in the window should be frozen
	4	10h	fDspZeros	= 1 if the window should display 0 (zero) values = 0 if the window should suppress display of 0 (zero) values
	5	20h	fDefaultHdr	= 1 (see the following explanation) = 0 use rgbHdr color
	6	40h	fArabic	= 1 for the Arabic version of Microsoft Excel
	7	80h	fDspGuts	= 1 if outline symbols are displayed

Offset	Bits	Mask	Name	Contents

1	0	01h	fFrozenNoSplit	= 1 if the panes in the window are frozen but there is no split
	1	02h	fSelected	= 1 if the sheet tab is selected
	2	04h	fPaged	= 1 if the sheet is currently being displayed in the workbook window
	7–3	F8h	(Reserved)

fDefaultHdr is 1 if the window's row and column headings and gridlines should be drawn in the window's default foreground color. If this field is 0, the RGB color in the rgbHdr field is used instead.