We have a requirement to load a workbook from a remote source from within the add-in. User logs in, selects from a list and workbook template loads.

With the Word JS API we can load a template remotely using an AJAX call that returns the workbook as a base64 string and then insert the response into the current workbook using the replace option. AFAIK this doesn't exist for the Excel API and we download the workbook and then instruct the user to open from the download pane.

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.

You can try to run this code and check the Undo/Redo stack:
Excel.run(function (ctx) {
return ctx.sync();
});

Allow Excel Javascript API to check for merge cells. Currently it can only merge/unmerge cells but can not check the cell status.

It would be extremely helpful in certain cases to prevent user to interact with the sheet/workbook while some action in the task pane is required or when some process is running (e.g. when some complex sheet changes are being performed - formatting, inserting columns, inserting data, charts....).

Add a getData() method to the chart object to get the worksheet range sourceData and seriesBy information of a chart.

Debugging on Mac is a pain.. The built-in safari tools are buggy and laggy. The only useful feature of volron.js is displaying console.log's.
I want a normal developer experience on Mac!

I'd like to be able to access the username listed under Account -> User Information in my add-in in Microsoft Office Excel 2016.

Besides being able to customize the add-in experience and address the user by first name, having the full name would allow me to look up internal users and perform more advance functions like looking up permissions or recording their userId along with actions they perform.

Function/ability to trace precedents and dependents with the office.js API (similar to GetPrecedents in VBA).

The current BindingDataChangedEventArgs object passed to the event handler for the Binding.BindingDataChanged event only contains properties for the binding that raised the event and the type of event. There is no specific information about what cells, columns, or rows in the table object were changed. When dealing with tables with many rows and columns and/or end-user gestures that edit/insert/delete many cells/rows/columns at once, this API is not very useful. Contrast this to the (Excel) COM APIs where, at least, the SheetChanged event provides a Range object that describes what was changed.

The enhanced Excel-specific APIs available for developing Office Add-ins that run with Excel 2016 are a nice start. There are some key missing APIs. One area in need of extending is eventing. For workbooks that contain multiple worksheets, it is critical for the Add-in to be able to determine when a worksheet is activated/deactivated so that the Add-in's UI can adapt accordingly. Similarly, the Office Add-in should be able to hook an event so that when the workbook gets closed/shut down (and maybe Saved), the Add-in can persist in-memory state into the workbook.

I generate tables for the corresponding styles based on the data in the sheet. I want to print them out.

I tried to find the api in the document,but I did not find it.

Türkiye Grafiği için Batman-Siirt illeri karışmakta.
Bolu ile düzce illeri karışmaktadır. Sorunun çözümü halinde daha aktif olarak kullanılabileceklerdir.

It's a big user interface improvement if a user and can and drop cells and data between the task pane and Excel. I found a way to get this functionality working in the Excel 2016 desktop client (and it's wonderful!) but as far as I can tell, there's no way to do it in the browser-based client. This means that I have to detect whether or not Excel is 'win32' or 'web' and then use an equivalent but much less intuitive menu-based interface for the 'web' case.

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!

Excelde oluşturulan dağılım grafiğinde dikey ve yatay çizgiler oluşturulamamakta.
Ayrıca yine aynı grafik türünde nokta ismine etiketin isimlendirilememesi hatası mevcuttur.
Powerbi de bu sorun yok ancak excelde mevcut.