SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index bb8bd98..f405e3c 100644 (file)
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -334,9 +334,9 @@ class Pman_Core_SimpleExcel extends Pman
                     $validator->_type = 3;
                     $validator->_incell=true;
 //                    $validator->setFormula1('a,b,c');
-//                    $validator->setList('Q2:Q10');
-                    $source = "Q2:Q10";
-                    $this->_formula1 = pack("CCC", 0x17, strlen($source), 0x0c) . $source;
+                    $validator->setList('$event.$O$2:$O$12');
+//                    $source = "Q2:Q10";
+//                    $this->_formula1 = pack("CCC", 0x17, strlen($source), 0x0c) . $source;
                     $this->worksheet->setValidation(2,1,2,1,$validator);
                     $this->worksheet->_storeDataValidity();
                     $this->start_row++;