From bee487c445768b8afd15bbfa7caa4d8427e4c880 Mon Sep 17 00:00:00 2001
From: Ri Xu <xuri.me@gmail.com>
Date: Tue, 28 Mar 2017 11:48:09 +0800
Subject: Leading space(s) character in cell value detection added. Related
 issue #32.

---
 excelize.go | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'excelize.go')

diff --git a/excelize.go b/excelize.go
index 1fbfcc2..e723cb5 100644
--- a/excelize.go
+++ b/excelize.go
@@ -161,6 +161,15 @@ func (f *File) SetCellStr(sheet, axis, value string) {
 	completeRow(xlsx, rows, cell)
 	completeCol(xlsx, rows, cell)
 
+	// Leading space(s) character detection.
+	if len(value) > 0 {
+		if value[0] == 32 {
+			xlsx.SheetData.Row[xAxis].C[yAxis].XMLSpace = xml.Attr{
+				Name:  xml.Name{Space: NameSpaceXML, Local: "space"},
+				Value: "preserve",
+			}
+		}
+	}
 	xlsx.SheetData.Row[xAxis].C[yAxis].T = "str"
 	xlsx.SheetData.Row[xAxis].C[yAxis].V = value
 }
-- 
cgit v1.2.1