The USERBVIEW record stores settings for a custom view in the workbook.
Record Data — BIFF8
|
Offset |
Name |
Size |
Contents |
|
4 |
iViewId |
4 |
ID for the custom view. |
|
8 |
iTabid |
4 |
Tab index for the active sheet (1-based). |
|
12 |
guid |
16 |
Globally unique identifier for the custom view. |
|
28 |
x |
4 |
Horizontal position of window. |
|
32 |
y |
4 |
Vertical position of window. |
|
36 |
dx |
4 |
Width of window. |
|
40 |
dy |
4 |
Height of window. |
|
44 |
wTabRatio |
2 |
Ratio of the width of the workbook tabs to the width of the horizontal scroll bar; to obtain the ratio, convert to decimal and then divide by 1000. |
|
46 |
grbit1 |
2 |
Option flags. |
|
48 |
grbit2 |
2 |
Option flags. |
|
50 |
wMergeInterval |
2 |
Time interval between automatic merges of shared workbook. |
|
52 |
(Reserved) |
2 | |
|
54 |
st |
var |
Name of custom view as a unicode string; for more information see "Unicode Strings in BIFF8" on page 264. |
The grbit1 field contains the option flags listed in the following table.
|
Bits |
Mask |
Name |
Contents | |
|
0 |
0001h |
fDspFmlaBar |
= 1 if the formula bar is displayed | |
|
1 |
0002h |
fDspStatus |
= 1 if the status bar is displayed | |
|
2 |
0004h |
fNoteOff |
= 1 if the comment indicator is off | |
|
3 |
0008h |
fDspHScroll |
= 1 if the horizontal scroll bar is displayed | |
|
4 |
0010h |
fDspVScroll |
= 1 if the vertical scroll bar is displayed | |
|
5 |
0020h |
fBotAdornment |
= 1 if the workbook tabs are displayed | |
|
6 |
0040h |
fZoom |
= 1 if the workbook window is maximized | |
|
8 – 7 |
0180h |
fHideObj |
= 10 if the Hide All option is turned on | |
|
15 – 9 |
FE00h |
(Reserved) | ||
The grbit2 field contains the option flags listed in the following table.
|
Bits |
Mask |
Name |
Contents | |
|
15 – 0 |
FFFFh |
(Reserved) |
Reserved; must be 0 (zero) | |