2.4.91 BrtBeginIconSet
-
-
The BrtBeginIconSet record specifies properties of a conditional formatting rule that uses an icon set and specifies the beginning of a collection of BrtCFVO (section 2.4.331) 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 BrtCFVO 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. Each BrtCFVO record following this record specifies the minimum value associated with the corresponding icon from the icon set. The first BrtCFVO record following this record MUST be ignored.
-
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
iSet |
|||||||||||||||||||||||||||||||
|
A |
B |
C |
D |
E |
F |
G |
reserved2 |
||||||||||||||||||||||||
iSet (4 bytes): A KPISets (section 2.5.86) integer that specifies the icon set used in the collection of BrtCFVO (section 2.4.331) records.
A - reserved1 (1 bit): This value MUST be 0, and MUST be ignored.
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.
-
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.
reserved2 (9 bits): This value MUST be 0, and MUST be ignored.