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.

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.

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

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!

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.

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

for example, after creation of a textbox shape have part of the text be subscript

e.g. I have a range A1:E7, Series of data are in columns, I want to plot A1:A7 as x against C1:C7, and E1:E7
Right now I have to copy data to another sheet so that the range is contiguous (new range = A1:C7) every time I want to draw a chart from the original data.
With large tables this seems a waste of time especially when I can just manually select multiple separate ranges in excel for an xy plot.

In Excel.ChartFill class we have a method to set the color of the chart point namely setSolidColor(color). Similarly can we have a method to retrieve or get the color of the chart point.

We have some images in format like EMF and WMF. How to insert such pictures/shapes in Excel worksheet. As addImage only takes base64 string.

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

Currently, the dynamic array returned from a custom function can be displayed only on calling cell and can be spilled towards right/bottom.

Provide a option to display the dynamic array by offsetting the starting cell similar to excel getOffsetRange(rowOffset: number, columnOffset: number)

For example : custom formula insert in B5 cell, and i need to display the below array starting from A5 instead of starting it from B5 cell.

Dynamic array =["Apple","Orange","Banana"]

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

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