diff options
| author | devloppper <76152313+devloppper@users.noreply.github.com> | 2022-11-22 00:14:03 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-11-22 00:15:57 +0800 |
| commit | dde6b9c00135cefffdd9c64b7f22cfdc34c28e47 (patch) | |
| tree | 3398c109a25a64db3e2371a389f488dc44b07554 /calc_test.go | |
| parent | aa80fa417985cb8f7df77d45825c41a81206df98 (diff) | |
This closes #1396, fix formula fn ADDRESS result error with empty worksheet name (#1397)
- Update unit tests
Co-authored-by: jayhoo <hujie@ynningneng.com>
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", |