summaryrefslogtreecommitdiff
path: root/styles_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'styles_test.go')
-rw-r--r--styles_test.go29
1 files changed, 28 insertions, 1 deletions
diff --git a/styles_test.go b/styles_test.go
index 69266ea..720340f 100644
--- a/styles_test.go
+++ b/styles_test.go
@@ -252,6 +252,33 @@ func TestNewStyle(t *testing.T) {
rows, err := f.GetRows("Sheet1")
assert.NoError(t, err)
assert.Equal(t, [][]string{{"1.23E+00", "1.23E+00"}}, rows)
+
+ f = NewFile()
+ // Test currency number format
+ customNumFmt := "[$$-409]#,##0.00"
+ style1, err := f.NewStyle(&Style{CustomNumFmt: &customNumFmt})
+ assert.NoError(t, err)
+ style2, err := f.NewStyle(&Style{NumFmt: 165})
+ assert.NoError(t, err)
+ assert.Equal(t, style1, style2)
+
+ style3, err := f.NewStyle(&Style{NumFmt: 166})
+ assert.NoError(t, err)
+ assert.Equal(t, 2, style3)
+
+ f = NewFile()
+ f.Styles.NumFmts = nil
+ f.Styles.CellXfs.Xf = nil
+ style4, err := f.NewStyle(&Style{NumFmt: 160, Lang: "unknown"})
+ assert.NoError(t, err)
+ assert.Equal(t, 1, style4)
+
+ f = NewFile()
+ f.Styles.NumFmts = nil
+ f.Styles.CellXfs.Xf = nil
+ style5, err := f.NewStyle(&Style{NumFmt: 160, Lang: "zh-cn"})
+ assert.NoError(t, err)
+ assert.Equal(t, 1, style5)
}
func TestGetDefaultFont(t *testing.T) {
@@ -344,4 +371,4 @@ func TestGetNumFmtID(t *testing.T) {
assert.NotEqual(t, id1, id2)
assert.NoError(t, f.SaveAs(filepath.Join("test", "TestStyleNumFmt.xlsx")))
-} \ No newline at end of file
+}