From c226dcc97a68b33cf3b3a869809d4c94f38e0639 Mon Sep 17 00:00:00 2001
From: Edward <edward@roojs.com>
Date: Thu, 13 Mar 2014 20:00:42 +0800
Subject: [PATCH] SimpleExcel.php

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

diff --git a/SimpleExcel.php b/SimpleExcel.php
index df3715a3..2c34eec8 100644
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -333,7 +333,7 @@ class Pman_Core_SimpleExcel extends Pman
                     $validator->_fixedList = 1;
                     $validator->_type = 3;
                     $validator->_incell=true;
-                    $validator->setFormula1('INDEX(B9:B10,\'\',LEN(B9:B10),0),1)');
+                    $validator->setFormula1('INDEX(B9:B10,LEN(B9:B10),1)');
                     
 //                    $validator->setList('Q2:Q10');
                     
-- 
2.39.2