$dataFormat == 'string' ) {
if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
$validator = $this->workbook->addValidator();
- $validator->_type = 0x03;
- $validator->setFormula1('$speaker.$Q$2:$Q$10');
- print_r($validator);exit;
+// $validator->setList("a b c");
+ $validator->_fixedList = 1;
+ $validator->_type = 3;
+ $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;