/** * Set Data validation * * @param PHPExcel_Cell_DataValidation $pDataValidation * @throws Exception */ public function setDataValidation(PHPExcel_Cell_DataValidation $pDataValidation = null) { $this->_dataValidation = $pDataValidation; $this->_dataValidation->setParent($this); }
/** * Set data validation * * @param string $pCellCoordinate Cell coordinate to insert data validation * @param PHPExcel_Cell_DataValidation $pDataValidation * @return PHPExcel_Worksheet */ public function setDataValidation($pCellCoordinate = 'A1', PHPExcel_Cell_DataValidation $pDataValidation = null) { if ($pDataValidation === null) { unset($this->_dataValidationCollection[$pCellCoordinate]); } else { $this->_dataValidationCollection[$pCellCoordinate] = $pDataValidation; $pDataValidation->setParent($this->getCell($pCellCoordinate)); } return $this; }
/** * 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; }