Feature Requests and Feedback
-
provide an event to let Outlook Add-in respond to a change in the message being written (for example message body, To, Cc and Bcc lists)
As referred to the post:
https://social.msdn.microsoft.com/Forums/office/en-US/720a1bd6-abb9-4f75-863f-1fc33256a629/is-there-an-event-for-when-recipients-change-in-outlook-2013?forum=appsforofficethere is no event JavaScript API an add-in for Outlook could use to react to a change in email message being written (compose mode).
For example if the user adds further To, Cc or Bcc Addresses, it would be advantageous if the add-in could react to it and display relevant data.153 votesThanks for your feedback, Requirement set 1.7 now supports the following events
1. RecurrenceChanged
2. RecipientsChanged
3. AppointmentTimeChangedDocumentation can be viewed here: https://docs.microsoft.com/en-us/javascript/api/office/office.eventtype?view=office-js
-
Add User Defined function support to the Apps for Office Excel APIs
Add User Defined function support to the Apps for Office Excel APIs so that users can enter formulas in excel. User Defined Functions are one of the most powerful features of Excel (and some competitor spreadsheets products now available in the web). They are critical for us to make our Apps for Office product as powerful as our legacy on premise product.
333 votesYes! We announced GA for Custom Functions @ Build 2019. Please give it a try!
http://aka.ms/customfunctions -
Custom properties for Excel Addin
We can read/update custom properties in Word. It would be great if we can have similar function in Excel also.
27 votes -
Worksheet password protection
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.
21 voteswe now support both workbook and sheet pwd protection
chek https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheetprotection?view=office-js#protect-options--password-enjoy!!!
-
API for host information
We need host information for tracking environments and reproducing errors.
The method with requirements checking and the undocumented feature with reading the sessionStorage or querystring are painful as requirements change and undocumented features disappear.Office.js could provide an API for this, as its internally use host information to load custom host scripts.
1 voteThanks for this suggestion! You can obtain host information from the Context object. There’s more information here: https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/context.md
Please take a look and let us know if you have any feedback.Thanks,
Office Extensibility Team -
Allow Officejs to open external excel workbook programatically
There should be a way to open a external excel workbook by providing URL for that file on excel online via officejs. so that user can open a template stored on some other server which contains desired formatting and named-ranges which can be modified on Excel Online
51 votesThis API is now available in production!
Here is a sample snippet
https://gist.github.com/JuaneloJuanelo/399608d6928f6183b474af8f1f7e1c8aKey instruction: Excel.createWorkbook(mybase64);
please enjoy!!!
-
Implement Conditional Formatting Editing
The ability to edit conditional formatting in OfficeJS Excel API.
21 votesWe shipped this as part of 1.6. Extensive support for conditional formatting.
check https://docs.microsoft.com/en-us/javascript/api/excel/excel.range?view=office-js#conditionalformats
-
Excel - Add CopyWorksheet
We have a need to repeat the same formatted Worksheet over and over based on selections made by the user. It would be great to setup a template so that same worksheet can be copied. The worksheet has all formatting including printing stuff in place already. Be great to just be able to copy that and fill in the data.
44 votesThis is now available in the API! check
https://docs.microsoft.com/en-us/javascript/api/excel/excel.worksheet?view=office-js#copy-positiontype--relativeto-we also have in preview inserting sheets from other workbooks, please check this sample (remember is PREVIEW)
https://gist.github.com/jipyua/caec8eb5fddc0f611c43a1dbb356fa2a -
Expose Workbook events via Excel JavaScript API
Similar to Document.SelectionChanged event, the following Workbook-level events would be useful to have exposed via the JavaScript API (in no particular order):
Activate,Deactivate
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetActivate,SheetDeactivate
SheetBeforeDoubleClick
SheetBeforeRightClick
SheetChange
SheetSelectionChange154 votesGlad to report that Many of the events asked here are GA!
please check this pageto see details;
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-eventsWe are still to provide (other are in, please try them!)
BeforeSave,AfterSave
BeforeClose
Shutdown
SheetBeforeDoubleClick
SheetBeforeRightClickthanks!
-
Add a method to copy a sheet with all data and formatting because there are no back-up or undo options for add-ins.
Since there is no way to cancel the changes made by an add-in, we need to provide users with backup options.
The current version of JavaScript API for Excel doesn't have a method for copying a sheet with its data and formatting, there are no elegant and fast workarounds available.
Could you please let us know if it's possible to add this method to JavaScript API for Excel?
114 votesnow we have this API please use it!
here the details: https://github.com/OfficeDev/office-js-docs/blob/ExcelJs_OpenSpec/reference/excel/worksheet.md#copypositiontype-worksheetpositiontype-relativeto-worksheetworksheetObject.copy(positionType, relativeTo);
Copy a worksheet and place it at the specified position. Return the copied worksheet.
Enjoy!
-
Allow Office Add-in in Excel to configure a cell so that user chooses value from a list of values
Enhance the Office JavaScript APIs (for Excel 2016+) to expose a mechanism (perhaps a Validation relationship or property) that allows the developer to configure a cell so that the end-user selects the value for the cell by picking from a list of values. The list of values might be specified by some other range. In a VSTO add-in (and native Excel) this can be achieved by configuring the Data Validation properties on a cell/range.
37 votesthis was shipped as part of our Data Validation feature! please try it!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.listdatavalidation?view=office-js -
Provide access to CustomXMLParts for Excel via JS APIs
It will be good to have access to CustomXmlParts for Excel via JS APIs. Currently it supported only by Word. It allows developers to provide coolest plug-ins for Excel 365.
18 votesThis is shipped as part of 1.5!
https://docs.microsoft.com/en-us/javascript/api/excel/excel.workbook?view=office-js#customxmlparts
Enjoy!!!
-
Method for determing which Office Application an Add-In is running in
Currently, an Add-In can be setup to be runnable in Excel, Word, PowerPoint, etc...
There are certain API features that are available to some of the Office Applications but not others; In addition, the availability of these features differ based on platform (fat clients, web, ipad, etc...). As such, we may choose to use TableData for an Add-In that is loaded in Excel, but HTML for the same Add-In loaded in Word.
Right now, we use the context.document.url property to determine the application, looking for the ",xls" extension in it.It's not a complete solution but it is getting us by…
17 votesHi Paul, thank you for the suggestion. This information is already available on the API. There’s more information in the documentation at: https://github.com/OfficeDev/office-js-docs/blob/master/reference/shared/context.md
Thanks,
Office Extensibility Team -
Add Abitility to create pivot Table via Office Javascript API
In the current version of the office javascript api I can see that the setSelectedDataAsync method allow only inserting text, matrix and table into excel spreadsheet.
I would like to see the javascript api enhanced and allow inserting pivot Table also. In this way I can use pivot Table helpers (such as slicer, fields list ....) and also refresh pivot table programmatically.
87 votesRecently GA as part of the 1.9 requirement set announced at Build!
-
Provide a feature which enable access to custom properties exists in the doc/workbook
Can you please provide a feature which enable access to custom properties exists in the doc/workbook ?,This will helps to make use of existing custom properties and will fill up the gap between OfficeJs and VSTO
18 votesThis feature is already supported in Word and Excel .
Please give it a try!!
https://docs.microsoft.com/en-us/javascript/api/excel_release/excel.customproperty?view=office-jshere is an example on how to use it in Word
async function insertNumericProperty() {
await context.sync(); console.log(“Property added”); });
await Word.run(async (context) => {
context.document.properties.customProperties.add(“Numeric Property”, 1234);}
async function insertStringProperty() {
await context.sync(); console.log(“Property added”); });
await Word.run(async (context) => {
context.document.properties.customProperties.add(“String Property”, “Hello World!”);}
async function readCustomDocumentProperties() {
await context.sync(); for (var i = 0; i < properties.items.length; i++) console.log( “Property Name:” + properties.items[i].key + “; Type=” + properties.items[i].type + “; Property Value=” + properties.items[i].value ); });
await Word.run(async (context) => {
let properties = context.document.properties.customProperties;
properties.load(“key,type,value”);}
-
Publish an official and up-to-date NuGet package for Exchange Web Services Managed API
NuGet is the quickest, easiest and best way to manage library dependencies. There are currently older published versions on NuGet with several /thousand/ downloads each that are not published by Microsoft. Please support the platform and provide us with official bits!
5 votesThanks for sharing this feedback. We have published the latest version of Exchange Web Services Managed API (2.2.1.1) via NuGet on 5/1/2018. Do give it a try. https://www.nuget.org/packages/Exchange.WebServices.Managed.Api/
Apologies for not updating this uservoice request, we are still doing some house cleaning as growing team.
- Don't see your idea?