2.4.44 BrtBeginDatabar14
The BrtBeginDatabar14 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. The collection of records specifies a data bar used in conditional formatting.
In the collection of records following this record, the first BrtCFVO14 (section 2.4.332) record specifies the minimum cell value used for the data bars in the conditional formatting range. The second BrtCFVO14 record specifies the maximum cell value used for the data bars in the conditional formatting range.
In the collection of records following this record, there are five optional BrtColor14 (section 2.4.335) records. They specify, in order, if they exist, the data bar positive bar color, data bar border color, data bar negative bar color, data bar negative border color, and data bar axis color.
The first optional BrtColor14 (section 2.4.335) record specifies the data bar positive bar color and MUST exist if and only if the iPri field of the BrtBeginCFRule14 (section 2.4.24) record specified by the CFRULE14 rule (as defined in section 2.1.8) that contains this record does not equal -1.
The second optional BrtColor14 record specifies the data bar border color and MUST exist if and only if the fBorder attribute equals 1.
The third optional BrtColor14 record specifies the data bar negative bar color and MUST exist if and only if the fCustomNegativeFillColor attribute equals 1.
The fourth optional BrtColor14 record specifies the data bar negative border color and MUST exist if and only if the fCustomNegativeBorderColor attribute equals 1 and the fBorder attribute equals 1.
The fifth optional BrtColor14 record specifies the data bar axis color and MUST exist if and only if bAxisPosType does not equal 0x02.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
bLenMin |
bLenMax |
fShowValue |
bDirection |
||||||||||||||||||||||||||||
|
bAxisPosType |
A |
B |
C |
D |
unused |
||||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) that specifies the Future Record (section 2.1.6) information for this record.
bLenMin (1 byte): An unsigned integer that specifies the minimum cell width occupied by the data bars in the 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. If there exists a BrtCFRuleExt (section 2.4.330) record with a guid field in the sheet equal to the guid field of the BrtBeginCFRule14 (section 2.4.24) that begins the collection of records that contains this record, and this record's bLenMin is 0 and this record's bLenMax is 100, then the bLenMin field of the BrtBeginDataBar (section 2.4.43) record contained in the collection of records that begins with the BrtBeginConditionalFormatting (section 2.4.34) record that contains the BrtCFRuleExt record with the same guid field MUST be 10. If there exists a BrtCFRuleExt record with a guid field in this sheet equal to the guid field of the BrtBeginCFRule14 (section 2.4.24) that begins the collection of records that contains this record, and this record's bLenMin is not 0 or this record's bLenMax is not 100, then the bLenMin field of the BrtBeginDataBar record contained in the collection of records that begins with the BrtBeginConditionalFormatting record that contains the BrtCFRuleExt record with the same guid field MUST be equal to this record’s bLenMin.
bLenMax (1 byte): An unsigned integer that specifies the maximum cell width occupied by the data bars in the 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. If there exists a BrtCFRuleExt (section 2.4.330) record with a guid field in the sheet equal to the guid field of the BrtBeginCFRule14 (section 2.4.24) that begins the collection of records that contains this record, and this record's bLenMin is 0 and this record's bLenMax is 100, then the bLenMax field of the BrtBeginDataBar (section 2.4.43) record contained in the collection of records that begins with the BrtBeginConditionalFormatting (section 2.4.34) record that contains the BrtCFRuleExt (section 2.4.330) record with the same guid field MUST be 90. If there exists a BrtCFRuleExt record with a guid field in the sheet equal to the guid field of the BrtBeginCFRule14 (section 2.4.24) that begins the collection of records that contains this record, and this record's bLenMin is not 0 or this record's bLenMax is not 100, then the bLenMax field of the BrtBeginDataBar record contained in the collection of records that begins with the BrtBeginConditionalFormatting record that contains the BrtCFRuleExt record with the same guid field MUST be equal to this record’s bLenMax.
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.
bDirection (1 byte): An unsigned integer that specifies the direction of the data bar. This value MUST be one of the values specified in the following table.
-
Value
Meaning
0x00
The direction of the data bar is determined by context.
0x01
The data bar is displayed in a left-to-right manner.
0x02
The data bar is displayed in a right-to-left manner.
bAxisPosType (1 byte): An unsigned integer that specifies the axis position for the data bar. This value MUST be one of the values specified in the following table.
-
Value
Meaning
0x00
The axis position for the data bar is calculated automatically.
0x01
The axis position for the data bar is the midpoint of the cell.
0x02
There is no axis for the data bar.
-
A - fBorder (1 bit): A bit that specifies whether the data bar has a border.
B - fGradient (1 bit): A bit that specifies whether the data bar fill is a gradient. The following table specifies the meaning of each value.
-
Value
Meaning
0
The data bar fill is a solid color.
1
The data bar fill is a gradient.
-
C - fCustomNegativeFillColor (1 bit): A bit that specifies whether the negative bar color of the data bar is different from the positive bar color.
D - fCustomNegativeBorderColor (1 bit): A bit that specifies whether the negative border color of the data bar is different from the positive border color.
unused (12 bits): Undefined and MUST be ignored.