We would like to have array formula support available in the office.js API. We use these heavily in our VSTO Excel Add-in in combination with user defined functions to display function output in multiple cells. Having this feature available would allow us to build the Excel Office Add-in we would like to build.

For other forum browsers, here is an example of an array formula.
https://www.ablebits.com/office-addins-blog/2015/02/25/array-formulas-functions-excel/#array-formula-intro

Please note that while Binding.setDataAsync() in the office.js API supports adding formulas to a range of cells, you cannot see or edit the formula after adding.

Your translation feature in Excel needs to be much more comprehensive in both terminology included and languages covered. LinguaFin (www.linguafin.com) is the most complete multilingual financial termbase available.

Inside Office.js in Excel 2016 I'd like to be able to call Excel's text to column function from javascript.

According to StackOverflow.com, it appears this feature does not exist yet: https://stackoverflow.com/questions/45448813/office-js-excel-call-text-to-column-excel-function-from-javascript/45466949#45466949

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.

An add-in is not necessary.

What IS NECESSARY is for the Excel Developers to FIX Excel 2013 Professional so that it sorts correctly.

I've reported previously that when sorting colums, Excel does no sort items correctly:

Take for example, :

window.print() does not work to print contents of either a dialogue window or taskpane.

As in VBA : for example :

Range("D2:E8").Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(2), _
Replace:=True, PageBreaks:=False, SummaryBelowData:=True

Would be great if there will be some function, which would be able to make sum/average/count by cell color in Excel. This is very common question from my students and the solution in VBA is too difficult for them. It would be sufficient if there will be color code as text available and then we could just sum etc. by the code.

We are also concerned about the issue mentioned on this post:

http://stackoverflow.com/questions/38847193/excel-office-add-in-api-worksheet-protection-password

Currently we are able to protect and unprotect a worksheet. What we need is an API for password protection of worksheets which the end user would not know as this is will make the worksheets on OneDrive more secure for use.

Add a close button to the tabs or some way to close the tabs by add-in, so that user can end the current session/logout and move for another without mess with previous application.

Thanks
Abhijit

Create an event so that modification in a dialogue window can update the task pane and perform as a single page application to perform two way data-binding as in angular js.

Allow js commands to focus cells for user input
maybe range.focus();
to allow user to write into cell after function has run without having to click the cell.

Hi i am starting to develop Excel Add-in with experience from VBA developing and web developing . Nice to see many APIs are with pretty familiar concept. but now facing the issue of excel crash when launched from Visual studio, (F5 and Cntr+F5). Can't find solution so far. Please help to fix. thanks

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

We have user's who use Android Mobiles and are wanting to access the different SharePoint sites/folders and libraries within the Excel App, but are given very limited access to each of them. However, this is not a problem for Apple devices.

Can something be done to improve the functionality of the excel app for Android users, which can already be seen with Apple devices?

will you test your modifications before giving us the shits

Are you here???
I’m Tiffany McDaniel Foster from Craigslist w4m Post.
Are you free today?
Write back me: tmcdaniel609@gmail.com