diff options
| author | xuri <xuri.me@gmail.com> | 2022-05-15 15:38:40 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-05-15 15:38:40 +0800 |
| commit | 19a0cf3cec71fc49851d29fb420674b027f50d93 (patch) | |
| tree | 4603ca353c4fa71be49edc6b4c99ebec4fd8d6eb /cell_test.go | |
| parent | c2311ce87dd2c681406728f885d2228dbefd7a21 (diff) | |
This closed #1163, fix set cell value with column and row style inherit issue
Diffstat (limited to 'cell_test.go')
| -rw-r--r-- | cell_test.go | 15 |
1 files changed, 15 insertions, 0 deletions
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) { |