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?

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).

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.

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

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.

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

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.

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

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

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

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.

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

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?

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.

microsoft excel ma common cell find and copy

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

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

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

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.

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