From bc31e545c8458d882ff6659ea3ca5e7a598d8789 Mon Sep 17 00:00:00 2001
From: Ri Xu <xuri.me@gmail.com>
Date: Fri, 14 Jul 2017 21:15:44 +0800
Subject: - Currency format supported, relate issue #80; - go test and godoc
 updated

---
 excelize_test.go | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 58 insertions(+)

(limited to 'excelize_test.go')

diff --git a/excelize_test.go b/excelize_test.go
index 0441c93..224e844 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -392,6 +392,64 @@ func TestSetCellStyleNumberFormat(t *testing.T) {
 	}
 }
 
+func TestSetCellStyleCurrencyNumberFormat(t *testing.T) {
+	xlsx, err := OpenFile("./test/Workbook_3.xlsx")
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellValue("Sheet1", "A1", 56)
+	xlsx.SetCellValue("Sheet1", "A2", 32.3)
+	var style int
+	style, err = xlsx.NewStyle(`{"number_format": 188, "decimal_places": -1}`)
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellStyle("Sheet1", "A1", "A1", style)
+	style, err = xlsx.NewStyle(`{"number_format": 188, "decimal_places": 31}`)
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellStyle("Sheet1", "A2", "A2", style)
+
+	err = xlsx.Save()
+	if err != nil {
+		t.Log(err)
+	}
+
+	xlsx, err = OpenFile("./test/Workbook_4.xlsx")
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellValue("Sheet1", "A1", 37947.7500001)
+	xlsx.SetCellValue("Sheet1", "A2", 37947.7500001)
+
+	style, err = xlsx.NewStyle(`{"number_format": 26, "lang": "zh-tw"}`)
+	if err != nil {
+		t.Log(err)
+	}
+	style, err = xlsx.NewStyle(`{"number_format": 27}`)
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellStyle("Sheet1", "A1", "A1", style)
+	style, err = xlsx.NewStyle(`{"number_format": 31, "lang": "ko-kr"}`)
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellStyle("Sheet1", "A2", "A2", style)
+
+	style, err = xlsx.NewStyle(`{"number_format": 71, "lang": "th-th"}`)
+	if err != nil {
+		t.Log(err)
+	}
+	xlsx.SetCellStyle("Sheet1", "A2", "A2", style)
+
+	err = xlsx.Save()
+	if err != nil {
+		t.Log(err)
+	}
+}
+
 func TestSetCellStyleFill(t *testing.T) {
 	xlsx, err := OpenFile("./test/Workbook_2.xlsx")
 	if err != nil {
-- 
cgit v1.2.1