Debugging in Excel 2016

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

Debugging in Excel 2016
 
Klosar Klos




Posts: 22
Joined: 2014-06-20
Hi Guys,

I have an issue with Add-in Express (version 8.1.4350.0. ) and Excel 2016, for some reason excel breaks whenever our add-in is active and user opens 2nd excel file. The same code/installation works perfectly on excel 2007-2013.

First of all does Add-in store somewhere internally more details about error out of box?

After installing Excel 2016 on a dev machine (we already have office 2013 there) we have been trying to debug app in 2016 but it doesn't work.

If I click on the Add-in project- >properties->debug - start external program and set Excel's 2015 path c:\Program Files\Microsoft Office\Office15\Excel.exe after hitting the Run button in VS 2015, excel starts and debugger works it stops on every single breakpoint

If we change external's program path to c:\Program Files\Microsoft Office\root\Office16\Excel.exe and hit the Run button in VS 2015, excel starts, but debugger doesn't work



[img]http://www.tiikoni.com/tis/view/?id=24707b0[/img]

Please see the attached image
Posted 27 Apr, 2016 10:44:54 Top
Klosar Klos




Posts: 22
Joined: 2014-06-20
Ok I've managed to "fix this" by changing .net version from 3.5 to 4.0. is it possible to debug in 3.5 and office 2016?

Also excel still breaks and can't figure out what is causing the error. It will be great if there is an option to turn on internal loggin

thanks
Posted 27 Apr, 2016 10:50:29 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hi Klosar,

I have an issue with Add-in Express (version 8.1.4350.0. ) and Excel 2016, for some reason excel breaks whenever our add-in is active and user opens 2nd excel file. The same code/installation works perfectly on excel 2007-2013.


Could you please provide more information about your code? How can we reproduce this issue? Or, is it possible to send your project (or some demo project with the same behavior) to me for testing?

Ok I've managed to "fix this" by changing .net version from 3.5 to 4.0. is it possible to debug in 3.5 and office 2016?


Yes, it is possible. Please have a look at the "Breakpoints are not hit when debugging" chapter (page 331) of the Add-in Express Developer Guide.
Posted 27 Apr, 2016 10:58:42 Top
Klosar Klos




Posts: 22
Joined: 2014-06-20
Thanks Dmitry. can you please give me you email address ?
Posted 27 Apr, 2016 11:06:18 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hi Klosar,

Sorry, I should have done that in my previous post. Because of our anti-spam policy I cannot post it right here, please find our support email address in the readme.txt file located in the Add-in Express installation folder.
Posted 27 Apr, 2016 11:21:04 Top
Klosar Klos




Posts: 22
Joined: 2014-06-20
Of course. I've just sent you an email. Just to highlight one more time this works in every other version of Excel except 2016. In the past, we had a similar issue which was caused by calling not supported method in that version of excel, but it this case it breaks before opening excel file and it's super hard to catch the exact place where it breaks

Thanks in advance!
Posted 27 Apr, 2016 11:58:27 Top
Klosar Klos




Posts: 22
Joined: 2014-06-20
Hi guys,

as I haven't received any reply on my support request via email can you please acknowledge that you've received my email

thanks
Posted 28 Apr, 2016 03:23:37 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hi Klosar,

We received your email, thank you. I will inform you about the results as soon as get any from our developers.
Posted 28 Apr, 2016 03:58:55 Top
Klosar Klos




Posts: 22
Joined: 2014-06-20
thank you. Btw as a hint to your developers, I believe that this issue wasn;t happening with previous (beta version) of the add-in. but as I don't have it on my hdd and can't download it anymore from your download area I can't test.

thank you guys!
Posted 28 Apr, 2016 04:08:51 Top
Dmitry Kostochko


Add-in Express team


Posts: 2875
Joined: 2004-04-05
Hi Klosar,

I have just sent you an email with instructions and comments.

Also, at the bottom of our download page, you can find a link to the page containing all previous builds:
"If you need an older version of Add-in Express for Office and .NET, you can download it https://www.add-in-express.com/downloads/adxnet-old.php".
Posted 28 Apr, 2016 09:35:27 Top