Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. 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 →
  2. Support Custom Functions on iPad

    My add-in's core value proposition lies in custom functions and we'd like to support as many platforms as possible.

    Would be great to see custom functions capabilities coming to iPad alongside Web / Mac / Windows!

    21 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. 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 →
  4. Reverse VLookUp/ WLookUp

    The LookUp formulas are very powerful tools for any kind of application. Often you are not only searching for the first corresponding value in an Excel sheet, but also for the last corresponding value in an Excel sheet. So reverse references would be very useful.
    The Reverse VLookUp should therefore search from bottom to top in the matrix.
    The Reverse WLookUp should therefore search from right to left in the matrix.

    18 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. Make working with invalid bindings easier

    Working with invalid bindings is slow and awkward. Please make working with them easier by:


    1. Actioning this feature request: https://github.com/OfficeDev/office-js/issues/804 (see also this Stack Overflow question: https://stackoverflow.com/q/45586251/185544 ).

    2. Making delete work on an invalid binding.

    Right now there are awkward, undocumented workarounds like the one in this Stack Overflow answer:https://stackoverflow.com/a/61803555/157247, but they're...awkward and undocumented. :-)

    Thanks!

    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. PLEASE!!! Remove the "Convert to Stocks" tag that pops onto the screen obscuring other data on the sheet.

    While the new stocks data type is fine, those of us NOT wanting Stocks are faced with a new persistent pop up tag suggesting we "convert" anything that kind of looks like a ticker symbol. This tag maddeningly blocks adjoining values that we NEED TO SEE while working.

    4 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. Fix an issue on excel custom-function about data formatting on date/time

    User can't customise date format of the data that has been rendered by custom-function - dynamic array formula.

    for more info: https://github.com/OfficeDev/office-js/issues/1068

    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 →
  8. I would really appreciate using high resolution pictures in header and footer

    ... not to lower picture quality causing blurring header & footer

    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 →
  9. 各 位 大 大 好 我 是 小 柒 加1ine:1j11

    各 位 大 大 好 我 是 小 柒 加1ine:1j11
    我 是 介 紹 美 眉 的 喔 當 你 們 看 到 這 則 信 息 的 時 候

    就 表 示 你 們 有 福 了 因 為 小 柒 會 幫 你 挑 選 最 優 質 最 適 合 你 的 美 眉 滿 足 你 的 性福 無 論 是 寂 寞 空 虛 的 夜 想 找 人 陪 還 是 工 作 累 了 倦 了 想 得 到 放 鬆 舒 壓

    還 是 夫 妻 性 福 生 活 並 不…

    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. Add "Find previous" button next to "Find next" in "Find and replace" (ctrl-f) in Excel

    In table with lots of rows I often need to find entry which I entered previously - for example I want to find last use of THIS word and if I use "find next" option it will lead me to the first use instead of last. And if I use "Find all" while I'm editing mid part of the table it will give me long list where I need to find the right context and that takes time. Sometimes, I just know that the right context of THIS word is used last time and I would like to jump there…

    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. Include workbook id inside Excel.context

    The context already have information such as the author of the document and the title, but it don't have the workbook id,

    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 →
  12. Implement arrow style for a data series in a chart

    In Office Excel, you have an option to implement an arrow style in your line chart for a data series.

    However, it seems like the office.js library is unable to implement this option.

    Excel.Line has the option I'm looking for (beginArrowheadLength, beginArrowheadStyle, etc, ), but it was strictly for shapes, completely separate from series charts, and has no way to somehow implement a custom shape to the data series.

    Adding this feature would help me greatly to create a chart directly to excel instead of building a custom chart inside the page.

    More information on my stackoverflow question:
    https://stackoverflow.com/questions/59971581/microsoft-office-js-excel-add-in-how-to-implement-arrow-style-for-a-data-serie

    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. Provide way in VBA to know who, if anyone, is currently coauthoring a OneDrive/Office365 document

    There are certain functions and events (only tested in Excel .xlsm desktop) that don't work when a document is in coauthor mode using OneDrive/Office365 syncing. If only one person is in the file, the macros work fine. If more than one are in it and co-authoring it would be good to know so certain macros can be prevented from running that otherwise cause the "Reload document" message on the computer that didn't run the macro.
    Some of the VBA that doesn't work during coauthoring include all .FormatConditions code (even though you can manually add conditional formatting, doing it by VBA…

    9 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. Optimización Función Buscar

    En mis hojas de calculo no uso la función Buscarv() o Burscarh() por su lentitud en ejecución y por su limitación de no poder devolver valores que se encuentran a la izquierda del vector de búsqueda. En cambio utilizo la siguiente función que mejora ambas características.

    Public Function BUSCAROPT(ValorBuscado As Variant, VectorBusqueda As Variant, VectorDevolucion As Variant) As Variant

    Dim Calculo1 As Double
    Dim Calculo2 As Variant

    Calculo1 = Application.WorksheetFunction.Match(ValorBuscado, VectorBusqueda, 0)

    Calculo2 = Application.WorksheetFunction.Index(VectorDevolucion, Calculo1)

    BUSCAROPT = Calculo2

    End Function

    Les sugiero agregar esta forma de calculo al paquete de funciones para mejorar rendimiento de libros de cálculo.

    Saludos.

    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. Ability to get Excel comment cell reference directly using Office.js

    Is it possible to get Excel comment cell reference directly using Office.js?
    Right now there is no reference regarding the cell the comment is written into.

    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 →
  16. Ability to set author and creation date in Excel comments using Office.js

    Is it possible to set the author and the creation date of an Excel comment as writable using Office.js?

    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 →
  17. Fix Worksheet Protection and Keyboard Arrow Keys

    When you protect a worksheet with a JavaScript function and allow unlocked cells only, you can not move around the cells with your arrow keys on your keyboard if that cell is surrounded by all locked cells. For example, If A1, B2, and A3 were locked, but A2 is unlocked, if you protect the worksheet from JavaScript and select A2, you will not be able to move around to the next unlocked cell using your keyboard arrow keys. If i protect the workbook manually and do the same thing it will allow me to move to the next unlocked cell…

    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. Add ability to create/manipulate Power Query objects from Javascript

    Possible use case: create a new query and modify the M code to connect, transform, and load data from different sources to worksheet or pivot tables. This is achievable in VBA but not in javascript. This function would allow add-ins to use Excel's native data ETL engine.

    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. I hope there is a mechanism to control the issue of line breaks.

    <Control xsi: type = "Button" id = "Contoso.TaskpaneButton">
                       <Label resid = "Contoso.TaskpaneButton.Label" />
                     ...
                     </ Control>
    <bt: String id = "Contoso.TaskpaneButton.Label" DefaultValue = "登录" />

    The Chinese characters in the above example, "登录" will be split into a word on the top, a word on the bottom, I just contacted excel add in, the official website did not introduce how to control the problem of character line breaks, which will cause the Chinese character ui is not friendly, I I hope there is a mechanism to control the issue of line breaks.

    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 →
  20. Add CurrentRegion to the office-js model

    VBA has a CurrentRegion method you can call to get -well- the current region. OfficeJS lacks such a property or method and it would be very useful to have. Excel already has it built-in which is proven as soon as you try to convert a range to a table or insert a chart so it should not be hard to include in the Office-js library.

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

Feedback and Knowledge Base