diff options
| author | xuri <xuri.me@gmail.com> | 2021-03-21 23:45:36 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2021-03-21 23:59:58 +0800 |
| commit | 874d59cee02b5fab36e7cf5e2595c473f65f6c9d (patch) | |
| tree | 0e51c5263e799400349742c7eaa662e60db5bc83 /calc_test.go | |
| parent | d3227393efb037bc13a4b5f7b150715f22761b4d (diff) | |
related issue #65 fn: FIXED
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 6fc61b0..d6a15c9 100644 --- a/calc_test.go +++ b/calc_test.go @@ -759,6 +759,15 @@ func TestCalcCellValue(t *testing.T) { "=EXACT(1,\"1\")": "TRUE", "=EXACT(1,1)": "TRUE", "=EXACT(\"A\",\"a\")": "FALSE", + // FIXED + "=FIXED(5123.591)": "5,123.591", + "=FIXED(5123.591,1)": "5,123.6", + "=FIXED(5123.591,0)": "5,124", + "=FIXED(5123.591,-1)": "5,120", + "=FIXED(5123.591,-2)": "5,100", + "=FIXED(5123.591,-3,TRUE)": "5000", + "=FIXED(5123.591,-5)": "0", + "=FIXED(-77262.23973,-5)": "-100,000", // FIND "=FIND(\"T\",\"Original Text\")": "10", "=FIND(\"t\",\"Original Text\")": "13", @@ -1478,6 +1487,12 @@ func TestCalcCellValue(t *testing.T) { // EXACT "=EXACT()": "EXACT requires 2 arguments", "=EXACT(1,2,3)": "EXACT requires 2 arguments", + // FIXED + "=FIXED()": "FIXED requires at least 1 argument", + "=FIXED(0,1,2,3)": "FIXED allows at most 3 arguments", + "=FIXED(\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=FIXED(0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=FIXED(0,0,\"\")": "strconv.ParseBool: parsing \"\": invalid syntax", // FIND "=FIND()": "FIND requires at least 2 arguments", "=FIND(1,2,3,4)": "FIND allows at most 3 arguments", |