See StackOverflow post explaining the issue. Setting an array formula like this is not working: let sheet = context.workbook.worksheets.getActiveWorksheet(); 1 let range = sheet.getRange("A31") range.formulas = [["{=INDEX(Data!$A$2:$A$35;MATCH(0;COUNTIF(A$1:$A9;Data!$A$2:$A$35);0))}"]] await context.sync(); ... View more

Currently, it is not possible to pass a formula to the Office API and receive an evaluation of it. There are workarounds, like writing to an empty cell, or writing to a  scoped name. Both solutions are not directly pretty.   Ideal API:   // ... await Excel.run(async (context) => { let sheet = context.workbook.worksheets.getActiveWorksheet(); const evaluatedFormula = await sheet.evaluateFormula(`=SUM(A1:A5,Sheet2!B1:B5)`) // best possible return value /* { "value": 165, "type": number, "cells_included_in_calculation": ["Sheet1!A1:A5","Sheet2!B1:B5"], "precedents": ["Sheet1!A1:A5","Sheet2!B1:B5"] // can deviate from cells included, in case of formulas like SUMIF / SUMIFS / COUNTIF / COUNTIFS / INDEX / ... } => in case of an error, it could simply return one */ } // ...     ... View more

I would like to see the event times in my timezone in Outlook Calendar all the time regardless of the timezone used when event was created.   For example:  Event is created with UTC timezone but my timezone is UTC+2 (this can happen when using different integrations or calendar syncs which create events for me in my calendar)   Current behavior: Open Outlook Calendar - event times in UTC+2 Click on the event and a little popup is shown - event times in UTC+2 Click edit and the short form for editing is displayed - event times in UTC+2 Click on more options and the full form is displayed - event times in UTC     ... View more

Our clients often need to download formidable spilling ranges from their ERP systems in a single custom function call.    The minimal repro repository mentioned in this bug:  https://github.com/OfficeDev/office-js/issues/2786  emulates the GI() function in Velixo add-in.   It's one of our most popular functions in our legacy XLL product and a big selling point for our company. It routinely returns dozens of thousands of rows which the customer pivots, sorts, filters, and aggregates in Excel.   It needs to work in exactly the same way across the legacy/new office.js based product, otherwise we simply can't promote migration to the new cross platform solution.   There is no workaround to the problem which makes it so urgent and painful: we need backwards compatibility with our old product so it needs to remain a single custom function call. As per MSFT in the GitHub issue, there is no addin <-> host request batching within function calls, only across multiple different function calls.   IMO the best solution to this would be to abstract away any payload size limit for CF return values from the add-in developers — and automatically batch those requests in chunks.   ... View more

Currently Word and Excel Office JS API's support reading and writing custom XML. Add custom XML support also for PPT. ... View more

Hello!   These are two features which we are extremely interested in. I've been asking in many Community Calls but I haven't had any ETAs yet, so hopefully posting here helps.   Please could we have a consistent method for Word, Excel and PowerPoint to save a file? Word and Excel have ‘context.document.save()’ and ‘context.workbook.save() but they lack similar options for behaviors (eg. skip the save dialogue). PowerPoint does not have context.presentation.save() yet. Please could we have an equivalent method for all three (Word, Excel, PowerPoint) with similar options/behaviors? This is really needed for developers. Please an ETA would be appreciated.   Similar to the previous question, could we have an equivalent method for all three (Word, Excel, PowerPoint) to close files with similar options/behaviors? This is also really needed for developers. Please an ETA would be appreciated.   Thank you so much in advance! ... View more

