Hi everyone!
I'm a new user for this mail group so let me know if I'm making any mistakes
here!
So I'm having some issues getting user defined functions running. I've defined
a STDEV.P and T.TEST custom functions and attached them using:
private static void setupCustomFormulas(Workbook wb){
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"). I think I'll fall back on j
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
You can get the list of currently supported functions by running some code.
See Supported Functions section of
https://poi.apache.org/spreadsheet/formula.html
We use bugzilla, and spreadsheet formulas belong to the Common SS module.
https://bz.apache.org/bugzilla/describecomponents.cgi?product=POI
OK cool, I'd love to help. I already have some base code and it's in my
interest to get this working anyhow.
So when I tried registering those formulas with this:
WorkbookEvaluator.registerFunction("STDEV.P", new STDEVP());
WorkbookEvaluator.registerFunction("T.TEST", new TTEST());
I got this e
