Issue with custom functions compatible with existing com Add-in

[vikasm1720]

I have existing custom function created in Com Add-in. To support MAC and online I am creating a web Add-in. I have included the equivalent add-in in the manifest. but the web add-in does not recognize the custom function created in com add-in when the same workbook opened on browser/mac instead, it throws #Name? and displays the namespace used in com add-in.

xxx.Office.Formulas COM

Custom function used in com Add-in template "=get("data").
Custom function displayed on Browser "=@xxx.Office.Formulas.get("data")"

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: e01562c5-ae22-8345-83f5-c1159bbb7cf0
• Version Independent ID: 70835436-060e-807f-3cee-a8ca0f7b6959
• Content: Make your Office Add-in compatible with an existing COM add-in - Office Add-ins
• Content Source: docs/develop/make-office-add-in-compatible-with-existing-com-add-in.md
• Product: non-product-specific
• Technology: add-ins
• GitHub Login: @o365devx
• Microsoft Alias: o365devx

[mscharlock]

Hi @vikasm1720 - I'm going to transfer this to the custom functions repo. I don't know why this would happen off the top of my head but our engineers might have an idea. Thanks!

[mscharlock]

@RuoyingLiang can you have a look at this? Thank you!

[lindalu-MSFT]

@vikasm1720 Hi, I assigned this to our Excel team to triage. Meanwhile, can you provide us exact repro steps, screenshots, error msgs, as well as your manifest. THANKS! You can attach files to a message by dragging and dropping.

[vikasm1720]

Addin.zip
Please find the attached screenshots and manifest.

[xiaochunms]

Looks like the CF is not installed for Web Add-in. You may can try to remove the whole EquivalentAddins node from manifest file and see if the CF can be recognized by Web-Addin without EquivalentAddins node.

[vikasm1720]

CF is installed on Web Add-in and if I remove the "xxx.Office.Formulas." from the formula, the CF gets detected and fetches data. I have tried removing the node from the manifest file too, but it does not get detected unless I edit the formula and remove "xxx.Office.Formulas." from it.

[xiaochunms]

It is the expected behavior for Custom Functions for XLL compatible mode. In Custom Functions XLL compatible mode, the Name follows the convention of XLL's functions, for example, no Namespace supported.

In your case, if you treat "xxx.Office.Formulas" as the Namespace, it explains everything.

If the EquivalentAddins node removed from the manifest file, it is a regular Web Add-in then. As Namespace is supported in this case, you can call the function by "=xxx.Office.Formulas.get("data")".

But with the EquivalentAddins node, it is a Custom Functions XLL compatible mode Web Add-in. As Namespace is not supported in this case, you need to call the function by "=get("data")" then.