You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/07/11 01:05:40 UTC
DO NOT REPLY [Bug 33726] Strange Formulas not parsed
https://issues.apache.org/bugzilla/show_bug.cgi?id=33726
Nick Burch <ni...@torchbox.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|major |enhancement
Status|NEW |RESOLVED
Resolution| |WONTFIX
--- Comment #2 from Nick Burch <ni...@torchbox.com> 2008-07-10 16:05:40 PST ---
At this time, we do not support excel formulas that utilise third party
extensions, sorry
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: [Bug 33726] Strange Formulas not parsed
Posted by David Fisher <df...@jmlafferty.com>.
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
> <df...@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 <ni...@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
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: [Bug 33726] Strange Formulas not parsed
Posted by Josh Micich <jo...@gmail.com>.
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 <df...@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 <ni...@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
Re: [Bug 33726] Strange Formulas not parsed
Posted by David Fisher <df...@jmlafferty.com>.
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 <ni...@torchbox.com> 2008-07-10
> 16:05:40 PST ---
> At this time, we do not support excel formulas that utilise third
> party
> extensions, sorry