SimpleExcel.php

diff --git a/SimpleExcel.php b/SimpleExcel.php
index d79f729..df3715a 100644 (file)
--- 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,MATCH(MAX(LEN(A6:A9)),LEN(B9:B10),0),1)');
+                    $validator->setFormula1('INDEX(B9:B10,\'\',LEN(B9:B10),0),1)');
                     
 //                    $validator->setList('Q2:Q10');