2.5.30 CFFilter

The CFFilter structure specifies the parameters of a conditional formatting rule of type top N 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
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.