SimpleExcel.php
authorEdward <edward@roojs.com>
Thu, 13 Mar 2014 08:18:31 +0000 (16:18 +0800)
committerEdward <edward@roojs.com>
Thu, 13 Mar 2014 08:18:31 +0000 (16:18 +0800)
SimpleExcel.php

index d8d4cf0..af21f3f 100644 (file)
@@ -329,12 +329,11 @@ class Pman_Core_SimpleExcel extends Pman
                     $dataFormat == 'string' ) {
                 if($worksheet_name == 'event' && $start_row == 2 && $c == 1){
                     $validator = $this->workbook->addValidator();
-                    $list = new Spreadsheet_Excel_Writer_Validation_List();
-                    $list->setList("a b c");
+//                    $validator->setList("a b c");
 //                    $validator->_fixedList = 1;
-//                    $validator->setFormula1('Q2:Q10');
+                    $validator->setFormula1('Q2:Q10');
                     
-                    $this->worksheet->setValidation(2,1,2,1,$list);
+                    $this->worksheet->setValidation(2,1,2,1,$validator);
                     $this->start_row++;
         
                     return $hasRender;