Feature Requests and Feedback
-
Enable single sign-on (SSO) for Office Add-ins
The Single Sign-on API is currently supported in office.js preview.
42 votesSingle sign in is now in product/GA! Thanks for your suggestion. Let us know if you encounter any issues by going to https://github.com/OfficeDev/office-js/issues and opening a new issue. Thanks, Microsoft 365 developer platform team.
-
Support for invoking O365 add-ins in shared mailbox context in the new Web Outlook
We have been told that support for add-ins in shared mailboxes will be added to Outlook in Q2/Q3 of 2019. Thus, we have started rolling out support for shared mailboxes in our add-in too.
As part of this, we have noticed that the add-in icons are only rendered in the context of a shared mailbox element if the user is in the old look of Web Outlook.
Since more and more people will be using the new look as default, users should be able to invoke the add-ins via the new look too.
Please add support for rendering the add-in…
58 votesShared Folders support was released as part of 1.8. Check out details here: (Delegate Access)
https://docs.microsoft.com/en-us/office/dev/add-ins/reference/objectmodel/requirement-set-1.8/outlook-requirement-set-1.8 -
Office Add-ins should run in Edge, not IE11
At the moment Word runs Add-ins in IE11
IE11 doesnt support ES2016, and is therefore much harder to develop for than all of the other newer browsers (Safari, Chrome, Edge).
Word should run Add-ins in Edge
353 votesThis is now GA. Please note that has both Office and Windows requirements.
See details here: https://developer.microsoft.com/en-us/office/blogs/microsoft-edge-webview-for-office-add-ins/
-
We need support for itemID in compose mode for Appointments for existing appointments or drafts
This is needed so that we don't have to call saveAsync every time to get itemid (this will trigger Attendee notification dialogs)
88 votes -
Support for shared mailboxes
Office 365 shared mailboxes are very useful. Unfortunately, they do not load outlook web add-ins right now: see http://stackoverflow.com/questions/35059067/make-outlook-add-ins-working-with-office-365-shared-mailboxes/35065215
This would be terrific to have add-ins for such mailboxes especially for all CRMs related apps1,425 votesHello all! We are happy to announce that the feature was GA on Ignite Nov 8th 2019! Its now part of our 1.8 requirement set!
Windows Builds 16.0.12130.20272+ should have support for it.
Mac: November update.
Online: Already on latest.https://docs.microsoft.com/en-us/javascript/api/outlook?view=outlook-js-1.8
-
Add Office Javascript API support for resources of type room in appointments/meetings
Currently, the requiredAttendees methods setAsync and getAsync have serious issues when resources of room type are used. I will add below my review of the three methods exposed on requiredAttendees object (picture in the link):
http://s17.postimg.org/satnvyrz3/RequiredAttendeesCalls_Behavior.png
377 votesHello all! We are happy to announce that the feature was GA on Ignite Nov 8th 2019! Its now part of our 1.8 requirement set!
check our how to use the enhancedLocation object here https://docs.microsoft.com/en-us/outlook/add-ins/get-or-set-the-location-of-an-appointment?view=outlook-js-1.8Windows Builds 16.0.12130.20272+ should have support for it.
Mac: November update.
Online: Already on latest.
docs.microsoft.com/en-us/javascript/api/out.. -
add support in OfficeJS for complex type meeting Location object
Currently OfficeJS only supports simple string type for the meeting Location property, and I would like to be able to access the same complex object type as is exposed in the O365 APIs.
Note that Outlook users can input a resolved address in the meeting form for Location, and O365 APIs already support this complex type for Location (https://msdn.microsoft.com/en-us/office/office365/api/complex-types-for-mail-contacts-calendar#Locationv10)
Vote to update the OfficeJS to support this same Location object.
42 votesWe shipped as part of 1.8 and EnhancedLocation object! please find more info here
https://docs.microsoft.com/en-us/office/dev/add-ins/reference/objectmodel/requirement-set-1.8/outlook-requirement-set-1.8 -
Add ItemSend event (so add-in can cancel email)
Would like to have an ItemSend event in the web API just like the regular API does. Is that on the planning stage for future releases?
451 votesItemSend event was released as part of 1.8.
https://docs.microsoft.com/en-us/javascript/api/outlook?view=outlook-js-1.8
Windows Build: 16.0.12130.20272
Mac: November update
Online: On live version. -
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!
-
Make O365 user identity available in Word Add In
Authenticated O365 users shall not be prompted to login again when they want to use Word Add-In. At the moment any Word Add In secured using O365 directory need to prompt users to enter their credential again despite that they have logged in to O365.
The goal is to provide a better user experience with this single sign on.89 votesSingle sign in is now in product/GA! Thanks for your suggestion. Let us know if you encounter any issues by going to https://github.com/OfficeDev/office-js/issues and opening a new issue. Thanks, Microsoft 365 developer platform team.
-
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 -
5 votes
We support Calendar extension points since long time ago, Give it a try!
-
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 -
Make O365 user identity available in Excel Add In
I need to know the identity of the user who is invoking my Excel-based add-in so that I can rigorously and securely associate various external data access levels with them. It doesn't matter if they are not signed in - the app defaults to a Guest User and can encourage the user to sign into their excel client.
Specifically, I spent the last 2 days picking my way through the wilderness of ADAL and MSAL options and have concluded that I cannot use them within the confines of an Excel task pane app AND provide a satisfactory user experience. This…
4 votesSingle sign in is now in product/GA! Thanks for your suggestion. Let us know if you encounter any issues by going to https://github.com/OfficeDev/office-js/issues and opening a new issue. Thanks, Microsoft 365 developer platform 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
- Don't see your idea?