$dataFormat == 'string' ) {
if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
$validator = $this->workbook->addValidator();
+// $validator->setList("a b c");
+ $validator->_fixedList = 1;
$validator->_type = 3;
-// $validator->_fixedList = 1;
- $validator->setFormula1('Q2:Q10');
+ $validator->_incell=true;
+ $validator->setFormula1('A9');
+
+// $validator->setList('Q2:Q10');
$this->worksheet->setValidation(2,1,2,1,$validator);
+ $this->worksheet->_storeDataValidity();
$this->start_row++;
return $hasRender;