Feedback by UserVoice

I suggest you ...

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.

333 votes
Sign in
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Darryl shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: facebook google
Signed in as (Sign out)
  • Bob commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Agree with guys below. Some status update is needed. For us this is critical.

  • atti commented  ·   ·  Flag as inappropriate

    Please provide some feedback what is the actual status and when do you plan to start implementation?

    This is critical feature!

  • Scott Harrison commented  ·   ·  Flag as inappropriate

    Will this feature include the use of user-defined functions with formula arrays? This would greatly help our use case.

  • atti commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Must have feature for transferring of many existing addins to the new JS API stuff from the legacy frameworks (SDK, COM, VSTO, VBA).

  • Michael Brennan commented  ·   ·  Flag as inappropriate

    I agree this would be an extremely powerful addition the JS object model. User defined functions/formulas would allow users to take control of where data should be returned within their Excel workbooks. This is a very common requirement when reporting is considered, for example building a dynamic Financial report/statement in Excel which can be refreshed requires a high level of Excel proficiency and lots of manual work to build.

    The common way this is solved on desktop Excel is to allow users to insert custom financial formulas which understand the source accounting/ERP system and then allow the user to quickly build their Financial layout around the custom formulas.

    The following would need to be supported:
    1. Ability to write custom functions in Javascript
    2. Have Excel 2013 / Excel Online recognize and allow access to these functions when a user references the function in Excel (e.g. =CustomFunctionName), Excel should allow users to interact with these custom functions in the same manner as existing functions.
    3. Allow custom functions to be filled in using the 'Function Arguments' UI which is available for standard Excel functions.
    4. Custom functions should refresh when the 'Calculate Now (F9)' feature is called.
    5. Custom functions should as far as is possible replicate the same capabilities as current desktop Excel User Defined Functions.

2 Next →

Feedback and Knowledge Base