2.5.5 AFDOper

Office

The AFDOper structure specifies an AutoFilter data operation.


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

vt

grbitSign

vtValue

...

...

vt (1 byte): An unsigned integer that specifies the type of comparison. MUST be a value as specified in the table listed under vtValue. If this structure is part of an AutoFilter12 record, the value of vt MUST NOT be 0x02.

grbitSign (1 byte): An unsigned integer that specifies the comparison operation between a cell value and vtValue. MUST be one of the following values:

Value

Meaning

0x01

Cell value is displayed if it is less than the value specified in vtValue.

0x02

Cell value is displayed if it is equal to the value specified in vtValue.

0x03

Cell value is displayed if it is less than or equal to the value specified in vtValue.

0x04

Cell value is displayed if it is greater than the value specified in vtValue.

0x05

Cell value is displayed if it is not equal to the value specified in vtValue.

0x06

Cell value is displayed if it is greater than or equal to the value specified in vtValue.

If vt is equal to 0x00, this field is undefined and MUST be ignored.

vtValue (8 bytes):  A variable type field whose type and meaning is dictated by the value of vt, as specified in the following table:

Value of vt

Meaning of vtValue

0x00

vtValue is 8 bytes which are undefined and MUST be ignored.

0x02

vtValue is an AFDOperRk that specifies a numeric value. MUST exist if and only if this structure is part of an AutoFilter record.

0x04

vtValue is an Xnum (section 2.5.342) that specifies a numeric value.

0x06

vtValue is an AFDOperStr that specifies a string value.

0x08

vtValue is an AFDOperBoolErr that specifies a Boolean or error value.

0x0C

All blanks are matched. vtValue is 8 bytes which are reserved, MUST be 0, and MUST be ignored.

0x0E

All non-blanks are matched. vtValue is 8 bytes which are reserved, MUST be 0, and MUST be ignored.

Show: