COMAddin and RTD problems

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

COMAddin and RTD problems
 
Posts 1 - 10 of 14
First | Prev. | 1 2 | Next | Last 
Jeff Chappo




Posts: 14
 Joined: 2006-09-20
I am currently developing a program that is a COMAddin which also uses an RTDAddin working with Excel.

I have run into some problems with the 2 Addins working together.

Example:

When I create an RTD formula in a cell, using Range.Formula property to set the forumla string, the RTD server is loaded in the same process space as my COMAddin, and I am able to use CallProxyMethod on the COMAddin and everything is fine.

When I create an RTD formula manually by double clicking a cell and writing the formula directly in the cell, the RTD server is loaded in a different process space as my COMAddin, and I am unable to use CallProxyMethod on the COMAddin, I get an exception relating to the serialization of objects that I am passing back. After adding [Serialization] tags to the classes of these objects, I get an exception that the .dll of the object I am returning cannot be found.

How can I circumvent this problem with the RTD server? Have you guys seen this problem before?

-Jeff Chappo
Posted 27 Dec, 2006 12:25:33 Top
Sergey Grischenko


Add-in Express team


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

Are the COM add-in and RTD server developed in one assembly?
Do you use the ADX loader?


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 28 Dec, 2006 06:20:46 Top
Jeff Chappo




Posts: 14
 Joined: 2006-09-20
The COM add-in and the RTD server are developed in different assemblies,
and yes I am using the ADX loader.
Posted 28 Dec, 2006 12:21:54 Top
Sergey Grischenko


Add-in Express team


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

In this case you need to install the COM add-in and RTD server in one application directory so that they use the same ADX loader. I can develop an example if you wish.
Posted 30 Dec, 2006 10:40:15 Top
Jeff Chappo




Posts: 14
 Joined: 2006-09-20
I do install them to the same directory, but what about during development? Since the behaviors are different, the code I write during development will be different than the release behavior on another machine.
Posted 03 Jan, 2007 13:59:04 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Jeff, I would suggest you to deploy the COM add-in and RTD server using the combined setup. What do you think?
Posted 04 Jan, 2007 07:02:13 Top
Jeff Chappo




Posts: 14
 Joined: 2006-09-20
Sergey, I do use the combined setup and everything works great. The only problem is I get inconsistancies in the way the program functions in the development environment, as opposed to the deployment computer.

I am also having problems with your remoting sample. For example, I use remoting so my RTD server can find my COMAddin. But, if I open another instance of Excel, it has it's own COMAddin. Then if I put an RTD forumula in, the RTD throws an exception because it does not have a channel setup to talk to the server.

See my problems?
Posted 12 Jan, 2007 16:14:28 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Jeff, do you use the latest Add-in Express 2007 version?
Posted 12 Jan, 2007 18:17:33 Top
Jeff Chappo




Posts: 14
 Joined: 2006-09-20
I am still using version 2.7, I tried to install 2007, but my old registration key does not work. What do I need to do to get access to 2007?
Posted 15 Jan, 2007 10:32:46 Top
Andrei Smolin


Add-in Express team


Posts: 18827
 Joined: 2006-05-11
Jeff,

Please use the bottom line of the Packages table on the Pricing page (http://www.add-in-express.com/add-in-net/pricing.php).
Posted 15 Jan, 2007 11:42:18 Top

Posts 1 - 10 of 14
First | Prev. | 1 2 | Next | Last