\PhpOffice\PhpSpreadsheet\CellDataValidation

Summary

Methods

Properties

Constants

__construct()
getFormula1()
setFormula1()
getFormula2()
setFormula2()
getType()
setType()
getErrorStyle()
setErrorStyle()
getOperator()
setOperator()
getAllowBlank()
setAllowBlank()
getShowDropDown()
setShowDropDown()
getShowInputMessage()
setShowInputMessage()
getShowErrorMessage()
setShowErrorMessage()
getErrorTitle()
setErrorTitle()
getError()
setError()
getPromptTitle()
setPromptTitle()
getPrompt()
setPrompt()
getHashCode()
__clone()

No public properties found

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

No protected methods found

No protected properties found

N/A

No private methods found

$formula1
$formula2
$type
$errorStyle
$operator
$allowBlank
$showDropDown
$showInputMessage
$showErrorMessage
$errorTitle
$error
$promptTitle
$prompt

N/A

File: vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/DataValidation.php
Package: Default
Class hierarchy: \PhpOffice\PhpSpreadsheet\Cell\DataValidation

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 DataValidation.

getFormula1()

getFormula1() : string

Get Formula 1.

Returns

string

setFormula1()

setFormula1(string  $value) : $this

Set Formula 1.

Parameters

string

$value

Returns

$this

getFormula2()

getFormula2() : string

Get Formula 2.

Returns

string

setFormula2()

setFormula2(string  $value) : $this

Set Formula 2.

Parameters

string

$value

Returns

$this

getType()

getType() : string

Get Type.

Returns

string

setType()

setType(string  $value) : $this

Set Type.

Parameters

string

$value

Returns

$this

getErrorStyle()

getErrorStyle() : string

Get Error style.

Returns

string

setErrorStyle()

setErrorStyle(string  $value) : $this

Set Error style.

Parameters

string

$value

see self::STYLE_*

Returns

$this

getOperator()

getOperator() : string

Get Operator.

Returns

string

setOperator()

setOperator(string  $value) : $this

Set Operator.

Parameters

string

$value

Returns

$this

getAllowBlank()

getAllowBlank() : boolean

Get Allow Blank.

Returns

boolean

setAllowBlank()

setAllowBlank(boolean  $value) : $this

Set Allow Blank.

Parameters

boolean

$value

Returns

$this

getShowDropDown()

getShowDropDown() : boolean

Get Show DropDown.

Returns

boolean

setShowDropDown()

setShowDropDown(boolean  $value) : $this

Set Show DropDown.

Parameters

boolean

$value

Returns

$this

getShowInputMessage()

getShowInputMessage() : boolean

Get Show InputMessage.

Returns

boolean

setShowInputMessage()

setShowInputMessage(boolean  $value) : $this

Set Show InputMessage.

Parameters

boolean

$value

Returns

$this

getShowErrorMessage()

getShowErrorMessage() : boolean

Get Show ErrorMessage.

Returns

boolean

setShowErrorMessage()

setShowErrorMessage(boolean  $value) : $this

Set Show ErrorMessage.

Parameters

boolean

$value

Returns

$this

getErrorTitle()

getErrorTitle() : string

Get Error title.

Returns

string

setErrorTitle()

setErrorTitle(string  $value) : $this

Set Error title.

Parameters

string

$value

Returns

$this

getError()

getError() : string

Get Error.

Returns

string

setError()

setError(string  $value) : $this

Set Error.

Parameters

string

$value

Returns

$this

getPromptTitle()

getPromptTitle() : string

Get Prompt title.

Returns

string

setPromptTitle()

setPromptTitle(string  $value) : $this

Set Prompt title.

Parameters

string

$value

Returns

$this

getPrompt()

getPrompt() : string

Get Prompt.

Returns

string

setPrompt()

setPrompt(string  $value) : $this

Set Prompt.

Parameters

string

$value

Returns

$this

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.