The USERSVIEWBEGIN record specifies settings for a custom view associated with the sheet. This record also marks the start of custom view records, which save custom view settings. Records between USERSVIEWBEGIN and USERSVIEWEND contain settings for the custom view, not settings for the sheet itself.
Record Data — BIFF8
|
Offset |
Name |
Size |
Contents |
|
4 |
guid |
16 |
Globally unique identifier for the custom view |
|
20 |
iTabid |
4 |
Tab index for the sheet (1-based) |
|
24 |
wScale |
4 |
Window zoom magnification |
|
28 |
icv |
4 |
Index to color value |
|
32 |
pnnSel |
4 |
Pane number of the active pane |
|
36 |
grbit |
4 |
Option flags |
|
40 |
refTopLeft |
8 |
Reference structure describing the visible area of the top-left pane (see text) |
|
48 |
operNum |
16 |
Array of 2 IEEE floating-point numbers that specify the vertical and horizontal positions of the pane split |
|
64 |
colRPane |
2 |
The first visible column of the right pane |
|
66 |
rwBPane |
2 |
The first visible of the bottom pane |
The grbit field contains the option flags listed in the following table.
|
Bits |
Mask |
Name |
Contents | |
|
0 |
00000001h |
fShowBrks |
= 1 if page breaks are displayed | |
|
1 |
00000002h |
fDspFmlaSv |
= 1 if the window should display formulas | |
|
2 |
00000004h |
fDspGridSv |
= 1 if the window should display gridlines | |
|
3 |
00000008h |
fDspRwColSv |
= 1 if the window should display row and column headings | |
|
4 |
00000010h |
fDspGutsSv |
= 1 if outline symbols are displayed | |
|
5 |
00000020h |
fDspZerosSv |
= 1 if the window should display 0 (zero) values | |
|
6 |
00000040h |
fHorizontal |
= 1 if the sheet is to be centered between the horizontal margins when printed | |
|
7 |
00000080h |
fVertical |
= 1 if the sheet is to be centered between the vertical margins when printed | |
|
8 |
00000100h |
fPrintRwCol |
= 1 to print row and column headings | |
|
9 |
00000200h |
fPrintGrid |
= 1 to print gridlines | |
|
10 |
00000400h |
fFitToPage |
= 1 if the Fit To option is on (Page Setup dialog box, Page tab) | |
|
11 |
00000800h |
fPrintArea |
= 1 if there is at least one print area on the sheet | |
|
12 |
00001000h |
fOnePrintArea |
= 1 if there is only one print area on the sheet | |
|
13 |
00002000h |
fFilterMode |
= 1 if the list is filtered | |
|
14 |
00004000h |
fEzFilter |
= 1 if AutoFilter is active (the drop-down arrows are displayed) | |
|
16 – 15 |
00018000h |
(Reserved) | ||
|
17 |
00020000h |
fSplitV |
= 1 if the window is split vertically | |
|
18 |
00040000h |
fSplitH |
= 1 if the window is split horizontally | |
|
20 – 19 |
00180000h |
fHiddenRw |
2 bits true => hidden rws are defined as name | |
|
21 |
00200000h |
fHiddenCol |
= 1 if there is at least one hidden column on the sheet | |
|
23 – 22 |
00C00000h |
(Reserved) | ||
|
24 |
01000000h |
fSizeWithWn |
= 1 if the chart is sized with window (chart sheet only) | |
|
25 |
02000000h |
fFilterUnique |
= 1 if the view contains a filtered list | |
|
26 |
04000000h |
fSheetLayoutView |
= 1 if the sheet is in page break preview | |
|
31 – 27 |
F8000000h |
(Reserved) | ||
The sheet view settings are saved using standard BIFF records that occur between the USERSVIEWBEGIN record and the USERSVIEWEND record.
The guid is a unique identifier for a particular custom view for the entire workbook. The same guid can be found on USERSVIEWBEGIN records for other sheets and also in the USERBVIEW record for the workbook.