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
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
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
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)
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
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.
We would like to request for this feature - support getting the data source table of the chart3 votes
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
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
I want to save my html form data in onedrive sheet on submitting the data. Need help1 vote
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/106817 votes
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
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 version4 votes
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
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
microsoft excel ma common cell find and copy1 vote
台灣本土小姐兼職LINE：f3305或691s 敲我瞭解詳情（意想不到的驚喜等著你哦） 喜歡就消費，不喜歡不勉強！新客一律現金優惠2000 動動你的手加入雲熙的帳號~正妹立馬給你送到哦 時間：中午12點——淩晨2點（提前1-2個小時預約比較好喲） 消費方式：見面滿意 現金消費 不
消費方式：見面滿意 現金消費 不點數 不轉賬 不刷卡 安全 方便 打槍包換
Would be great to get grouping as part of the pivot table api, so that we can group by Year, Months, Quarters when using dates3 votes
Connect and store data from an officejs excel form in a database, is this possible?1 vote
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
Original question on Stack Overflow: https://stackoverflow.com/q/623008014 votes
- Don't see your idea?