AppDomain issue with Excel

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

AppDomain issue with Excel
 
Hemant Gome




Posts: 14
Joined: 2006-12-19
Hi Sergey,
As per below topic link, the problem was resolved but have you found any solution for this ?
http://www.add-in-express.com/forum/read.php?FID=5&TID=1565&MID=7246&phrase_id=442980#message7246

I asked this because the problem resurfaced with our new addin.
Let me explain in detail -
We already have a COM addin installed (not developed using ADX) and now we install a new addin (developed using ADX). This new addin has UI and Functions.

Case 1:
Start the excel with a new spreadsheet. Click on the new addin's UI to create functions on the spreadsheet. For this case, everything works fine as we see only one appdomain.

Case 2:
Start the excel with an existing spreadsheet. Click on the existing functions, press F2 and hit enter to refresh the spreadsheet. For this case, we are having problem as we see two appdomains - one for UI and another for Functions.

Case 3:
Start the excel with an existing spreadsheet. Click on the existing functions and using the UI, update the spreadsheet. For this case, again no problem, everything works fine as we see only one appdomain.

Case 4:
Uncheck the COM addin from the Tools->AddIns list (but keep the new addin listed) and close the excel. Now perform the Case 2, this time, everything works fine as we see only one appdomain.

Could you please let us know the reason for this behaviour ?
Why does the COM addin interfere with the new addin's Functions ?

Thanks in advance,
- Hemant

Posted 30 Apr, 2007 15:29:34 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hi Hemant.

Please try not to use the ADX loader for the COM add-in. In this case the add-in UI and UDF will be loaded in the same domain with Excel.


P.S. Note that we take up your forum requests in the order we receive them.
Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.

Posted 01 May, 2007 17:39:47 Top
Hemant Gome




Posts: 14
Joined: 2006-12-19
Hi Sergey,
I didn't get you mean by not to use the ADX Loader. What other options I have ?

-Hemant
Posted 02 May, 2007 10:33:22 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hemant, I meant that you could try to create a non-isolated add-in via the Add-in Express wizard (see the 'Non Isolated' option of the 'Isolation' group in the wizard).
Posted 02 May, 2007 18:56:43 Top
Hemant Gome




Posts: 14
Joined: 2006-12-19
Hi Sergey,
I am unable to see Isolation group in my wizard. Where is it located and which version of wizard ?
Our addin is developed in C#, VS 2003, ADX 2007

Thx.
Hemant
Posted 03 May, 2007 12:49:46 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
Joined: 2004-07-05
Hi Hemant.

I have just sent you a screenshot.
Posted 04 May, 2007 09:30:23 Top