From 6bef8b87925e7ffd2758223e023d3ae871a8eca8 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 13 Mar 2014 16:28:57 +0800 Subject: [PATCH] SimpleExcel.php --- SimpleExcel.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/SimpleExcel.php b/SimpleExcel.php index bb8bd989..f405e3ce 100644 --- 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++; -- 2.39.2