Collaboration diagram for PHPExcel_Cell_DataValidation:

Public Member Functions
	__construct ()
	Create a new PHPExcel_Cell_DataValidation.
	getFormula1 ()
	Get Formula 1.
	setFormula1 ($value= '')
	Set Formula 1.
	getFormula2 ()
	Get Formula 2.
	setFormula2 ($value= '')
	Set Formula 2.
	getType ()
	Get Type.
	setType ($value=PHPExcel_Cell_DataValidation::TYPE_NONE)
	Set Type.
	getErrorStyle ()
	Get Error style.
	setErrorStyle ($value=PHPExcel_Cell_DataValidation::STYLE_STOP)
	Set Error style.
	getOperator ()
	Get Operator.
	setOperator ($value= '')
	Set Operator.
	getAllowBlank ()
	Get Allow Blank.
	setAllowBlank ($value=false)
	Set Allow Blank.
	getShowDropDown ()
	Get Show DropDown.
	setShowDropDown ($value=false)
	Set Show DropDown.
	getShowInputMessage ()
	Get Show InputMessage.
	setShowInputMessage ($value=false)
	Set Show InputMessage.
	getShowErrorMessage ()
	Get Show ErrorMessage.
	setShowErrorMessage ($value=false)
	Set Show ErrorMessage.
	getErrorTitle ()
	Get Error title.
	setErrorTitle ($value= '')
	Set Error title.
	getError ()
	Get Error.
	setError ($value= '')
	Set Error.
	getPromptTitle ()
	Get Prompt title.
	setPromptTitle ($value= '')
	Set Prompt title.
	getPrompt ()
	Get Prompt.
	setPrompt ($value= '')
	Set Prompt.
	getHashCode ()
	Get hash code.
	__clone ()
	Implement PHP __clone to create a deep clone, not just a shallow copy.

Data Fields
const	TYPE_NONE = 'none'
const	TYPE_CUSTOM = 'custom'
const	TYPE_DATE = 'date'
const	TYPE_DECIMAL = 'decimal'
const	TYPE_LIST = 'list'
const	TYPE_TEXTLENGTH = 'textLength'
const	TYPE_TIME = 'time'
const	TYPE_WHOLE = 'whole'
const	STYLE_STOP = 'stop'
const	STYLE_WARNING = 'warning'
const	STYLE_INFORMATION = 'information'
const	OPERATOR_BETWEEN = 'between'
const	OPERATOR_EQUAL = 'equal'
const	OPERATOR_GREATERTHAN = 'greaterThan'
const	OPERATOR_GREATERTHANOREQUAL = 'greaterThanOrEqual'
const	OPERATOR_LESSTHAN = 'lessThan'
const	OPERATOR_LESSTHANOREQUAL = 'lessThanOrEqual'
const	OPERATOR_NOTBETWEEN = 'notBetween'
const	OPERATOR_NOTEQUAL = 'notEqual'

Private Attributes
	$_formula1
	$_formula2
	$_type = PHPExcel_Cell_DataValidation::TYPE_NONE
	$_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP
	$_operator
	$_allowBlank
	$_showDropDown
	$_showInputMessage
	$_showErrorMessage
	$_errorTitle
	$_error
	$_promptTitle
	$_prompt

Detailed Description

Definition at line 36 of file DataValidation.php.

Constructor & Destructor Documentation

PHPExcel_Cell_DataValidation::__construct ( )

Create a new PHPExcel_Cell_DataValidation.

Exceptions

Exception

Definition at line 159 of file DataValidation.php.

References STYLE_STOP, and TYPE_NONE.

    {
        // Initialise member variables
                $this->_formula1                        = '';
                $this->_formula2                        = '';
                $this->_type                            = PHPExcel_Cell_DataValidation::TYPE_NONE;
                $this->_errorStyle                      = PHPExcel_Cell_DataValidation::STYLE_STOP;
                $this->_operator                        = '';
                $this->_allowBlank                      = false;
                $this->_showDropDown            = false;
                $this->_showInputMessage        = false;
                $this->_showErrorMessage        = false;
                $this->_errorTitle                      = '';
                $this->_error                           = '';
                $this->_promptTitle             = '';
                $this->_prompt                          = '';
    }

Member Function Documentation

PHPExcel_Cell_DataValidation::__clone ( )

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

Definition at line 464 of file DataValidation.php.

                                  {
                $vars = get_object_vars($this);
                foreach ($vars as $key => $value) {
                        if (is_object($value)) {
                                $this->$key = clone $value;
                        } else {
                                $this->$key = $value;
                        }
                }
        }

PHPExcel_Cell_DataValidation::getAllowBlank ( )

Get Allow Blank.

Returns: boolean

Definition at line 282 of file DataValidation.php.

References $_allowBlank.

                                        {
                return $this->_allowBlank;
        }

PHPExcel_Cell_DataValidation::getError ( )

Get Error.

Returns: string

Definition at line 382 of file DataValidation.php.

References $_error.

                                   {
                return $this->_error;
        }

PHPExcel_Cell_DataValidation::getErrorStyle ( )

Get Error style.

Returns: string

Definition at line 242 of file DataValidation.php.

References $_errorStyle.

                                        {
                return $this->_errorStyle;
        }

