You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by poijava <ga...@hsbcib.com> on 2008/04/01 11:02:00 UTC
Re: POI Formulas
Do you know where I can get the latest SVN build?
g
Josh Micich wrote:
>
> With regard to generation of spreadsheets, POI currently only supports
> built-in functions (the ~300 basic functions like ROUND and STDEV).
>
> I did some quick research on the "Bloomberg Excel add-in", but I
> couldn't determine exactly how to set up my Excel so that I could try
> calling BDP. I'm guessing that there is a .xlam or .xll file, for
> Bloomberg, much like the standard "Analysis Toolpack" (analys32.xll /
> atpvbaen.xlam which has functions like PRICE, YIELD and WEEKNUM)
>
> I think that POI currently encodes an unknown function call as an
> 'external function in the current workbook', but what is needed (for
> add-ins) is an 'external function in an external workbook'. POI may
> support calls to add-ins soon, and if the bloomberg stuff is an
> "add-in", your sample code should work.
>
> BTW, when I try the code on the latest svn trunk, the formula
> *appears* to get in OK (the cell content displays as '=BDP(A1,"PX YEST
> CLOSE")' ). My excel(2007) evaluates this to '#NAME?'
>
> I can think of two main reasons why you got '=#N/A', and I got '#NAME?'
> - you are using a prior version of POI (less than svn trunk which is
> 3.0.2+), in which case there is a very slight chance that the trunk
> may actually work for you.
> - you have the Bloomberg add-in which confuses Excel as to the exact
> definition of the called BDP().
>
>
>
> On Mon, Mar 31, 2008 at 10:50 AM, poijava <ga...@hsbcib.com>
> wrote:
>>
>> Hi I am trying to create a formula in Java to call a bloomberg function
>> in
>> excel as follows
>>
>> cell1.setCellFormula("BDP(A1,\"PX YEST CLOSE\")");
>>
>> I get a "=#N/A" in the column when the spreadsheet is opened. Can anyone
>> help?
>> --
>> View this message in context:
>> http://www.nabble.com/POI-Formulas-tp16397740p16397740.html
>> Sent from the POI - Dev mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
--
View this message in context: http://www.nabble.com/POI-Formulas-tp16397740p16416906.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: POI Formulas
Posted by Nick Burch <ni...@torchbox.com>.
On Tue, 1 Apr 2008, poijava wrote:
> Do you know where I can get the latest SVN build?
If you don't want to do your own svn checkout, you can get automatically
built nightlies from
http://encore.torchbox.com/poi-svn-build/
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org