XLL addin causes excel to crash when moving a sheet to a new workbook

Add-in Express™ Support Service
That's what is more important than anything else

XLL addin causes excel to crash when moving a sheet to a new workbook
 
Andrei Smolin


Add-in Express team


Posts: 14122
Joined: 2006-05-11
Chris,

Thank you for sending me the video. I've reproduced the crash on both Excel 2010 and 2013. The issue is now filed under #6262 in our bug-tracking db. At the moment it looks like this may relate to handling the OnCalculationEnded event. Our guys look into this. I'll let you know if I have news on this.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 23 Jan, 2015 06:47:54 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
Fantastic thanks for your help Andrei :)
Posted 23 Jan, 2015 11:44:07 Top
Andrei Smolin


Add-in Express team


Posts: 14122
Joined: 2006-05-11
Hello Chris,

We've found out that this is an Excel problem, not Add-in Express: we reproduce it on a simple code built on an example that comes with Excel SDK. The issue also occurs in Excel 2013. We'll prepare a code sample and I post in on the Excel for Developers forum expecting that Microsoft will react to it; I'll post a link here.

As to now, we can only suggest that you don't use the OnCalculationEnded event. If your assembly contains a COM add-in, you can intercept the AfterCalculate event which is available for a COM add-in loaded in Excel 2007-2013.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 03 Mar, 2015 09:12:41 Top
Andrei Smolin


Add-in Express team


Posts: 14122
Joined: 2006-05-11
Hello Chris,

Here's my question on the Excel for Developers forum:
https://social.msdn.microsoft.com/Forums/office/en-US/faa95526-523c-4ac1-a8c8-bb52cde63263/an-xll-that-crashes-excel-when-dragging-a-sheet-to-another-workbook?forum=exceldev

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 Mar, 2015 06:29:00 Top
Andrei Smolin


Add-in Express team


Posts: 14122
Joined: 2006-05-11
Chris,

They think this is a bug in Excel.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 25 Mar, 2015 05:15:29 Top