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