From 89c262fc1d525f74bb0e2fb61ae7a3d10d07a12a Mon Sep 17 00:00:00 2001
From: xuri <xuri.me@gmail.com>
Date: Sat, 3 Apr 2021 22:56:02 +0800
Subject: Fixed #813, streaming data writer result missing after call normal
 API #65 formula function: COMPLEX

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

(limited to 'calc_test.go')

diff --git a/calc_test.go b/calc_test.go
index 04f95bc..2abeec0 100644
--- a/calc_test.go
+++ b/calc_test.go
@@ -83,6 +83,13 @@ func TestCalcCellValue(t *testing.T) {
 		// BITXOR
 		"=BITXOR(5,6)":  "3",
 		"=BITXOR(9,12)": "5",
+		// COMPLEX
+		"=COMPLEX(5,2)":         "5+2i",
+		"=COMPLEX(5,-9)":        "5-9i",
+		"=COMPLEX(-1,2,\"j\")":  "-1+2j",
+		"=COMPLEX(10,-5,\"i\")": "10-5i",
+		"=COMPLEX(0,5)":         "5i",
+		"=COMPLEX(3,0)":         "3",
 		// DEC2BIN
 		"=DEC2BIN(2)":    "10",
 		"=DEC2BIN(3)":    "11",
@@ -1080,6 +1087,12 @@ func TestCalcCellValue(t *testing.T) {
 		"=BITXOR(\"\",-1)": "#NUM!",
 		"=BITXOR(1,\"\")":  "#NUM!",
 		"=BITXOR(1,2^48)":  "#NUM!",
+		// COMPLEX
+		"=COMPLEX()":              "COMPLEX requires at least 2 arguments",
+		"=COMPLEX(10,-5,\"\")":    "#VALUE!",
+		"=COMPLEX(\"\",0)":        "strconv.ParseFloat: parsing \"\": invalid syntax",
+		"=COMPLEX(0,\"\")":        "strconv.ParseFloat: parsing \"\": invalid syntax",
+		"=COMPLEX(10,-5,\"i\",0)": "COMPLEX allows at most 3 arguments",
 		// DEC2BIN
 		"=DEC2BIN()":        "DEC2BIN requires at least 1 argument",
 		"=DEC2BIN(1,1,1)":   "DEC2BIN allows at most 2 arguments",
-- 
cgit v1.2.1