From 7907650a97115dbb771c7b977c5f260a1ff1cc65 Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Wed, 24 Nov 2021 00:09:35 +0800
Subject: This closes #1069, support time zone location when set cell value

---
 cell_test.go | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'cell_test.go')

diff --git a/cell_test.go b/cell_test.go
index f699c05..e49212f 100644
--- a/cell_test.go
+++ b/cell_test.go
@@ -178,6 +178,24 @@ func TestSetCellBool(t *testing.T) {
 	assert.EqualError(t, f.SetCellBool("Sheet1", "A", true), `cannot convert cell "A" to coordinates: invalid cell name "A"`)
 }
 
+func TestSetCellTime(t *testing.T) {
+	date, err := time.Parse(time.RFC3339Nano, "2009-11-10T23:00:00Z")
+	assert.NoError(t, err)
+	for location, expected := range map[string]string{
+		"America/New_York": "40127.75",
+		"Asia/Shanghai":    "40128.291666666664",
+		"Europe/London":    "40127.958333333336",
+		"UTC":              "40127.958333333336",
+	} {
+		timezone, err := time.LoadLocation(location)
+		assert.NoError(t, err)
+		_, b, isNum, err := setCellTime(date.In(timezone))
+		assert.NoError(t, err)
+		assert.Equal(t, true, isNum)
+		assert.Equal(t, expected, b)
+	}
+}
+
 func TestGetCellValue(t *testing.T) {
 	// Test get cell value without r attribute of the row.
 	f := NewFile()
-- 
cgit v1.2.1