diff options
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 92460d7..2cd5646 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1922,6 +1922,13 @@ func TestCalcCellValue(t *testing.T) { // EFFECT "=EFFECT(0.1,4)": "0.103812890625", "=EFFECT(0.025,2)": "0.02515625", + // EUROCONVERT + "=EUROCONVERT(1.47,\"EUR\",\"EUR\")": "1.47", + "=EUROCONVERT(1.47,\"EUR\",\"DEM\")": "2.88", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\")": "0.44", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",FALSE)": "0.44", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",FALSE,3)": "0.44", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",TRUE,3)": "0.43810592", // FV "=FV(0.05/12,60,-1000)": "68006.0828408434", "=FV(0.1/4,16,-2000,0,1)": "39729.4608941662", @@ -3958,6 +3965,14 @@ func TestCalcCellValue(t *testing.T) { "=EFFECT(0,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", "=EFFECT(0,0)": "#NUM!", "=EFFECT(1,0)": "#NUM!", + // EUROCONVERT + "=EUROCONVERT()": "EUROCONVERT requires at least 3 arguments", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",TRUE,3,1)": "EUROCONVERT allows at most 5 arguments", + "=EUROCONVERT(\"\",\"FRF\",\"DEM\",TRUE,3)": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",\"\",3)": "strconv.ParseBool: parsing \"\": invalid syntax", + "=EUROCONVERT(1.47,\"FRF\",\"DEM\",TRUE,\"\")": "strconv.ParseFloat: parsing \"\": invalid syntax", + "=EUROCONVERT(1.47,\"\",\"DEM\")": "#VALUE!", + "=EUROCONVERT(1.47,\"FRF\",\"\",TRUE,3)": "#VALUE!", // FV "=FV()": "FV requires at least 3 arguments", "=FV(0,0,0,0,0,0,0)": "FV allows at most 5 arguments", |