diff options
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 24 |
1 files changed, 22 insertions, 2 deletions
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 { |