Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Expose Workbook events via Excel JavaScript API

    Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):

    Activate,Deactivate
    BeforeSave,AfterSave
    BeforeClose
    Shutdown
    SheetActivate,SheetDeactivate
    SheetBeforeDoubleClick
    SheetBeforeRightClick
    SheetChange
    SheetSelectionChange

    154 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  2. 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
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    33 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  3. Custom properties for Excel Addin

    We can read/update custom properties in Word. It would be great if we can have similar function in Excel also.

    27 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  4. Worksheet password protection

    We are also concerned about the issue mentioned on this post:

    http://stackoverflow.com/questions/38847193/excel-office-add-in-api-worksheet-protection-password

    Currently we are able to protect and unprotect a worksheet. What we need is an API for password protection of worksheets which the end user would not know as this is will make the worksheets on OneDrive more secure for use.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  5. Make O365 user identity available in Excel Add In

    I need to know the identity of the user who is invoking my Excel-based add-in so that I can rigorously and securely associate various external data access levels with them. It doesn't matter if they are not signed in - the app defaults to a Guest User and can encourage the user to sign into their excel client.

    Specifically, I spent the last 2 days picking my way through the wilderness of ADAL and MSAL options and have concluded that I cannot use them within the confines of an Excel task pane app AND provide a satisfactory user experience. This…

    4 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  6. Allow Officejs to open external excel workbook programatically

    There should be a way to open a external excel workbook by providing URL for that file on excel online via officejs. so that user can open a template stored on some other server which contains desired formatting and named-ranges which can be modified on Excel Online

    51 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    5 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  7. Implement Conditional Formatting Editing

    The ability to edit conditional formatting in OfficeJS Excel API.

    21 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  8. Excel - Add CopyWorksheet

    We have a need to repeat the same formatted Worksheet over and over based on selections made by the user. It would be great to setup a template so that same worksheet can be copied. The worksheet has all formatting including printing stuff in place already. Be great to just be able to copy that and fill in the data.

    44 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  9. Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.

    Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.

    The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.

    Could you please let us know if it's possible to add this method to JavaScript API for Excel?

    114 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  10. Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values

    Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.

    37 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  11. Provide access to CustomXMLParts for Excel via JS APIs

    It will be good to have access to CustomXmlParts for Excel via JS APIs. Currently it supported only by Word. It allows developers to provide coolest plug-ins for Excel 365.

    18 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  12. Add Abitility to create pivot Table via Office Javascript API

    In the current version of the office javascript api I can see that the setSelectedDataAsync method allow only inserting text, matrix and table into excel spreadsheet.

    I would like to see the javascript api enhanced and allow inserting pivot Table also. In this way I can use pivot Table helpers (such as slicer, fields list ....) and also refresh pivot table programmatically.

    87 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    3 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base