Search code examples
ms-officeoffice-jscustom-functions-excelscriptlab

Submit add-ins with custom functions (update?)


I asked a question regarding submitting add-ins with custom functions 6 months ago. The conclusion at the moment was an add-in that uses custom functions cannot currently be published to the Office Store or via Office 365 centralized deployment.

But I realize that the document has changed, now it is

Known issues

... ...

Deployment via the Office 365 Admin Portal and AppSource are not yet enabled.

Moreover, I found the new functions button in Script Lab. Users could register a function like =ScriptLab.BlankSnippet1.add10(…) and use it in Excel.

So my questions are

1) Has Script Lab successfully submitted a function ScriptLab in AppSource?

2) Today, could other developers outside Microsoft submit add-ins with custom functions like Script Lab?


Solution

  • Update - Custom Functions are now generally available, so you can now submit add-ins that contain custom functions for validation in the store. If submitting an add-in with Custom Functions, please see the validation policies here:

    https://learn.microsoft.com/en-us/office/dev/store/validation-policies#15-add-ins-with-excel-custom-functions