filtercolumn-ag凯发旗舰厅



com.spire.xls.core.spreadsheet.autofilter
class filtercolumn

java.lang.object
  extended by com.spire.xls.core.spreadsheet.autofilter.filtercolumn
all implemented interfaces:
iautofilter

public class filtercolumn
extends java.lang.object
implements iautofilter

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

filtercolumn

public filtercolumn( filtercolumns,
                    int fieldindex)

filtercolumn

public filtercolumn( filtercolumns,
                    int fieldindex,
                    boolean hiddenbutton,
                    boolean showbutton)
method detail

getvisibledropdown

public boolean getvisibledropdown()
indicates whether the autofilter button for this column is visible.

setvisibledropdown

public void setvisibledropdown(boolean value)
indicates whether the autofilter button for this column is visible.

getfilter

public java.lang.object getfilter()

setfilter

public void setfilter(java.lang.object value)

getfiltertype

public filtertype getfiltertype()

setfiltertype

public void setfiltertype(filtertype value)

getfieldindex

public int getfieldindex()

setfieldindex

public void setfieldindex(int value)

gettop10items

public int gettop10items()
number of items display in top10items mode.
specified by:
gettop10items in interface iautofilter

settop10items

public void settop10items(int value)
number of items display in top10items mode.
specified by:
settop10items in interface iautofilter

istop10items

public boolean istop10items()
highest-valued 10 items displayed
specified by:
istop10items in interface iautofilter

istop10items

public void istop10items(boolean value)
description copied from interface: iautofilter
true if the first condition is a simple equality. read-only.
specified by:
istop10items in interface iautofilter

getshowtopitem

public boolean getshowtopitem()
description copied from interface: iautofilter
true if the top 10 autofilter shows the top items; false if it shows the bottom items. read-only.
specified by:
getshowtopitem in interface iautofilter

setshowtopitem

public void setshowtopitem(boolean value)
description copied from interface: iautofilter
true if the first condition is a simple equality. read-only.
specified by:
setshowtopitem in interface iautofilter

issimple2

public boolean issimple2()
true if the second condition is a simple equality.
specified by:
issimple2 in interface iautofilter

issimple2

public void issimple2(boolean value)
description copied from interface: iautofilter
true if the first condition is a simple equality. read-only.
specified by:
issimple2 in interface iautofilter

issimple1

public boolean issimple1()
true if the first condition is a simple equality.
specified by:
issimple1 in interface iautofilter

issimple1

public void issimple1(boolean value)
description copied from interface: iautofilter
true if the first condition is a simple equality. read-only.
specified by:
issimple1 in interface iautofilter

istop10percent

public boolean istop10percent()
highest-valued 10 items displayed (percentage specified in condition)
specified by:
istop10percent in interface iautofilter

istop10percent

public void istop10percent(boolean value)
description copied from interface: iautofilter
true if the top 10 autofilter shows percentage; false if it shows items. read-only.
specified by:
istop10percent in interface iautofilter

isand

public boolean isand()
logical and of firstcondtion and secondcondition.
specified by:
isand in interface iautofilter

isand

public void isand(boolean value)
description copied from interface: iautofilter
true means to use and operation between conditions, false to use or. read-only.
specified by:
isand in interface iautofilter

isfiltered

public boolean isfiltered()
description copied from interface: iautofilter
false indicates that this autofilter was not used; otherwise true.
specified by:
isfiltered in interface iautofilter

getsecondcondition

public iautofiltercondition getsecondcondition()
second condition of autofilter.
specified by:
getsecondcondition in interface iautofilter

getfirstcondition

public iautofiltercondition getfirstcondition()
first condition of autofilter.
specified by:
getfirstcondition in interface iautofilter

hasfirstcondition

public boolean hasfirstcondition()
first condition used.

hassecondcondition

public boolean hassecondcondition()
second condition used


网站地图