quantlib-dev

[Quantlib-dev] QuantLibXL not working with Excel 2007 ?

[Kim K. T. <kue...@vo...>]

Hi all,

QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
But the addin cannot be loaded by Excel 2007.  It gives the error 
message R6043 Runtime Error.

Did anybody succesfully load the addin in EXCEl 2007?


Best regards,
Kim Tang

Re: [Quantlib-dev] QuantLibXL not working with Excel 2007 ?

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

On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <kue...@vo...> wrote:
> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.

how did you manage to compile it with boost 1.40 ?
The current QLXL trunk cannot be compiled with boost 1.40 as there are
errors in the boost header files

ciao -- Nando

--
RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano

Re: [Quantlib-dev] QuantLibXL not working with Excel 2007 ?

[Kim K. T. <kue...@vo...>]

Hi Ferdinando,

i dont know which errors you are talking about, since i dont get them.
The problem with the preprocessor BOOST_HAS_LONG_LONG is for example 
fixed in the trunk version.
See the log message:

Revision: 51503
Author: bemandawes
Date: 15:14:09, Sonntag, 1. März 2009
Message:
config: fix both BOOST_HAS_LONG_LONG and BOOST_NO_LONG_LONG getting 
defined at the same time for some compilers
----
Modified : /trunk/boost/config/suffix.hpp



However using the latest boost library from trunk version i managed to 
compile quantlib together with QLXL. The problem is that the produced 
addin cannot be loaded by Excel 2007.

Best regrards,
Kim

Ferdinando Ametrano schrieb:
> On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <kue...@vo...> wrote:
>   
>> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
>>     
>
> how did you manage to compile it with boost 1.40 ?
> The current QLXL trunk cannot be compiled with boost 1.40 as there are
> errors in the boost header files
>
> ciao -- Nando
>
> --
> RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano
>
>   

Re: [Quantlib-dev] QuantLibXL not working with Excel 2007 ?

[Kim K. T. <kue...@vo...>]

Hi all,

some more tests show that the combination QuantLib 0.9.7, QuantLibXL
0.9.7 und boost 1.41 compiles fine. The produced addin can also be
loaded by Excel 2007 if the whole Solution QuantLibXL_full_vc9 is
compiled under static (runtime) mode.

Is there a reason for that?

Best regards,
Kim

Ferdinando Ametrano schrieb:
> On Sun, Sep 27, 2009 at 6:06 PM, Kim Kuen Tang <kue...@vo...> wrote:
>   
>> QuantLibXL compiled successfully with MSVC 2008  and boost  1.40.
>>     
>
> how did you manage to compile it with boost 1.40 ?
> The current QLXL trunk cannot be compiled with boost 1.40 as there are
> errors in the boost header files
>
> ciao -- Nando
>
> --
> RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano
>
>   

Re: [Quantlib-dev] QuantLibXL not working with Excel 2007 ?

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

Hi Kim

On Thu, Oct 1, 2009 at 6:40 AM, Kim Kuen Tang <kue...@vo...> wrote:
> some more tests show that the combination QuantLib 0.9.7, QuantLibXL
> 0.9.7 und boost 1.41 compiles fine. The produced addin can also be
> loaded by Excel 2007 if the whole Solution QuantLibXL_full_vc9 is
> compiled under static (runtime) mode.
>
> Is there a reason for that?

I personally don't use the boost trunk, official releases only.

When boost 1.40 has been released I checked and the QuantLib trunk did
not compile; there was QLXL code triggering error in boost header
files. For me it was the end of the story as I don't want to patch
boost and I'm willing to wait for 1.41, using 1.39 in the meantime

As for Excel 2007 I don't have acces to it as I still use Excel 2002
at work and Excel 2003 at home.

ciao -- Nando

-- 
RSS feed: http://www.google.com/reader/shared/ferdinando.ametrano