From 85e71f01be7cae1ef4fab3a2339ec5cbf5af922b Mon Sep 17 00:00:00 2001
From: Edward <edward@roojs.com>
Date: Thu, 13 Mar 2014 16:22:52 +0800
Subject: [PATCH] SimpleExcel.php

---
 SimpleExcel.php | 1 +
 1 file changed, 1 insertion(+)

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 57e6fc68..27d43c19 100644
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -333,6 +333,7 @@ class Pman_Core_SimpleExcel extends Pman
                     $validator->_fixedList = 1;
                     $validator->_type = 3;
                     $validator->_incell=true;
+                    $validator->setFormula1('Q2:Q10');
 //                    $validator->setList('Q2:Q10');
                     
                     $this->worksheet->setValidation(2,1,2,1,$validator);
-- 
2.39.2