On Tue, 13 Sep 2016, Justin Flowers wrote:
OK, it was a sanity issue on my part. Apparently you can get this issue
if a UDF is not defined. And of course I wrote a Java UDF here that it
cannot find on its side. The functions I'm implementing already exist in
Excel, just not yet in POI ("STDEV.P" and "T.TEST").
Ah. You can't generally use UDFs to implement functions that POI lacks,
generally only for brand new custom functions. See
http://poi.apache.org/spreadsheet/eval-devguide.html for a bit more on
implementing a "missing" function, and also a talk from an old ApacheCon:
http://home.apache.org/~yegor/apachecon_us2010/Evaluation_Of_Excel_Formulas_In_POI.pptx
We'd love a patch if you can implement the missing functions! See
http://poi.apache.org/guidelines.html
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org
