Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Provide values entered by the user into a bound cell directly to the Office.EventType.BindingDataChanged callback function

    Excel Online and Office.js provide an excellent way of integrating Microsoft's tools with other cloud-based services, but latency is currently a barrier and this is a way of solving it.

    I have developed an office.js task pane app that binds to many cells, each linked to variables in mathematical models running on an external server. When the user enters a value, that value is sent to a remote server, results are computed, and they are sent back to be written to various other cells in the spreadsheet.

    However, a value entered by the user is not directly passed to the…

    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 →
  2. New standard number format for Excel: Versioning

    It would be nice to have a standard format for version numbers that can be sorted/conditionally-formatted like regular numbers. By version numbers I mean "2.1.0; 2.1.2; 2.2.0; 3.0.0" etc.

    I work in software development and use excel to track releases, this would be very helpful to have standard.

    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 →
  3. Render Office.js task pane even if Excel is in the background

    I have observed that is Excel is hidden or if another window covers the Excel task pane, the Office.js add-in does not load. I have observed this behavior with Excel 2016 C2R on Windows.

    Please enhance Excel and/or the embedded browser to render the add-in regardless of the currently visibility. Thanks!

    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 →
  4. created a new add-in for data management in Excel. Would love feedback/suggestions!

    I created a new add-in for data management in Excel. Would love feedback/suggestions! Here's the link to the video: https://youtu.be/uSAexY1HsHs.
    Thanks!

    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 →
  5. Support for get active worksheet as file in excel online office 365

    How to get active worksheet as file in excel online office 365?

    For getting whole file or document we are able to do it using Office.context.document.getFileAsync() but i wanted to get worksheet as file using office API.

    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. Enable recalculation in JavaScript API at worksheet-level, workbook-level and range-level

    At the moment, we could recalculate all currently open workbooks in JavaScript API. It would be necessary to be able to trigger recalculation at worksheet-level, workbook-level and range-level.

    For a comparison, all the recalculation mentioned above are possible in Excel COM (VBA & .NET).

    Formulas are the essence to make an Excel a "program" rather than a database. Recalculation of formulas is how an Excel as a program executes. It is necessary to give developers have more control of these essences of Excel.

    10 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 →
  7. allow add-in to use user's authorizations

    An add-in that has been installed, and approved should not have to initiate another oauth flow to have access to documents on a sharepoint site, onedrive site, onedrive for business site,etc.
    The API should make this readily available when the user is logged in, and has already granted permissions to the add-in itself.

    10 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 →
  8. Automate Task Pane Insertion into Excel

    Excel Addin
    I want to insert the task Pane Addin into my excel file using Powershell script.
    We deploy add-in in SharePoint catalog and then manually insert into excel files.
    This is preventing use from getting into automated deployment.

    16 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 ability to refresh a chart from Javascript

    Sometimes a chart connected to a table is not refreshed on all table changes. For sample if I delete and add rows to a table, the chart is refreshed, but after calling table.reapplyFilters() it is not.
    Please, add ability to refresh a chart on demand.

    9 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 →
  10. Allow merged cells to grow. (wrap text)

    Need the ability to have a top section with more columns than the bottom section. Merging cells doesn't work if you want a cell to be able to get taller (Wrap text).

    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 →
  11. Update Office.js on NuGet

    Been working with Excel and have been notified over the past several weeks, requests I made were updated however the last time Nuget.org was updated was 11/5/2015. Is there some other way I should be updating the Office.js scripts in my VS project? I know this isn't a suggestion but hopefully someone can comment and I can remove this.

    4 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 a "Convert to Number" button to Excel

    There are only convoluted ways to convert many cells in Excel from text to number. Error checking won't appear soon for many cells, "Text to Columns" is not really for this, Paste Special, using functions, or macros are really not straightforward. Please add a "Convert to Number" button somewhere to the ribbon!

    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 →
  13. Office 2013 JavaScript API - Problem with indexing rows above 32'768 in bindingObj.setFormatsAsync

    Hello there.

    I can't mark rows with index above 32 768. I've got big amounts of data (even up to 1 milion) to validate, and I need to mark invalid cells/rows by background color or other formating options.

    There's no effect on rows above that unfortunately "small int".

    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 →
  14. Add select all (ctrl+a) and copy (ctrl+c) inside a cell in Excel

    When a cell is in focus, allow the contents to be selected and copied

    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 →
  15. Copy named table

    There is no method currently in the API for copying a worksheet or a named table/range. It would be helpful to expose these features through the API. By copying a named table or a worksheet, it should copy all the formatting, formulas and data validations as well.

    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 →
  16. Extend the XLL addin api xlAddInManagerInfo12 to support more kinds of information

    The XLL addin api xlAddInManagerInfo12 has a parameter to identify what kind of information Excel wants about your addin, but this parameter currently only ever has 1 value, to request your addin's title.
    Other kinds of addins (VBA, COM) can provide a full title and description to Excel, but XLL addins can only have a title. Please add an additional value to this function so that XLL addins can also have a description.

    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 →
  17. Add ability to refresh Power View from Javascript

    If we have a Power View based on Excel Table, the Power View is not refreshed on table changes.
    Please, add ability to trigger a Power View refresh from Javascript API

    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 →
  18. Fix Excel API - binding.getRange() returns the wrong address if the binding was created from bindings.addFromNamedItemAsync()

    It returns the sheet name that was active when the call to addFromNamedItemAsync() was made and not the range of the actual named item. The cell range is correct though.

    For example if the "MyNamedRange" which points to A1,B1,C1 is in Sheet1 to but the active sheet is Sheet2 when the binding is created then range.address = "Sheet2!$A$1:$C$1 after binding.getRange() and it should be Sheet1
    function getRangeAddressFromBinding()
    {
    Excel.run(function (ctx)
    {

      var binding = ctx.workbook.bindings.getItem("myId");
    
    var range = binding.getRange();

    range.load('address');

    return ctx.sync().then(function ()
    {
    write("Range address is " + range.address);
    });

    })
    .catch(function (error)
    {

      console.log("Error: " + error);
    
    if
    6 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 →
  19. Excel API - call to binding.getRange() on a deleted binding range corrupts the workbook file and needs repair when re-opened

    If binding range is deleted by deleting all columns or rows of the range and then binding.getRange() is called it corrupts the workbook file and when re-opened the workbook needs repair (which will delete all the corrupt binding AND all other binding ranges in the same sheet that was corrupted).

    This might not seem like a big deal at first but, in addition to this occurring when the user is in session with your add-in loaded, a lot can happen when your add-in is not loaded and when it is re-loaded you have to deal with these situations if you…

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

  • Don't see your idea?

Feedback and Knowledge Base