diff options
| author | Zhang Zhipeng <414326615@qq.com> | 2020-12-14 09:56:42 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-12-14 09:56:42 +0800 |
| commit | ad79505173302fdd7619288b793497052e25a148 (patch) | |
| tree | a3c994b63a6c0e32231f3ea10d4c87810d42796f /calc_test.go | |
| parent | 61057c58d34c78232ad0a5c1702ea9fa25a7641a (diff) | |
new formula func CLEAN and TRIM, change import path to v2 (#747)
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6998b77..f928797 100644 --- a/calc_test.go +++ b/calc_test.go @@ -463,6 +463,13 @@ func TestCalcCellValue(t *testing.T) { // DATE "=DATE(2020,10,21)": "2020-10-21 00:00:00 +0000 UTC", "=DATE(1900,1,1)": "1899-12-31 00:00:00 +0000 UTC", + // Text Functions + // CLEAN + "=CLEAN(\"\u0009clean text\")": "clean text", + "=CLEAN(0)": "0", + // TRIM + "=TRIM(\" trim text \")": "trim text", + "=TRIM(0)": "0", } for formula, expected := range mathCalc { f := prepareData() @@ -779,6 +786,13 @@ func TestCalcCellValue(t *testing.T) { `=DATE("text",10,21)`: "DATE requires 3 number arguments", `=DATE(2020,"text",21)`: "DATE requires 3 number arguments", `=DATE(2020,10,"text")`: "DATE requires 3 number arguments", + // Text Functions + // CLEAN + "=CLEAN()": "CLEAN requires 1 argument", + "=CLEAN(1,2)": "CLEAN requires 1 argument", + // TRIM + "=TRIM()": "TRIM requires 1 argument", + "=TRIM(1,2)": "TRIM requires 1 argument", } for formula, expected := range mathCalcError { f := prepareData() |