This closes #1069, support time zone location when set cell value

1 files changed, 2 insertions, 0 deletions

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