List of changes/fixes done to support Excel 2019

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

List of changes/fixes done to support Excel 2019
List of changes/fixes done to support Excel 2019 
WSAddInDev


Guest


Hi Team,

For technically development purposes I need below information from Add-in express team.
If you can share deep level details that would be excellent.

1. What all changes we did for support of Excel 2019? Only version string changes or some other changes as well?
2. Have we come across any issues while supporting Excel 2019?
3. Did we come across any design or architecture change in Excel 2019 as compare to earlier Excel versions?
4. Is there any difference in registration of Excel add-in for Excel 2016 and Excel 2019?
5. Is it possible to use earlier created Excel add-in with Excel 2019 (tested only with Excel 2016)? Do we have any known compatibility issue?

Thanks,
Winshuttle Dev
Posted 29 Mar, 2019 13:53:50 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Hello,

The "Office 2019" title makes sense only in the context of the deployment technology that *you* use when installing a new Office version on your machine; specifically, you can install Office 2019 only using a .MSI file. If you install Office using a web link (on the Microsoft.com web site), you install a Click-To-Run Office version which is named Office 365.

The functionality of Office 2019 and desktop applications from Office 365 may be slightly different. This is because Microsoft switched to continuous delivery; the Insider channel produces 1-2 new Office builds every week. This explains why you may claim that Office 2019 and Office 365 are still Office 2016. In particular, calling Application.Version returns 16.0 in Excel 2019 or Excel from Office 365.

They gradually update Office (Excel) and its object model; see also https://www.add-in-express.com/forum/read.php?FID=5&TID=15302. I don't know if they update interops. That means that your add-in built/tested with Excel 2016 will work with 2019. Still, you must be aware that they can introduce a new feature that may affect your add-in. Say, I see mso3DModel = 30 (&H1E) in Office.MsoShapeType which is missing in Office 2016; if your add-in deals with shape, it may be affected. Also, see TextJoin in the above-mentioned page.


Andrei Smolin
Add-in Express Team Leader
Posted 01 Apr, 2019 03:02:40 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
Forgot to mention: you can also check if they provide more details at https://support.office.com/en-us/article/what-s-the-difference-between-office-365-and-office-2019-ed447ebf-6060-46f9-9e90-a239bd27eb96.


Andrei Smolin
Add-in Express Team Leader
Posted 01 Apr, 2019 03:41:41 Top
WSAddInDev


Guest


Hi Andrei,

Thanks for quick response.

Is it possible if you can share the technical changes Add-in Express development team had to do to support of Excel 2019?

Basically, if there is any internal structure or design or architecture change that your team came across.

Thanks,
Posted 01 Apr, 2019 04:43:01 Top
Andrei Smolin


Add-in Express team


Posts: 18823
 Joined: 2006-05-11
No such change was made.


Andrei Smolin
Add-in Express Team Leader
Posted 01 Apr, 2019 05:41:58 Top