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 = ''; } /** * Get Formula 1 * * @return string */ public function getFormula1() { return $this->formula1; } /** * Set Formula 1 * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setFormula1($value = '') { $this->formula1 = $value; return $this; } /** * Get Formula 2 * * @return string */ public function getFormula2() { return $this->formula2; } /** * Set Formula 2 * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setFormula2($value = '') { $this->formula2 = $value; return $this; } /** * Get Type * * @return string */ public function getType() { return $this->type; } /** * Set Type * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setType($value = PHPExcel_Cell_DataValidation::TYPE_NONE) { $this->type = $value; return $this; } /** * Get Error style * * @return string */ public function getErrorStyle() { return $this->errorStyle; } /** * Set Error style * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setErrorStyle($value = PHPExcel_Cell_DataValidation::STYLE_STOP) { $this->errorStyle = $value; return $this; } /** * Get Operator * * @return string */ public function getOperator() { return $this->operator; } /** * Set Operator * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setOperator($value = '') { $this->operator = $value; return $this; } /** * Get Allow Blank * * @return boolean */ public function getAllowBlank() { return $this->allowBlank; } /** * Set Allow Blank * * @param boolean $value * @return PHPExcel_Cell_DataValidation */ public function setAllowBlank($value = false) { $this->allowBlank = $value; return $this; } /** * Get Show DropDown * * @return boolean */ public function getShowDropDown() { return $this->showDropDown; } /** * Set Show DropDown * * @param boolean $value * @return PHPExcel_Cell_DataValidation */ public function setShowDropDown($value = false) { $this->showDropDown = $value; return $this; } /** * Get Show InputMessage * * @return boolean */ public function getShowInputMessage() { return $this->showInputMessage; } /** * Set Show InputMessage * * @param boolean $value * @return PHPExcel_Cell_DataValidation */ public function setShowInputMessage($value = false) { $this->showInputMessage = $value; return $this; } /** * Get Show ErrorMessage * * @return boolean */ public function getShowErrorMessage() { return $this->showErrorMessage; } /** * Set Show ErrorMessage * * @param boolean $value * @return PHPExcel_Cell_DataValidation */ public function setShowErrorMessage($value = false) { $this->showErrorMessage = $value; return $this; } /** * Get Error title * * @return string */ public function getErrorTitle() { return $this->errorTitle; } /** * Set Error title * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setErrorTitle($value = '') { $this->errorTitle = $value; return $this; } /** * Get Error * * @return string */ public function getError() { return $this->error; } /** * Set Error * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setError($value = '') { $this->error = $value; return $this; } /** * Get Prompt title * * @return string */ public function getPromptTitle() { return $this->promptTitle; } /** * Set Prompt title * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setPromptTitle($value = '') { $this->promptTitle = $value; return $this; } /** * Get Prompt * * @return string */ public function getPrompt() { return $this->prompt; } /** * Set Prompt * * @param string $value * @return PHPExcel_Cell_DataValidation */ public function setPrompt($value = '') { $this->prompt = $value; return $this; } /** * Get hash code * * @return string Hash code */ public function getHashCode() { 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__ ); } /** * Implement PHP __clone to create a deep clone, not just a shallow copy. */ public function __clone() { $vars = get_object_vars($this); foreach ($vars as $key => $value) { if (is_object($value)) { $this->$key = clone $value; } else { $this->$key = $value; } } } }