2.4.43 BrtBeginDatabar
The BrtBeginDatabar record specifies data bar properties and specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF and the Macro Sheet (section 2.1.7.32) part ABNF. The collection of records specifies a data bar used in conditional formatting.
In the collection of records following this record, the first BrtCFVO (section 2.4.331) record specifies the minimum cell value used for the data bars in this conditional formatting range. The second BrtCFVO record specifies the maximum cell value used for the data bars in this conditional formatting range. The BrtColor (section 2.4.334) record specifies the color of the data bar.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
bLenMin |
bLenMax |
fShowValue |
|||||||||||||||||||||||||||||
bLenMin (1 byte): An unsigned integer that specifies the minimum cell width occupied by the data bars in this conditional formatting range, expressed as a percentage of the width of the cell being formatted. This value MUST be greater than or equal to 0 and less than or equal to bLenMax.
bLenMax (1 byte): An unsigned integer that specifies the maximum cell width occupied by the data bars in this conditional formatting range, expressed as a percentage of the width of the cell being formatted. This value MUST be greater than or equal to bLenMin and less than or equal to 100.
fShowValue (1 byte): A Boolean (section 2.5.98.3) that specifies whether the cells in the conditional formatting range display both the data bar and the numeric value or only the data bar. The following table specifies the meaning of each value.
-
Value
Meaning
0x00
Only the data bar is displayed in the cell.
0x01
Both the data bar and the numeric value are displayed in the cell.