diff options
| author | xuri <xuri.me@gmail.com> | 2021-04-03 22:56:02 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-04-03 22:56:02 +0800 |
| commit | 89c262fc1d525f74bb0e2fb61ae7a3d10d07a12a (patch) | |
| tree | 76883f69be3b44beeb18e7da66183e8d591df123 /calc_test.go | |
| parent | 6e812a27c6e74a141e301c0f19484743ea437c52 (diff) | |
Fixed #813, streaming data writer result missing after call normal API
#65 formula function: COMPLEX
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 13 |
1 files changed, 13 insertions, 0 deletions
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", |