PHPExcel_Cell_DataValidation::getErrorTitle ( )

Get Error title.

Returns: string

Definition at line 362 of file DataValidation.php.

References $_errorTitle.

                                        {
                return $this->_errorTitle;
        }

PHPExcel_Cell_DataValidation::getFormula1 ( )

Get Formula 1.

Returns: string

Definition at line 182 of file DataValidation.php.

References $_formula1.

                                      {
                return $this->_formula1;
        }

PHPExcel_Cell_DataValidation::getFormula2 ( )

Get Formula 2.

Returns: string

Definition at line 202 of file DataValidation.php.

References $_formula2.

                                      {
                return $this->_formula2;
        }

PHPExcel_Cell_DataValidation::getHashCode ( )

Get hash code.

Returns: string Hash code

Definition at line 442 of file DataValidation.php.

References STYLE_STOP, and TYPE_NONE.

                                      {
        return md5(
                  $this->_formula1
                . $this->_formula2
                . $this->_type = PHPExcel_Cell_DataValidation::TYPE_NONE
                . $this->_errorStyle = PHPExcel_Cell_DataValidation::STYLE_STOP
                . $this->_operator
                . ($this->_allowBlank ? 't' : 'f')
                . ($this->_showDropDown ? 't' : 'f')
                . ($this->_showInputMessage ? 't' : 'f')
                . ($this->_showErrorMessage ? 't' : 'f')
                . $this->_errorTitle
                . $this->_error
                . $this->_promptTitle
                . $this->_prompt
                . __CLASS__
        );
    }

PHPExcel_Cell_DataValidation::getOperator ( )

Get Operator.

Returns: string

Definition at line 262 of file DataValidation.php.

References $_operator.

                                      {
                return $this->_operator;
        }

PHPExcel_Cell_DataValidation::getPrompt ( )

Get Prompt.

Returns: string

Definition at line 422 of file DataValidation.php.

References $_prompt.

                                    {
                return $this->_prompt;
        }

PHPExcel_Cell_DataValidation::getPromptTitle ( )

Get Prompt title.

Returns: string

Definition at line 402 of file DataValidation.php.

References $_promptTitle.

                                         {
                return $this->_promptTitle;
        }

PHPExcel_Cell_DataValidation::getShowDropDown ( )

Get Show DropDown.

Returns: boolean

Definition at line 302 of file DataValidation.php.

References $_showDropDown.

                                          {
                return $this->_showDropDown;
        }

PHPExcel_Cell_DataValidation::getShowErrorMessage ( )

Get Show ErrorMessage.

Returns: boolean

Definition at line 342 of file DataValidation.php.

References $_showErrorMessage.

                                              {
                return $this->_showErrorMessage;
        }

PHPExcel_Cell_DataValidation::getShowInputMessage ( )

Get Show InputMessage.

Returns: boolean

Definition at line 322 of file DataValidation.php.

References $_showInputMessage.

                                              {
                return $this->_showInputMessage;
        }

PHPExcel_Cell_DataValidation::getType ( )

Get Type.

Returns: string

Definition at line 222 of file DataValidation.php.

References $_type.

                                  {
                return $this->_type;
        }

PHPExcel_Cell_DataValidation::setAllowBlank ( $value = false )

Set Allow Blank.

Parameters

boolean $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 292 of file DataValidation.php.

                                                      {
                $this->_allowBlank = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setError ( $value = '' )

Set Error.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 392 of file DataValidation.php.

                                              {
                $this->_error = $value;
                return $this;
        }

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

Set Error style.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 252 of file DataValidation.php.

                                                                                       {
                $this->_errorStyle = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setErrorTitle ( $value = '' )

Set Error title.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 372 of file DataValidation.php.

                                                   {
                $this->_errorTitle = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setFormula1 ( $value = '' )

Set Formula 1.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 192 of file DataValidation.php.

                                                 {
                $this->_formula1 = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setFormula2 ( $value = '' )

Set Formula 2.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 212 of file DataValidation.php.

                                                 {
                $this->_formula2 = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setOperator ( $value = '' )

Set Operator.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 272 of file DataValidation.php.

                                                 {
                $this->_operator = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setPrompt ( $value = '' )

Set Prompt.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 432 of file DataValidation.php.

                                               {
                $this->_prompt = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setPromptTitle ( $value = '' )

Set Prompt title.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 412 of file DataValidation.php.

                                                    {
                $this->_promptTitle = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setShowDropDown ( $value = false )

Set Show DropDown.

Parameters

boolean $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 312 of file DataValidation.php.

                                                        {
                $this->_showDropDown = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setShowErrorMessage ( $value = false )

Set Show ErrorMessage.

Parameters

boolean $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 352 of file DataValidation.php.

                                                            {
                $this->_showErrorMessage = $value;
                return $this;
        }

PHPExcel_Cell_DataValidation::setShowInputMessage ( $value = false )

Set Show InputMessage.

Parameters

boolean $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 332 of file DataValidation.php.

                                                            {
                $this->_showInputMessage = $value;
                return $this;
        }

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

Set Type.

Parameters

string $value

Returns: PHPExcel_Cell_DataValidation

Definition at line 232 of file DataValidation.php.

                                                                                {
                $this->_type = $value;
                return $this;
        }