Hi Josh,
I guess this is related to the nabble thread around April 1st:
http://www.nabble.com/POI-Formulas-td16397740.html
Oh yeah, that's a good discussion. Gee, it's been a busy 4 months.
There hasn't been much progress as of late. The junit
TestExternalFunction, shows the small amount POI supports so far.
There are many things outstanding, for instance recognising calls to
local VBA functions vs true external functions.
My goal was to support calls to the Analysis Toolpack. Once this is
done it will be clearer how to create a generalised interface for any
third party extension. Alternatively (if I'm too slow), someone else
can go ahead and add support for calling any external function, and
I'll chip in to make sure calls to the Analysis Toolpack will work OK
too.
Yes, your (4a)
(4b) Evaluating functions from non-standard but well known excel
add-ins such as 'Bloomberg'
FunctionAdapter - An interface a user can use to write a java class
that implements a named external function. What would that look like?
You'll know after (4a)
Then if someone has a Bloomberg or whatever itch it can be scratched
in a way compatible with your formula work.
(4c) Evaluating any arbitrary add-in function from a supplied .xlam or
.xll add-in file (VBA / .Net assemblies).
We could be interested in DotNetFunctionAdapter. And this is the "OS
limitations" issue - only works on Windows, not Java only.
It all depends on whether or not we want to convert some of our legacy
fortran code into C#, Java, or both. That will depend on what the
situation warrants. I am glad to have some viable plans to fit several
possible architectural requirements, but I really can't say any more ...
But no promises, we'll see which itch we have to scratch.
Best Regards,
Dave
regards,
Josh
On Thu, Jul 10, 2008 at 4:55 PM, David Fisher
<[EMAIL PROTECTED]> wrote:
Nick,
I think that there is something that can be done to allow a properly
motivated POI user to add support for any necessary "third party"
extension.
But we need to enable such a user first.
I would propose a FunctionAdapter interface. The user would then
roll their
own version of the extension in Java. A simple example would be a
"true
random" number generator. Josh would need to comment if this is
easy or hard
to do.
If such an interface were available, then a more complicated piece
would be
a DotNetFunctionAdapter that if run on a Windows platform could
harness an
Office extension that implements the .Net function interface for
Excel. I
can see a scenario where we might get a need to do this in Q4, but
I think
we're more motivated to support charting first.
Regards,
Dave
On Jul 10, 2008, at 6:05 PM, [EMAIL PROTECTED] wrote:
--- Comment #2 from Nick Burch <[EMAIL PROTECTED]> 2008-07-10
16:05:40
PST ---
At this time, we do not support excel formulas that utilise third
party
extensions, sorry
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
