2.4.304 BrtBeginWsView
The BrtBeginWsView record specifies sheet view settings for the current sheet. It also specifies the beginning of a collection of records as defined by the Worksheet part ABNF (section 2.1.7.62), the Dialog Sheet (section 2.1.7.20) part ABNF, and the Macro Sheet (section 2.1.7.32) part ABNF. This collection specifies additional sheet view settings for the current sheet. Sheet view settings and workbook view settings for the associated workbook view (specified by iwbkview) together define the display of a sheet.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
reserved1 |
xlView |
|||||||||||||||||||
|
... |
rwTop |
||||||||||||||||||||||||||||||
|
... |
colLeft |
||||||||||||||||||||||||||||||
|
... |
icvHdr |
reserved2 |
|||||||||||||||||||||||||||||
|
reserved3 |
wScale |
||||||||||||||||||||||||||||||
|
wScaleNormal |
wScaleSLV |
||||||||||||||||||||||||||||||
|
wScalePLV |
iWbkView |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fWnProt (1 bit): A bit that specifies whether the window displaying the sheet view is locked because of window protection.
B - fDspFmla (1 bit): A bit that specifies whether formulas (section 2.2.2) are displayed in cells in the sheet view. This value MUST be 0 for dialog sheets.
C - fDspGrid (1 bit): A bit that specifies whether gridlines are displayed in the sheet view.
D - fDspRwCol (1 bit): A bit that specifies whether row headings and column (1) headings are displayed in the sheet view. This value MUST be 0 for dialog sheets.
E - fDspZeros (1 bit): A bit that specifies how zero values are displayed in cells in the sheet view. This value MUST be 0 for dialog sheets. Possible values for this field are listed in the following table.
-
Value
Meaning
0
Cells with a zero value appear blank.
1
Cells with a zero value display the number 0 (zero).
F - fRightToLeft (1 bit): A bit that specifies whether the sheet view is displayed in a right-to-left manner.
G - fSelected (1 bit): A bit that specifies whether the sheet is selected in the sheet view.
H - fDspRuler (1 bit): A bit that specifies whether the ruler is displayed in the sheet view. This value MUST be ignored if xlView is not equal to XLVPAGELAYOUTVIEW. This value MUST be 1 for dialog sheets and macro sheets.
I - fDspGuts (1 bit): A bit that specifies whether outline symbols are displayed in the sheet view. This value MUST be 0 for dialog sheets.
J - fDefaultHdr (1 bit): A bit that specifies whether the default color is used for the gridlines, overriding the color specified in icvHdr. This value MUST be 1 for dialog sheets.
K - fWhitespaceHidden (1 bit): A bit that specifies whether the page margins, headers, and footers are hidden. This value MUST be ignored if xlView is not equal to XLVPAGELAYOUTVIEW. This value MUST be 0 for dialog sheets and macro sheets.
reserved1 (5 bits): This value MUST be 0 and MUST be ignored.
xlView (4 bytes): An XLView (section 2.5.168) that specifies the type of sheet view.
rwTop (4 bytes): An UncheckedRw (section 2.5.155) that specifies the first row that is displayed in the sheet view.
colLeft (4 bytes): An UncheckedCol (section 2.5.153) that specifies the first column (1) that is displayed in the sheet view.
icvHdr (1 byte): An Icv (section 2.5.76) that specifies the color of the gridlines displayed in the sheet view.
reserved2 (1 byte): This value MUST be 0 and MUST be ignored.
reserved3 (2 bytes): This value MUST be 0 and MUST be ignored.
wScale (2 bytes): An unsigned integer that specifies a percentage value that specifies the zoom level of the sheet displayed in the sheet view. This value MUST be greater than or equal to 10 and less than or equal to 400.
wScaleNormal (2 bytes): An unsigned integer that specifies a percentage value that specifies the zoom level of the sheet when displayed in Normal view. This value MUST be 0 or a value greater than or equal to 10 and less than or equal to 400. If the value is zero, the zoom level is assumed to be 100.
wScaleSLV (2 bytes): An unsigned integer that specifies a percentage value that specifies the zoom level of the sheet when displayed in Page Break Preview view. This value MUST be 0 or a value greater than or equal to 10 and less than or equal to 400. If the value is zero, the zoom level is assumed to be 100.
wScalePLV (2 bytes): An unsigned integer that specifies a percentage value that specifies the zoom level of the sheet when displayed in Page Layout view. This value MUST be 0 or a value greater than or equal to 10 and less than or equal to 400. If the value is zero, the zoom level is assumed to be 100.
iWbkView (4 bytes): An unsigned integer that specifies the zero-based index of a BrtBookView (section 2.4.310) record in the collection of all records directly following BrtBeginBookViews (section 2.4.11) in the Workbook (section 2.1.7.61) part. The referenced BrtBookView specifies the workbook view this sheet view is associated with.