class DataValidation (View source)

Constants

TYPE_NONE

TYPE_CUSTOM

TYPE_DATE

TYPE_DECIMAL

TYPE_LIST

TYPE_TEXTLENGTH

TYPE_TIME

TYPE_WHOLE

STYLE_STOP

STYLE_WARNING

STYLE_INFORMATION

OPERATOR_BETWEEN

OPERATOR_EQUAL

OPERATOR_GREATERTHAN

OPERATOR_GREATERTHANOREQUAL

OPERATOR_LESSTHAN

OPERATOR_LESSTHANOREQUAL

OPERATOR_NOTBETWEEN

OPERATOR_NOTEQUAL

Methods

__construct()

Create a new DataValidation.

string
getFormula1()

Get Formula 1.

setFormula1(string $value)

Set Formula 1.

string
getFormula2()

Get Formula 2.

setFormula2(string $value)

Set Formula 2.

string
getType()

Get Type.

setType(string $value)

Set Type.

string
getErrorStyle()

Get Error style.

setErrorStyle(string $value)

Set Error style.

string
getOperator()

Get Operator.

setOperator(string $value)

Set Operator.

bool
getAllowBlank()

Get Allow Blank.

setAllowBlank(bool $value)

Set Allow Blank.

bool
getShowDropDown()

Get Show DropDown.

setShowDropDown(bool $value)

Set Show DropDown.

bool
getShowInputMessage()

Get Show InputMessage.

setShowInputMessage(bool $value)

Set Show InputMessage.

bool
getShowErrorMessage()

Get Show ErrorMessage.

setShowErrorMessage(bool $value)

Set Show ErrorMessage.

string
getErrorTitle()

Get Error title.

setErrorTitle(string $value)

Set Error title.

string
getError()

Get Error.

setError(string $value)

Set Error.

string
getPromptTitle()

Get Prompt title.

setPromptTitle(string $value)

Set Prompt title.

string
getPrompt()

Get Prompt.

setPrompt(string $value)

Set Prompt.

string
getHashCode()

Get hash code.

__clone()

Implement PHP __clone to create a deep clone, not just a shallow copy.

Details

__construct()

Create a new DataValidation.

string getFormula1()

Get Formula 1.

Return Value

string

DataValidation setFormula1(string $value)

Set Formula 1.

Parameters

string $value

Return Value

DataValidation

string getFormula2()

Get Formula 2.

Return Value

string

DataValidation setFormula2(string $value)

Set Formula 2.

Parameters

string $value

Return Value

DataValidation

string getType()

Get Type.

Return Value

string

DataValidation setType(string $value)

Set Type.

Parameters

string $value

Return Value

DataValidation

string getErrorStyle()

Get Error style.

Return Value

string

DataValidation setErrorStyle(string $value)

Set Error style.

Parameters

string $value see self::STYLE_*

Return Value

DataValidation

string getOperator()

Get Operator.

Return Value

string

DataValidation setOperator(string $value)

Set Operator.

Parameters

string $value

Return Value

DataValidation

bool getAllowBlank()

Get Allow Blank.

Return Value

bool

DataValidation setAllowBlank(bool $value)

Set Allow Blank.

Parameters

bool $value

Return Value

DataValidation

bool getShowDropDown()

Get Show DropDown.

Return Value

bool

DataValidation setShowDropDown(bool $value)

Set Show DropDown.

Parameters

bool $value

Return Value

DataValidation

bool getShowInputMessage()

Get Show InputMessage.

Return Value

bool

DataValidation setShowInputMessage(bool $value)

Set Show InputMessage.

Parameters

bool $value

Return Value

DataValidation

bool getShowErrorMessage()

Get Show ErrorMessage.

Return Value

bool

DataValidation setShowErrorMessage(bool $value)

Set Show ErrorMessage.

Parameters

bool $value

Return Value

DataValidation

string getErrorTitle()

Get Error title.

Return Value

string

DataValidation setErrorTitle(string $value)

Set Error title.

Parameters

string $value

Return Value

DataValidation

string getError()

Get Error.

Return Value

string

DataValidation setError(string $value)

Set Error.

Parameters

string $value

Return Value

DataValidation

string getPromptTitle()

Get Prompt title.

Return Value

string

DataValidation setPromptTitle(string $value)

Set Prompt title.

Parameters

string $value

Return Value

DataValidation

string getPrompt()

Get Prompt.

Return Value

string

DataValidation setPrompt(string $value)

Set Prompt.

Parameters

string $value

Return Value

DataValidation

string getHashCode()

Get hash code.

Return Value

string Hash code

__clone()

Implement PHP __clone to create a deep clone, not just a shallow copy.