diff options
| author | xuri <xuri.me@gmail.com> | 2022-04-11 00:04:00 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-04-11 00:04:00 +0800 |
| commit | c1940c2a1ebd66519bb85abaa2fd7985f0430985 (patch) | |
| tree | c19d436c320ba46d8f42e7cbb960654e8cfe6b40 /calc_test.go | |
| parent | 9b8f1a15e1b75f56d9305b49212ee34ec085943f (diff) | |
This includes new formula functions support, dependencies upgrade, and bug fix
- Fix page setup fields parsing issue
- Go Modules dependencies upgrade
- Ref #65, CONFIDENCE.T and PHI
- Ref #1198, Fix the issue that the chart axis maximum and minimum didn't work when the value is 0
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 689fd92..c553d12 100644 --- a/calc_test.go +++ b/calc_test.go @@ -879,6 +879,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", + // CONFIDENCE.T + "=CONFIDENCE.T(0.05,0.07,100)": "0.0138895186611049", // CORREL "=CORREL(A1:A5,B1:B5)": "1", // COUNT @@ -1122,6 +1124,11 @@ func TestCalcCellValue(t *testing.T) { // PERMUTATIONA "=PERMUTATIONA(6,6)": "46656", "=PERMUTATIONA(7,6)": "117649", + // PHI + "=PHI(-1.5)": "0.129517595665892", + "=PHI(0)": "0.398942280401433", + "=PHI(0.1)": "0.396952547477012", + "=PHI(1)": "0.241970724519143", // QUARTILE "=QUARTILE(A1:A4,2)": "1.5", // QUARTILE.EXC @@ -2643,6 +2650,16 @@ func TestCalcCellValue(t *testing.T) { "=CORREL()": "CORREL requires 2 arguments", "=CORREL(A1:A3,B1:B5)": "#N/A", "=CORREL(A1:A1,B1:B1)": "#DIV/0!", + // CONFIDENCE.T + "=CONFIDENCE.T()": "CONFIDENCE.T requires 3 arguments", + "=CONFIDENCE.T(\"\",0.07,100)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CONFIDENCE.T(0.05,\"\",100)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CONFIDENCE.T(0.05,0.07,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=CONFIDENCE.T(0,0.07,100)": "#NUM!", + "=CONFIDENCE.T(1,0.07,100)": "#NUM!", + "=CONFIDENCE.T(0.05,0,100)": "#NUM!", + "=CONFIDENCE.T(0.05,0.07,0)": "#NUM!", + "=CONFIDENCE.T(0.05,0.07,1)": "#DIV/0!", // COUNTBLANK "=COUNTBLANK()": "COUNTBLANK requires 1 argument", "=COUNTBLANK(1,2)": "COUNTBLANK requires 1 argument", @@ -2985,6 +3002,9 @@ func TestCalcCellValue(t *testing.T) { "=PERMUTATIONA(0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", "=PERMUTATIONA(-1,0)": "#N/A", "=PERMUTATIONA(0,-1)": "#N/A", + // PHI + "=PHI()": "PHI requires 1 argument", + "=PHI(\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", // QUARTILE "=QUARTILE()": "QUARTILE requires 2 arguments", "=QUARTILE(A1:A4,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", |