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.

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!

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.

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 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?

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

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

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?

Excel Online doesnt allow any edits on the PivotTable data value.
We have a use case where the user can edit the pivottable and in the onchange event we run the custom code to update the source and do other calculations and then refresh the pivottable so that the changes are persistent on the Pivottable.

This works fine in desktop Excel but not in Online Excel since edibility is not supported on it.

Currently we can add buttons to Cell Menu only in excel. since PivotTable is widely used it would make sense to add support for PivotTable Context Menu as well.

Provide a context menu option for Excel Tables. Currently they are only visible on normal cells. As soon as I create a table, the custom context menu that I created disappears.

Is there a way of expanding existing Excel Range in js /react? i have been trying to do this but no luck. The first data i loaded consisted of 3 rows and i wrapped that with range. then i loaded another data with 6 rows the Range didn't expand to accommodate the second data size.

Excel officejs should support Table event listener for User input events only.

The current event listenrer is triggered by both background update and user input which is not ideal.

Details could be found https://github.com/OfficeDev/office-js/issues/1122