Feedback by UserVoice

Feature Requests and Feedback

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. Add support for calculated fields in a Pivot Table

    I cannot find a way to add calculated fields to a PivotTable in Office JS.
    In VBA there was CalculatedFields where we can add value fields with excel formula expression.

    Is it not supported, if yes then is it their in the to do list and when can we expect to have it?

    7 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. Inserting OMML formulas into Excel sheet via office.js

    0

    I would like to add mathematical formulas (not Excel equations) of OMML type into an Excel sheet via office.js. I know you can add them manually by using "Insert" / "Equation" ("Equation" just below "Symbol"), which results in an OMML formula (an <m:oMath> element in the Excel sheet XML source).

    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. Pivot Table: Direct Data Loading

    In VBA you can query a database and directly load result set to the Pivot Table “cache”. This allows for quick data refreshing since you bypass writing the data to excel and then refreshing the pivot tables.

    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. Excel.createWorkbook(base64) API to support Workbook name and other attributes

    We see a very common requirement that when you create a new workbook from a stream or create a copy of current workbook, that the new workbook to carry a name based on the current context. We have a very specific requirement on this and I posted in the StackOverflow (refer below link)
    https://stackoverflow.com/questions/64822043/creating-a-workbook-with-a-custom-name-using-excel-createworkbookbase64

    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 →
  5. 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 →
  6. Support getting the data source table of the chart

    The current OfficeJS API is not supporting getting data source of the created chart object in excel. Right now, when we try to get the data from the chart, we could get data points but we could not reserve the real data and it's format.

    So, in this case, if you create a chart then get data from chart and draw it back you will see different data.
    Reference:https://stackoverflow.com/questions/62423384/is-there-any-way-to-get-number-format-of-chartpoint-using-officejs/63465765#63465765

    We would like to request for this feature - support getting the data source table of the chart

    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 →
  7. Table.ColumnCollection.add() Allow multiple columns at once.

    Table.RowCollection.add() allows you to insert multiple rows in the same method call, but with columns that's not the case.

    Currently, my workaround is to use a simple for loop to iterate over multiple calls of Table.ColumnCollection.add(), which I believe has a negative impact on performance.

    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. Please update boilerplate yo office for Excel TypeScript + React

    Dear,
    the yo office template generator for office (React + typescript) is hopelessly outdated. Please update it with functional components and latest versions of packages.

    1 vote
    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. I want to save my html form data in onedrive sheet on submitting the data

    I want to save my html form data in onedrive sheet on submitting the data. Need help

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

    17 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. 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 →
  12. add a visible non-visible property to all add-ins

    There should be a property which tells if the taskpane add-in is currently visible on the screen, and also an event for any change in this property. I know there is the document.visibilty property but it is not reliable especially in the desktop version

    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 →
  13. platform in manifest file

    Is it possible to specify Platform along with Hosts in manifest file ? Any workaround to show the addin only for Web client not for thick client?

    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. pass parameters from the command line into Office.initialize.

    Currently we launch the Addin (saved workbook) on desktop by running excel.exe via the command prompt as we have to pass some parameters to the addin.

    But I cant find any way to read these command line arguments in the addins Office.initialize.

    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 →
  15. microsoft excel ma common cell find and copy

    microsoft excel ma common cell find and copy

    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. 台灣本土小姐兼職LINE:f3305或691s 敲我瞭解詳情(意想不到的驚喜等著你哦) 喜歡就消費,不喜歡不勉強!新客一律現金優惠2000 動動你的手加入雲熙的帳號~正妹立馬給你送到哦 時間:中午12點——淩晨2點(提前1-2個小時預約比較好喲) 消費方式:見面滿意 現金消費 不

    台灣本土小姐兼職LINE:f3305或691s
    敲我瞭解詳情(意想不到的驚喜等著你哦)
    喜歡就消費,不喜歡不勉強!新客一律現金優惠2000
    動動你的手加入雲熙的帳號~正妹立馬給你送到哦
    時間:中午12點——淩晨2點(提前1-2個小時預約比較好喲)
    消費方式:見面滿意 現金消費 不點數 不轉賬 不刷卡 安全 方便 打槍包換
    外約地點:旅館/飯店/住家/外約
    外送茶服務:全套服務應有盡有唷!
    精心挑選全臺各行各業最優質MM
    在累的時候來喝一杯好茶 讓自己的弟弟快樂
    讓自己的心理的需求得到滿足

    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. Extend pivot api to include grouping. Helpful when using dates in a pivot table.

    Would be great to get grouping as part of the pivot table api, so that we can group by Year, Months, Quarters when using dates

    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 →
  18. Connect and store data from an officejs excel form in a database, is this possible?

    Connect and store data from an officejs excel form in a database, is this possible?

    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 →
  19. How to get address (Range object) of topLeftCell of selected shape in Excel, using Office JS APIs ?

    When we select any shape then we have a property topLeftCell of a shape in Excel VBA which returns a Range object and we can get address of that particular range object. How can we get similar one using OfficeJS APIs for Excel.

    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. Add ability to resize a table via the JavaScript API

    Feature request: add a way to resize a table through the JavaScript API equivalent to what can be done by a user by dragging the table’s “sizing handle” (or in VBA through “ListObject.resize”); that is, resize the table without inserting (or removing) cells in the worksheet.

    Original question on Stack Overflow: https://stackoverflow.com/q/62300801

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

Feedback and Knowledge Base