diff options
| author | xuri <xuri.me@gmail.com> | 2021-09-03 22:51:56 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-09-03 22:51:56 +0800 |
| commit | 2616aa88cb2b1e45c03ada60093f4dfe7fabfb87 (patch) | |
| tree | 1e27c047dce669ad33f77e54ee0ea9c57526789c /excelize_test.go | |
| parent | 5e1fbd6bf703b9e3ff0eba48c7ee861b99778cba (diff) | |
Add set shared formula support and documentation for the `SetCellFormula`
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 28 |
1 files changed, 1 insertions, 27 deletions
diff --git a/excelize_test.go b/excelize_test.go index f33c3d5..02abce5 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -83,7 +83,7 @@ func TestOpenFile(t *testing.T) { assert.NoError(t, err) _, err = f.GetCellFormula("Sheet2", "I11") assert.NoError(t, err) - getSharedForumula(&xlsxWorksheet{}, "", "") + getSharedForumula(&xlsxWorksheet{}, 0, "") // Test read cell value with given illegal rows number. _, err = f.GetCellValue("Sheet2", "a-1") @@ -401,32 +401,6 @@ func TestGetCellHyperLink(t *testing.T) { } -func TestSetCellFormula(t *testing.T) { - f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) - if !assert.NoError(t, err) { - t.FailNow() - } - - assert.NoError(t, f.SetCellFormula("Sheet1", "B19", "SUM(Sheet2!D2,Sheet2!D11)")) - assert.NoError(t, f.SetCellFormula("Sheet1", "C19", "SUM(Sheet2!D2,Sheet2!D9)")) - - // Test set cell formula with illegal rows number. - assert.EqualError(t, f.SetCellFormula("Sheet1", "C", "SUM(Sheet2!D2,Sheet2!D9)"), `cannot convert cell "C" to coordinates: invalid cell name "C"`) - - assert.NoError(t, f.SaveAs(filepath.Join("test", "TestSetCellFormula1.xlsx"))) - - f, err = OpenFile(filepath.Join("test", "CalcChain.xlsx")) - if !assert.NoError(t, err) { - t.FailNow() - } - // Test remove cell formula. - assert.NoError(t, f.SetCellFormula("Sheet1", "A1", "")) - assert.NoError(t, f.SaveAs(filepath.Join("test", "TestSetCellFormula2.xlsx"))) - // Test remove all cell formula. - assert.NoError(t, f.SetCellFormula("Sheet1", "B1", "")) - assert.NoError(t, f.SaveAs(filepath.Join("test", "TestSetCellFormula3.xlsx"))) -} - func TestSetSheetBackground(t *testing.T) { f, err := OpenFile(filepath.Join("test", "Book1.xlsx")) if !assert.NoError(t, err) { |