Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Special Cells method

    In Excel API, I can't choose cells based if they have formulas or values.

    In VBA, I can do that by using Range.SpecialCells method. Also, I can specify if I want to get only text values, numbers, errors and/or booleans.

    Please, support this for Excel JavaScript API, because currently, I'm looping all the worksheet's used range rectangle to get the values, and my loops spend a lot of time skipping blank cells.

    39 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 →
  2. Add array formula support to the Excel Office Add-In API

    We would like to have array formula support available in the office.js API. We use these heavily in our VSTO Excel Add-in in combination with user defined functions to display function output in multiple cells. Having this feature available would allow us to build the Excel Office Add-in we would like to build.

    For other forum browsers, here is an example of an array formula.
    https://www.ablebits.com/office-addins-blog/2015/02/25/array-formulas-functions-excel/#array-formula-intro

    Please note that while Binding.setDataAsync() in the office.js API supports adding formulas to a range of cells, you cannot see or edit the formula after adding.

    93 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 →
  3. Ability to manipulate Excel comments

    Please add the ability to create, delete, and modify Excel Comments on specific cells using Office.js

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

    The ability to update, delete and insert into the Named Item Collection items for excel named ranges.

    40 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 →
  5. 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 →
  6. 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

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

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

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

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

  14. 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 →
  15. 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

  16. 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

  17. 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

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

  19. 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

  20. 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

← Previous 1
  • Don't see your idea?

Feedback and Knowledge Base