When working on Excel Add-In, specifically with Data Validation lists, is it possible to retrieve the source of the list?

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.

I want to develop an iOS app with xcode. I need to use Excel-related functions. How should I do it?

Like inserting shapes in a worksheet it would be useful to insert pictures in a range/cell. The range/cell acts as an anchor.

Our Add-in deals dynamic server address so we need to update the manifest frequently. The only way to update the Add-in cache is to refresh and insert again, is it possible to do it in automation?

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!

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.

Text style editing capabilities are super non-uniform through the API. If you let us use things like strikethrough for Excel.RangeFont, why would you not provide it for shapes too?

Positioning a shape using javascript is very tedious and most often than not, I find myself wanting to position a shape at a very specific position. Being able to attach a shape to cell using something like shape.attachToCell(row, col) could position the shape's top left corner (regardless of the current worksheet's resolution) to the top left corner of the given cell coordinate.

Ex: I want to place a shape and align it the cell A5, I could call shape.attachToCell(0,4); which would make the shape's top left corner "snap" to the left top corner of the cell A5.

Since range.left returns different values depending on the amount of Zoom your worksheet is, we should be able to edit the zoom or at least know the amount of zoom so we can take the changing position values into consideration.

Can you expose the comments/notes feature in the excel-js api. I am interested in developing an add-in that depends on comments/notes. I noticed that there are other developers who are also interested in add-ins that need access to comments/notes. Following is a stackoverflow thread about it:

https://stackoverflow.com/questions/44019257/excel-javascript-api-set-note-to-cell

I work for a large company. We receive requests for proposals in Excel and need to respond in Excel. We need to be able to track our editor's changes in Excel. Currently we can only track changes in Word but that is not the format that consultants use. We have to copy from Excel to Word for editing, then back to Excel to finalized. This is wasting a lot of time. Please add track changes to Excel so that it works the same as Word.

This would allow the ability to have the menu system outside of the content add-in. In addition would provide the ability to seamlessly bring in other charting libraries for more complicated live charting of financial data.

Currently, you can use the PivotTable object and it's associated collections to create, edit, delete PivotTables. But currently, this relies on using Excel itself for the aggregation.

It would be nice to instead be able to manually manipulate the PivotTable object and define hooks for expanding Hierarchies to perform custom aggregation.

This would be useful for using analysis servers which aren't 100% XMLA compliant as well as any other services that want to perform some kind of aggregation on data not available in the worksheet.

In VB, i can use Union method to Union Multiple range when when they meet the conditions.but in API-js i canot select multiple areas
example: sheet.getRanges("A1:A5,B1:F1").select();

Currently the web socket implementation for desktop version of Excel (Version 16.0.11601.20130 32 Bit) is not correct. The property bufferedAmount is not implemented in this version. Further messages are lost, if “send” on the WebSocket is called frequently directly from a custom function. It seems as if the SDXPlatformBundle_foundation.js has some bugs.
In office online the problem does not exist. Please make desktop version behave like online version of Excel with a complete implementation of WebSockets.

The new Convert to Stocks under Data/Data Types has been extremely helpful. One metric I would like to have added to the Field list is Trailing Twelve Month (TTM) Dividend Yield. This is a common metric in investments, one that I would think your data source already has available.