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.

219 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    DarrylDarryl shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    15 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Anonymous commented  ·   ·  Flag as inappropriate

        This is going to be a huge on Excel lovers.

        Looking forward to an update on this.

      • Andy ComleyAndy Comley commented  ·   ·  Flag as inappropriate

        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.

      • BobBob 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.

      • HervyHervy commented  ·   ·  Flag as inappropriate

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

      • attiatti 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 HarrisonScott 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.

      • attiatti 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.

      • attiatti 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 BrennanMichael 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.

      Feedback and Knowledge Base