2.5.26 CFExFilterParams

The CFExFilterParams structure specifies parameters for a conditional formatting rule of type filter.


0


1


2


3


4


5


6


7


8


9

1
0


1


2


3


4


5


6


7


8


9

2
0


1


2


3


4


5


6


7


8


9

3
0


1

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.