Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add an event that can be subscribed to when a user makes a change to a cell.

    This might look not so important in many use cases. However, when the add-in takes in data from the worksheets and saves them through API calls, it becomes quite useful for a good user experience. Currently, users would need to click on a button in the add-in that would save all of the rows in one go. However, It would be nice if they don't require to do that and the changes can be saved real-time.

    1 vote
    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 →
  2. Javascript API For Excel Enhancements (copy worksheet/copy Range,merge cells,call a VBA function)

    I think the Office Add-In technology is a great start, but is just too limiting to replace an older VBA application. Maybe a start would be to allow the JS API to call a VBA function so we could retain some macros especially for copying worksheets and formatting which is cumbersome in the new technology. Secondly it would help alot if we could define a worksheet and hide it and then copy and populate that spreadsheet, but their is no worksheet.copy method. Likewise if we can't do that it would at least be nice to copy a Range retaining all…

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

    Hi there,
    We’re happy to say that part of your request is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/range merge() method for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  3. Ability to add new workbooks in Excel Javascript API

    Maybe implement it similarly the VBA object model where you have a collection of workbooks.

    1 vote
    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 →
  4. Provide a common Parent object in the JavaScript API to current objects

    Currently in the JavaScript API (speaking of Excel specifically, but this should be Office-wide). This is somewhat in the API right now, but it is not fully worked out, and most importantly it's non-uniform in its application in the current objects available.

    Grabbing a table object, it has a getRange() property. This allows us to get the range of the table, that's great. The range object then has a worksheet property. Where this varies from the much more robust VBA is that a ListObject (aka table) has a Parent of the worksheet, not a range. A range has a Parent…

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs requirement set 1,2. Please see http://dev.office.com/reference/add-ins/excel/table for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  5. Programmatic access to ribbon commands

    https://msdn.microsoft.com/en-us/library/mt621545
    The new support for adding ribbon commands for Excel task pane add-ins is a good start. However, it will be even better if we can have programmatic access to these buttons. At the very least, the add-in should be able to update visibility and label. Ideally, the add-in could create buttons on the fly and control most properties. Thanks.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    8 comments  ·  Add-in: Excel  ·  Flag idea as inappropriate…  ·  Admin →
  6. Ability to modify Excel worksheet visibility

    Please provide the ability to modify Excel worksheet visibility from Office.js (in a task pane add-in).

    The Worksheet.visibility property is currently read-only. Ideally, this property could also be modified to change worksheet visibility at runtime.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/worksheet for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  7. Ability to get/set Locked property of Excel range objects

    In Office.js for Excel, please provide read/write access to the Locked property of cells. This property should be available on the range's format object.

    This ability is essential to providing appropriate "read-only" behavior when combined with an API to toggle worksheet protection. (suggestion filed separately).

    1 vote
    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 →

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/worksheetprotection for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  8. Give an example of how to register a javascript plugin in excel

    The JavaScript Excel API looks very usefull.
    However, I could not figure out how to register my add-in in excel.

    1 vote
    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 →
  9. Expose active cell via Excel JavaScript API

    similar to Workbook.getSelectedRange API, ability to get (and set) the currently active cell would be useful.

    please consider exposing Workbook.getActiveCell(), as well as Range.activate() APIs.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/workbook and getSelectedRange() for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  10. Ability to customize Excel ribbon

    Please provide the ability to customize the Excel ribbon from Office.js (in a task pane add-in).

    Add a new tab that appears when workbook is active
    Add new ribbon buttons to custom tab
    Hook button click event to execute app logic
    Set label, tooltip, icon, etc.

    3 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 →
  11. Extend the getFileAsync functionality to work on Excel as well.

    Extend the getFileAsync functionality to work on Excel as well. It's essential in order to be able to export the file to a web service.

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

    Thank you for your feedback! We’re happy to announce that you can now get Excel files using the getFileAsync() method. You can read more about it here: https://dev.office.com/reference/add-ins/shared/document.getfileasync

    And there is also a code sample of how to get Excel files here: https://github.com/OfficeDev/office-js-snippets/blob/master/samples/excel/82-document/get-file-in-slices-async.yaml

    Please check it out and give us feedback.

    Thanks!
    Office Extensibility Team

  12. Allow Office Add-in in Excel to make cells read-only for end-user

    Enhance the Office add-in javascript APIs (for Excel) to allow the add-in to programmatically make cells in the worksheet read-only.

    Our use case requires that our add-in be able to populate a table in the worksheet with values, but some of the values should be read-only for the end-user. (In our COM/VSTO add-in we toggled worksheet protection off/on to accomplish this).

    See this forum post for the origin of this suggestion:
    https://social.msdn.microsoft.com/Forums/office/en-US/2aef0535-8a26-4618-8d13-0144f852b7d1/is-it-possible-for-an-excel-task-pane-addin-to-make-cells-readonly-to-the-enduser-but-writable?forum=appsforoffice

    1 vote
    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 →

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/worksheetprotection for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  13. 9 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 →

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/tablecolumn for more information. The delete() method on this object will delete a table column.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  14. Allow app to delete all data present in excel sheet

    It would be good if developer could delete all the data present on excel sheet (Table,Matrix and independent text) on single call of function. In current version it would delete only table data (excluding headers) and for other things it have to been done manually by placing blank values at specific bindings. Thanks

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/range for more information. You can simply call getUsedRange(),delete() on the workbook you intend to delete data from.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  15. Need to retrieve excel cell formatting properties

    Need the equivalent API of bindingObj.setFormatsAsync(cellFormat [,options], callback); to get excel cell formatting properties, something like getFormatsAsync().

    1 vote
    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 →

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/rangeFormat for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  16. Need method to Office API to allow changing Height of Excel rolls and Column widths

    It would be great if once could change an Excel Web app Row height, and width via code as well as being able to change Column width and height via code. Rows and Columns sizes can be changes on the client version of Office via code and being able to do the same with the Web version of Excel would be great help as our customers are asking that our Office based apps that currently work on the clients would work on the Web Version of Excel.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/rangeFormat for more information. You can set values to rowHeight and columnWidth properties or simply call autofitRows() and autofitColumns() methods.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  17. Add ability to create chart via Office javascript API

    Currently we are allowed to insert excel tables via office js api. However, the creation of charts based on this tables are done manually in excel.

    I would like too see the JS API be enhanced to allow creating all type of charts supported in excel online.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/chartcollection#addtype-string-sourcedata-range-seriesby-string for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  18. Allow deleting entire Tables/Matrix, not just their content

    The api provide us the option of deleting a table binding content, but not the table itself.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/table for more information. You can simply call the delele() method to delete the entire table.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  19. Add ability to import a table into excel as html from an office app.

    I would like to be able to call setDataAsync and pass in an html table that can be imported at the currently selected cell or user prompted location. Excel is very good at opening html files that contain tables and adding them into a workbook. being able to do this from an office app would be very helpful.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/table for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

  20. Allow access to the addresses of selected cells via the Apps for Office Excel APIs

    Allow access to the cell address of selected cells – With the new Apps for Office APIs most things that can be achieved are via “binding to cells”. Often this binding is based on cells the user has selected. There is no way to get the actual Excel cell addresses of these cells which makes things very difficult and complex workarounds are needed that over complicate the user experience.

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

    Hi there,
    We’re happy to say that this is now possible with new Excel JavaScript APIs. Please see http://dev.office.com/reference/add-ins/excel/range and the address property for more information.

    To find even more about all these new APIs, please check out our API documentation on http://dev.office.com/docs/add-ins/excel/excel-add-ins-javascript-programming-overview or https://github.com/OfficeDev/office-js-docs/tree/master/excel.

    Thank you,
    Office Extensibility Team

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base