2.4.333 UserBView
The UserBView record specifies the general custom view settings that apply to a whole workbook. There are accompanying UserSViewBegin records that specify individual custom view settings of each sheet. The set of this record and the accompanying UserSViewBegin records share the same GUID.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
unused1 |
|||||||||||||||||||||||||||||||
|
tabId |
reserved1 |
||||||||||||||||||||||||||||||
|
guid (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
x |
|||||||||||||||||||||||||||||||
|
y |
|||||||||||||||||||||||||||||||
|
dx |
|||||||||||||||||||||||||||||||
|
dy |
|||||||||||||||||||||||||||||||
|
wTabRatio |
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
|||||||||||||||||
|
unused2 |
O |
P |
unused3 |
||||||||||||||||||||||||||||
|
wMergeInterval |
st (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
unused1 (4 bytes): Undefined and MUST be ignored.
tabId (2 bytes): A TabId structure that specifies the active sheet in this custom view. If the value of the fInvalidTabId field is 1, the value of tabId is undefined and MUST be ignored.
reserved1 (2 bytes): MUST be zero, and MUST be ignored.
guid (16 bytes): A GUID as specified by [MS-DTYP] that specifies the identity of the custom view.
x (4 bytes): A signed integer that specifies the horizontal position of the workbook window, in pixels.
y (4 bytes): A signed integer that specifies the vertical position of the workbook window, in pixels.
dx (4 bytes): A signed integer that specifies the width of the workbook window, in pixels. MUST be greater than or equal to 0.
dy (4 bytes): A signed integer that specifies the height of the workbook window, in pixels. MUST be greater than or equal to 0.
wTabRatio (2 bytes): An unsigned integer that specifies the ratio of the window area used to display sheet tabs and the window area used to display the horizontal scroll bar. The value of wTabRatio MUST be greater than or equal to zero and less than or equal to 1000. A value of 0 specifies that only the horizontal scroll bar is displayed. A value of 1000 specifies that only sheet tabs are displayed.
A - fDspFmlaBar (1 bit): A bit that specifies whether a formula bar is displayed.
B - fDspStatus (1 bit): A bit that specifies whether a status bar is displayed.
C - mdNoteDisp (2 bits): An unsigned integer that specifies whether to show cell comment and visual cue on each cell that has a comment. MUST be a value from the following table:
-
Value
Meaning
0x0
Comment and visual cue are off for each cell with a comment.
0x1
A visual cue that indicates the cell has a comment.
0x2
Comment and visual cue are on for each cell with a comment.
D - fDspHScroll (1 bit): A bit that specifies whether a horizontal scroll bar is displayed.
E - fDspVScroll (1 bit): A bit that specifies whether a vertical scroll bar is displayed.
F - fBotAdornment (1 bit): A bit that specifies whether sheet tabs are displayed.
G - fZoom (1 bit): A bit that specifies whether the workbook window is maximized. The value of fIconic and the value of fZoom MUST NOT both be 1.
H - fHideObj (2 bits): A HideObjEnum structure that specifies how ActiveX objects, OLE objects, and drawing objects appear in the workbook Window.
I - fPrintIncl (1 bit): A bit that specifies whether the custom view includes the print settings of the workbook. MUST be a value from the following table:
-
Value
Meaning
0x0
The custom view does not include print settings of the workbook.
0x1
The custom view includes print settings of the workbook.
UserSViewBegin records that have a guid field value equal to the guid of this record specify which print settings are included in the custom view.
Additionally, print titles and print areas are specified by Lbl records that have Name containing the guid of this record, using the following form, where <guid> matches the value of guid with the characters left brace "{", right brace "}", and dash "-" in guid replaced by an underscore "_" character:
Print titles: Z<guid>.wvu.PrintTitles
Print area: Z<guid>.wvu.PrintArea
J - fRowColIncl (1 bit): A bit that specifies whether the custom view includes the hidden rows, hidden columns, and filters for the workbook. MUST be a value from the following table:
-
Value
Meaning
0x0
The custom view does not include Hidden rows, hidden columns, or filter settings.
0x1
The custom view includes Hidden rows, hidden columns, or filter settings of the workbook.
UserSViewBegin records that have a guid field value equal to the guid of this record specify whether Hidden rows, hidden columns, or filter settings are included in the custom view.
Additionally, hidden rows and hidden columns are specified by Lbl records that have Name containing the guid of this record, using the following form, where <guid> matches the value of guid with the characters left brace "{", right brace "}", and dash "-" in guid replaced by an underscore "_" character:
Hidden rows: Z<guid>.wvu.Rows
Hidden columns: Z<guid>.wvu.Cols
Filter settings are also specified by Lbl records that have Name containing the value of guid for this record, using the following form, where <guid> matches the value of guid with the characters left brace "{", right brace "}", and dash "-" in guid replaced by an underscore "_" character:
Range being filtered: Z<guid>.wvu.FilterData
Range containing filter criteria: Z<guid>.wvu.FilterCriteria
K - fInvalidTabId (1 bit): A bit that specifies whether the tabId field is ignored.
L - fTimedUpdate (1 bit): A bit that specifies whether updates associated with linked or external data are coordinated. If the value of the fPersonalView field is 0, the value of fTimedUpdate MUST be 0.
M - fAllMemChanges (1 bit): A bit that specifies whether the changes being saved have priority in a merge conflict. If the value of the fTimedUpdate field is 0, the value of fAllMemChanges is undefined and MUST be ignored.
N - fOnlySync (1 bit): A bit that specifies whether the automatic update merges the current changes into a shared workbook or whether the automatic update merges and also saves the changes. If the value of the fPersonalView field is 0, the value of fOnlySync MUST be 0.
unused2 (2 bytes): Undefined and MUST be ignored.
O - fPersonalView (1 bit): A bit that specifies whether the custom view is the personal view of a shared workbook. MUST be 0 if this is not a shared workbook.
P - fIconic (1 bit): A bit that specifies whether the workbook window is minimized. The value of fIconic and the value of fZoom MUST NOT both be 1.
unused3 (14 bits): Undefined and MUST be ignored.
wMergeInterval (2 bytes): An unsigned integer that specifies the time interval, in minutes, between automatic merges of a shared workbook. The restrictions on the value of wMergeInterval are dictated by the value of the fPersonalView field and the value of the fTimedUpdate field, as specified in the following table:
-
fPersonalView
fTimedUpdate
wMergeInterval
1
1
MUST be greater than or equal to 5 and less than or equal to 1440.
1
0
Undefined and MUST be ignored.
0
0
MUST be 65535.
-
st (variable): An XLUnicodeString structure that specifies the name of the custom view.