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




Posts: 17
Joined: 2014-07-07
Hi,

Our customers reported that excel's move sheet to new book feature crashes excel when our XLL addin is loaded. There is simply an apprash.

Problem signature:
Problem Event Name: APPCRASH
Application Name: excel.exe
Application Version: 14.0.7140.5000
Application Timestamp: 5462a671
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6161
Fault Module Timestamp: 4dace5b9
Exception Code: c0000005
Exception Offset: 0003b458
OS Version: 6.1.7601.2.1.0.256.1
Locale ID: 1033

Additional information about the problem:
LCID: 1033
skulcid: 1033

Our addin has some UDFs in it and is hooked up to a few events but it only writing a log message on initialize and clearing a flag oncalc canceled and ended. The UDFs aren't in use at all in the sample file.

OnInitialize
OnCalculationCanceled
OnCalculationEnded

It happens and many types of files an example of which is here:

https://www.dropbox.com/s/110mzkvy4s5z1o8/FF.xlsx?dl=0

We simply right click the active sheet and select move to new book.

Our clickonce addin installer is located here:

http://addin.vena.io/develop/vena.application

Not sure what you guys need to debug this but I haven't had the chance to try reproducing it with a simple empty XLL addin and see if it still occurs.

Please let me know what you need and I can try and get you enough code to actually repro it on your side.

Thanks,

Chris
Posted 07 Jan, 2015 10:52:05 Top
Andrei Smolin


Add-in Express team


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

Does your add-in include a COM add-in? Or this is a single XLL add-in?

Could you please try to reproduce this using a simple test add-in? Make sure that all COM add-ins and Excel add-ins are turned off.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 08 Jan, 2015 09:11:01 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
It has both. COM + XLL. Ok I will do as you've asked thx.
Posted 08 Jan, 2015 09:23:44 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
So I setup a simple addin and was able to reproduce it using the FF.xlsx file above. Simply open the file, right click on the 2014 sheet and choose move to new book and excel dies.


Here is the addin zip:

https://www.dropbox.com/s/qhkln90ukbgsb9h/MyAddin1.7z?dl=0

Thanks,

Chris
Posted 08 Jan, 2015 09:45:36 Top
Andrei Smolin


Add-in Express team


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

The issue isn't reproducible on my side. Could you please check if the issue is still reproducible if you disable all other COM add-ins and Excel add-ins?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 09 Jan, 2015 04:05:13 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
Hi Andrei,

Sorry I missed your post as I didn't notice any email notifications. Yeah my test was with no addins other than the COM and XLL addins in the zip file I included. All other addin were inactive. I wonder if it has to do with Visual Studio version? I'm using VS 2010 with Microsoft Office Pro Plus 2010 SP2.

This is my VS config:

Microsoft Visual Studio 2010
Version 10.0.40219.1 SP1Rel
Microsoft .NET Framework
Version 4.5.50938 SP1Rel

Installed Version: Premium

Microsoft Office Developer Tools 01021-532-2002102-70222
Microsoft Office Developer Tools

Microsoft Visual Basic 2010 01021-532-2002102-70222
Microsoft Visual Basic 2010

Microsoft Visual C# 2010 01021-532-2002102-70222
Microsoft Visual C# 2010

Microsoft Visual C++ 2010 01021-532-2002102-70222
Microsoft Visual C++ 2010

Microsoft Visual F# 2010 01021-532-2002102-70222
Microsoft Visual F# 2010

Microsoft Visual Studio 2010 Code Analysis Spell Checker 01021-532-2002102-70222
Microsoft Visual Studio 2010 Code Analysis Spell Checker

Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.

The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.

Microsoft Visual Studio 2010 Team Explorer 01021-532-2002102-70222
Microsoft Visual Studio 2010 Team Explorer

Microsoft Visual Web Developer 2010 01021-532-2002102-70222
Microsoft Visual Web Developer 2010

