Exemplo n.º 1
0
 /**
  * Set Cell DataValidation is List, need setFormula1
  * @param PHPExcel_Cell_DataValidation $Validator [description]
  * @return PHPExcel_Cell_DataValidation
  */
 public function setCellList(\PHPExcel_Cell_DataValidation $Validator)
 {
     $Validator->setType(\PHPExcel_Cell_DataValidation::TYPE_LIST);
     $Validator->setErrorStyle(\PHPExcel_Cell_DataValidation::STYLE_INFORMATION);
     $Validator->setAllowBlank(false);
     $Validator->setShowDropDown(true);
     $Validator = $this->setPrompt($Validator, 'Pick From List');
     $Validator = $this->setError($Validator, 'Input error', 'Value is not in list.');
     return $Validator;
 }