Info on Shape in Excel

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

Info on Shape in Excel
 
Marco Cordini




Posts: 2
Joined: 2016-09-06
good morning to all
I have a little problem in coversione a vsto addin excel using Add-in Express for Microsoft??? Office and .net.
In the addin it is also used shape.SoftEdge the object, but in add-in Express I saw that the object exists but there are not all the property eg. the radius
I'm doing something wrong?
Thank you very much
Marco

p.s. Sorry for my poor English
Posted 07 Sep, 2016 02:45:48 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Marco,

That property was introduced in Excel 2010; see https://msdn.microsoft.com/en-us/library/office/ff839530(v=office.15).aspx. The problem occurs if your add-in project uses interops for the Office version that doesn't have this property in the Excel object model (Office 2000-2007). You can bypass this in two ways:
- if you don't need to support Office 2000-2007, you replace the Office interops used in your project as described below
- if you need to support Office 2000-2007, you have to use late binding (see System.Type.InvokeMember in MSDN or search through our forums and blogs)

To replace interops, close Visual Studio, set the minOfficeVersionSupported attribute (see adxloader.dll.manifest in the Loader folder of your add-in project) to the number below, replace the files in the Interops folder with the corresponding files from {Add-in Express}\Redistributables\Interop Assemblies\{Office version}, start Visual Studio and register your project.

Office versions:
9 ?Â?Ð?ã Office 2000
10 ?Â?Ð?ã Office 2002
11 ?Â?Ð?ã Office 2003
12 ?Â?Ð?ã Office 2007
14 ?Â?Ð?ã Office 2010
15 ?Â?Ð?ã Office 2013
16 ?Â?Ð?ã Office 2016

If you use interops for Office 2000, this may also require that you remove the corresponding references, copy interop files, create references to the new files, compile the project and fix compile-time errors (if any). A typical C#-related problem is the need to replace the code on the pattern Collection.Item(index) with Collection[index].


Andrei Smolin
Add-in Express Team Leader
Posted 07 Sep, 2016 03:34:18 Top
Marco Cordini




Posts: 2
Joined: 2016-09-06
Thanks Andrei

It works now

Marco
Posted 07 Sep, 2016 04:38:13 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
You are welcome!


Andrei Smolin
Add-in Express Team Leader
Posted 07 Sep, 2016 04:46:36 Top