share spreadsheets with quantlib add-in 0.8.0

[gianfranco.cianchetti]

Hello,

I installed version 0.8.0 of the QLib add-in, but if I try to share my spreadsheet, then the formulas

qlbondyield2

and

qlbondcleanprice2

return #NAME

I didn't have such a problem with similar formulas in version 0.3.14.

Do you have any suggestions?

Thanks

****** Gianfranco ******
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[Eric Ehlers-2]

Hello,

> Hello,
>
> I installed version 0.8.0 of the QLib add-in, but if I try to share my
> spreadsheet, then the formulas
>
> qlbondyield2
>
> and
>
> qlbondcleanprice2
>
> return #NAME

I just tried without success to recreate the problem.  I used the example
workbook YC_SwapDemo.xls, after sharing it I find it continues to work
correctly.  Can you let me know what I need to do to recreate the problem?

Any ql function will return #NAME if the XLL is not loaded, could that be
the problem?

Thanks,
Eric



-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users

[gianfranco.cianchetti]

Yes,

indeed my error is not properly related with the QuantLib Add-in.

In this spreadsheet I also use two other add-ins (one of them being Bloomberg) and if I open excel and then I open the spreadsheet everything works fine.

Maybe it is just a problem of excel loading the various add-ins.

Regards
**********************************************************************
Gianfranco Cianchetti
Technical support
mailto:[hidden email]

SoftSolutions!
Via San Francesco d'Assisi, 3b 24121 Bergamo (BG) Italia
Tel: [phone]
Mobile: [phone]
Fax: [phone]
http://www.softsolutions.it
**********************************************************************
This document is strictly confidential and is intended for use by the addressee unless otherwise indicated. If you have received this e-mail in error we would be very grateful if you could please notify us immediately at mailto:[hidden email] and delete this e-mail from your system.

SoftSolutions! reserves the right to monitor all e-mail communications through its internal and external networks.

SoftSolutions! s.r.l.
**********************************************************************

"Eric Ehlers" <[hidden email]>

14/09/2007 19.59

Please respond to
[hidden email]

To	[hidden email]
cc	[hidden email]
Subject	Re: [Quantlib-users] share spreadsheets with quantlib add-in 0.8.0

Hello,

> Hello,
>
> I installed version 0.8.0 of the QLib add-in, but if I try to share my
> spreadsheet, then the formulas
>
> qlbondyield2
>
> and
>
> qlbondcleanprice2
>
> return #NAME

I just tried without success to recreate the problem.  I used the example
workbook YC_SwapDemo.xls, after sharing it I find it continues to work
correctly.  Can you let me know what I need to do to recreate the problem?

Any ql function will return #NAME if the XLL is not loaded, could that be
the problem?

Thanks,
Eric





-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users