Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Important! Problem with RangeAreas method

    This both code will work in VBA:
    dim rng as range
    set rng = range("d3:d4,f3:f4") // 2 areas range
    rng.copy destination:=sheet.range("...")
    or: reverse region area
    set rng = range("f3:f4,d3:d4") // 2 areas range

    rng.copy destination:=sheet.range("...")

    There is a rearrangement of the selection so
    It will affect the recording of range.value
    In API-javascript this code did not work
    sheet.getRange("d1").copyFrom("f3:f4,d3:d4");

    because selections do not arrange themselves

    so if using the Findall method: var searchrange=sheet.findAll(...)
    i canot using searchrange nomarly. because the search result order returns a messy result
    I can only format this.
    //
    This is my personal opinion
    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. Relative Object Model

    Small question: getSelectedRange() method why not contain in worksheet method.it's easy to confuse and unreasonable
    Suppose I am using a sheet variable and now i need reference to Selection then I will have to refer a new variable =context.workbook.getSelectedRange(); instead sheet.getSelectedRange();
    It makes the command longer

    I think should be add: .... getActiveworkSheet().getSelectedRange();
    even ....getActiveSheet().getSelection(); ...

    Thanks you!

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

Feedback and Knowledge Base