xlsvalidationwrapper-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.spreadsheet
class xlsvalidationwrapper

java.lang.object
  extended by com.spire.xls.core.spreadsheet.commonwrapper
      extended by com.spire.xls.core.spreadsheet.xlsvalidationwrapper
all implemented interfaces:
idatavalidation, ioptimizedupdate
direct known subclasses:
validation
public class xlsvalidationwrapper
extends commonwrapper
implements idatavalidation
constructor summary
xlsvalidationwrapper(xlsrange range, xlsvalidation wrap)
           
xlsvalidationwrapper(xlsrange range, xlsvalidation wrap, boolean readonly)
           
 
method summary
 alertstyletype getalertstyle()
           
 celldatatype getallowtype()
          type of the allowed data.
 validationcomparisonoperator getcompareoperator()
          compare operator used.
 ixlsrange getdatarange()
          range of possible values.
 java.util.date getdate1()
          first formula's datetime value.
 java.util.date getdate2()
          second formula's datetime value.
 java.lang.string geterrormessage()
          message of the error box.
 java.lang.string geterrortitle()
          title of the error box.
 java.lang.string getformula1()
          value of the first formula.
 java.lang.string getformula2()
          value of the second formula.
 boolean getignoreblank()
          indicates whether empty cell is allowed.
 java.lang.string getinputmessage()
          message of the input box.
 java.lang.string getinputtitle()
          title of the input box.
 java.lang.object getparent()
           
 int getpromptboxhposition()
          horizontal position of the prompt box.
 int getpromptboxvposition()
          vertical position of the prompt box.
 boolean getshowerror()
          indicates whether to show error box.
 boolean getshowinput()
          indicates whether to show prompt box.
 java.lang.string[] getvalues()
          array of possible values (when values in list are entered manually)
 boolean isinputpositionfixed()
           
 void isinputpositionfixed(boolean value)
           
 boolean isinputvisible()
           
 void isinputvisible(boolean value)
           
 boolean islistinformula()
          indicates whether formula contains list of values.
 void islistinformula(boolean value)
           
 boolean issuppressdropdownarrow()
          indicates whether to suppress drop-down arrow.
 void issuppressdropdownarrow(boolean value)
          indicates whether to suppress drop-down arrow.
 void setalertstyle(alertstyletype alertstyle)
           
 void setallowtype(celldatatype allowtype)
          type of the allowed data.
 void setcompareoperator(validationcomparisonoperator compareoperator)
          compare operator used.
 void setdatarange(ixlsrange value)
           
 void setdate1(java.util.date value)
          first formula's datetime value.
 void setdate2(java.util.date value)
          second formula's datetime value.
 void seterrormessage(java.lang.string errormessage)
          sets message of the error box.
 void seterrortitle(java.lang.string value)
          title of the error box.
 void setformula1(java.lang.string formula1)
          value of the first formula.
 void setformula2(java.lang.string formula2)
          value of the second formula.
 void setignoreblank(boolean value)
          indicates whether empty cell is allowed.
 void setinputmessage(java.lang.string value)
          message of the input box.
 void setinputtitle(java.lang.string value)
          title of the input box.
 void setpromptboxhposition(int value)
          horizontal position of the prompt box.
 void setpromptboxvposition(int value)
          vertical position of the prompt box.
 void setshowerror(boolean showerror)
          indicates whether to show error box.
 void setshowinput(boolean value)
          indicates whether to show prompt box.
 void setvalues(java.lang.string[] value)
           
 
methods inherited from class com.spire.xls.core.spreadsheet.commonwrapper
beginupdate, endupdate
 
methods inherited from interface com.spire.xls.core.interfacess.ioptimizedupdate
beginupdate, endupdate
 
constructor detail

xlsvalidationwrapper

public xlsvalidationwrapper(xlsrange range,
                            xlsvalidation wrap)

xlsvalidationwrapper

public xlsvalidationwrapper(xlsrange range,
                            xlsvalidation wrap,
                            boolean readonly)
method detail

getparent

public java.lang.object getparent()

getinputtitle

public java.lang.string getinputtitle()
title of the input box.
specified by:
getinputtitle in interface idatavalidation

setinputtitle

public void setinputtitle(java.lang.string value)
title of the input box.
specified by:
setinputtitle in interface idatavalidation

getinputmessage

public java.lang.string getinputmessage()
message of the input box.
specified by:
getinputmessage in interface idatavalidation

setinputmessage

public void setinputmessage(java.lang.string value)
message of the input box.
specified by:
setinputmessage in interface idatavalidation

geterrortitle

public java.lang.string geterrortitle()
title of the error box.
specified by:
geterrortitle in interface idatavalidation

seterrortitle

public void seterrortitle(java.lang.string value)
title of the error box.
specified by:
seterrortitle in interface idatavalidation

geterrormessage

public java.lang.string geterrormessage()
message of the error box.
specified by:
geterrormessage in interface idatavalidation

seterrormessage

public void seterrormessage(java.lang.string errormessage)
sets message of the error box.
specified by:
seterrormessage in interface idatavalidation

getformula1

public java.lang.string getformula1()
description copied from interface: idatavalidation
value of the first formula.
specified by:
getformula1 in interface idatavalidation

setformula1

public void setformula1(java.lang.string formula1)
description copied from interface: idatavalidation
value of the first formula.
specified by:
setformula1 in interface idatavalidation

