From 4a74951e81c9b0c64b0ce9319e325a1f67c621c6 Mon Sep 17 00:00:00 2001 From: Ri Xu Date: Thu, 27 Jul 2017 11:46:04 +0800 Subject: - Support set custom number format, relate issue #86; - go test and godoc updated --- excelize_test.go | 24 ++++++++++++++++++++++-- 1 file changed, 22 insertions(+), 2 deletions(-) (limited to 'excelize_test.go') diff --git a/excelize_test.go b/excelize_test.go index 23630f3..5b942e1 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -420,8 +420,8 @@ func TestSetCellStyleCurrencyNumberFormat(t *testing.T) { if err != nil { t.Log(err) } - xlsx.SetCellValue("Sheet1", "A1", 37947.7500001) - xlsx.SetCellValue("Sheet1", "A2", 37947.7500001) + xlsx.SetCellValue("Sheet1", "A1", 42920.5) + xlsx.SetCellValue("Sheet1", "A2", 42920.5) style, err = xlsx.NewStyle(`{"number_format": 26, "lang": "zh-tw"}`) if err != nil { @@ -450,6 +450,26 @@ func TestSetCellStyleCurrencyNumberFormat(t *testing.T) { } } +func TestSetCellStyleCustomNumberFormat(t *testing.T) { + xlsx := NewFile() + xlsx.SetCellValue("Sheet1", "A1", 42920.5) + xlsx.SetCellValue("Sheet1", "A2", 42920.5) + style, err := xlsx.NewStyle(`{"custom_number_format": "[$-380A]dddd\\,\\ dd\" de \"mmmm\" de \"yyyy;@"}`) + if err != nil { + t.Log(err) + } + xlsx.SetCellStyle("Sheet1", "A1", "A1", style) + style, err = xlsx.NewStyle(`{"custom_number_format": "[$-380A]dddd\\,\\ dd\" de \"mmmm\" de \"yyyy;@"}`) + if err != nil { + t.Log(err) + } + xlsx.SetCellStyle("Sheet1", "A2", "A2", style) + err = xlsx.SaveAs("./test/Workbook_custom_number_format.xlsx") + 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