2.4.861 BrtWsProp
The BrtWsProp record specifies properties for a dialog sheet, a macro sheet, or a worksheet.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
C |
D |
E |
F |
G |
H |
I |
J |
K |
L |
M |
N |
O |
P |
Q |
reserved4 |
brtcolorTab |
|||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
rwSync |
||||||||||||||||||||||||||||||
|
... |
colSync |
||||||||||||||||||||||||||||||
|
... |
strName (variable) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
A - fShowAutoBreaks (1 bit): A bit that specifies whether automatic page breaks are visible on the sheet.
B - reserved1 (2 bits): This value MUST be 0, and MUST be ignored.
C - fPublish (1 bit): A bit that specifies whether the published feature is enabled for the sheet. If this record appears within a collection of records as defined by the Dialog Sheet (section 2.1.7.20) part ABNF or Macro Sheet (section 2.1.7.32) part ABNF, this value MUST be 1 and MUST be ignored.
D - fDialog (1 bit): A bit that specifies whether the sheet is a dialog sheet. This value MUST be 1, if this record appears within a collection of records as defined by the Dialog Sheet part ABNF; otherwise, this value MUST be 0.
E - fApplyStyles (1 bit): A bit that specifies whether to apply the built-in cell style (section 2.2.6.1.2) when an outline is applied. The iOutLevel field of each BrtColInfo (section 2.4.333) record specifies column (1) outline level. The built-in cell style for the column (1) outline level is specified by the BrtStyle (section 2.4.798) record with iLevel field equal to iOutLevel minus 1. The iOutLevel field of each BrtRowHdr (section 2.4.761) record specifies the row outline level. The built-in cell style for the outline level is specified by the BrtStyle record with iLevel field equal to iOutLevel minus 1.
F - fRowSumsBelow (1 bit): A bit that specifies the location of summary rows relative to detailed data rows when an outline is applied. If the value is 1, then a summary row appears below the detailed data rows. If the value is 0, then a summary row appears above the detailed data rows. If this record appears within a collection of records as defined by the Dialog Sheet part ABNF, this value MUST be 1 and MUST be ignored.
G - fColSumsRight (1 bit): A bit that specifies the location of summary columns (1) relative to detailed data columns (1) when an outline is applied. If the value is 1, then the summary columns (1) appear to the right, if the sheet is displayed left-to-right, or appear to the left, if the sheet is displayed right-to-left. If the value is 0, then the summary columns (1) appear to the left, if the sheet is displayed left-to-right, or appear to the right, if the sheet is displayed right-to-left. If this record appears within a collection of records as defined by the Dialog Sheet part ABNF, this value MUST be 1 and MUST be ignored.
H - fFitToPage (1 bit): A bit that specifies whether to fit the printable contents to a single page when printing the sheet.
I - reserved2 (1 bit): This value MUST be 0, and MUST be ignored.
J - fShowOutlineSymbols (1 bit): A bit that specifies whether the outline symbols of the sheet are visible. If this record appears within a collection of records as defined by the Dialog Sheet part ABNF, this value MUST be 1 and MUST be ignored.
K - reserved3 (1 bit): This value MUST be 0, and MUST be ignored.
L - fSyncHoriz (1 bit): A bit that specifies whether horizontal scrolling is synchronized across multiple windows displaying the sheet.
M - fSyncVert (1 bit): A bit that specifies whether vertical scrolling is synchronized across multiple windows displaying the sheet.
N - fAltExprEval (1 bit): A bit that specifies whether the sheet uses transition formula evaluation.
O - fAltFormulaEntry (1 bit): A bit that specifies whether the sheet uses transition formula entry.
P - fFilterMode (1 bit): A bit that specifies whether the sheet has one or more AutoFilters. If this record appears within a collection of records as defined by the Dialog Sheet part ABNF or Macro Sheet part ABNF, this value MUST be 0 and MUST be ignored.
Q - fCondFmtCalc (1 bit): A bit that specifies whether the conditional formatting calculations are to be evaluated. This field MUST be one of the values specified in the following table.
-
Value
Meaning
0
Conditional formatting is not evaluated normally and all the existing conditional formatting will not be updated as cells associated with the conditional formatting change.
1
Conditional formatting is evaluated normally and all the existing conditional formatting will be updated as the cells associated with the conditional formatting change.
reserved4 (6 bits): This value MUST be 0, and MUST be ignored.
brtcolorTab (8 bytes): A BrtColor (section 2.4.334) that specifies a background color of the sheet tab.
rwSync (4 bytes): A RwNullable (section 2.5.128) that specifies an anchor row for synchronous vertical scrolling if fSyncHoriz or fSyncVert are 1; otherwise, MUST be 0xFFFFFFFF, and MUST be ignored.
colSync (4 bytes): A ColNullable (section 2.5.24) that specifies an anchor column (1) for synchronous horizontal scrolling if fSyncHoriz or fSyncVert are 1; otherwise, MUST be 0xFFFFFFFF, and MUST be ignored.
strName (variable): A CodeName (section 2.5.22) for the sheet. If this record appears within a collection of records as defined by the Dialog Sheet part ABNF or Macro Sheet part ABNF, this value MUST be a 32-bit zero (0x00000000) and MUST be ignored.