SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index b9788c1..bedf6f4 100644 (file)
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -330,7 +330,7 @@ class Pman_Core_SimpleExcel extends Pman
                 if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
                     $validator = $this->workbook->addValidator();
                     $validator->_type = 0x03;
-                    $validator->setFormula1('=Q2:Q10');
+                    $validator->setFormula1('=speaker!$Q$2:$Q$10');
                     $this->worksheet->setValidation(2,1,2,1,$validator);
                     $this->start_row++;