2.4.853 BrtWbProp
The BrtWbProp record specifies properties of a workbook.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
unused |
||||||||||||||
|
dwThemeVersion |
|||||||||||||||||||||||||||||||
|
strName (variable) |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - f1904 (1 bit): A bit that specifies the date system used in the workbook. This field MUST be one of the values specified in the following table.
-
Value
Meaning
0x0
Workbook uses the 1900 date base system as specified by [ISO/IEC29500-1:2016] section 18.17.4.
0x1
Workbook uses the 1904 backwards-compatibility date system as specified by [ISO/IEC29500-1:2016] section 18.17.4.
-
B - reserved1 (1 bit): This value MUST be 0, and MUST be ignored.
C - fHideBorderUnselLists (1 bit): A bit that specifies whether table borders are visible when a table is not active.
D - fFilterPrivacy (1 bit): A bit that specifies whether personally identifying information is removed from the workbook when it is saved.
E - fBuggedUserAboutSolution (1 bit): A bit that specifies whether a warning is requested before loading a smart document manifest file.
F - fShowInkAnnotation (1 bit): A bit that specifies whether ink comments are visible in the workbook.
G - fBackup (1 bit): A bit that specifies whether the backup feature is enabled for the workbook.
H - fNoSaveSup (1 bit): A bit that specifies whether external link values are cached with the workbook when it is saved.
I - grbitUpdateLinks (2 bits): An unsigned integer that specifies how embedded OLE links in the workbook are to be updated. This field MUST be one of the values specified in the following table.
-
Value
Meaning
0x0
The link update behavior is application specific.
0x1
The links are not automatically updated.
0x2
The links are automatically updated<53> .
J - fHidePivotTableFList (1 bit): A bit that specifies whether the PivotTable field list is hidden.
K - fPublishedBookItems (1 bit): A bit that specifies whether this workbook is published. This field MUST be one of the values specified in the following table.
-
Value
Meaning
0x0
Each sheet is published according to its own publishing state as specified by the field fPublish of the BrtWsProp (section 2.4.861) structure.
0x1
Individual items in a sheet specify their own publishing states.
-
L - fCheckCompat (1 bit): A bit that specifies whether the file format compatibility checker is enabled for the workbook.
M - mdDspObj (2 bits): An unsigned integer that specifies how shapes in the workbook are displayed. The meaning of each value is specified in the following table.
-
Value
Meaning
0x0
The shapes are visible.
0x1
Placeholders are shown in place of the shapes.
0x2
The shapes are not visible.
N - fShowPivotChartFilter (1 bit): A bit that specifies whether the PivotChart filter pane is visible.
O - fAutoCompressPictures (1 bit): A bit that specifies whether pictures in the workbook are compressed when the workbook is saved.
P - reserved2 (1 bit): This value MUST be 0, and MUST be ignored.
Q - fRefreshAll (1 bit): A bit that specifies whether all external data in the workbook are refreshed when the workbook is opened.
unused (13 bits): This field is undefined and MUST be ignored.
dwThemeVersion (4 bytes): An unsigned integer that specifies the version number of the theme applied to the workbook. When the value is 0, the version number of the theme is specified by the Theme (section 2.1.7.52) part ABNF.
strName (variable): A CodeName (section 2.5.22) for the workbook<54>.