2.5.292 XlsFilter_Top10

Office

The XlsFilter_Top10 structure specifies filter information for a 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

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.

Show: