2.5.292 XlsFilter_Top10
The XlsFilter_Top10 structure specifies filter information for a top N filter.
|
|
|
|
|
|
|
|
|
|
1 |
|
|
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
|
3 |
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
top10ft |
|||||||||||||||||||||||||||||||
|
A |
reserved1 |
numTopN |
|||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
reserved2 (14 bytes) |
||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
|
... |
|||||||||||||||||||||||||||||||
top10ft (4 bytes): A Top10FT that specifies the top N filter type.
A - fTop (1 bit): A bit that specifies whether the filter displays the top or bottom records.
-
Value
Meaning
0
Display the bottom records.
1
Display the top records.
reserved1 (15 bits): MUST be zero, and MUST be ignored.
numTopN (8 bytes): An Xnum (section 2.5.342) that specifies the number or percentage of records to include.
If top10Ft is TOP10FTPERCENT, numTopN specifies the percentage of records to include; otherwise numTopN specifies the number of records to include.
If top10ft is TOP10FTPERCENT, numTopN MUST be greater than or equal to 0 and less than or equal to 100.
If top10ft is TOP10FTSUM, numTopN MUST be greater than or equal to 0 and less than or equal to 2147483647.
If top10ft is TOP10FTCOUNT, numTopN MUST be an integer greater than or equal to 0 and less than or equal to 2147483647.
reserved2 (14 bytes): MUST be zero, and MUST be ignored.