https://bz.apache.org/bugzilla/show_bug.cgi?id=60355
Javen O'Neal <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #1 from Javen O'Neal <[email protected]> --- (In reply to kenneth_lau from comment #0) > HsGetVal is a valid XLA Add-In formula. Excel is able to read and parse > without problems. POI does not natively know how to evaluate HsGetValue because it is not an Excel core function or a function in the official Excel Analysis ToolPak [1]. If you need to evaluate this formula in POI, you can re-implement HsGetValue as a FreeRefFunction and register the function with a POI formula evaluator [2]. You may also find [3] and [4] helpful to learn about formula evaluation in POI. For examples of User Defined Functions in POI, see [5] and [6] [1] https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-6a63e598-cd6d-42e3-9317-6b40ba1a66b4 [2] https://poi.apache.org/spreadsheet/user-defined-functions.html [3] https://poi.apache.org/spreadsheet/eval-devguide.html [4] https://poi.apache.org/spreadsheet/formula.html [5] https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/SettingExternalFunction.java?view=markup [6] https://svn.apache.org/viewvc/poi/trunk/src/examples/src/org/apache/poi/ss/examples/formula/UserDefinedFunctionExample.java?view=markup -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
