idatavalidation-ag凯发旗舰厅

com.spire.xls.core
interface idatavalidation

all superinterfaces:

ioptimizedupdate

all known implementing classes:

validation, xlsvalidation, xlsvalidationwrapper

public interface idatavalidation
extends ioptimizedupdate

contains a condition and the formatting attributes applied to the cells, if the condition is met.

getinputtitle

java.lang.string getinputtitle()

title of the prompt box.

setinputtitle

void setinputtitle(java.lang.string value)

title of the prompt box.

getinputmessage

java.lang.string getinputmessage()

text of the prompt box.

setinputmessage

void setinputmessage(java.lang.string value)

text of the prompt box.

geterrortitle

java.lang.string geterrortitle()

title of the error box.

seterrortitle

void seterrortitle(java.lang.string value)

title of the error box.

geterrormessage

java.lang.string geterrormessage()

text of the error message.

seterrormessage

void seterrormessage(java.lang.string value)

text of the error message.

getformula1

java.lang.string getformula1()

value of the first formula.

setformula1

void setformula1(java.lang.string value)

value of the first formula.

getdate1

java.util.date getdate1()

first formula's datetime value.

setdate1

void setdate1(java.util.date value)

first formula's datetime value.

getformula2

java.lang.string getformula2()

value of the second formula.

setformula2

void setformula2(java.lang.string value)

value of the second formula.

getdate2

java.util.date getdate2()

second formula's datetime value.

setdate2

void setdate2(java.util.date value)

second formula's datetime value.

getallowtype

celldatatype getallowtype()

type of the allowed data.

setallowtype

void setallowtype(celldatatype value)

type of the allowed data.

getcompareoperator

validationcomparisonoperator getcompareoperator()

compare operator used.

setcompareoperator

void setcompareoperator(validationcomparisonoperator value)

compare operator used.

islistinformula

boolean islistinformula()

indicates whether formula contains list of values.

getignoreblank

boolean getignoreblank()

indicates whether empty cell is allowed.

setignoreblank

void setignoreblank(boolean value)

indicates whether empty cell is allowed.

issuppressdropdownarrow

boolean issuppressdropdownarrow()

indicates whether to suppress drop-down arrow.

issuppressdropdownarrow

void issuppressdropdownarrow(boolean value)

indicates whether to suppress drop-down arrow.

getshowinput

boolean getshowinput()

indicates whether to show prompt box.

setshowinput

void setshowinput(boolean value)

indicates whether to show prompt box.

getshowerror

boolean getshowerror()

indicates whether to show error box.

setshowerror

void setshowerror(boolean value)

indicates whether to show error box.

getpromptboxhposition

int getpromptboxhposition()

horizontal position of the prompt box.

setpromptboxhposition

void setpromptboxhposition(int value)

horizontal position of the prompt box.

getpromptboxvposition

int getpromptboxvposition()

vertical position of the prompt box.

setpromptboxvposition

void setpromptboxvposition(int value)

vertical position of the prompt box.

isinputvisible

boolean isinputvisible()

isinputvisible

void isinputvisible(boolean value)

isinputpositionfixed

boolean isinputpositionfixed()

isinputpositionfixed

void isinputpositionfixed(boolean value)

getalertstyle

alertstyletype getalertstyle()

setalertstyle

void setalertstyle(alertstyletype value)

getvalues

java.lang.string[] getvalues()

array of possible values (when values in list are entered manually)

setvalues

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

getdatarange

ixlsrange getdatarange()

range of possible values.