2.4.294 BrtBeginUserShView
The BrtBeginUserShView record specifies custom view settings for a sheet. It also specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF, 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 custom view settings. There is a companying BrtUserBookView (section 2.4.843) record that specifies the custom view settings that apply to a whole workbook. The set of this record and the companying BrtUserBookView record share the same GUID.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
guid (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
iTabId |
|||||||||||||||||||||||||||||||
|
dwScale |
|||||||||||||||||||||||||||||||
|
icv |
|||||||||||||||||||||||||||||||
|
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 |
c |
d |
||
|
rfxTopLeft (16 bytes) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
guid (16 bytes): A GUID as specified by [MS-DTYP], section 2.3.4, that specifies the unique identifier of a BrtUserBookView (section 2.4.843) record in the Workbook (section 2.1.7.61) part ABNF. The referenced BrtUserBookView specifies the custom workbook view that this custom view is associated with.
iTabId (4 bytes): An unsigned integer that specifies the active sheet in this view. This value MUST equal the value of the iTabID field in a BrtBundleSh (section 2.4.313) record. This value MUST be greater than or equal to 1 and less than or equal to 65,535.
dwScale (4 bytes): An unsigned integer that specifies a percentage value that specifies the zoom level of the sheet displayed in the view. If the sheet is a dialog sheet, MUST be zero or a value greater than or equal to 10 and less than or equal to 400. If the sheet is not a dialog sheet, MUST be greater than or equal to 10 and less than or equal to 400.
icv (4 bytes): An Icv (section 2.5.76) that specifies the color of the gridlines displayed in the view. This value MUST be less than or equal to 64.
A - fShowBrks (1 bit): A bit that specifies whether page breaks are displayed in the view.
B - fDspFmlaSv (1 bit): A bit that specifies whether formulas (section 2.2.2) are displayed in the view. This value MUST be 0 for dialog sheets.
C - fDspGridSv (1 bit): A bit that specifies whether gridlines are displayed in the view.
D - fDspRwColSv (1 bit): A bit that specifies whether row headings and column (1) headings are displayed in the view. This value MUST be 0 for dialog sheets.
E - fDspGutsSv (1 bit): A bit that specifies whether outline symbols are displayed in the view. This value MUST be 0 for dialog sheets. This value MUST be 1 for macro sheets.
F - fDspZerosSv (1 bit): A bit that specifies how zero values are displayed in cells in the view. This value MUST be 0 for dialog sheets.
-
Value
Meaning
0
Cells with a zero value appear blank.
1
Cells with a zero value display the number 0 (zero).
G - fHorizontal (1 bit): A bit that specifies whether printed pages are centered horizontally.
H - fVertical (1 bit): A bit that specifies whether printed pages are centered vertically.
I - fPrintRwCol (1 bit): A bit that specifies whether row headings and column (1) headings are printed. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fPrintIncl field value of 0.
J - fPrintGrid (1 bit): A bit that specifies whether gridlines are printed. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fPrintIncl field value of 0.
K - fFitToPage (1 bit): A bit that specifies whether fit to page is applied to printed pages. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fPrintIncl field value of 0.
L - fPrintArea (1 bit): A bit that specifies whether there is a print area applied to the sheet. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fPrintIncl field value of 0.
-
Additionally if fPrintArea is 1, there MUST be a BrtName (section 2.4.711) record for the print area as specified in the description for the fPrintIncl field in BrtUserBookView (section 2.4.843).
M - fOnePrintArea (1 bit): A bit that specifies whether there is exactly one print area applied to the sheet. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fPrintIncl field value of 0.
-
Additionally if fOnePrintArea is 1, there MUST be a BrtName record for the print area as specified in the description for the fPrintIncl field in BrtUserBookView.
N - fFilterMode (1 bit): A bit that specifies whether an AutoFilter range is being filtered. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fRowColIncl field value of 0.
-
Additionally if fFilterMode is 1, there MUST be a BrtName record for the range being filtered and a BrtName record for the range containing filter criteria as specified in the description for the fRowColIncl field in BrtUserBookView.
O - fEzFilter (1 bit): A bit that specifies whether AutoFilter dropdown buttons are displayed in the view. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fRowColIncl field value of 0.
-
Additionally if fEzFilter is 1, there MUST be a BrtName record for the range being filtered and a BrtName record for the range containing filter criteria as specified in the description for the fRowColIncl field in BrtUserBookView.
P - reserved1 (1 bit): This value MUST be 0 and MUST be ignored.
Q - reserved2 (1 bit): This value MUST be 0 and MUST be ignored.
R - fSplitV (1 bit): A bit that specifies whether there are split panes stacked vertically in the view.
S - fSplitH (1 bit): A bit that specifies whether there are split panes arranged side-by-side in the view.
T - fHiddenRw (2 bits): An unsigned integer that specifies whether any hidden rows exist in the sheet in this view. This value MUST be a value from the following table.
-
Value
Meaning
0x0
There are no hidden rows in the sheet in this view.
0x1
There are hidden rows in the sheet in this view.
-
This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fRowColIncl field value of 0.
-
Additionally, if fHiddenRw is 0x1, there MUST be a BrtName record for the hidden rows as specified in the description for the fRowColIncl field in BrtUserBookView.
U - fHiddenCol (1 bit): A bit that specifies whether any hidden columns exist in the sheet in this view. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fRowColIncl field value of 0.
-
Additionally, if fHiddenCol is 1, there MUST be a BrtName record for the hidden rows as specified in the description for the fRowColIncl field in BrtUserBookView.
V - hsState (2 bits): An ST_SheetState (section 2.5.143) that specifies the visibility state of the sheet in this view.
W - reserved3 (1 bit): This value MUST be 0 and MUST be ignored.
X - fFilterUnique (1 bit): A bit that specifies whether duplicate records are filtered out of a range in the sheet in this view. This value MUST be 0 for dialog sheets. This value MUST be 0 if the BrtUserBookView (section 2.4.843) record with guid field value equal to the guid of this record has a fRowColIncl field value of 0.
-
Additionally if fFilterUnique is 1, there MUST be a BrtName record for the range being filtered and a BrtName record for the range containing filter criteria as specified in the description for the fRowColIncl field in BrtUserBookView.
Y - fSheetLayoutView (1 bit): A bit that specifies whether the type of view displayed is a Page Break Preview view. The value of fSheetLayoutView and fPageLayoutView MUST NOT both be TRUE (1). This value MUST be 0 for macro sheets and dialog sheets.
Z - fPageLayoutView (1 bit): A bit that specifies whether the type of view displayed is a Page Layout view. The value of fSheetLayoutView and fPageLayoutView MUST NOT both be TRUE (1). This value MUST be 0 for macro sheets and dialog sheets.
a - reserved4 (1 bit): This value MUST be 0, and MUST be ignored.
b - fRuler (1 bit): A bit that specifies whether the ruler is displayed in the view.
c - reserved5 (1 bit): This value MUST be 0, and MUST be ignored.
d - reserved6 (1 bit): This value MUST be 0, and MUST be ignored.
rfxTopLeft (16 bytes): An UncheckedRfX (section 2.5.154) that specifies the logical top-left cell displayed in the view.