diff options
Diffstat (limited to 'calc_test.go')
-rw-r--r-- | calc_test.go | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 2cd5646..b3eb196 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1788,6 +1788,9 @@ func TestCalcCellValue(t *testing.T) { "=HLOOKUP(F3,F3:F8,3,FALSE)": "34440", "=HLOOKUP(INT(F3),F3:F8,3,FALSE)": "34440", "=HLOOKUP(MUNIT(1),MUNIT(1),1,FALSE)": "1", + // HYPERLINK + "=HYPERLINK(\"https://github.com/xuri/excelize\")": "https://github.com/xuri/excelize", + "=HYPERLINK(\"https://github.com/xuri/excelize\",\"Excelize\")": "Excelize", // VLOOKUP "=VLOOKUP(D2,D:D,1,FALSE)": "Jan", "=VLOOKUP(D2,D1:D10,1)": "Jan", @@ -3725,6 +3728,9 @@ func TestCalcCellValue(t *testing.T) { "=MATCH(0,A1:B1)": "MATCH arguments lookup_array should be one-dimensional array", // TRANSPOSE "=TRANSPOSE()": "TRANSPOSE requires 1 argument", + // HYPERLINK + "=HYPERLINK()": "HYPERLINK requires at least 1 argument", + "=HYPERLINK(\"https://github.com/xuri/excelize\",\"Excelize\",\"\")": "HYPERLINK allows at most 2 arguments", // VLOOKUP "=VLOOKUP()": "VLOOKUP requires at least 3 arguments", "=VLOOKUP(D2,D1,1,FALSE)": "VLOOKUP requires second argument of table array", |