class PHPExcel_Cell_DataValidation

PHPExcelCellDataValidation

Copyright (c) 2006 - 2015 PHPExcel

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

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 PHPExcelCellDataValidation

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 = PHPExcel_Cell_DataValidation::TYPE_NONE)

Set Type

string
getErrorStyle()

Get Error style

setErrorStyle(string $value = PHPExcel_Cell_DataValidation::STYLE_STOP)

Set Error style

string
getOperator()

Get Operator

setOperator(string $value = '')

Set Operator

boolean
getAllowBlank()

Get Allow Blank

setAllowBlank(boolean $value = false)

Set Allow Blank

boolean
getShowDropDown()

Get Show DropDown

setShowDropDown(boolean $value = false)

Set Show DropDown

boolean
getShowInputMessage()

Get Show InputMessage

setShowInputMessage(boolean $value = false)

Set Show InputMessage

boolean
getShowErrorMessage()

Get Show ErrorMessage

setShowErrorMessage(boolean $value = false)

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

at line 158
__construct()

Create a new PHPExcelCellDataValidation

at line 181
string getFormula1()

Get Formula 1

Return Value

string

at line 192
PHPExcel_Cell_DataValidation setFormula1(string $value = '')

Set Formula 1

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 203
string getFormula2()

Get Formula 2

Return Value

string

at line 214
PHPExcel_Cell_DataValidation setFormula2(string $value = '')

Set Formula 2

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 225
string getType()

Get Type

Return Value

string

at line 236
PHPExcel_Cell_DataValidation setType(string $value = PHPExcel_Cell_DataValidation::TYPE_NONE)

Set Type

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 247
string getErrorStyle()

Get Error style

Return Value

string

at line 258
PHPExcel_Cell_DataValidation setErrorStyle(string $value = PHPExcel_Cell_DataValidation::STYLE_STOP)

Set Error style

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 269
string getOperator()

Get Operator

Return Value

string

at line 280
PHPExcel_Cell_DataValidation setOperator(string $value = '')

Set Operator

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 291
boolean getAllowBlank()

Get Allow Blank

Return Value

boolean

at line 302
PHPExcel_Cell_DataValidation setAllowBlank(boolean $value = false)

Set Allow Blank

Parameters

boolean $value

Return Value

PHPExcel_Cell_DataValidation

at line 313
boolean getShowDropDown()

Get Show DropDown

Return Value

boolean

at line 324
PHPExcel_Cell_DataValidation setShowDropDown(boolean $value = false)

Set Show DropDown

Parameters

boolean $value

Return Value

PHPExcel_Cell_DataValidation

at line 335
boolean getShowInputMessage()

Get Show InputMessage

Return Value

boolean

at line 346
PHPExcel_Cell_DataValidation setShowInputMessage(boolean $value = false)

Set Show InputMessage

Parameters

boolean $value

Return Value

PHPExcel_Cell_DataValidation

at line 357
boolean getShowErrorMessage()

Get Show ErrorMessage

Return Value

boolean

at line 368
PHPExcel_Cell_DataValidation setShowErrorMessage(boolean $value = false)

Set Show ErrorMessage

Parameters

boolean $value

Return Value

PHPExcel_Cell_DataValidation

at line 379
string getErrorTitle()

Get Error title

Return Value

string

at line 390
PHPExcel_Cell_DataValidation setErrorTitle(string $value = '')

Set Error title

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 401
string getError()

Get Error

Return Value

string

at line 412
PHPExcel_Cell_DataValidation setError(string $value = '')

Set Error

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 423
string getPromptTitle()

Get Prompt title

Return Value

string

at line 434
PHPExcel_Cell_DataValidation setPromptTitle(string $value = '')

Set Prompt title

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 445
string getPrompt()

Get Prompt

Return Value

string

at line 456
PHPExcel_Cell_DataValidation setPrompt(string $value = '')

Set Prompt

Parameters

string $value

Return Value

PHPExcel_Cell_DataValidation

at line 467
string getHashCode()

Get hash code

Return Value

string Hash code

at line 490
__clone()

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