SimpleExcel.php

[Pman.Core] / SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 88b5a5a..ee80251 100644 (file)
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -330,10 +330,15 @@ class Pman_Core_SimpleExcel extends Pman
                 if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
                     $validator = $this->workbook->addValidator();
 //                    $validator->setList("a b c");
-//                    $validator->_fixedList = 1;
-                    $validator->setList('Q2:Q10');
+                    $validator->_fixedList = 1;
+                    $validator->_type = 3;
+                    $validator->_incell=true;
+                    $validator->setFormula1('H10');
                     
-                    $this->worksheet->setValidation(2,1,2,1,$validator);
+//                    $validator->setList('Q2:Q10');
+                    
+                    $this->worksheet->setValidation(2,1,0,0,$validator);
+                    $this->worksheet->_storeDataValidity();
                     $this->start_row++;
         
                     return $hasRender;