|
|||||||||
| prev class next class | frames no frames | ||||||||
| summary: nested | field | constr | method | detail: field | constr | method | ||||||||
java.lang.objectcom.spire.xls.core.spreadsheet.autofilter.filtercolumn
public class filtercolumn
| constructor summary | |
|---|---|
filtercolumn( filtercolumns,
int fieldindex)
|
|
filtercolumn( filtercolumns,
int fieldindex,
boolean hiddenbutton,
boolean showbutton)
|
|
| method summary | |
|---|---|
int |
getfieldindex()
|
java.lang.object |
getfilter()
|
filtertype |
getfiltertype()
|
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 items display in top10items mode. |
boolean |
getvisibledropdown()
indicates whether the autofilter button for this column is visible. |
boolean |
hasfirstcondition()
first condition used. |
boolean |
hassecondcondition()
second condition used |
boolean |
isand()
logical and of firstcondtion and secondcondition. |
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()
highest-valued 10 items displayed |
void |
istop10items(boolean value)
true if the first condition is a simple equality. |
boolean |
istop10percent()
highest-valued 10 items displayed (percentage specified in condition) |
void |
istop10percent(boolean value)
true if the top 10 autofilter shows percentage; false if it shows items. |
void |
setfieldindex(int value)
|
void |
setfilter(java.lang.object value)
|
void |
setfiltertype(filtertype value)
|
void |
setshowtopitem(boolean value)
true if the first condition is a simple equality. |
void |
settop10items(int value)
number of items display in top10items mode. |
void |
setvisibledropdown(boolean value)
indicates whether the autofilter button for this column is visible. |
| constructor detail |
|---|
public filtercolumn( filtercolumns,
int fieldindex)
public filtercolumn( filtercolumns,
int fieldindex,
boolean hiddenbutton,
boolean showbutton)
| method detail |
|---|
public boolean getvisibledropdown()
public void setvisibledropdown(boolean value)
public java.lang.object getfilter()
public void setfilter(java.lang.object value)
public filtertype getfiltertype()
public void setfiltertype(filtertype value)
public int getfieldindex()
public void setfieldindex(int value)
public int gettop10items()
gettop10items in interface iautofilterpublic void settop10items(int value)
settop10items in interface iautofilterpublic boolean istop10items()
istop10items in interface iautofilterpublic void istop10items(boolean value)
iautofilteristop10items in interface iautofilterpublic boolean getshowtopitem()
iautofiltergetshowtopitem in interface iautofilterpublic void setshowtopitem(boolean value)
iautofiltersetshowtopitem in interface iautofilterpublic boolean issimple2()
issimple2 in interface iautofilterpublic void issimple2(boolean value)
iautofilterissimple2 in interface iautofilterpublic boolean issimple1()
issimple1 in interface iautofilterpublic void issimple1(boolean value)
iautofilterissimple1 in interface iautofilterpublic boolean istop10percent()
istop10percent in interface iautofilterpublic void istop10percent(boolean value)
iautofilteristop10percent in interface iautofilterpublic boolean isand()
isand in interface iautofilterpublic void isand(boolean value)
iautofilterisand in interface iautofilterpublic boolean isfiltered()
iautofilterisfiltered in interface iautofilterpublic iautofiltercondition getsecondcondition()
getsecondcondition in interface iautofilterpublic iautofiltercondition getfirstcondition()
getfirstcondition in interface iautofilterpublic boolean hasfirstcondition()
public boolean hassecondcondition()
|
|||||||||
| prev class next class | frames no frames | ||||||||
| summary: nested | field | constr | method | detail: field | constr | method | ||||||||