diff options
| author | xuri <xuri.me@gmail.com> | 2020-05-31 15:13:52 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2020-05-31 15:13:52 +0800 |
| commit | 22df34c4933bb28f6827b011cb6d9d3fd9f0e8d2 (patch) | |
| tree | 4d813ed6e18c1e608cc3425cadb098ccb1415ba1 /calc_test.go | |
| parent | fa2571a17e869d5793d14dd67d8e2a6d15e80daf (diff) | |
fn: ISBLANK, ISERR, ISERROR, ISEVEN, ISNA, ISNONTEXT, ISODD, NA
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 3639af7..4f2ca7b 100644 --- a/calc_test.go +++ b/calc_test.go @@ -384,6 +384,32 @@ func TestCalcCellValue(t *testing.T) { "=TRUNC(99.999,-1)": "90", "=TRUNC(-99.999,2)": "-99.99", "=TRUNC(-99.999,-1)": "-90", + // Information functions + // ISBLANK + "=ISBLANK(A1)": "FALSE", + "=ISBLANK(A5)": "TRUE", + // ISERR + "=ISERR(A1)": "FALSE", + "=ISERR(NA())": "FALSE", + // ISERROR + "=ISERROR(A1)": "FALSE", + "=ISERROR(NA())": "TRUE", + // ISEVEN + "=ISEVEN(A1)": "FALSE", + "=ISEVEN(A2)": "TRUE", + // ISNA + "=ISNA(A1)": "FALSE", + "=ISNA(NA())": "TRUE", + // ISNONTEXT + "=ISNONTEXT(A1)": "FALSE", + "=ISNONTEXT(A5)": "TRUE", + `=ISNONTEXT("Excelize")`: "FALSE", + "=ISNONTEXT(NA())": "FALSE", + // ISODD + "=ISODD(A1)": "TRUE", + "=ISODD(A2)": "FALSE", + // NA + "=NA()": "#N/A", } for formula, expected := range mathCalc { f := prepareData() @@ -659,6 +685,23 @@ func TestCalcCellValue(t *testing.T) { "=TRUNC()": "TRUNC requires at least 1 argument", `=TRUNC("X")`: "#VALUE!", `=TRUNC(1,"X")`: "#VALUE!", + // Information functions + // ISBLANK + "=ISBLANK(A1,A2)": "ISBLANK requires 1 argument", + // ISERR + "=ISERR()": "ISERR requires 1 argument", + // ISERROR + "=ISERROR()": "ISERROR requires 1 argument", + // ISEVEN + "=ISEVEN()": "ISEVEN requires 1 argument", + // ISNA + "=ISNA()": "ISNA requires 1 argument", + // ISNONTEXT + "=ISNONTEXT()": "ISNONTEXT requires 1 argument", + // ISODD + "=ISODD()": "ISODD requires 1 argument", + // NA + "=NA(1)": "NA accepts no arguments", } for formula, expected := range mathCalcError { f := prepareData() |