Add-in Express for Microsoft Office and .NET v7.5.4072
Add-in Express for Microsoft Office and .NET. For more information about Add-in Express™, see the following website: http://www.add-in-express.com. Copyright © Add-in Express Ltd. All rights reserved.

Critical Update for Microsoft Visual Studio 2010 Premium - ENU (KB2938807) KB2938807
This critical update is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this critical update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2938807.

Crystal Reports Templates for Microsoft Visual Studio 2010
Crystal Reports Templates for Microsoft Visual Studio 2010

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2529927) KB2529927
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2529927.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2548139) KB2548139
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2548139.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2549864) KB2549864
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2549864.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2565057) KB2565057
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2565057.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2635973) KB2635973
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2635973.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB2890573) KB2890573
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2890573.

Hotfix for Microsoft Visual Studio 2010 Premium - ENU (KB3002340) KB3002340
This hotfix is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this hotfix will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/3002340.

JetBrains ReSharper 7.1.2 Full Edition build 7.1.2000.1478 on 2013-02-18T20:08:04
JetBrains ReSharper 7.1.2 package for Microsoft Visual Studio. For more information about ReSharper, visit http://www.jetbrains.com/resharper/. Copyright © 2003–2015 JetBrains, Inc.

Microsoft Visual Studio 2010 Premium - ENU Service Pack 1 (KB983509) KB983509
This service pack is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this service pack will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/983509.

Microsoft Visual Studio 2010 SharePoint Developer Tools 10.0.40219
Microsoft Visual Studio 2010 SharePoint Developer Tools

Microsoft XNA Game Studio 4.0
Microsoft XNA Game Studio 4.0
Build 4.0.30901.0

NuGet Package Manager 2.8.50926.602
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

PostSharp 3.1.32.0

Security Update for Microsoft Visual Studio 2010 Premium - ENU (KB2645410) KB2645410
This security update is for Microsoft Visual Studio 2010 Premium - ENU.
If you later install a more recent service pack, this security update will be uninstalled automatically.
For more information, visit http://support.microsoft.com/kb/2645410.

Git Extensions
Git Extensions is a graphical interface for Git
For more information about Git Extensions, see the Git Extensions website at
http://code.google.com/p/gitextensions/
Copyright © 2012 Henk Westhuis
Posted 17 Jan, 2015 15:12:41 Top
Andrei Smolin


Add-in Express team


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

Thank you. The issue seemingly doesn't relate to the extensions that you have installed in VS. This may relate to .NET 4.5.1 if you use it in your add-in; there are some updates that you need to install as my VS shows .NET 4.5.51209 SP1 Rel.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Jan, 2015 07:25:31 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
Hi Andrei, so I updated my .NET to 4.5.2 (4.5.51209 SP1 Rel) and the same thing happens. I wonder how we can debug this as I can reproduce it two ways (on our addin that's built on a separate build machine and my debug environment). Have you tested it on Office 2010 SP2?

Chris
Posted 19 Jan, 2015 13:31:53 Top
Andrei Smolin


Add-in Express team


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

Yes, I tested it in Excel 2010 SP2. Could you please send me a video showing how you start Excel and reproduce the issue?

Also please test the same scenario with the COM add-in disabled. Then disable the XLL add-in and turn the COM add-in on: does the issue persist?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Jan, 2015 09:45:29 Top
Chris Christodoulou




Posts: 17
Joined: 2014-07-07
Hi Andrei, Our support team made a video with the issue. It looks a bit different than on my machine, as I didn't see the memory message, but the effect is the same.

https://www.dropbox.com/s/xoeif40pam3wcpd/MoveSheetError.mp4?dl=0

Excel is started by just double clicking the FF.xlsx file and the only thing that seems to trigger it is the XLL. The COM addin doesn't affect the tests at all. We turn the XLL on and it happens, when it's off it doesn't.

Thanks,

Chris
Posted 22 Jan, 2015 12:45:07 Top