2.5.5 AFDOper
The AFDOper structure specifies an AutoFilter data operation.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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.