From 19a0cf3cec71fc49851d29fb420674b027f50d93 Mon Sep 17 00:00:00 2001 From: xuri Date: Sun, 15 May 2022 15:38:40 +0800 Subject: This closed #1163, fix set cell value with column and row style inherit issue --- cell_test.go | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'cell_test.go') diff --git a/cell_test.go b/cell_test.go index 8ed8e1f..da251cd 100644 --- a/cell_test.go +++ b/cell_test.go @@ -156,6 +156,21 @@ func TestSetCellValue(t *testing.T) { f := NewFile() assert.EqualError(t, f.SetCellValue("Sheet1", "A", time.Now().UTC()), newCellNameToCoordinatesError("A", newInvalidCellNameError("A")).Error()) assert.EqualError(t, f.SetCellValue("Sheet1", "A", time.Duration(1e13)), newCellNameToCoordinatesError("A", newInvalidCellNameError("A")).Error()) + // Test set cell value with column and row style inherit + style1, err := f.NewStyle(&Style{NumFmt: 2}) + assert.NoError(t, err) + style2, err := f.NewStyle(&Style{NumFmt: 9}) + assert.NoError(t, err) + assert.NoError(t, f.SetColStyle("Sheet1", "B", style1)) + assert.NoError(t, f.SetRowStyle("Sheet1", 1, 1, style2)) + assert.NoError(t, f.SetCellValue("Sheet1", "B1", 0.5)) + assert.NoError(t, f.SetCellValue("Sheet1", "B2", 0.5)) + B1, err := f.GetCellValue("Sheet1", "B1") + assert.NoError(t, err) + assert.Equal(t, "50%", B1) + B2, err := f.GetCellValue("Sheet1", "B2") + assert.NoError(t, err) + assert.Equal(t, "0.50", B2) } func TestSetCellValues(t *testing.T) { -- cgit v1.2.1