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 : bool

Allow Blank

Type

bool

$_showDropDown

$_showDropDown : bool

Show DropDown

Type

bool

$_showInputMessage

$_showInputMessage : bool

Show InputMessage

Type

bool

$_showErrorMessage

$_showErrorMessage : bool

Show ErrorMessage

Type

bool

$_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() : mixed

Create a new PHPExcel_Cell_DataValidation

Returns

mixed —

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() : bool

Get Allow Blank

Returns

bool —

setAllowBlank()

setAllowBlank(bool  $value = false) : \PHPExcel_Cell_DataValidation

Set Allow Blank

Parameters

bool $value

Returns

\PHPExcel_Cell_DataValidation —

getShowDropDown()

getShowDropDown() : bool

Get Show DropDown

Returns

bool —

setShowDropDown()

setShowDropDown(bool  $value = false) : \PHPExcel_Cell_DataValidation

Set Show DropDown

Parameters

bool $value

Returns

\PHPExcel_Cell_DataValidation —

getShowInputMessage()

getShowInputMessage() : bool

Get Show InputMessage

Returns

bool —

setShowInputMessage()

setShowInputMessage(bool  $value = false) : \PHPExcel_Cell_DataValidation

Set Show InputMessage

Parameters

bool $value

Returns

\PHPExcel_Cell_DataValidation —

getShowErrorMessage()

getShowErrorMessage() : bool

Get Show ErrorMessage

Returns

bool —

setShowErrorMessage()

setShowErrorMessage(bool  $value = false) : \PHPExcel_Cell_DataValidation

Set Show ErrorMessage

Parameters

bool $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() : mixed

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

Returns

mixed —