diff options
| author | xuri <xuri.me@gmail.com> | 2021-02-15 00:09:35 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-02-15 00:09:35 +0800 |
| commit | 36b7990d6ba1036823abf7a01ec8cf74509d4910 (patch) | |
| tree | 118e8a9e0db3d071defb497cd98b2fa85595f7b9 /excelize_test.go | |
| parent | ca6b1577a7d1508e61e7084ee67ab0dd759b305e (diff) | |
lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/excelize_test.go b/excelize_test.go index 1b48872..8bce6d1 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -542,10 +542,10 @@ func TestWriteArrayFormula(t *testing.T) { assert.NoError(t, f.SetCellFormula("Sheet1", avgCell, fmt.Sprintf("ROUND(AVERAGEIF(%s,%s,%s),0)", assocRange, nameCell, valRange))) ref := stdevCell + ":" + stdevCell - t := STCellFormulaTypeArray + arr := STCellFormulaTypeArray // Use an array formula for standard deviation - f.SetCellFormula("Sheet1", stdevCell, fmt.Sprintf("ROUND(STDEVP(IF(%s=%s,%s)),0)", assocRange, nameCell, valRange), - FormulaOpts{}, FormulaOpts{Type: &t}, FormulaOpts{Ref: &ref}) + assert.NoError(t, f.SetCellFormula("Sheet1", stdevCell, fmt.Sprintf("ROUND(STDEVP(IF(%s=%s,%s)),0)", assocRange, nameCell, valRange), + FormulaOpts{}, FormulaOpts{Type: &arr}, FormulaOpts{Ref: &ref})) } assert.NoError(t, f.SaveAs(filepath.Join("test", "TestWriteArrayFormula.xlsx"))) |