From ef07772ae2edc7b3350f802bd17be363574ceee1 Mon Sep 17 00:00:00 2001
From: Alan <alan@roojs.com>
Date: Tue, 19 Jul 2022 14:59:39 +0800
Subject: [PATCH] fix date type column

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

diff --git a/SimpleExcel.php b/SimpleExcel.php
index 6c36750e..3928a84a 100644
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -394,7 +394,7 @@ class Pman_Core_SimpleExcel extends Pman
           //  print_R(array($start_row+$r, $c, $v, $format));exit;
           // handle 0 prefixes..
           
-            if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
+            if ($dataFormat == 'date' || preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
                 $dataFormat = 'date';
                 $format = empty($format) ? $this->formats['_default_date_format_']: $format;
                 $ut_to_ed_diff = 86400 * 25569;
-- 
2.39.2