Re: Excel 2007 crashes when closing (QuantLibXL.xla)

Posted by Eric Ehlers-2 on
URL: http://quantlib.414.s1.nabble.com/Re-Excel-2007-crashes-when-closing-QuantLibXL-xla-tp6564p6568.html

Hi Piter,

On Fri, September 12, 2008 02:09, Piter Dias wrote:
> The PV in range [VanillaSwap.xls]Pricing!$C$30 is not valid (know I have two
problems )

What value do you get exactly?  I get a PV of zero.  Do you get #NA?  If so,
please right click in the cell and select "Display Error" - what does that
say?

> but what trigged the error was something much simpler:
> 1) Load C:\Program Files\QuantLibXL-0.9.6\framework\QuantLibXL.xla from
start-up menu
> 2) Exit Excel

Good information.  So we're not relying on any specific functionality being
called.

> qlxlversion, for example.Do you have some places you recomend to put the
breakpoints? Some classes or functions called when Excel closes.

File qlxl\register\addin.cpp, function xlAutoClose().  But the fact that the
earlier crash did not produce a stack trace indicates that the crash is not
associated with a specific line of QLXL source code.  It could still relate to
memory corruption triggered by earlier misbehavior of the XLL.

An earlier version of QuantLibXL.xla crashed because of a stack overflow in
VBA code, in that case also the debugger never stopped in the XLL.

Frederik reports a crash using QuantLibXL-vc80-mt-s-0_9_6.xll only, no
QuantLibXL.xla, I'm unable to reproduce his results, are you?

For version 0.9.6, we changed the initialization of some global singletons.
Previously they were static variables with file scope, now they have been
moved into function init() in addin.cpp.  Maybe we broke something relating to
destruction of these structures.

Others report functions returning zero, or something like MINDOUBLE.  So far
I'm unable to recreate any of these problems.  I can only suggest that we all
continue to compare notes until something clicks.  Many thanks for your help.

Regards,
Eric

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


-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users