Re: [Quantlib-dev] [Quantlib-users] QuantlibXL with Office 2003 Service Pack 3

[Ferdinando A. <na...@am...>]

On Wed, Mar 3, 2010 at 9:09 AM, Yang Ye <lea...@ya...> wrote:
> We got a problem for functions returning double with Office 2003 SP3.
> E.g.  function qlSmileSectionVolatility. Sometimes, it return just 0;
> Sometimes, it return a very big number (negative/positive). We could
> trace to
>
> returnValue = ObjectIdLibObjPtr->volatility(
>               StrikeCpp);
> return &returnValue;
>
> returnValue is still correct before return. But Excel displayed the
> wrong number.

this is the second report I receive about this kind of problem. what
version of Excel are you using?

An user wrote me about Excel 2003 (11.8169.8172) SP3 having the bug
while Excel 2003 (11.8237.8221) SP3 is working correctly.
I use Excel 2003 (11.8220.8202) SP3 and don't have this problem.

I googled around with no luck, I hope somebody more knowledgeable will help

ciao -- Nando