diff options
| author | xuri <xuri.me@gmail.com> | 2022-04-07 08:16:55 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-04-07 08:16:55 +0800 |
| commit | 9b8f1a15e1b75f56d9305b49212ee34ec085943f (patch) | |
| tree | 99d1a7236f184eada699f34840881048b39880dc /calc_test.go | |
| parent | 5bf4bce9d41b2f8cd9d24e0d57a0d6868ef9433d (diff) | |
ref #65, new formula functions: MODE.MULT and MODE.SNGL
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 19 |
1 files changed, 14 insertions, 5 deletions
diff --git a/calc_test.go b/calc_test.go index f6499de..689fd92 100644 --- a/calc_test.go +++ b/calc_test.go @@ -4880,8 +4880,11 @@ func TestCalcMODE(t *testing.T) { } f := prepareCalcData(cellData) formulaList := map[string]string{ - "=MODE(A1:A10)": "3", - "=MODE(B1:B6)": "2", + "=MODE(A1:A10)": "3", + "=MODE(B1:B6)": "2", + "=MODE.MULT(A1:A10)": "", + "=MODE.SNGL(A1:A10)": "3", + "=MODE.SNGL(B1:B6)": "2", } for formula, expected := range formulaList { assert.NoError(t, f.SetCellFormula("Sheet1", "C1", formula)) @@ -4890,9 +4893,15 @@ func TestCalcMODE(t *testing.T) { assert.Equal(t, expected, result, formula) } calcError := map[string]string{ - "=MODE()": "MODE requires at least 1 argument", - "=MODE(0,\"\")": "#VALUE!", - "=MODE(D1:D3)": "#N/A", + "=MODE()": "MODE requires at least 1 argument", + "=MODE(0,\"\")": "#VALUE!", + "=MODE(D1:D3)": "#N/A", + "=MODE.MULT()": "MODE.MULT requires at least 1 argument", + "=MODE.MULT(0,\"\")": "#VALUE!", + "=MODE.MULT(D1:D3)": "#N/A", + "=MODE.SNGL()": "MODE.SNGL requires at least 1 argument", + "=MODE.SNGL(0,\"\")": "#VALUE!", + "=MODE.SNGL(D1:D3)": "#N/A", } for formula, expected := range calcError { assert.NoError(t, f.SetCellFormula("Sheet1", "C1", formula)) |