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! We are at the early stages of design and prototyping exercise for this feature. We look forward to sharing the details as soon as we can.
As always, when the design draft is ready, we’ll present design for your review under the open-spec branches of repository: https://github.com/officedev/office-js-docs.
Thanks!
Office Extensibility Team
22 comments
-
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.
-
Sathish Raju
commented
This is very critical for us. Please provide update.
-
atti
commented
Please provide some feedback what is the actual status and when do you plan to start implementation?
This is critical feature!
-
Yuki K
commented
Any updates on this? it has been a while.
-
Eric Lacroix commented
Please keep me posted on progress
-
Rudy Cortembert
commented
Please make sure one UDF can populate a table/array "à la Bloomberg".
Thanks -
Scott Harrison
commented
Will this feature include the use of user-defined functions with formula arrays? This would greatly help our use case.
-
atti
commented
One more idea, would it be possible to support also clustering of the formulas?
I mean there is quite a lot custom formulas that perform some operation on DB (retrieving data for instance) and such formulas usually flood the DB with requests unless some "custom" clustering is performed (like invoking two sequential calculations to get the formulas in first one and then return the values in the second). It would be extremely useful to have support for such scenario internally.
I know there is concept of ASYNC formulas but that does not solve the problem.
-
atti
commented
-
atti
commented
Must have feature for transferring of many existing addins to the new JS API stuff from the legacy frameworks (SDK, COM, VSTO, VBA).