2.4.92 BrtBeginIconSet14
The BrtBeginIconSet14 record specifies properties of a conditional formatting rule that uses an icon set and specifies the beginning of a collection of records as defined by the Worksheet (section 2.1.7.62) part ABNF. The collection of BrtCFVO14 (section 2.4.332) records specifies the set of values that specify the thresholds used by the conditional formatting rule to determine which icons to display in the applied range. The collection of BrtCFIcon (section 2.4.329) records specifies a custom set of icons if the fCustom value is 1. The first BrtCFVO14 record following this record MUST be ignored.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
FRTHeader |
|||||||||||||||||||||||||||||||
|
iSet |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
reserved |
||||||||||||||||||||||||
FRTHeader (4 bytes): An FRTBlank (section 2.5.55) value that specifies the future record (section 2.1.6) information for this record.
iSet (4 bytes): A KPISets14 (section 2.5.87) value that specifies the icon set used in the collection of BrtCFVO14 (section 2.4.332) records.
A - fCustom (1 bit): A bit that specifies whether a custom set of icons is used. If the value equals 1, then there MUST be the same number of BrtCFIcon (section 2.4.329) records as BrtCFVO14 records and the icons specified by the BrtCFIcon records are used rather than those specified by the iSet field. If the value equals 0, then there MUST be 0 BrtCFIcon records.
-
Value
Meaning
0
No custom set of icons is used.
1
A custom set of icons is used.
B - fIcon (1 bit): A bit that specifies whether the cells in the applied range display the icon and cell value, or the icon only.
-
Value
Meaning
0
The icon and cell value are shown in the cell.
1
Only the icon is shown in the cell.
C - fReverse (1 bit): A bit that specifies whether the icons in the icon set specified in iSet are shown in reverse order. If fCustom equals one, this value MUST be ignored.
-
Value
Meaning
0
The icons specified in iSet are shown in reverse order.
1
The icons specified in iSet are shown in the order defined by the icon set.
-
D - unused1 (1 bit): This value is undefined, and MUST be ignored.
E - unused2 (1 bit): This value is undefined, and MUST be ignored.
F - unused3 (1 bit): This value is undefined, and MUST be ignored.
G - unused4 (1 bit): This value is undefined, and MUST be ignored.
reserved (9 bits): This value MUST be 0, and MUST be ignored.