xlsvalidation-j9官方网址

com.spire.xls.core.spreadsheet
class xlsvalidation

java.lang.object
  com.spire.xls.core.spreadsheet.xlsvalidation

all implemented interfaces:

idatavalidation, ioptimizedupdate

public class xlsvalidation
extends java.lang.object
implements idatavalidation

represents data validation for a worksheet range.

xlsvalidation

public xlsvalidation(xlsdatavalidationcollection parent)

getinputtitle

public java.lang.string getinputtitle()

description copied from interface: idatavalidation

title of the prompt box.

specified by:

getinputtitle in interface idatavalidation

setinputtitle

public void setinputtitle(java.lang.string value)

description copied from interface: idatavalidation

title of the prompt box.

specified by:

setinputtitle in interface idatavalidation

getinputmessage

public java.lang.string getinputmessage()

description copied from interface: idatavalidation

text of the prompt box.

specified by:

getinputmessage in interface idatavalidation

setinputmessage

public void setinputmessage(java.lang.string value)

description copied from interface: idatavalidation

text of the prompt box.

specified by:

setinputmessage in interface idatavalidation

geterrortitle

public java.lang.string geterrortitle()

description copied from interface: idatavalidation

title of the error box.

specified by:

geterrortitle in interface idatavalidation

seterrortitle

public void seterrortitle(java.lang.string value)

description copied from interface: idatavalidation

title of the error box.

specified by:

seterrortitle in interface idatavalidation

geterrormessage

public java.lang.string geterrormessage()

description copied from interface: idatavalidation

text of the error message.

specified by:

geterrormessage in interface idatavalidation

seterrormessage

public void seterrormessage(java.lang.string value)

description copied from interface: idatavalidation

text of the error message.

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 value)

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 value)

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 value)

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 value)

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

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

getshapescount

public int getshapescount()

gets number of required shapes objects.

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 value)

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 value)

specified by:

setalertstyle in interface idatavalidation

getvalues

public java.lang.string[] getvalues()

if this is data validation list, then gets / sets array of all possible values.

specified by:

getvalues in interface idatavalidation

setvalues

public void setvalues(java.lang.string[] value)

if this is data validation list, then gets / sets array of all possible values.

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)

addrange

public void addrange(xlsvalidation dv)

parameters:

dv -

addrange

public void addrange(xlsrange range)

adds range to the collection.

parameters:

range - range to add.

removerange

public void removerange(java.awt.rectangle[] rectangles)

removes ranges from collection.

parameters:

rectangles - ranges to remove.

removerange

public void removerange(xlsrange range)

removes range from collection.

parameters:

range - range to remove.

getworksheet

public xlsworksheet getworksheet()

parent worksheet.

containscell

public boolean containscell(long lcellindex)

indicates whether this object contains data validation settings for cell with specified index.

parameters:

lcellindex - cell index to search.

returns:

true if this object contains data validation settings for cell with specified index.

getparent

public java.lang.object getparent()

parent object for this object.

getparentcollection

public xlsdatavalidationcollection getparentcollection()

gets / sets parent data validation collection.