2.5.30 CFFilter
The CFFilter structure specifies the parameters of a conditional formatting rule of type top N filter.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
cbFilter |
reserved1 |
A |
B |
reserved2 |
|||||||||||||||||||||||||||
|
iParam |
|||||||||||||||||||||||||||||||
cbFilter (2 bytes): An unsigned integer that specifies the size of the structure in bytes, excluding the cbFilter field itself.
reserved1 (1 byte): MUST be zero and MUST be ignored.
A - fTop (1 bit): A bit that specifies whether the top or bottom items are displayed with the conditional formatting. MUST be one of the following values:
-
Value
Meaning
0x0
Bottom items are displayed with the conditional formatting
0x1
Top items are displayed with the conditional formatting
-
B - fPercent (1 bit): A bit that specifies whether a percentage of top or bottom items are displayed with the conditional formatting, or a set number of top or bottom items are displayed with the conditional formatting. MUST be one of the following values:
-
Value
Meaning
0x0
Top or bottom iParam items are displayed with the conditional formatting.
0x1
Top or bottom iParam percent of items are displayed with the conditional formatting
reserved2 (6 bits): MUST be zero and MUST be ignored.
iParam (2 bytes): An unsigned integer that specifies how many values are displayed with the conditional formatting. If fPercent is set to 1 then this field represents a percent and MUST be less than or equal to 100, otherwise this field is a number of cells and MUST be less than or equal to 1000.