/**
* 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;
}
