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.

285 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 →

    22 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...
      • TieTie commented  ·   ·  Flag as inappropriate

        Hi team, I was told that there should have been some news around the 12th of May. So is there any update?

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

      ← Previous 1

      Feedback and Knowledge Base