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

1 files changed, 10 insertions, 0 deletions

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)
 }