summaryrefslogtreecommitdiff
path: root/excelize_test.go
diff options
context:
space:
mode:
authorRi Xu <xuri.me@gmail.com>2017-07-14 21:15:44 +0800
committerRi Xu <xuri.me@gmail.com>2017-07-14 21:15:44 +0800
commitbc31e545c8458d882ff6659ea3ca5e7a598d8789 (patch)
treed83e3a302061b820082d656197710cc71b0a30b7 /excelize_test.go
parent20aae4e0e6e9d40a35a1d6ef6e3f357afdda0605 (diff)
- Currency format supported, relate issue #80;
- go test and godoc updated
Diffstat (limited to 'excelize_test.go')
-rw-r--r--excelize_test.go58
1 files changed, 58 insertions, 0 deletions
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 {