diff options
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/calc_test.go b/calc_test.go index 5d61712..1376c00 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1800,14 +1800,23 @@ func TestCalcCellValue(t *testing.T) { // Excel Lookup and Reference Functions // ADDRESS "=ADDRESS(1,1,1,TRUE)": "$A$1", + "=ADDRESS(1,2,1,TRUE)": "$B$1", "=ADDRESS(1,1,1,FALSE)": "R1C1", + "=ADDRESS(1,2,1,FALSE)": "R1C2", "=ADDRESS(1,1,2,TRUE)": "A$1", + "=ADDRESS(1,2,2,TRUE)": "B$1", "=ADDRESS(1,1,2,FALSE)": "R1C[1]", + "=ADDRESS(1,2,2,FALSE)": "R1C[2]", "=ADDRESS(1,1,3,TRUE)": "$A1", + "=ADDRESS(1,2,3,TRUE)": "$B1", "=ADDRESS(1,1,3,FALSE)": "R[1]C1", + "=ADDRESS(1,2,3,FALSE)": "R[1]C2", "=ADDRESS(1,1,4,TRUE)": "A1", + "=ADDRESS(1,2,4,TRUE)": "B1", "=ADDRESS(1,1,4,FALSE)": "R[1]C[1]", - "=ADDRESS(1,1,4,TRUE,\"\")": "A1", + "=ADDRESS(1,2,4,FALSE)": "R[1]C[2]", + "=ADDRESS(1,1,4,TRUE,\"\")": "!A1", + "=ADDRESS(1,2,4,TRUE,\"\")": "!B1", "=ADDRESS(1,1,4,TRUE,\"Sheet1\")": "Sheet1!A1", // CHOOSE "=CHOOSE(4,\"red\",\"blue\",\"green\",\"brown\")": "brown", |