From 2e1b0efadc0519fa4572b2437401bf2993366a07 Mon Sep 17 00:00:00 2001 From: xuri Date: Fri, 24 Jun 2022 01:03:19 +0800 Subject: ref #65, new formula function: HYPERLINK --- calc.go | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'calc.go') diff --git a/calc.go b/calc.go index c71cd10..d9bf653 100644 --- a/calc.go +++ b/calc.go @@ -14514,6 +14514,21 @@ func (fn *formulaFuncs) HLOOKUP(argsList *list.List) formulaArg { return newErrorFormulaArg(formulaErrorNA, "HLOOKUP no result found") } +// HYPERLINK function creates a hyperlink to a specified location. The syntax +// of the function is: +// +// HYPERLINK(link_location,[friendly_name]) +// +func (fn *formulaFuncs) HYPERLINK(argsList *list.List) formulaArg { + if argsList.Len() < 1 { + return newErrorFormulaArg(formulaErrorVALUE, "HYPERLINK requires at least 1 argument") + } + if argsList.Len() > 2 { + return newErrorFormulaArg(formulaErrorVALUE, "HYPERLINK allows at most 2 arguments") + } + return newStringFormulaArg(argsList.Back().Value.(formulaArg).Value()) +} + // calcMatch returns the position of the value by given match type, criteria // and lookup array for the formula function MATCH. func calcMatch(matchType int, criteria *formulaCriteria, lookupArray []formulaArg) formulaArg { -- cgit v1.2.1