I have a problem when submitting my Addin for Office
My plugin must work on Word and Excel 2016 (MS Desktop 2016, Online, Mac). When I submitted, they told me that all must be in one project.
This is about the 4.12.1 chapter about extension exigence page, when I wanted to put the "requirements" tags.
So, I put these lines, but the plugin didn't work. Only "WordApi" or "ExcelApi" is allowed but not the both. In the furnished manifest, I put only WordApi.
<Requirements> <Sets DefaultMinVersion="1.1"> <Set Name="WordApi" MinVersion="1.2"/> <Set Name="ExcelApi" MinVersion="1.1"/> </Sets> </Requirements>
I spent one day to search everywhere but nothing. Do you have a solution?
I believe the issue here is using a single manifest for both Word and Excel. If you specify both 'Document' and 'Workbook as hosts but then add WordApi as a requirement it will effectively disable your add-in in Excel. This is because Excel will always fail the requirement check for for WordApi. Similarly, if you specify ExcelApi it will effectively disable the add-in for Word.
The workaround is to create two manifest files, one for each host. Note that this will require that you submit two different add-ins for validation since each add-in is linked to a single manifest.
When submitting multiple add-ins there are a couple of important steps that need to be taken:
Each add-in must have a unique name. You cannot submit two add-ins with the same name as it would make it pretty difficult for user's to discern between them. As an aside, descriptive names are super important. I cannot overstate how much better add-ins with descriptive names perform over add-ins that rely only on brand/product names.
Each manifest must have a unique GUID
<id>in the manifest. This is how Office identifies each add-ins (Names may change change but Ids remain the same) and submitting two add-ins with the same Id will trigger an error condition. Even in side-loaded scenarios, duplicate Ids will present problems when deploying.
Validation isn't an automated process, it involves human beings actually testing your add-in. Providing as much detail as possible will help them get up to speed quickly so they can focus on helping you get into the Store.