| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481 | 
							- <?php
 
- namespace PhpOffice\PhpSpreadsheet\Cell;
 
- class DataValidation
 
- {
 
-     // Data validation types
 
-     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';
 
-     // Data validation error styles
 
-     const STYLE_STOP = 'stop';
 
-     const STYLE_WARNING = 'warning';
 
-     const STYLE_INFORMATION = 'information';
 
-     // Data validation operators
 
-     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';
 
-     /**
 
-      * Formula 1.
 
-      *
 
-      * @var string
 
-      */
 
-     private $formula1 = '';
 
-     /**
 
-      * Formula 2.
 
-      *
 
-      * @var string
 
-      */
 
-     private $formula2 = '';
 
-     /**
 
-      * Type.
 
-      *
 
-      * @var string
 
-      */
 
-     private $type = self::TYPE_NONE;
 
-     /**
 
-      * Error style.
 
-      *
 
-      * @var string
 
-      */
 
-     private $errorStyle = self::STYLE_STOP;
 
-     /**
 
-      * Operator.
 
-      *
 
-      * @var string
 
-      */
 
-     private $operator = self::OPERATOR_BETWEEN;
 
-     /**
 
-      * Allow Blank.
 
-      *
 
-      * @var bool
 
-      */
 
-     private $allowBlank = false;
 
-     /**
 
-      * Show DropDown.
 
-      *
 
-      * @var bool
 
-      */
 
-     private $showDropDown = false;
 
-     /**
 
-      * Show InputMessage.
 
-      *
 
-      * @var bool
 
-      */
 
-     private $showInputMessage = false;
 
-     /**
 
-      * Show ErrorMessage.
 
-      *
 
-      * @var bool
 
-      */
 
-     private $showErrorMessage = false;
 
-     /**
 
-      * Error title.
 
-      *
 
-      * @var string
 
-      */
 
-     private $errorTitle = '';
 
-     /**
 
-      * Error.
 
-      *
 
-      * @var string
 
-      */
 
-     private $error = '';
 
-     /**
 
-      * Prompt title.
 
-      *
 
-      * @var string
 
-      */
 
-     private $promptTitle = '';
 
-     /**
 
-      * Prompt.
 
-      *
 
-      * @var string
 
-      */
 
-     private $prompt = '';
 
-     /**
 
-      * Create a new DataValidation.
 
-      */
 
-     public function __construct()
 
-     {
 
-     }
 
-     /**
 
-      * Get Formula 1.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getFormula1()
 
-     {
 
-         return $this->formula1;
 
-     }
 
-     /**
 
-      * Set Formula 1.
 
-      *
 
-      * @param string $value
 
-      *
 
-      * @return 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 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 DataValidation
 
-      */
 
-     public function setType($value)
 
-     {
 
-         $this->type = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Error style.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getErrorStyle()
 
-     {
 
-         return $this->errorStyle;
 
-     }
 
-     /**
 
-      * Set Error style.
 
-      *
 
-      * @param string $value see self::STYLE_*
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setErrorStyle($value)
 
-     {
 
-         $this->errorStyle = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Operator.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getOperator()
 
-     {
 
-         return $this->operator;
 
-     }
 
-     /**
 
-      * Set Operator.
 
-      *
 
-      * @param string $value
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setOperator($value)
 
-     {
 
-         $this->operator = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Allow Blank.
 
-      *
 
-      * @return bool
 
-      */
 
-     public function getAllowBlank()
 
-     {
 
-         return $this->allowBlank;
 
-     }
 
-     /**
 
-      * Set Allow Blank.
 
-      *
 
-      * @param bool $value
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setAllowBlank($value)
 
-     {
 
-         $this->allowBlank = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Show DropDown.
 
-      *
 
-      * @return bool
 
-      */
 
-     public function getShowDropDown()
 
-     {
 
-         return $this->showDropDown;
 
-     }
 
-     /**
 
-      * Set Show DropDown.
 
-      *
 
-      * @param bool $value
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setShowDropDown($value)
 
-     {
 
-         $this->showDropDown = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Show InputMessage.
 
-      *
 
-      * @return bool
 
-      */
 
-     public function getShowInputMessage()
 
-     {
 
-         return $this->showInputMessage;
 
-     }
 
-     /**
 
-      * Set Show InputMessage.
 
-      *
 
-      * @param bool $value
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setShowInputMessage($value)
 
-     {
 
-         $this->showInputMessage = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Show ErrorMessage.
 
-      *
 
-      * @return bool
 
-      */
 
-     public function getShowErrorMessage()
 
-     {
 
-         return $this->showErrorMessage;
 
-     }
 
-     /**
 
-      * Set Show ErrorMessage.
 
-      *
 
-      * @param bool $value
 
-      *
 
-      * @return DataValidation
 
-      */
 
-     public function setShowErrorMessage($value)
 
-     {
 
-         $this->showErrorMessage = $value;
 
-         return $this;
 
-     }
 
-     /**
 
-      * Get Error title.
 
-      *
 
-      * @return string
 
-      */
 
-     public function getErrorTitle()
 
-     {
 
-         return $this->errorTitle;
 
-     }
 
-     /**
 
-      * Set Error title.
 
-      *
 
-      * @param string $value
 
-      *
 
-      * @return 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 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 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 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 .
 
-             $this->errorStyle .
 
-             $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;
 
-             }
 
-         }
 
-     }
 
- }
 
 
  |