iautofilter-ag凯发旗舰厅

overview

package

class

tree

deprecated

index

help

prev class next class

frames no frames

summary: nested | field | constr | method

detail: field | constr | method

com.spire.xls.core
interface iautofilter

represents autofiltering for the specified worksheet..

method summary
`iautofiltercondition`	`getfirstcondition()` first condition of autofilter.
`iautofiltercondition`	`getsecondcondition()` second condition of autofilter.
`boolean`	`getshowtopitem()` true if the top 10 autofilter shows the top items; false if it shows the bottom items.
`int`	`gettop10items()` number of elements to show in top10 mode.
`boolean`	`isand()` true means to use and operation between conditions, false to use or.
`void`	`isand(boolean value)` true means to use and operation between conditions, false to use or.
`boolean`	`isfiltered()` false indicates that this autofilter was not used; otherwise true.
`boolean`	`issimple1()` true if the first condition is a simple equality.
`void`	`issimple1(boolean value)` true if the first condition is a simple equality.
`boolean`	`issimple2()` true if the second condition is a simple equality.
`void`	`issimple2(boolean value)` true if the first condition is a simple equality.
`boolean`	`istop10items()` true if the condition is a top 10 autofilter.
`void`	`istop10items(boolean value)` true if the first condition is a simple equality.
`boolean`	`istop10percent()` true if the top 10 autofilter shows percentage; false if it shows items.
`void`	`istop10percent(boolean value)` true if the top 10 autofilter shows percentage; false if it shows items.
`void`	`setshowtopitem(boolean value)` true if the first condition is a simple equality.
`void`	`settop10items(int value)` true if the first condition is a simple equality.

method detail

iautofiltercondition getfirstcondition()

first condition of autofilter.

iautofiltercondition getsecondcondition()

second condition of autofilter.

boolean isfiltered()

false indicates that this autofilter was not used; otherwise true.

boolean isand()

true means to use and operation between conditions, false to use or. read-only.

void isand(boolean value)

true means to use and operation between conditions, false to use or. read-only.

boolean istop10percent()

true if the top 10 autofilter shows percentage; false if it shows items. read-only.

void istop10percent(boolean value)

true if the top 10 autofilter shows percentage; false if it shows items. read-only.