added default formatting for date types when the cell style is 0 and the data type is :time

3 files changed, 6 insertions, 0 deletions

diff --git a/lib/axlsx/stylesheet/styles.rb b/lib/axlsx/stylesheet/styles.rb
index 6b64fb30..de5835dd 100644
--- a/lib/axlsx/stylesheet/styles.rb
+++ b/lib/axlsx/stylesheet/styles.rb
@@ -286,6 +286,8 @@ module Axlsx
       @cellXfs = SimpleTypedList.new Xf, "cellXfs"
       @cellXfs << Xf.new(:borderId=>0, :xfId=>0, :numFmtId=>0, :fontId=>0, :fillId=>0)
       @cellXfs << Xf.new(:borderId=>1, :xfId=>0, :numFmtId=>0, :fontId=>0, :fillId=>0)
+      # default date formatting
+      @cellXfs << Xf.new(:borderId=>0, :xfId=>0, :numFmtId=>14, :fontId=>0, :fillId=>0)
       @cellXfs.lock
 
       @dxfs = SimpleTypedList.new(Xf, "dxfs"); @dxfs.lock
diff --git a/lib/axlsx/util/constants.rb b/lib/axlsx/util/constants.rb
index 50dd6f27..4f1cb561 100644
--- a/lib/axlsx/util/constants.rb
+++ b/lib/axlsx/util/constants.rb
@@ -199,6 +199,9 @@ module Axlsx
   # cellXfs id for thin borders around the cell
   STYLE_THIN_BORDER = 1
 
+  # cellXfs id for default date styling
+  STYLE_DATE = 2
+
   # error messages RestrictionValidor
   ERR_RESTRICTION = "Invalid Data: %s. %s must be one of %s." 
 
diff --git a/lib/axlsx/workbook/worksheet/cell.rb b/lib/axlsx/workbook/worksheet/cell.rb
index 1b1b60cc..a9b4a704 100644
--- a/lib/axlsx/workbook/worksheet/cell.rb
+++ b/lib/axlsx/workbook/worksheet/cell.rb
@@ -169,6 +169,7 @@ module Axlsx
     def cast_value(v)
       if (@type == :time && v.is_a?(Time)) || (@type == :time && v.respond_to?(:to_time))
         v = v.respond_to?(:to_time) ? v.to_time : v
+        self.style = STYLE_DATE if self.style == 0
         # Using hardcoded offsets here as some operating systems will not except a 'negative' offset from the ruby epoc.
         # (1970)
         epoc1900 = -2209021200 #Time.local(1900, 1, 1)