2.5.26 CFExFilterParams
The CFExFilterParams structure specifies parameters for a conditional formatting rule of type filter.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
A |
B |
reserved1 |
iParam |
reserved2 (13 bytes) |
|||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
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 the top or bottom items are displayed with the conditional formatting, or whether a set number of the top or bottom items are displayed with the conditional formatting. MUST be one of the following values:
-
Value
Meaning
0x0
A set number of top or bottom items, specified by iParam, are displayed with the conditional formatting.
0x1
A percentage of top or bottom items, specified by iParam, are displayed with the conditional formatting
reserved1 (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 equals 1 then this field represents a percent and MUST be less than or equal to 100. Otherwise, this field represents a set number of cells and MUST be less than or equal to 1000.
reserved2 (13 bytes): MUST be zero and MUST be ignored.