From ad79505173302fdd7619288b793497052e25a148 Mon Sep 17 00:00:00 2001
From: Zhang Zhipeng <414326615@qq.com>
Date: Mon, 14 Dec 2020 09:56:42 +0800
Subject: new formula func CLEAN and TRIM, change import path to v2 (#747)

---
 calc_test.go | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'calc_test.go')

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()
-- 
cgit v1.2.1