From: Edward Date: Thu, 13 Mar 2014 12:00:42 +0000 (+0800) Subject: SimpleExcel.php X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=c226dcc97a68b33cf3b3a869809d4c94f38e0639 SimpleExcel.php --- 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');