From 814f877356e76e8546ea36b8d4d2a075731a9265 Mon Sep 17 00:00:00 2001
From: Edward <edward@roojs.com>
Date: Thu, 13 Mar 2014 15:08:47 +0800
Subject: [PATCH] SimpleExcel.php

---
 SimpleExcel.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 51072fc6..36c3e9d9 100644
--- 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('$speaker!$Q$2:$Q$10');
+                    $validator->setFormula1('$speaker.$Q$2:$Q$10');
                     print_r($validator);exit;
                     $this->worksheet->setValidation(2,1,2,1,$validator);
                     $this->start_row++;
-- 
2.39.2