Export (0) Print
Expand All
Expand Minimize

2.4.346 Window2

Office

The Window2 record specifies attributes of the window used to display a sheet in a workbook and that specifies the beginning of a collection of records as defined by the Chart Sheet substreamABNF, Macro Sheet substream ABNF, and Worksheet substream ABNF. The collection of records specifies the settings of a Page Layout view for a sheet, the zoom of the current view, the position of either frozen panes or unfrozen panes, and the selectedcells within the sheet. When this record is contained in a macro sheet substream or a worksheet substream, it has a length of 18 bytes. When this record is contained in a chart sheet substream, it has a length of 10 bytes (which are the first 10 bytes of the original 18-byte record) and only the fSelected field is used. This record specifies extended properties of an associated Window1 record, and that association is specified in Window1.


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

A

B

C

D

E

F

G

H

I

J

K

L

M

rwTop

colLeft

icvHdr

reserved2

wScaleSLV

wScaleNormal

unused

reserved3

A - fDspFmlaRt (1 bit): A bit that specifies whether the window displays formulas (section 2.2.2) or values. If the value is 1, the window displays formulas (section 2.2.2). This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

B - fDspGridRt (1 bit): A bit that specifies whether the window displays gridlines.

Value

Meaning

0

The window does not display gridlines.

1

The window displays gridlines.

This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

C - fDspRwColRt (1 bit): A bit that specifies whether the window displays row headings and column headings.

Value

Meaning

0

The window does not display row headings and column headings.

1

The window displays row headings and column headings.

This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

D - fFrozenRt (1 bit): A bit that specifies whether the panes in the window are frozen. The value MUST be 0 if either the value of colLeft is 255 or the value of rwTop is 65535. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

E - fDspZerosRt (1 bit): A bit that specifies whether the window displays zero values.

Value

Meaning

0

The window displays cells that have a value of zero as blank.

1

The window displays cells that have a value of zero as a zero.

This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

F - fDefaultHdr (1 bit): A bit that specifies whether the gridlines of the window are drawn in the window's default foreground color or in the color specified by the value of icvHdr. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

Value

Meaning

0

Gridlines of the window are drawn in the color specified by the value of icvHdr.

1

Gridlines of the window are drawn in the default foreground color of the window.

G - fRightToLeft (1 bit): A bit that specifies whether the text is displayed in right-to-left mode in the window.

Value

Meaning

0

The text is displayed in left-to-right mode.

1

The text is displayed in right-to-left mode.

This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

H - fDspGuts (1 bit): A bit that specifies whether the window displays the outline state. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

I - fFrozenNoSplit (1 bit): A bit that specifies whether the panes in the window are frozen without pane splits or frozen with pane splits. If the value of fFrozenRt is 0, the value of fFrozenNoSplit MUST be 0.

Value

Meaning

0

The panes in the window are frozen with pane splits.

1

The panes in the window are frozen without pane splits.

This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

J - fSelected (1 bit): A bit that specifies whether the sheet tab is selected.

K - fPaged (1 bit): A bit that specifies whether the sheet is currently being displayed in the window. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

L - fSLV (1 bit): A bit that specifies whether the sheet is in Page Break Preview view. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

M - reserved1 (4 bits): MUST be zero, and MUST be ignored. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

rwTop (2 bytes): A RwU structure that specifies a zero-based row index of the first visible row of the sheet. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

colLeft (2 bytes): A ColU structure that specifies a zero-based column index of the logical left-most visible column. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

icvHdr (2 bytes): An Icv structure that specifies the color of the gridlines. MUST be less than or equal to 64. MUST be 64 if and only if the value of fDefaultHdr is 1. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

reserved2 (2 bytes): MUST be zero, and MUST be ignored. This field is undefined and MUST be ignored if this record is contained in a chart sheet substream.

wScaleSLV (2 bytes): An unsigned integer that specifies the zoom level in the Page Break Preview view. If the value of fSLV is 1 and this record has an associated Scl as specified in the ABNF in Common Productions, the value of wScaleSLV is undefined and MUST be ignored. MUST<143> be either 0 or greater than or equal to 10 and less than or equal to 400. A value of 0 specifies the default zoom level. This field MUST NOT exist if this record is contained in a chart sheet substream.

wScaleNormal (2 bytes): An unsigned integer that specifies the zoom level in the Normal view. If the value of fSLV is 0 and the value of the fPageLayoutView field of the PLV, as specified in the ABNF in Common Productions, is 0 and this record has an associated Scl, then the value of wScaleNormal is undefined and MUST be ignored. MUST<144> be either 0 or greater than or equal to 10 and less than or equal to 400. A value of 0 specifies the default zoom level. This field MUST NOT exist if this record is contained in a chart sheet substream.

unused (2 bytes): Undefined and MUST be ignored. This field MUST NOT exist if this record is contained in a chart sheet substream.

reserved3 (2 bytes): MUST be zero, and MUST be ignored. This field MUST NOT exist if this record is contained in a chart sheet substream.

Show:
© 2014 Microsoft