diff options
| author | xuri <xuri.me@gmail.com> | 2022-06-24 01:03:19 +0800 |
|---|---|---|
| committer | xuri <xuri.me@gmail.com> | 2022-06-24 01:03:19 +0800 |
| commit | 2e1b0efadc0519fa4572b2437401bf2993366a07 (patch) | |
| tree | 8af25079777593916bfd4e40febea172d094a1f7 /calc_test.go | |
| parent | 61c71caf4fdd056a45c69d8f3aea2231da2c074a (diff) | |
ref #65, new formula function: HYPERLINK
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", |