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

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

Eric,

> 1) Start Excel 
> 2) Load C:\Program Files\QuantLibXL-0.9.6\framework\QuantLibXL.xla 
> 3) Invoke menu item QuantLibXL | Actions | Bootstrap Yield Curves 
> 4) Invoke menu item QuantLibXL | Open Workbook and browse to 
> InterestRateDerivitives\VanillaSwap.xls 
> 5) Confirm valid PV in range [VanillaSwap.xls]Pricing!$C$30 
> 6) Exit Excel 
> 7) When prompted to save changes, hold down Shift key (to suppress > subsequent 
> prompts) and click No 

The PV in range [VanillaSwap.xls]Pricing!$C$30 is not valid (know I have two problems ) 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 

Inded I was able to close the spreadsheets but when Excel is really ready to close it crashes. humm Could be some of the classes loaded? May be changing QuantLibXL.xla in order to write log messages before doing anything else...

> - Compile QuantLibXL with configuration Debug 
> - Edit QuantLibXL.xla to load QuantLibXL-vc80-mt-sgd-0_9_5.xll 
> - Start Excel and attach the debugger 
> - Run the test above and if we're lucky you'll get a stack trace showing the 
> line of code on which the crash occurs 

I did it to QuantLibXL-vc90-mt-sgd-0_9_6 but no VC Express shows no line of code, just the same meaningless exception message.

First-chance exception at 0x108bb645 in EXCEL.EXE: 0xC0000005: Access violation reading location 0x108bb645.

Unhandled exception at 0x108bb645 in EXCEL.EXE: 0xC0000005: Access violation reading location 0x108bb645.

 However I can put some breakpoints if you give some tips. It worked well with qlxlversion, for example.

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

Thanks a lot,

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