qlxl #NUM!

[paolo baroni]

Hi,

sometimes when I open a spreadsheet or when I copy a function the qlxl seems not working well and the output of the functions is #NUM!.

For example in "Yield Curve Bootstrapping2" (in attachment) I tried to use, in cols R and S  the same function as in col H. On my computer the output is #NUM!.

Can someone help me?

Thanks

Paolo

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Eric Ehlers-2]

Hi Paolo,

Any time a QuantLibXL function returns #NUM, the error message can be  
retrieved with ohRangeRetrieveError().

Regards,
Eric

> Hi,
> sometimes when I open a spreadsheet or when I copy a function the qlxl seems
> not working well and the output of the functions is #NUM!.
>
> For example in "Yield Curve Bootstrapping2" (in attachment) I tried to use,
> in cols R and S  the same function as in col H. On my computer the output is
> #NUM!.
>
> Can someone help me?
>
> Thanks
>
> Paolo
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>

===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid


------------------------------------------------------------------------------
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[paolo baroni]

Hi Eric,

I don't know why but it doesn't work yet. For example if I open a xls as <book2> sent by Giuseppe Circo the functions work well but if I save it on my pc it doesn't work anymore...

Suggestions?

Thanks

ciao Paolo

2010/4/29 Eric Ehlers <[hidden email]>

Hi Paolo,

Any time a QuantLibXL function returns #NUM, the error message can be retrieved with ohRangeRetrieveError().

Regards,
Eric

Hi,
sometimes when I open a spreadsheet or when I copy a function the qlxl seems
not working well and the output of the functions is #NUM!.

For example in "Yield Curve Bootstrapping2" (in attachment) I tried to use,
in cols R and S  the same function as in col H. On my computer the output is
#NUM!.

Can someone help me?

Thanks

Paolo

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

===================================================
Eric Ehlers
nazcatech sprl | Brussels | http://www.nazcatech.be
* Distributed computing for pricing analytics
* Use Microsoft Excel as a client to the Grid

------------------------------------------------------------------------------

_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users