poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Micich" <josh.mic...@gmail.com>
Subject Re: [Bug 33726] Strange Formulas not parsed
Date Fri, 11 Jul 2008 00:41:56 GMT
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 <dfisher@jmlafferty.com> 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, bugzilla@apache.org wrote:
>
>> --- Comment #2 from Nick Burch <nick@torchbox.com>  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message