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.go | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'cell.go')

diff --git a/cell.go b/cell.go
index e1c7803..5c34bb9 100644
--- a/cell.go
+++ b/cell.go
@@ -225,6 +225,8 @@ func (f *File) setCellTimeFunc(sheet, axis string, value time.Time) error {
 // timestamp.
 func setCellTime(value time.Time) (t string, b string, isNum bool, err error) {
 	var excelTime float64
+	_, offset := value.In(value.Location()).Zone()
+	value = value.Add(time.Duration(offset) * time.Second)
 	excelTime, err = timeToExcelTime(value)
 	if err != nil {
 		return
-- 
cgit v1.2.1