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 error:
"java.lang.IllegalArgumentException: STDEV.P is not a function from the Excel
Analysis Toolpack."
Any ideas what direction I should be looking to add "STDEV.P" and "T.TEST" to
my local version so that this exception isn't thrown? I'm guessing to look at
"org.apache.poi.ss.formula.atp.AnalysisToolPak" ? Is there a central file that
contains all valid formula prototypes?
Justin
-----Original Message-----
From: Javen O'Neal [mailto:[email protected]]
Sent: September-13-16 12:49 PM
To: POI Users List <[email protected]>
Subject: RE: Formulas don't throw exceptions but show up "#NAME"
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
On Sep 13, 2016 9:31 AM, "Nick Burch" <[email protected]> wrote:
> 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: [email protected] For additional
> commands, e-mail: [email protected]
>
>