Currently only rich text content controls are available through Word API ( https://docs.microsoft.com/en-us/javascript/api/word/word.contentcontrol?view=word-js-preview#word-word-contentcontrol-type-member) Could you please add also other types of content control?  In particular in my company we need DropDown and CheckBox. ... View more

At the moment, SSO implementation using OfficeRuntime.Auth.getAccessToken() is supporting only for OWA, Desktop and macOs. We are facing lot of issues when Addins are supported for mobile platforms and use SSO as authorization process.  we are having different auth code flow implementation for mobile devices but when come to Intune management , we are facing a problem because of Device ID claim is not in access token. ... View more

The Office.context.document.getFileAsync-API already supports PDF export. Unfortunately, the file format is PDF 1.8 whereas we need a PDF/A compatible export. It is possible to specify PDF/A when saving the PDF manually through the "Options" dialog in the Office application. Unfortunately, there is no (documented) way to specify the type of PDF in the getFileAsync-API. It would be great, if the API is expanded so that PDF/A compatibility can be requested as well (either with a new file format flag or as an option in the optional GetFileOptions-object). ... View more

We'd like to see better note-taking and annotation tools across all apps on the iOS platform, but also better integration with Windows, Android, and macOS. Many enterprise customers use various tools like Adobe Acrobat, PDFExpert, GoodNotes, Notability, etc. for their workflows. Usually, these tools are used as annotation tools due to their very basic functionality in OneDrive, SharePoint and Office products. For simplicity, we will "only" deal with the iOS platform in the following. When using annotation tools in an enterprise context, companies usually need a way to prevent data loss. Unfortunately, very few vendors offer AppConfigs or Intune SDK-enabled apps. Therefore, it would be even better if Microsoft already offered appropriate options in the apps for the platform. Best case, a consistent experience, regardless of platform. For the user it would then be a seamless process and for ITSec no further action would be needed on the app side once M365 has been approved (and for iOS/Android MAM/APP has been enabled). Let's take a look at a typical, everyday process: - Documents that need to be signed, approved, or commented on are converted to PDFs or already exist as PDFs - They are uploaded to OneDrive, giving the employee or approving colleague/supervisor access to the documents - Annotations are made using iPads (with 2nd generation iPads Pro and Apple Pencils). - Everything is stored on OneDrive - In the past, an app was set up for this, but the annotation features were pretty frustrating there too, and it was an enterprise app, so it was always pretty much work to keep it running (and make it cool and secure) Well, to improve the situation, here's what we've found out so far and suggest: - Some time ago there was a Microsoft blog post, for better integration of Apple Files and Microsoft OneDrive / SharePoint. Apple said they haven't changed anything, but Microsoft said they are working on a new implementation for iOS 15 that affects Apple Files and OneDrive. iOS 16 came out - and it's still the case that the OneDrive content is visible, but not writable and sometimes the Files app says "read only mode" at the bottom (but rather rarely) - Inside files we can't open, read or interact with files from OneDrive, but we still see all content - Inside OneDrive, a PDF is always opened with the PDF viewer inside OneDrive, same with the Office app - resulting in an eraser, three silly pens (not worth calling pens) and a highlighter - In Office, if you open another app for Office content like Excel, Word, or PowerPoint, there's already the drawing tool, which offers some cool and usable pens - In PDFExpert or similar apps, the tools are "ok", but there is also a dynamic feature that gives a more natural writing feel (still not cool, but nicer) - In the Apple Files app, Notes app, or whatever, Apple's note pens come into play (available as Apple PencilKit as an SDK)-the coolest, the best, and the ones that no one ever has to learn how to use because they just work naturally, like we learned to do as kids  Having established the necessary context, let's conclude with three questions: - How can we solve the problem with Apple Files and View and Annotate? - How can we ensure that pens from the Office suite get into the OneDrive PDF view for a better annotation experience? - What can we do to consolidate pen capabilities across Apple and Microsoft? Again, at best, a consistent experience regardless of platform.  ... View more

Similar to  "MobileMessageReadCommandSurface", we would like to get support for "MobileMessageComposeCommandSurface" for bringing the functionalities of the Add-in to compose window in Mobile(iOS/Android) Outlook. ... View more

Hi there, Please add functionality to get/set the "Link To Previous" to header/footer sections I see that it is possible in Office VBA Add-in but not in Office.js see link: https://docs.microsoft.com/en-us/office/vba/api/Word.HeaderFooter.LinkToPrevious Thanks! ... View more

Background I recently posted two questions to Stack Overflow: Outlook Add-In: how to automatically reply based on custom logic? Outlook Add-In: how to simulate automatic reply with external service? In brief, I am trying to find a way to send an automatic reply to an email based on custom logic, e.g. whether the sender is verified according to an external service. (The automatic reply feature native to Outlook is extremely limited.)   The Oulook Add-Ins team answered that this is not currently possible because web add-ins require the context of an item to run. So, a user would need to manually select a message before the add-in could do anything.   Another Stack Overflow user answered that this is currently possible but with VSTO add-ins only. Unfortunately, VSTO is a very old framework and only works with Windows and desktop Outlook, while modern users often use web Outlook on other platforms.   Request: Allow Add-Ins to Run Without Item Context Therefore, I request that Outlook add-ins be allowed to run without item context, so they can take action without the user manually selecting an item. This would allow me to build such an automatic reply feature.   Of course, it will be important to tightly scope what the add-in can do without item context and make users aware of what they're agreeing to by installing such an add-in. But this is entirely achievable, and users would very much benefit from an add-in that can do more for them.   -----   I'm currently unable to make any progress on my automatic replies feature, so please consider implementing this soon! Thank you. ... View more

I want to add field codes using word JavaScript API. I checked the API documentation but I found nothing regarding this. It would be great, if there a possible way to do this through the API. ... View more

I need to have an office.js add-in create an Excel workbook from the bytes of a workbook that has been encrypted with a password that must remain unknown to the user.      I can create a workbook using: Excel.createWorkbook(base64)  However, this prompts the user to enter the password.  I'd like to be able to specify the password in the code so the workbook gets created without prompting the user to enter it. ... View more

In Outlook, one of the obvious use cases for an add-in is to take data from an email and put it in another application. It is then helpful for an add-in to provide an option to continue working in the other application where that data was sent.    On Windows, Mac and Web, add-ins are able to open a browser window to a URL where that data was created in the other application.   On Android and iOS, add-ins can not open a URL in the user's browser. OpenBrowserWindowApi is not supported and window.open creates another dialog within the Outlook app.   This should be a pretty simple addition to the Outlook Android and iOS apps, exposed to the add-in web view via OpenBrowserWindowApi. Example Android code: https://stackoverflow.com/a/2201999/4853706 ... View more

It is a simple feature, and it might look like a minor issue, but I believe it is an important way of improving clarity, diversity & inclusion.    In a global economy, we constantly work and communicate with people from other cultures and countries. With that, some names might be difficult to type for people who are not used to their orthography. Even though it is an unintentional mistake, some people might feel not included if they have their names constantly misspelled in emails.    So, my request is that Outlook "validates" the people names on the body of emails against the people listed on the TO/CC lines. If it encounters a name that seems to be misspelled (e.g.: Alexander vs. Alexandre), it could underline it in blue, so the user can identify a possible mistake and correct it.    Besides eliminating confusion caused by the typo, it would make the receiver feel more included by being referenced by their correct name.    ... View more

Hello! In the current version, we can get selected data in PowerPoint/Excel/Word using `Office.context.document.getSelectedDataAsync`. However, this method can only work for some specific types of data such as `Office.CoercionType`. In PowerPoint, `ShapeType` is a very important kind of data, I want to modify some selected shapes in slides. Maybe I missed some methods to get the selected shapes in PowerPoint, I would be appreciated if you have any ideas about that. I believe this is also really needed for developers. Thank you so much in advance!   ... View more

Currently the internetHeaders property is available only for the compose mode of messages in Outlook. See Get and set internet headers on a message in an Outlook add-in for more information.   But the compose mode of appointments don't provide such properties, specifically, the Office.AppointmentCompose  interface doesn't have the `internetHeaders` property defined.   As a result, there is no way to add custom internet headers to the meeting requests sent to attendees. ... View more