Hello Dave, I guess this is related to the nabble thread around April 1st: http://www.nabble.com/POI-Formulas-td16397740.html
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. 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]