getdate1

public java.util.date getdate1()
first formula's datetime value.
specified by:
getdate1 in interface idatavalidation

setdate1

public void setdate1(java.util.date value)
first formula's datetime value.
specified by:
setdate1 in interface idatavalidation

getformula2

public java.lang.string getformula2()
description copied from interface: idatavalidation
value of the second formula.
specified by:
getformula2 in interface idatavalidation

setformula2

public void setformula2(java.lang.string formula2)
description copied from interface: idatavalidation
value of the second formula.
specified by:
setformula2 in interface idatavalidation

getdate2

public java.util.date getdate2()
second formula's datetime value.
specified by:
getdate2 in interface idatavalidation

setdate2

public void setdate2(java.util.date value)
second formula's datetime value.
specified by:
setdate2 in interface idatavalidation

getallowtype

public celldatatype getallowtype()
description copied from interface: idatavalidation
type of the allowed data.
specified by:
getallowtype in interface idatavalidation

setallowtype

public void setallowtype(celldatatype allowtype)
description copied from interface: idatavalidation
type of the allowed data.
specified by:
setallowtype in interface idatavalidation

getcompareoperator

public validationcomparisonoperator getcompareoperator()
description copied from interface: idatavalidation
compare operator used.
specified by:
getcompareoperator in interface idatavalidation

setcompareoperator

public void setcompareoperator(validationcomparisonoperator compareoperator)
description copied from interface: idatavalidation
compare operator used.
specified by:
setcompareoperator in interface idatavalidation

islistinformula

public boolean islistinformula()
description copied from interface: idatavalidation
indicates whether formula contains list of values.
specified by:
islistinformula in interface idatavalidation

islistinformula

public void islistinformula(boolean value)

getignoreblank

public boolean getignoreblank()
description copied from interface: idatavalidation
indicates whether empty cell is allowed.
specified by:
getignoreblank in interface idatavalidation

setignoreblank

public void setignoreblank(boolean value)
description copied from interface: idatavalidation
indicates whether empty cell is allowed.
specified by:
setignoreblank in interface idatavalidation

issuppressdropdownarrow

public boolean issuppressdropdownarrow()
description copied from interface: idatavalidation
indicates whether to suppress drop-down arrow.
specified by:
issuppressdropdownarrow in interface idatavalidation

issuppressdropdownarrow

public void issuppressdropdownarrow(boolean value)
description copied from interface: idatavalidation
indicates whether to suppress drop-down arrow.
specified by:
issuppressdropdownarrow in interface idatavalidation

getshowinput

public boolean getshowinput()
description copied from interface: idatavalidation
indicates whether to show prompt box.
specified by:
getshowinput in interface idatavalidation

setshowinput

public void setshowinput(boolean value)
description copied from interface: idatavalidation
indicates whether to show prompt box.
specified by:
setshowinput in interface idatavalidation

getshowerror

public boolean getshowerror()
description copied from interface: idatavalidation
indicates whether to show error box.
specified by:
getshowerror in interface idatavalidation

setshowerror

public void setshowerror(boolean showerror)
description copied from interface: idatavalidation
indicates whether to show error box.
specified by:
setshowerror in interface idatavalidation

getpromptboxhposition

public int getpromptboxhposition()
description copied from interface: idatavalidation
horizontal position of the prompt box.
specified by:
getpromptboxhposition in interface idatavalidation

setpromptboxhposition

public void setpromptboxhposition(int value)
description copied from interface: idatavalidation
horizontal position of the prompt box.
specified by:
setpromptboxhposition in interface idatavalidation

getpromptboxvposition

public int getpromptboxvposition()
description copied from interface: idatavalidation
vertical position of the prompt box.
specified by:
getpromptboxvposition in interface idatavalidation

setpromptboxvposition

public void setpromptboxvposition(int value)
description copied from interface: idatavalidation
vertical position of the prompt box.
specified by:
setpromptboxvposition in interface idatavalidation

isinputvisible

public boolean isinputvisible()
specified by:
isinputvisible in interface idatavalidation

isinputvisible

public void isinputvisible(boolean value)
specified by:
isinputvisible in interface idatavalidation

isinputpositionfixed

public boolean isinputpositionfixed()
specified by:
isinputpositionfixed in interface idatavalidation

isinputpositionfixed

public void isinputpositionfixed(boolean value)
specified by:
isinputpositionfixed in interface idatavalidation

getalertstyle

public alertstyletype getalertstyle()
specified by:
getalertstyle in interface idatavalidation

setalertstyle

public void setalertstyle(alertstyletype alertstyle)
specified by:
setalertstyle in interface idatavalidation

getvalues

public java.lang.string[] getvalues()
description copied from interface: idatavalidation
array of possible values (when values in list are entered manually)
specified by:
getvalues in interface idatavalidation

setvalues

public void setvalues(java.lang.string[] value)
specified by:
setvalues in interface idatavalidation

getdatarange

public ixlsrange getdatarange()
description copied from interface: idatavalidation
range of possible values.
specified by:
getdatarange in interface idatavalidation

setdatarange

public void setdatarange(ixlsrange value)
overview  package   class  tree  deprecated  index  help 
 prev class   next class frames    no frames    
summary: nested | field | constr | method detail: field | constr | method
网站地图