2.4.334 UserSViewBegin
The UserSViewBegin record specifies custom view settings for the current sheet and specifies the beginning of a collection of records as defined by the Chart Sheet substream ABNF, Dialog Sheet substream ABNF, Macro Sheet substream ABNF, and Worksheet substream ABNF. The collection of records specifies custom view settings for the current sheet. There is an associated UserBView record, specified by the guid field, that specifies custom view settings that apply to the whole workbook. If the current sheet is a chart sheet, the UserSViewBegin_Chart version of this record MUST be used.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
guid (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
iTabid |
reserved1 |
||||||||||||||||||||||||||||||
|
wScale |
|||||||||||||||||||||||||||||||
|
icvHdr |
reserved2 |
||||||||||||||||||||||||||||||
|
pnnSel |
reserved3 |
reserved4 |
|||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
R |
S |
T |
U |
V |
W |
X |
Y |
Z |
a |
b |
||||
|
ref8TopLeft |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
operNumX |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
operNumY |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
colRPane |
rwBPane |
||||||||||||||||||||||||||||||
guid (16 bytes): A GUID, as specified by [MS-DTYP], that specifies the association with a UserBView. MUST equal the value of the guid field of the UserBView.
iTabid (2 bytes): A TabId structure that specifies the sheet of this custom view.
reserved1 (2 bytes): MUST be zero, and MUST be ignored.
wScale (4 bytes): An unsigned integer that specifies the zoom level of the window used to display the sheet. MUST be greater than or equal to 10 and less than or equal to 400.
icvHdr (2 bytes): An Icv structure that specifies the color of the gridlines displayed in the view. MUST be less than or equal to 64.
reserved2 (2 bytes): MUST be zero, and MUST be ignored.
pnnSel (1 byte): A PaneType structure that specifies the active pane.
reserved3 (2 bytes): MUST be zero, and MUST be ignored.
reserved4 (1 byte): MUST be zero, and MUST be ignored.
A - fShowBrks (1 bit): A bit that specifies whether page breaks are displayed.
B - fDspFmlaSv (1 bit): A bit that specifies whether the window used to display the sheet displays formulas or values. MUST be 0 for dialog sheets. MUST be a value from the following table:
-
Value
Meaning
0x0
The window used to display the sheet displays values.
0x1
The window used to display the sheet displays formulas.
C - fDspGridSv (1 bit): A bit that specifies whether the window used to display the sheet displays gridlines.
D - fDspRwColSv (1 bit): A bit that specifies whether the window used to display the sheet displays row and column headings. MUST be 0 for dialog sheets.
E - fDspGutsSv (1 bit): A bit that specifies whether outline symbols are displayed. MUST be 0 for dialog sheets. MUST be 1 for macro sheets.
F - fDspZerosSv (1 bit): A bit that specifies whether the window used to display the sheet displays zero values or suppresses display of zero values. MUST be 0 for dialog sheets. MUST be a value from the following table:
-
Value
Meaning
0
The window used to display the sheet displays zero values.
1
The window used to display the sheet suppresses display of zero values.
G - fHorizontal (1 bit): A bit that specifies whether the sheet is centered between the horizontal margins when printed.
H - fVertical (1 bit): A bit that specifies whether the sheet is centered between the vertical margins when printed.
I - fPrintRwCol (1 bit): A bit that specifies whether to print the row and column headings. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fPrintIncl field value of 0.
J - fPrintGrid (1 bit): A bit that specifies whether to print the gridlines. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equals to the guid of this record has the fPrintIncl field value of 0.
K - fFitToPage (1 bit): A bit that specifies whether the fit to page option is enabled. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fPrintIncl field value of 0.
L - fPrintArea (1 bit): A bit that specifies whether there is at least one print area on the sheet. If the value of fOnePrintArea is 1, the value of fPrintArea MUST be 1. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fPrintIncl field value of 0.
-
Additionally, if fPrintArea is 1, there MUST exist an Lbl record for the print area as specified in the description for the fPrintIncl field in UserBView.
M - fOnePrintArea (1 bit): A bit that specifies whether there is only one print area on the sheet. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fPrintIncl field value of 0.
-
Additionally, if fOnePrintArea is 1, there MUST exist an Lbl record for the print area as specified in the description for the fPrintIncl field in UserBView.
N - fFilterMode (1 bit): A bit that specifies whether there are hidden cells because of filtering. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fRowColIncl field value of 0.
-
Additionally, if fFilterMode is 1, there MUST exist an Lbl record for the range being filtered as specified in the description for the fRowColIncl field in UserBView. There can exist an Lbl record for the range containing filter criteria as specified in the description for the fRowColIncl field in UserBView.
O - fEzFilter (1 bit): A bit that specifies whether the AutoFilter icon is shown on the sheet. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fRowColIncl field value of 0.
-
Additionally, if fEzFilter is 1, there MUST exist an Lbl record for the range being filtered as specified in the description for the fRowColIncl field in UserBView. There can exist an Lbl record for the range containing filter criteria as specified in the description for the fRowColIncl field in UserBView.
P - fFrozen (1 bit): A bit that specifies whether the panes in the window used to display the sheet are frozen. If the value of fFrozenNoSplit is 1, the value of fFrozen MUST be 1.
Q - fFrozenNoSplit (1 bit): A bit that specifies whether the panes in the window used to display the sheet are frozen panes but are not split panes.
R - fSplitV (1 bit): A bit that specifies whether the window used to display the sheet is split vertically.
S - fSplitH (1 bit): A bit that specifies whether the window used to display the sheet is split horizontally.
T - fHiddenRw (2 bits): An unsigned integer that specifies the state of hidden rows, excluding the filtered rows. MUST be a value from the following table:
-
Value
Meaning
0x0
Indicates a hidden row is present.
0x1
Indicates a hidden row is not present.
-
MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fRowColIncl field value of 0.
-
Additionally, if fHiddenRw is 1, there MUST exist an Lbl record for the hidden rows as specified in the description for the fRowColIncl field in UserBView.
-
U - fHiddenCol (1 bit): A bit that specifies whether there is at least one hidden column in the sheet. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fRowColIncl field value of 0.
-
Additionally, if fHiddenRw is 1, there MUST exist an Lbl record for the hidden columns as specified in the description for the fRowColIncl field in UserBView.
V - unused1 (3 bits): Undefined and MUST be ignored.
W - fFilterUnique (1 bit): A bit that specifies whether the sheet has the advanced filter enabled and is displaying only unique rows. MUST be 0 for dialog sheets. MUST be 0 if the UserBView record with guid field value equal to the guid of this record has the fRowColIncl field value of 0.
-
Additionally, if fFilterUnique is 1, there MUST exist an Lbl record for the range being filtered as specified in the description for the fRowColIncl field in UserBView. There can exist an Lbl record for the range containing filter criteria as specified in the description for the fRowColIncl field in UserBView.
X - fSheetLayoutView (1 bit): A bit that specifies whether the sheet is in the Page Break Preview view. Only one of this value or the value of fPageLayoutView can be 1. If both values are 0, the custom view is in the Normal view. MUST be 0 for dialog sheets and macro sheets.
Y - fPageLayoutView (1 bit): A bit that specifies whether the sheet is in the Page Layout view. MUST be 0 for dialog sheets and macro sheets.
Z - unused2 (1 bit): Undefined and MUST be ignored.
a - fRuler (1 bit): A bit that specifies whether the ruler is displayed.
b - reserved5 (2 bits): MUST be zero, and MUST be ignored.
ref8TopLeft (8 bytes): A Ref8U structure that specifies the visible area of the logical top-left pane.
operNumX (8 bytes): A floating-point number that specifies the left-to-right position of the start of the split pane expressed as a column number. The value MUST be greater than or equal to 0. The sum of this value and the value of ref8TopLeft.colFirst MUST be less than or equal to 256.
operNumY (8 bytes): A floating-point number that specifies the top-to-bottom position of the start of the split pane expressed as a row number. The value MUST be greater than or equal to 0. The sum of this value and the value of ref8TopLeft.rowFirst MUST be less than or equal to 65536.
colRPane (2 bytes): An unsigned integer that specifies the first visible column of the logical right pane. MUST be 65535 or less than or equal to 255. If the value of the fSplitV field is 1, the value of colRPane MUST be 65535. If the value of the fSplitV field is 0, the value of colRPane MUST be less than or equal to 255.
rwBPane (2 bytes): An unsigned integer that specifies the first visible row of the bottom pane. If the value of the fSplitH field is 1, the value of rwBPane MUST be 65535.