Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Excel API Reference Variable

    var range = context.workbook.worksheets.getItem("Sheet1").getRange("A1:D4");

    var sumOfTwoLookups = context.workbook.functions.sum(
    
    context.workbook.functions.vlookup("Wrench", range, 2, false),
    context.workbook.functions.vlookup("Wrench", range, 3, false)
    );

    Is it possible to change it similarly vba code

    with context.workbook.functions
    ...<my code>
    end with

    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 →
  2. Workbook Views control

    Hi All,

    At the moment, workbook can't switch views,
    Please advise Workbook Views control, such as Normal, Page Break Preview, Page Layout and Custom VIews,
    I need your support and feedback,

    Best Regards,

    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 →
  3. 5 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. 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 →
  5. 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 →
  6. FunctionFile Implementation in Angular

    I have a angular component that is doing some styling stuff I want to call that component using FunctionFile insted of Taskpane.

    Please give me some suggestions.

    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. Focus on Custom Office Ribbon by office js or manifest.xml file

    While opening the excel instead of home menu can I focus on my custom made menu?

    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 →
  8. 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 →
  9. 2 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. Eddit Excel Image effect with api

    Can image effects be programmatically edited wit API - (brightness, contrast, possibly un cropping) .
    Also there is now way to select image, like range.select(address)

    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 →
  11. add-in commands in office 2016

    I have Office 2016 Build 16.0.4266.1003. My Addin is working fine in this but add-in commands is not working with this build.
    I think MS shall give support of add-in commands in All build of MS 2016.

    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 →
  12. User Defined Aggregation function

    Aggregation function (e.g. Average, Count, Min, Max, ...) seems to be first-class citizen function in Excel.

    Only those functions can be used to summarize field values in Pivot Table and in Subtotal function.

    As far as I know, I can expose user defined function into Excel through an Add-In but I cannot extend aggregation functions.

    Please provide an API to register our own aggregation functions such as we can use them in PivotTable or Subtotal function.

    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. While using getFileAsync method, error which code is 12007 was happened

    I am uploading 1.01Gb excel file via getFileAsync of office javascript.

    uploaded till 1Gb, error which code is 12007 was happened . How to fix it could you pls help me

    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 →
  14. Power Pivot

    Add Power Pivot

    2 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. 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 →
  16. SSO for Excel custom functions

    Use case: We have a task pane Excel Add-in working in conjunction with custom functions. Custom functions as well as the task pane need authentication before they are granted access to a resource. We'd like to offer either Single-Sign-On with the Microsoft account or sign-on with a proprietary account and want to avoid burdening the user with multiple sign-in prompts. The custom functions don't need any UI, that means the user can run custom functions with or without opening the task pane.

    I'm aware of the 'OfficeRuntime.AsyncStorage' option to exchange tokens between the task pane and the custom function portions.

    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 →
  17. 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 →
  18. Desktop background excel - Live

    Dear,

    For example my computer background is black color. I think we can usefull desktop by background live on desktop by office programs.

    I can use it as excel on desktop background in computer and I don't need to open the Office programs to take notes. This is very usefull

    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. Application.ScreenUpdating

    Add possibilities to disable screen updating to speed up things (Application.ScreenUpdating)

    18 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 →
  20. Excel Angular Addin without any third-party needed

    As it's confusing, inconsistent and depending on third-party sources, I cannot make my Excel Angular Addin to work. I have followed step by step instructions for several times and for some reason it won't work for me.
    I successfully created a Excel JQuery Addin project, however, I really need to do it in Angular and it must be reliable and easy to build.
    I have professional experience with Angular 7 and I am sure other developers would be happy to be able to dev in Angular without any external complications/dependencies.

    Regards,
    Fernando

    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 →
  • Don't see your idea?

Feedback and Knowledge Base