Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Freezing the top row of an excel sheet

    An excel user can freeze ehter the top row ; first row; or both.
    this isnt posible yet in the office-js api.

    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 →
  2. fix uncaught errors inside promise when an Office.EventType.BindingDataChanged event re-triggers itself (Office.js)

    When a user changes a bound cell, it triggers an Office.EventType.BindingDataChanged event and a callback associated with it. In the Excel Online browser-based client and not the desktop Excel client, if the callback function makes further changes to the bound cell e.g. changing its color based on input value (*), this produces uncaught errors after ctx.sync is called.

    These errors surface outside my functions after they return control to the browser (chrome in this case), so I am ignoring them at the moment and hope they have no ill effects but thought you'd like to know.

    I originally mitigated this…

    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. 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 →
  4. 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 →
  5. 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 →
  6. 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 →
  7. 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 →
  8. 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 →
  9. 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 →
  10. 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 →
  11. 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 →
  12. 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 →
  13. 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 →
  14. 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 →
  15. 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 →
  16. 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 →
  17. 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 →
  18. 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 →
  19. 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 →
  20. 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 →
  • Don't see your idea?

Feedback and Knowledge Base