From dde6b9c00135cefffdd9c64b7f22cfdc34c28e47 Mon Sep 17 00:00:00 2001
From: devloppper <76152313+devloppper@users.noreply.github.com>
Date: Tue, 22 Nov 2022 00:14:03 +0800
Subject: This closes #1396, fix formula fn ADDRESS result error with empty
 worksheet name (#1397)

- Update unit tests

Co-authored-by: jayhoo <hujie@ynningneng.com>
---
 calc_test.go | 11 ++++++++++-
 1 file changed, 10 insertions(+), 1 deletion(-)

(limited to 'calc_test.go')

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",
-- 
cgit v1.2.1