Excel 2007 crashes when closing (QuantLibXL.xla)

[Piter Dias-3]

Guys,

I compiled SVN QuantLibXL 0.9.6 and was using the XLL while there wasn't a
official release.

Today I download the release version and installed it using QuantLibXL.xla. I
tested with YieldCurveBootstrapping.xls and everything worked well until
Excel is close (by me).

When I try to close the Excel it hangs and Windows Vista says the program
stopped to work. The event viewer says the problem is
QuantLibXL-vc80-mt-s-0_9_6.xll_unloaded.

Does anyone know something about it? I suppose most of QuantLibXL tests is
still done in Excel 2003, right?

Thanks a lot,

Piter Dias
[hidden email]



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

[Eric Ehlers-2]

Hi Piter,

On Tue, September 9, 2008 02:44, Piter Dias wrote:
> Guys,
>
> I compiled SVN QuantLibXL 0.9.6 and was using the XLL while there wasn't a
> official release.

And things were working OK for you back then?  So you have a
QuantLibXL-vc80-mt-s-0_9_6.xll which you compiled yourself from some older
snapshot of the source code, and that continues to work OK.  And you get the
crash with the QuantLibXL-vc80-mt-s-0_9_6.xll from the release.  Is that
right?  Have you tried comparing the QuantLibXL-vc80-mt-s-0_9_6.xll from the
binary installation versus one you build yourself from the released source
code?

> Today I download the release version and installed it using QuantLibXL.xla. I
> tested with YieldCurveBootstrapping.xls and everything worked well until
> Excel is close (by me).
>
> When I try to close the Excel it hangs and Windows Vista says the program
> stopped to work. The event viewer says the problem is
> QuantLibXL-vc80-mt-s-0_9_6.xll_unloaded.
>
> Does anyone know something about it? I suppose most of QuantLibXL tests is
> still done in Excel 2003, right?

Right, for me at least.  Others were still on 2002 last I knew.

On my machine I have Excel 2003 and 2007, but Windows XP rather than Vista.  I
tested QuantLibXL.xla and it works OK for me.  Here's the test I used:

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

I tried that with 2003 and 2007, no crash.  The only difference between the
two is that 2007 throws up dozens of message dialogs and otherwise runs a lot
more slowly.  Can you try that test and confirm whether you get the crash?

If you omit steps 3) and 4), does it still crash?  If not it would indicate
that one of these steps triggers a bug which corrupts memory.

If you care to take the troubleshooting further, the next step would be:

- 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

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

[thepriceupay-quant]

Hi,

I am also using Excel 2007 under Win XP and I can get a reproducible crash when I do the following (using QuantLibXL-vc80-mt-s-0_9_6.xll):

1) Open Spreadsheet
2) Use any ql-Function
3) Exit Excel
4) When prompted to save changes, click Cancel
5) Try to exit again -> crash!

Hope that helps.

Regards,
Frederik
 

----- Ursprüngliche Mail ----
Von: Eric Ehlers <[hidden email]>
An: [hidden email]
CC: [hidden email]
Gesendet: Donnerstag, den 11. September 2008, 17:38:53 Uhr
Betreff: Re: [Quantlib-users] Excel 2007 crashes when closing (QuantLibXL.xla)

Hi Piter,

On Tue, September 9, 2008 02:44, Piter Dias wrote:
> Guys,
>
> I compiled SVN QuantLibXL 0.9.6 and was using the XLL while there wasn't a
> official release.

And things were working OK for you back then?  So you have a
QuantLibXL-vc80-mt-s-0_9_6.xll which you compiled yourself from some older
snapshot of the source code, and that continues to work OK.  And you get the
crash with the QuantLibXL-vc80-mt-s-0_9_6.xll from the release.  Is that
right?  Have you tried comparing the QuantLibXL-vc80-mt-s-0_9_6.xll from the
binary installation versus one you build yourself from the released source
code?

> Today I download the release version and installed it using QuantLibXL.xla. I
> tested with YieldCurveBootstrapping.xls and everything worked well until
> Excel is close (by me).
>
> When I try to close the Excel it hangs and Windows Vista says the program
> stopped to work. The event viewer says the problem is
> QuantLibXL-vc80-mt-s-0_9_6.xll_unloaded.
>
> Does anyone know something about it? I suppose most of QuantLibXL tests is
> still done in Excel 2003, right?

Right, for me at least.  Others were still on 2002 last I knew.

On my machine I have Excel 2003 and 2007, but Windows XP rather than Vista.  I
tested QuantLibXL.xla and it works OK for me.  Here's the test I used:

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

I tried that with 2003 and 2007, no crash.  The only difference between the
two is that 2007 throws up dozens of message dialogs and otherwise runs a lot
more slowly.  Can you try that test and confirm whether you get the crash?

If you omit steps 3) and 4), does it still crash?  If not it would indicate
that one of these steps triggers a bug which corrupts memory.

If you care to take the troubleshooting further, the next step would be:

- 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

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

__________________________________________________
Do You Yahoo!?
Sie sind Spam leid? Yahoo! Mail verfügt über einen herausragenden Schutz gegen Massenmails.
http://mail.yahoo.com
-------------------------------------------------------------------------
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

[Eric Ehlers-2]

Hi Frederik,

On Thu, September 11, 2008 17:19, [hidden email] wrote:
> Hi,
>
> I am also using Excel 2007 under Win XP and I can get a reproducible crash
when I do the following (using QuantLibXL-vc80-mt-s-0_9_6.xll):
>
> 1) Open Spreadsheet
> 2) Use any ql-Function
> 3) Exit Excel
> 4) When prompted to save changes, click Cancel
> 5) Try to exit again -> crash!
>
> Hope that helps.

Yes it does and thanks for reporting the error.  I also have Excel 2007 on XP,
unfortunately I'm unable to reproduce the problem on my machine.  I'll hit a
few internet cafes and see what results I get there, I'll keep you posted...

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