diff options
author | Ri Xu <xuri.me@gmail.com> | 2017-07-14 21:15:44 +0800 |
---|---|---|
committer | Ri Xu <xuri.me@gmail.com> | 2017-07-14 21:15:44 +0800 |
commit | bc31e545c8458d882ff6659ea3ca5e7a598d8789 (patch) | |
tree | d83e3a302061b820082d656197710cc71b0a30b7 /excelize_test.go | |
parent | 20aae4e0e6e9d40a35a1d6ef6e3f357afdda0605 (diff) |
- Currency format supported, relate issue #80;
- go test and godoc updated
Diffstat (limited to 'excelize_test.go')
-rw-r--r-- | excelize_test.go | 58 |
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 { |