Constants

TYPE_NONE

TYPE_NONE = 'none'

TYPE_CUSTOM

TYPE_CUSTOM = 'custom'

TYPE_DATE

TYPE_DATE = 'date'

TYPE_DECIMAL

TYPE_DECIMAL = 'decimal'

TYPE_LIST

TYPE_LIST = 'list'

TYPE_TEXTLENGTH

TYPE_TEXTLENGTH = 'textLength'

TYPE_TIME

TYPE_TIME = 'time'

TYPE_WHOLE

TYPE_WHOLE = 'whole'

STYLE_STOP

STYLE_STOP = 'stop'

STYLE_WARNING

STYLE_WARNING = 'warning'

STYLE_INFORMATION

STYLE_INFORMATION = 'information'

OPERATOR_BETWEEN

OPERATOR_BETWEEN = 'between'

OPERATOR_EQUAL

OPERATOR_EQUAL = 'equal'

OPERATOR_GREATERTHAN

OPERATOR_GREATERTHAN = 'greaterThan'

OPERATOR_GREATERTHANOREQUAL

OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual'

OPERATOR_LESSTHAN

OPERATOR_LESSTHAN = 'lessThan'

OPERATOR_LESSTHANOREQUAL

OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual'

OPERATOR_NOTBETWEEN

OPERATOR_NOTBETWEEN = 'notBetween'

OPERATOR_NOTEQUAL

OPERATOR_NOTEQUAL = 'notEqual'

Properties

$_formula1

$_formula1 : string

Formula 1

Type

string

$_formula2

$_formula2 : string

Formula 2

Type

string

$_type

$_type : string

Type

Type

string

$_errorStyle

$_errorStyle : string

Error style

Type

string

$_operator

$_operator : string

Operator

Type

string

$_allowBlank

$_allowBlank : boolean

Allow Blank

Type

boolean

$_showDropDown

$_showDropDown : boolean

Show DropDown

Type

boolean

$_showInputMessage

$_showInputMessage : boolean

Show InputMessage

Type

boolean

$_showErrorMessage

$_showErrorMessage : boolean

Show ErrorMessage

Type

boolean

$_errorTitle

$_errorTitle : string

Error title

Type

string

$_error

$_error : string

Error

Type

string

$_promptTitle

$_promptTitle : string

Prompt title

Type

string

$_prompt

$_prompt : string

Prompt

Type

string

Methods

__construct()

__construct() 

Create a new PHPExcel_Cell_DataValidation

getFormula1()

getFormula1() : string

Get Formula 1

Returns

string

setFormula1()

setFormula1(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Formula 1

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getFormula2()

getFormula2() : string

Get Formula 2

Returns

string

setFormula2()

setFormula2(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Formula 2

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getType()

getType() : string

Get Type

Returns

string

setType()

setType(string  $value = \PHPExcel_Cell_DataValidation::TYPE_NONE) : \PHPExcel_Cell_DataValidation

Set Type

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getErrorStyle()

getErrorStyle() : string

Get Error style

Returns

string

setErrorStyle()

setErrorStyle(string  $value = \PHPExcel_Cell_DataValidation::STYLE_STOP) : \PHPExcel_Cell_DataValidation

Set Error style

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getOperator()

getOperator() : string

Get Operator

Returns

string

setOperator()

setOperator(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Operator

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getAllowBlank()

getAllowBlank() : boolean

Get Allow Blank

Returns

boolean

setAllowBlank()

setAllowBlank(boolean  $value = false) : \PHPExcel_Cell_DataValidation

Set Allow Blank

Parameters

boolean $value

Returns

\PHPExcel_Cell_DataValidation

getShowDropDown()

getShowDropDown() : boolean

Get Show DropDown

Returns

boolean

setShowDropDown()

setShowDropDown(boolean  $value = false) : \PHPExcel_Cell_DataValidation

Set Show DropDown

Parameters

boolean $value

Returns

\PHPExcel_Cell_DataValidation

getShowInputMessage()

getShowInputMessage() : boolean

Get Show InputMessage

Returns

boolean

setShowInputMessage()

setShowInputMessage(boolean  $value = false) : \PHPExcel_Cell_DataValidation

Set Show InputMessage

Parameters

boolean $value

Returns

\PHPExcel_Cell_DataValidation

getShowErrorMessage()

getShowErrorMessage() : boolean

Get Show ErrorMessage

Returns

boolean

setShowErrorMessage()

setShowErrorMessage(boolean  $value = false) : \PHPExcel_Cell_DataValidation

Set Show ErrorMessage

Parameters

boolean $value

Returns

\PHPExcel_Cell_DataValidation

getErrorTitle()

getErrorTitle() : string

Get Error title

Returns

string

setErrorTitle()

setErrorTitle(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Error title

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getError()

getError() : string

Get Error

Returns

string

setError()

setError(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Error

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getPromptTitle()

getPromptTitle() : string

Get Prompt title

Returns

string

setPromptTitle()

setPromptTitle(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Prompt title

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getPrompt()

getPrompt() : string

Get Prompt

Returns

string

setPrompt()

setPrompt(string  $value = '') : \PHPExcel_Cell_DataValidation

Set Prompt

Parameters

string $value

Returns

\PHPExcel_Cell_DataValidation

getHashCode()

getHashCode() : string

Get hash code

Returns

string —

Hash code

__clone()

__clone() 

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