Add User Defined function support to the Apps for Office Excel APIs
Add User Defined function support to the Apps for Office Excel APIs so that users can enter formulas in excel. User Defined Functions are one of the most powerful features of Excel (and some competitor spreadsheets products now available in the web). They are critical for us to make our Apps for Office product as powerful as our legacy on premise product.
Darryl
shared this idea
Darryl, thanks for your feedback! Today we announced that JavaScript custom functions in Excel are available for you to try in Developer Preview! See https://aka.ms/customfunctions for details.
Thanks for all the feedback and comments here!
Office Extensibility Team
31 comments
-
Kevin Thompson
commented
Is there any estimate of if/when this will be released to the public? I'm trying to decide between a VBA add-in and a javascript add-in. The latter is preferable, but not if the feature won't be released for a long time.
-
Murugananth S
commented
Hi Team,
I am trying to implement custom functions in VS2017 but due to manifest error not able to do.
Error : DesktopFormFactor need to use instead FormFactor.
-
Anonymous
commented
How can we call our own web api call in custom functions?
-
Murugananth S
commented
Team,
I am not able to use with task pane in sample application. Can you please suggest how to include custom functions in sample application. -
Anwesh Gangula
commented
How do we try the developer preview?
-
Song Seunggeun commented
Is there any official discussion on the release date of this preview? :)
-
Nathan Jackson
commented
This is one of the features that's preventing me from beginning to port over a fairly large library of legacy VBA code into JavaScript.
-
Tie
commented
Hello team, i have seen a tag `custom-functions-excel` in StackOverflow, it seems that there is some update, right?
-
Sven Wehmeier
commented
Hi team, some update would be really appreciated.
-
Doug Jenkins
commented
The potential for on-line Excel UDFs is enormous, and the long wait is frustrating.
-
We wanted to just give a quick update that we are still working on this. We are hoping to have something in preview later this year.
Thanks!
Office Extensibility Team -
Charles Walker
commented
Any news on this topic ?
-
Hervy
commented
Hi team, some update would be really appreciated.
-
Tie
commented
Hi team, I was told that there should have been some news around the 12th of May. So is there any update?
-
Thorsten Hans commented
hey team, any update on this one?
-
Hector David
commented
#jirabot
-
Anonymous
commented
This is going to be a huge on Excel lovers.
Looking forward to an update on this.
-
Andy Comley
commented
Its hard to see how any addin for Excel can look like its working alongside Excel without this feature. At the moment Excel addins look totally disconnected with the rest of Excel functionality. Users want close integration between addins and Excel - so the ability to hook into the formula mechanism is a key part of that.
-
Bob
commented
Why was this important feature released in first version? And even more it is not scheduled in recent release? Without it, I don't think the Office API can support us to do a real addin product.
-
Hervy
commented
Agree with guys below. Some status update is needed. For us this is critical.