From 36b7990d6ba1036823abf7a01ec8cf74509d4910 Mon Sep 17 00:00:00 2001 From: xuri Date: Mon, 15 Feb 2021 00:09:35 +0800 Subject: lint issue fixed and new formula function: ATAN, AVERAGE, AVERAGEA, CONCAT, CONCATENATE, COUNT, COUNTBLANK, MAX --- excelize_test.go | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'excelize_test.go') 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"))) -- cgit v1.2.1