diff options
| author | xuri <xuri.me@gmail.com> | 2022-03-06 00:29:33 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-03-06 00:29:33 +0800 |
| commit | 354d1696d8999ea00cb420f633a9abaae67228b6 (patch) | |
| tree | 2524c600729295486b64ef43449f906b0a0f680b /calc_test.go | |
| parent | f0cb29cf6668ab96992b1e48278d9f5b1f9e4976 (diff) | |
ref #65, new formula functions: CORREL, SUMX2MY2, SUMX2PY2, and SUMXMY2
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 3749702..fa216c9 100644 --- a/calc_test.go +++ b/calc_test.go @@ -747,6 +747,12 @@ func TestCalcCellValue(t *testing.T) { `=SUMSQ("",A1,B1,A2,B2,6)`: "82", `=SUMSQ(1,SUMSQ(1))`: "2", "=SUMSQ(MUNIT(3))": "0", + // SUMX2MY2 + "=SUMX2MY2(A1:A4,B1:B4)": "-36", + // SUMX2PY2 + "=SUMX2PY2(A1:A4,B1:B4)": "46", + // SUMXMY2 + "=SUMXMY2(A1:A4,B1:B4)": "18", // TAN "=TAN(1.047197551)": "1.732050806782486", "=TAN(0)": "0", @@ -785,6 +791,8 @@ func TestCalcCellValue(t *testing.T) { "=CONFIDENCE(0.05,0.07,100)": "0.0137197479028414", // CONFIDENCE.NORM "=CONFIDENCE.NORM(0.05,0.07,100)": "0.0137197479028414", + // CORREL + "=CORREL(A1:A5,B1:B5)": "1", // COUNT "=COUNT()": "0", "=COUNT(E1:F2,\"text\",1,INT(2))": "3", @@ -2238,6 +2246,15 @@ func TestCalcCellValue(t *testing.T) { // SUMSQ `=SUMSQ("X")`: "strconv.ParseFloat: parsing \"X\": invalid syntax", "=SUMSQ(C1:D2)": "strconv.ParseFloat: parsing \"Month\": invalid syntax", + // SUMX2MY2 + "=SUMX2MY2()": "SUMX2MY2 requires 2 arguments", + "=SUMX2MY2(A1,B1:B2)": "#N/A", + // SUMX2PY2 + "=SUMX2PY2()": "SUMX2PY2 requires 2 arguments", + "=SUMX2PY2(A1,B1:B2)": "#N/A", + // SUMXMY2 + "=SUMXMY2()": "SUMXMY2 requires 2 arguments", + "=SUMXMY2(A1,B1:B2)": "#N/A", // TAN "=TAN()": "TAN requires 1 numeric argument", `=TAN("X")`: "strconv.ParseFloat: parsing \"X\": invalid syntax", @@ -2284,6 +2301,10 @@ func TestCalcCellValue(t *testing.T) { "=CONFIDENCE.NORM(1,0.07,100)": "#NUM!", "=CONFIDENCE.NORM(0.05,0,100)": "#NUM!", "=CONFIDENCE.NORM(0.05,0.07,0.5)": "#NUM!", + // CORREL + "=CORREL()": "CORREL requires 2 arguments", + "=CORREL(A1:A3,B1:B5)": "#N/A", + "=CORREL(A1:A1,B1:B1)": "#DIV/0!", // COUNTBLANK "=COUNTBLANK()": "COUNTBLANK requires 1 argument", "=COUNTBLANK(1,2)": "COUNTBLANK requires 1 argument", |