From 02dc356b3cc8d3dc3b8eb81549cf041053b51979 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 13 Mar 2014 16:26:42 +0800 Subject: [PATCH] SimpleExcel.php --- SimpleExcel.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/SimpleExcel.php b/SimpleExcel.php index 7d061cc1..a6937973 100644 --- a/SimpleExcel.php +++ b/SimpleExcel.php @@ -335,7 +335,8 @@ class Pman_Core_SimpleExcel extends Pman $validator->_incell=true; // $validator->setFormula1('a,b,c'); // $validator->setList('Q2:Q10'); - + $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