From ea51158da114eff19966fe08eb9ce50cb8a2dc90 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 13 Mar 2014 19:10:05 +0800 Subject: [PATCH] SimpleExcel.php --- SimpleExcel.php | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) diff --git a/SimpleExcel.php b/SimpleExcel.php index 28056993..99e27234 100644 --- a/SimpleExcel.php +++ b/SimpleExcel.php @@ -327,7 +327,25 @@ class Pman_Core_SimpleExcel extends Pman if ( (is_numeric($v) && strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.') || $dataFormat == 'string' ) { + if($worksheet_name == 'event' && $start_row == 2 && $c == 1){ + $validator = $this->workbook->addValidator(); +// $validator->setList("a b c"); + $validator->_fixedList = 1; + $validator->_type = 3; + $validator->_incell=true; + + +// $validator->setList('Q2:Q10'); + + $this->worksheet->setValidation(2,1,2,1,$validator); + $this->worksheet->_storeDataValidity(); + $this->start_row++; + + return $hasRender; + } + $worksheet->writeString($start_row+$r, $c, $v, $format); + } else { $worksheet->write($start_row+$r, $c, $v, $format); -- 2.39.2