From 4834a058aa3f953a7010704f2358633ae6e1d492 Mon Sep 17 00:00:00 2001 From: xuri Date: Mon, 19 Oct 2020 23:55:54 +0800 Subject: This closes #714 and closes #715, fix wrong worksheet index returned by NewSheet in some case, fix panic on formatted value with no built-in number format ID --- cell_test.go | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'cell_test.go') diff --git a/cell_test.go b/cell_test.go index a855344..f707256 100644 --- a/cell_test.go +++ b/cell_test.go @@ -299,4 +299,14 @@ func TestFormattedValue(t *testing.T) { assert.NoError(t, err) v = f.formattedValue(1, "43528") assert.Equal(t, "03/04/2019", v) + + // formatted value with no built-in number format ID + assert.NoError(t, err) + f.Styles.NumFmts = nil + numFmtID := 5 + f.Styles.CellXfs.Xf = append(f.Styles.CellXfs.Xf, xlsxXf{ + NumFmtID: &numFmtID, + }) + v = f.formattedValue(1, "43528") + assert.Equal(t, "43528", v) } -- cgit v1.2.1