Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Ability to open/replace workbook with Excel JS API in a similar way Word API can with insertFileFromBase64

    We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.

    With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.

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

    The API is in preview for Excel Desktop and Mac now!
    This feature is not be able to GA due to this API is not available on Excel online due to the Excel online cannot insert worksheet from the external workbook, so Team is now working on investigating on Excel online. and figure out the features that we can support now and our strategy is to build addFromBase64 for Excel Online with a limited supported feature, which allow us to GA this API. and then we will continue iterating this API to support more features

    For Excel Desktop and Mac beta preview. you could use our Beta CDN, more info on this here https://aka.ms/excelapiopenspec

    Here is a sample code snippet using the API

    https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a

    key line of code context.workbook.worksheets.addFromBase64(mybase64)

    send an xlsx (base64 encoded)

    please use it and send us feedback!

  2. Fix GeneralExceptions being thrown when multiple workbook are opened

    Sometimes when more than one workbook is opened, then a:
    GeneralException: There was an internal error while processing the request
    is thrown during various office-js operations.

    See https://github.com/OfficeDev/office-js/issues/771 for details.

    I know there's a workaround:
    https://docs.microsoft.com/en-us/office/troubleshoot/excel/force-excel-to-open-new-instance
    but it's impossible to force clients to use it.

    137 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 →
  3. Fix the issue with new JavaScript API for Excel: any change by an add-in clears the Undo/Redo stack.

    You can try to run this code and check the Undo/Redo stack:
    Excel.run(function (ctx) {
    return ctx.sync();
    });

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

    Renat, thanks for reporting this issue! We are aware of this and the bug is currently being patched. Note that the undo stack will be removed upon any “update” action occurring in the add-in. For read actions, we’ll preserve the undo-stack. We’ll let you know when this is available.

    Thanks,
    Office Extensibility Team

  4. JS API function to prevent user from sheet interaction

    It would be extremely helpful in certain cases to prevent user to interact with the sheet/workbook while some action in the task pane is required or when some process is running (e.g. when some complex sheet changes are being performed - formatting, inserting columns, inserting data, charts....).

    80 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 →
  5. Add Workbook.CancelEdit or WorkSheet.CancelEdit to get around GeneralExceptionError when cell being edited

    It would be great to have a CancelEdit or have the Range Select / setting range values automatically cancel the editing and avoid this error which seems to have no workaround.

    Whenever a cell is being edited by the user, any attempt to select a different range or update values in different ranges causes the General Exception error. There is no method to Cancel the Edit (essentially just need to send the ESCAPE keystroke to the workbook).

    To reproduced just double-click on a cell to go into edit mode and then execution of this code fails:
    Excel.run(function (ctx) {

        //this
    65 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 →

    Hi Brian. Thank you for your input, it is greatly appreciated! We’ve added this to our backlog as something we want to implement. There are many items on the backlog, so we can’t set an exact estimated time for this, but we’ll keep you posted with status updates.

    Thanks!
    Office Extensibility Team

  6. Enable binding keyboard shortcuts to a button in Office Add-in or a function in JavaScript

    I have implemented an Excel Add-in, where there are buttons. Clicking on a button will trigger a JavaScript function.

    It will be much convenient to allow users to bind shortcut to a button / function. Users will be able to trigger them more quickly when they need.

    There may be several possibilities as solutions: 1) provide a mean in JavaScript API to bind a shortcut to a button / function; so it will be the job of the add-in developer to bind a shortcut 2) provide a mean to allow users to bind a shortcut to a button in an…

    56 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 →
  7. merged cell

    Allow Excel Javascript API to check for merge cells. Currently it can only merge/unmerge cells but can not check the cell status.

    53 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 →
  8. Make a tool for debugging Javascript API in Chrome Devtools

    Debugging on Mac is a pain.. The built-in safari tools are buggy and laggy. The only useful feature of volron.js is displaying console.log's.
    I want a normal developer experience on Mac!

    37 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 →
  9. Add worksheet activate/deactivate; workbook shutdown events to the Office Add-in Javascript APIs

    The enhanced Excel-specific APIs available for developing Office Add-ins that run with Excel 2016 are a nice start. There are some key missing APIs. One area in need of extending is eventing. For workbooks that contain multiple worksheets, it is critical for the Add-in to be able to determine when a worksheet is activated/deactivated so that the Add-in's UI can adapt accordingly. Similarly, the Office Add-in should be able to hook an event so that when the workbook gets closed/shut down (and maybe Saved), the Add-in can persist in-memory state into the workbook.

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

    Thank you for your request!

    We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

    If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

    https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

    Thanks!
    Office Extensibility Team

  10. Ability to get username in Excel

    I'd like to be able to access the username listed under Account -> User Information in my add-in in Microsoft Office Excel 2016.

    Besides being able to customize the add-in experience and address the user by first name, having the full name would allow me to look up internal users and perform more advance functions like looking up permissions or recording their userId along with actions they perform.

    33 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 →
  11. chart.getData() Method

    Add a getData() method to the chart object to get the worksheet range sourceData and seriesBy information of a chart.

    33 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 →
  12. Enable fetching VBA macros of a workbook in JavaScript API

    In VBA, we could use for example Wb.VBProject.VBComponents to fetch all the VBA macros of a workbook Wb:

    https://msdn.microsoft.com/en-us/library/aa443982(v=vs.60).aspx

    In contrast, at the moment, it is not possible to get the VBA macros out of the workbook using JavaScript APIs.

    These VBA macros, even in form of text, will enable (existing and emerging) analysis tools over VBA macros. Although such tools are not a lot (because they are hard to build), it is not impossible, and it is necessary. For instance,

    1) some big companies have in-house tools to inspect their VBA macros against programming guidelines, and find code smells.

    32 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 →
  13. Trace Precedents/Dependents

    Function/ability to trace precedents and dependents with the office.js API (similar to GetPrecedents in VBA).

    31 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 →
  14. Provide more information with the Binding.BindingDataChanged event (for Excel table bindings)

    The current BindingDataChangedEventArgs object passed to the event handler for the Binding.BindingDataChanged event only contains properties for the binding that raised the event and the type of event. There is no specific information about what cells, columns, or rows in the table object were changed. When dealing with tables with many rows and columns and/or end-user gestures that edit/insert/delete many cells/rows/columns at once, this API is not very useful. Contrast this to the (Excel) COM APIs where, at least, the SheetChanged event provides a Range object that describes what was changed.

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

    Thank you for your request!

    We are collecting API requirements for developing Office Add-ins in Excel, specifically for Events API.

    If you are considering moving an existing COM/VSTO/VBA Add-in to Office Add-in, or creating a new Office Add-in in Excel, and have events requirements, please fill the survey below and help us focus on the right set of events and design. We truly appreciate your help!

    https://forms.office.com/Pages/ResponsePage.aspx?id=v4j5cvGGr0GRqy180BHbR-JHDwXr1WhPtbjLQNPOgHtUOFhNTTRVNEE5WE9VVzExOVY5Tko2V05TSi4u

    Thanks!
    Office Extensibility Team

  15. Harita Grafiği

    Türkiye Grafiği için Batman-Siirt illeri karışmakta.
    Bolu ile düzce illeri karışmaktadır. Sorunun çözümü halinde daha aktif olarak kullanılabileceklerdir.

    27 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 →
  16. Grafiklerin Geliştirilmesi

    Excelde oluşturulan dağılım grafiğinde dikey ve yatay çizgiler oluşturulamamakta.
    Ayrıca yine aynı grafik türünde nokta ismine etiketin isimlendirilememesi hatası mevcuttur.
    Powerbi de bu sorun yok ancak excelde mevcut.

    24 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 →
  17. Add the print api

    I generate tables for the corresponding styles based on the data in the sheet. I want to print them out.

    I tried to find the api in the document,but I did not find it.

    23 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 →
  18. Improved native reference control while using Bindings.addFromPromptAsync

    Currently when we use Bindings.addFromPromptAsync to use it as a cell reference picker which supports ANCHORING we face two issues:

    1) There is NO way how to get the range address directly (you have to find the Binding from the ID and there you can call binding.getRange() method!).

    2) The returned address from the binding.getRange() (as shown above) IGNORES the anchors used in the native dialog!

    My suggestion is to add a way to the Bindings.addFromPromptAsync to return the cell address really shown in the native dialog (i.e. it would support anchors like $A1, A$1, $A$1)! It could be as…

    23 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 →
  19. Support drag-drop capability between the browser-based Excel online and office.js task pane apps

    It's a big user interface improvement if a user and can and drop cells and data between the task pane and Excel. I found a way to get this functionality working in the Excel 2016 desktop client (and it's wonderful!) but as far as I can tell, there's no way to do it in the browser-based client. This means that I have to detect whether or not Excel is 'win32' or 'web' and then use an equivalent but much less intuitive menu-based interface for the 'web' case.

    23 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 →
  20. Add support for Document.getFileAsync method in Volume licensed versions of Office Excel

    I am attempting to use the Document.getFileAsync method in Office Excel 2016 on Windows. Executing the method fails with an "Permission Denied" error.

    Error code: 7000
    Error name: "Permission Denied"
    Error message: "You don't have sufficient permissions for this action."

    This functionality is critical to our Add-in and we have many customers that use this 2016 volume licensed version of Office. They are not able to upgrade since the version is locked down at 16.0.4266.1001.

    22 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 →
← Previous 1 3 4 5 11 12
  • Don't see your idea?

Feedback and Knowledge Base