\PHPExcel_Cell_DataValidation

PHPExcel_Cell_DataValidation

This library is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation; either version 2.1 of the License, or (at your option) any later version.

This library is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.

You should have received a copy of the GNU Lesser General Public License along with this library; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA

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/Execl/PHPExcel/Cell/DataValidation.php
Package: PHPExcel_Cell
Class hierarchy: \PHPExcel_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 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.

category	PHPExcel
copyright	Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
license	http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
version	VERSION##, ##DATE