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

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

Eric,

> 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? 

I get #Value in this cell and #Num in some others. Take a look at the attached image.

> 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. 

You are right. The debug ended before the Excel exception.

> 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. 

I make some test and the error is not in VBA itself.

> 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? 

I can reproduce it. I open Excel, QuantLibXL-vc90-mt-sgd-0_9_6.xll, RelinkableHandles.xls or CmsCouponPricers.xls and close Excel in order to crash it. I only crashes if I open one of these spreadsheets.

In the other hand, if I coment those files in QuantLibXL.xla it doesn't crash. Nowadays my QuantLibXL.xla doesn't have these files and it is working without exception.

At RelinkableHandles.xls the formula =qlWorkbookPath(Trigger)&"\..\Data\XML\010_StartUp\010_RH\" returns #Name because of qlWorkbookPath, but it happens in the others startup spreadsheets too.

Any idea? I think we are almost there.

Regards,

-------------------------------------------------------------------------
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