excel5 writer + data validation

Topics: Developer Forum, User Forum
Jun 4, 2008 at 2:37 PM
Edited Jun 4, 2008 at 3:11 PM

I tried to look for potential answers to my question but didn't find anything on this forum. So here is my question:

can excel5 write data validations? If yes, what do I do wrong, because the drop down list never shows up. Here is my code:

$objValidation = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow(4,34)->getDataValidation();
$objValidation->setType(PHPExcel_Cell_DataValidation::TYPE_LIST );

thank you very much in advance.