diff options
| author | xuri <xuri.me@gmail.com> | 2022-07-03 15:31:24 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-07-03 15:31:24 +0800 |
| commit | d74adcbb159280be962918125d20ec8ac67a3f93 (patch) | |
| tree | a3cd2c37ec175b8400a9d13eef5c7565aaacca05 /calc_test.go | |
| parent | 695db4eae06fdc2a049fc50f61e6a60f83013290 (diff) | |
ref #65, new formula function: DGET
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 4436b60..b8efd61 100644 --- a/calc_test.go +++ b/calc_test.go @@ -4632,6 +4632,7 @@ func TestCalcDatabase(t *testing.T) { "=DCOUNTA(A4:E10,\"Profit\",A1:F2)": "2", "=DCOUNTA(A4:E10,\"Tree\",A1:F2)": "2", "=DCOUNTA(A4:E10,\"Age\",A2:F3)": "0", + "=DGET(A4:E6,\"Profit\",A1:F3)": "96", "=DMAX(A4:E10,\"Tree\",A1:F3)": "0", "=DMAX(A4:E10,\"Profit\",A1:F3)": "96", "=DMIN(A4:E10,\"Tree\",A1:F3)": "0", @@ -4665,6 +4666,9 @@ func TestCalcDatabase(t *testing.T) { "=DCOUNTA(A4:E10,NA(),A1:F2)": "#VALUE!", "=DCOUNTA(A4:E4,,A1:F2)": "#VALUE!", "=DCOUNTA(A4:E10,\"x\",A2:F3)": "#VALUE!", + "=DGET()": "DGET requires 3 arguments", + "=DGET(A4:E5,\"Profit\",A1:F3)": "#VALUE!", + "=DGET(A4:E10,\"Profit\",A1:F3)": "#NUM!", "=DMAX()": "DMAX requires 3 arguments", "=DMAX(A4:E10,\"x\",A1:F3)": "#VALUE!", "=DMIN()": "DMIN requires 3 arguments", |