Office Add Ins community call-April 2019

Key Takeaways

morning everyone thanks for joining us for the April office add-ins community call so a few notes about the call as we get started here first of all if you don't already have the recurring meeting invite for this call you can download it using the link above Doug's on the call here today joining us remotely he'll be pasting links into the chat window so any of the link so when the slides feel free to grab those out of the chat window the next call after today will be next month May 8th the first second Wednesday of the month as usual and for those of you who haven't joined us today the office add-ins calls are simply a chance for you to meet some of the members of the product team that are behind the office add-ins ap is in platform and to learn a little bit about what's new what's coming soon we typically try to cover a variety of topics on each call and do at least one deep dive or kind of go deeper on one topic per call and then it's also a chance for you to connect with us directly for QA so we publish a forum ahead of time I'll be showing that link later where you can submit your questions ahead of time or you can submit your questions here feel free to type them in the chat window and we'll address them either as they come up or at the end of each section or at the end of the call or alternatively whatever we don't get to we always cover in the blog post that we use that we published to recap the call all right so today we're gonna start with an office add-ins overview from Doug as we normally do for those of you who may be new to office add-ins office web ad ends we have Raymond Liu joining us from the Excel team in China to talk about what's new and what's coming soon with the excel JavaScript API s we have Sudhir here to touch base and give us an update on the edge web view control that's coming soon I know Sudhir has been here a couple of times but it's important information especially for those of you haven't heard it before so we're gonna just do a quick recap and kind of give you those of you who have heard it before an update on where we're at care will join us to talk about a new feature that's coming soon to com2 web add-in mappings you'll hear more about that shortly and then build is right around the corner next month so Doug will be talking about that and in giving us nothing on what's coming with build if we have time at the end we'll do some Q&A so here's just a quick look at the presenters I'm cam Brandel I'm a senior dev writer on the office platform p.m. team and my colleague Doug is also on my team Ramon's with the Excel team in China working on the Excel JavaScript API s sudhir and K are both senior program managers on the office platform PM team hey Doug would you be able to start presenting and just show you show your slides yeah do that so I am having trouble with my sharing this morning I'm going to do as we always do at the beginning of this call we give a quick overview of what office add-ins are because we want this call call to be useful to those who are brand new to the platform as well those you who know it quite well so an office add in a current generation office at Ian's is a website with a manifest file that tells Office where that website is so that's just in real simple terms what it is at a high level that manifest file the way you get that file that makes it an add-in is with our yo office command-line tool and I'll be giving you a link to the documentation we can get that so the old-style add-ins were comm code that only ran in Windows and so on the big benefit of the new approach is it'll run anywhere office runs so you can create an add-in that will work on the Windows desktop Mac desktop in the browser iOS and Android and so on and then you can publish that Adium to the office store and the way you do that in in simple terms is you're just uploading that manifest file to the store and one of the other benefits of the new approach is once you've stood up your ad in this way let's say you find a bug you need to fix or you want to roll out a new feature all you do is update your website you don't have to go back to the store and republish anything and that manifest is pointing to your end point that suddenly has the new functionality or the fix so it's a lot more agile and also completely cross-platform so the things you can do in your add-in because it's just a website you can call any web api that you need to use you can get at Microsoft graph and then the thing that we talk about mostly on this call is the office j/s API that lets you get at the content within the documents so you can get it for example read and write content and an Excel spreadsheet or Word document and you can do a variety of things there without look you can have it a diem that is for when you're creating a message or an add-in that runs in the Outlook UI separate from the individual message bunch of flexibility there if you want to learn more about all this I'll paste that in the chat window in a minute but here's where we have all the comprehensive documentation reference documentation overviews quick starts and so on a quick aside here for folks I went through every one of our quick starts here a couple weeks ago is kind of a little exercise and that was kind of interesting to go through all of them and we're gonna polish up a few things based on that but but I was kind of pleased to find they all work right now so we have we have 14 quick starts five of them for Excel because excels where we've made the biggest investment in the api's as you'll see when we talk about the accelerate guys little later so that's kind of a high-level overview of what the modern generation office add-ins are all about great thanks Doug yes if he could keep showing the slides I'll let you drive from here on out so we have we have Raymond Lou Raymond are you on the line with us here today hello can you hear me oh sure Stan thanks Raymond so Raymond is joining us from China to talk about what's new with the excel JavaScript API is and what's coming soon so go ahead Raymond okay thanks everyone for participating the MIT community call my name is Raymond and I'm program manager of excel JavaScript API team and I'm honored to join this call from China and my team is located in China Beijing China the team started in journey in five years ago we build an excel javascript empower of partners and our excel developer to Butte they're adding in a solution to enable their customer to do more on a Excel platform so as you can see the starting at 1.6 we are celebrate our progress release more and more API you can see the curve is getting steeper after May 2017 so in next month's in the build we will release 1.9 there will be more than 500 API in this release so after 1.9 release the total number of API is almost 1900 you can see the API details from this link and we are still kept investing and building more and more API to enable our partners achieve more and more comfortable a complicated scenario so today I'm gonna share some avi that is now I mean working in progress we were happy to get your feedback in early stage so today the three API we're gonna share is all about events so we have on click on single click events on Road hide in change events and also row sort events so the single click events will be fired when a single click left click on the cell the worksheet and a Rohatyn change the event will be fired a pound rose and he didn't go I hate it so Rose soda it will be high it will be fired but after the row and column was sorted so before I introduce this events I will like to give you a demo for introduce what was that's about so these as sweet as we a lot of the customer are have a very complicated scenario so some of the data has her a keen for me hierarchy level information that is to say they are not displayed all level in the first in the first layer so they want to you know have a chance to feel top to see more data more data under this level so once you click they get the data from the server and insert the data below this this hierarchy here a key level so let me play this video just ladies in understand more puppies I click the button to expand it and I can double click to add it and I'd also can do drill down drill down drilling from the column as well so this is a single click to drill down and click our ear other ear we will just select for selection on me and double click to enter the edit mode so that is the the function for this API so so for the API design we will have following properties and you can get the time actually the every event we have typed into about I hope we almost we have around thirty eight thirty type of API and the worksheet ID which is a GUI ID and to represent the shape and also we can you can get the address which is the cell address and the address that you have been clicked and furthermore the most important thing is the click single click where where the point is which is a left of the left and offset top so I want to call out that this is the the the distance between from the cell it's not from the the a one is from the sale that they clicked okay and this is a simple code that I had abused this demo a pivot moment ago I shared to you and and this is the the register event you can use that to add the single click I can have this function and then I can do all the logic in this function and also I just use the mouse layer after connect the position to define where is the hot point it is if it's in hot point I will do these kind of action and also I will use the number format to change change the status of the plus and science so that's that that is the the logic for these you see these events the the dreidel Jordan logic for leverage these events okay I play this and let you see more about this scenario okay so I when I hi choose from these nine thirteen to fifteen and you can see that this is hide it I want to hide it there's that there's luck information so thirteen to seventeen is hide it here you can see these even the information from the events and also I can do do some another kind of hi witches I choose the the the wrote height which is set into 0 which means is also not be able to display that is also height and you can see that the information is also high or sorry I clean again yeah and and also can that also support out is think discontinued range so if I choose twenty four twenty twenty six I hide it and then if you see the even lock it will show you where the the places we hide okay and and furthermore we also can do the unhide events so when we do the unhide they will show you the information all the the set of the roles that we hide it unhide it so another scenario is we could use the group and ungroup if we click the group in system and also the this side and this will be hiding and from these events you can see that the dress fourteen to seventeen was high the the Auto filter you know the future I can choose the criteria if it's that when there are two events were phi1 is to hide and another one is unhide so that is to say that is to say that every every action in Auto filter we will need to unhide the previous one and also hide the one that in this filter okay yeah this is the event lock for for this height change log information and for these events design we have the address of course this is the where is the affected Rose which is hidden or unheeded and we have properties to show you whether these heat it true is a hidden or false is not he is it's visible and this there's another information we like to call-- which is the source so as these events is support the core scenario that is to say someone is height is your height is the action that you do it is the local if someone is working on the remotely and another user is doing this some of the same work and all that they hide it and that events will be removed so what she idea is a GUI ideas well we which will represent which worksheet will be hide it or not so type is the events what kind of events are for for in this means that we this is the row hydrant events so this is the code sample for the row hidden actually this is quite easy we just when we have the events we just log comes a lot and to type all these events information just we saw it in demo in the last time I would like to show you is on row sorted demo so let me quickly to play this that you don't understand to learn more about that so this is the register this events and also this is unsorted what action doing when the events is fired so I first add the simple data and then I reduce the sorted handle then there's Regis the eventual success will resist it so if you pay attention to this [Music] information we can see that I wants to do the sorting for the for the quarter one and if you can pay attention to the second one second row actually is the the the sandal art as you can see that this is not changed its keep the same state a sample and the the first role in the and the other rows has are changed therefore the assorted areas are a 2 2 F 2 and a 4 2 a 4 which means the sandal parties haven't changed because it is it is still here and if we do a sword which is from large to small and that is this day that salt air is the food table which is a 2 to f7 all sorted so if I do is sort it again by large to small and as you can see that this events also fired however the salt error is empty it means that is nothing are sorted okay okay you can use these events in the future when we release this API okay so these designs like we have a four properties we have the type of events that or events we have this type thing and the source like I like we discussed this team also from top local and remote and address this is where our sort happen here is a simple code and you could use that you to reduced it the function to handle this sort events and also you can this is the put a lock for these events okay if you have any question or a feedback you could share to us from the phone dink yeah we welcome to hear from you thank you very much awesome thanks Raymond before we move on to Sudhir and the edge web view control a couple questions for you Raymond just everyone is aware the API is that you show today are coming in a tan requirement set 1.9 is that correct no these yeah he's after the actually this is an early already view preview actually seen in the preview so it's not okay okay so coming coming sometime post 1.9 in the meantime if if any of you on the call today have feedback we'd love to hear your feedback Raymond would you prefer they add that to the open spec repo is that where you'd like them to add the feedback on these api's that they saw today yeah yeah you couldn't provide the feedback through the link I have sure perfect so everyone I pasted that link to the open spec the Excel JavaScript API opens back in the chat window so if you have any feedback on the design of the API is that you saw today we're still you know flushing out the rest of that implementation so feel free to provide your feedback by opening issues in the Excel it's actually office jazz Doc's Rico that aka Emma's link will take you there so thanks Raymond I appreciate that one quick question that came in on the chat window here while you were speaking for the Excel JavaScript API and events do we plan to add more information to data changed event args somebody's saying it would be extremely helpful to also get information about what the old formula was and the new formula not just old value a new value because in some cases the value may not change but the formula will have changed so we are we planning is there any plans right now that you're aware of to add additional information about formulas to the data changed event args yeah I think we will take into consideration right now we in point 1.1 a 1.9 release we will release the before and after the before value and after value so for that the formula thing we will need to take into consideration I cannot promise right now when we release it when we will fix it but we would take into consideration okay great thanks Raymond and thanks for the feedback there via the chat window all right so I'm gonna request control Raymond if you can let me go ahead and share my screen sure sure all right so we're good to go Sudhir is here to talk about give us an update on the edge webview control go ahead Sudhir awesome thank you well good morning afternoon and evening everybody I think to joining the call today again as Kim mentioned I'm a program manager on the office platform team I've been here the last couple of months talking about the edge webview control just wanted to come back over here and talk to you folks about it again just a quick show of hands or yeses or nois in the chat window have folks been testing with the new edge control have you've been successful so far can anybody chime in and say yes no maybe okay well I'll let you I'll let you folks chime in as I keep talking about this but I'd love to know if you folks as upper calls are being successful sort of testing with the new edge webview control or not but let me get started with sort of the the context and what we're trying to do over here as you may already know for office wall battens we use the web control that's available on the platform today so for example on win32 today we use the trident or the Internet Explorer web control to render your web a dents on Mac OS for example we use the web code to control and so on and so forth so that's sort of the the context of how Office add-ins are run on a particular platform with this new change what we are looking to do is that to actually bring in the edge web view control to be the the control the runtime the T well that runs your office add-ins edge web view as you know is is the modern web control that's currently available on Windows 10 it is way more performant and as standards compliant then the current ie trident web control that we use it also supports the latest ECMAScript that's the JavaScript specification so here much more modern than what Trident is able to do today and that's the thing that we want to start using for office add-ons you'll see that starting Windows 10 version 19 xx I think I believe that current version that's available out for insiders is 1903 we are using the edge control as the default control for office add-ins also you'll need the latest version of office this is the earliest version where we started using the edge control as the as the default control for our office add-ons but again we'll talk about sort of how to go out and get the latest office and Windows versions in just a bit but you want to make sure that you get the latest control because we've fixed a bunch of bugs in there in the newer versions of office if you will so anyway the gist of this is we were the edge control is the new bottom control and in the in the latest versions of office and windows that is the control that we're using to render your office Adams render and run your office add-ins can you go to the next slide for me I'm Kim so how does this impact your your adder that you currently have in the office store or maybe you have it in in deployed through centralized deployment today as I said starting the office version 1601 one four to five we will be using edge control as the default control on the older Windows builds so that's the 18x x and lower bills we will continue to use ie Trident as the default web control so no changes over there on older versions of office and older versions of Windows if you will what this means is you'll have to test your out in both in the old item control you want to make sure that it's continuing to work over there but also test your add in using the the new edge control um again this change does not impact your office add-ins that you may have available on on Mac or obviously office online as well as the other non windows office versions if you will such as iOS and Android and so on and so forth ok next slide for me ok so as you're testing this there's there's just one sort of an issue that you want to be aware of if you've if you folks have been on the call the last couple of months the issues list was about or how long I believe before were down to just one and this is an issue quote-unquote issue if you will this is something that you'll have to do a workaround that you'll have to implement as you are working with the edge web view control with this if you are loading a localhost at and so for example if your manifest says localhost whatever as the source URL for your particular web add-in you will have to implement this workaround a pretty simple workaround to make sure that the edge webview control can load from the localhost this is I wouldn't actually call this an issue this is more of an implementation detail and the way edge handles local hosts again that's a pretty simple loopback exemption that you'll have to enable for edge to be testing your atom from from the local host if you will so again take a look at that and make sure that you implement it as you are testing your at it and then the last slide came if you can advance once so really that the call-to-action is tested please give us your feedback I'm looking to take this to production as soon as possible over here so it really serves you well to end your customer as well to actually for you to be able to test this control test is added using the new control and give us any feedback if you are seeing any issues with the new control we've already had about four issues reported to that github link that you see on the slide very important for us to be able to hear back from you and and know that the types of issues that you're encountering I believe the four issues that we've encountered or that have been reported were of the order of there was one issue where when you were using or when the when the developer was using the edge web you control any open href open window links were opening in the background versus the foreground so that that's again something that you as a developer cannot fix it's something that we can fix from a platform standpoint there were a couple other issues reported that sort of were something to do with sort of the the rendering of the control itself or the rendering of the ad and it's stuff where I believe the have wanna see the zoom wasn't set right on the control or something to that effect so anyway the point being I tested let us know any issues that you see we'd like to know issues that you think that the platform should be fixing but not something that you can handle yourself from from a standard web development standpoint so if it's something about you know the font not looking right or you know some sort of a functionality that that was available on ie but changed in in edge webview that's something that you can fix and I would like for you to fix that and certainly don't report those types of issues on github but anything like oh the view doesn't look right or scroll bars are not appearing or for whatever reason there's a crash in Excel or Word or PowerPoint or whatever it is we'd certainly like to know those issues and please do report those issues on on that github link over there if you go up and in terms of getting the latest versions of office windows you just you know I believe you have to be in the insiders program as long as you're the insiders program definitely get the latest versions of office in Windows as I've said before we've addressed a number of issues in the latest latest build so the later version that you get the better experience you're gonna see from a new edge control perspective and for debugging again I have a link out there for using the the edge dev tools just a much better experience if you will in terms of debugging your your ad and using those those tools that are currently available so quick pause over here any questions or comments or thoughts from folks on the call okay well I don't believe they are so during how the chromium announcement impacts the the edge control if so no impact on this particular control chromium is something that we are working with the edge team very closely on at this point we as soon as the edge team makes the chromium control available widely our our goal is to sort of enable office add-ins desert start using the edge control I don't have a definitive timeline on that at this point it's looking like it might be sometime later this year maybe early next year I don't know at this point but again rest assure that we're working very closely with the edge browser team to make sure that we move lockstep with with them and make chromium as the control available for office add-ins when when the OS itself makes that available for users that makes sense okay any other girl she liked you awesome any other questions or comments okay well if there are none again please do test it and let us know if you see any issues and were paying very close attention to get happen the issues that are being reported over there again appreciate all the feedback so far but do keep it coming and we are looking to take this live over here hopefully in the next few weeks or so thank you great thanks to dear and really a thanks to everyone who's tested so far and provided us feedback in the office Jas repo and github you know as much as we test things internally there's really no substitute for real-world testing and feedback so we really appreciate you guys chiming in there alright so next Kara's here is joined me in the room he's going to talk a little bit about the comp web add-in bridge for UDS to custom functions cool sure scream everyone my name is kare p.m. with working on Excel custom functions and one of the as we were building out custom functions with one of the things that we realized specifically from our partners on the group on this call as well as our custom functions call was hey we needed a way for existing workbooks that were created using the old style of custom functions called xol user-defined functions we needed a way for those workbooks to be essentially brought over for the modern web add-in equivalence and in doing so as we're planning out that compatibility mode we also realized well hey when it came time to deployment and we got this feedback from partners as well which was hey there were certain situations where a we have a existing comm added and that commented may have some functionality or it may already be deployed to an organization so getting them to change that upfront and instead move to the web added and to begin with maybe a harder thing to do or the web at it may not have all that functionality to combat and yet and so as we're building this out we decided hey it may make sense to have a way for the web add into essentially suppress itself on Windows where the a providers calm add-in is already running and so that's what this feature enables and a component of this is the also the ability for us to have your XML user-defined functions be saved in the same format as your JavaScript custom function so I'll talk about that as well so yeah the combo web atom bridge as now calling it allows your web at and to choose an equivalent commented and if that commented is installed on that client machine the the web added does not appear on the ribbon and then if your as part of as part of this you can also declare your javascript custom functions to be saved in a compatible format as your xol user-defined functions this also means on Windows if your XML user defined functions are running well we will use those instead of your JavaScript functions now what this allows you to do is have a have an experience where you can have your web add and work on Excel online and Mac and then your combat and and your Excel o user-defined functions work on Excel for Windows right now this feature is only available in Excel and so and it will be launching when we launch javascript custom functions which I'm not ready to publicly declare a date yet but it's we're working on hard and it should be very it should be fairly soon so the essentially the way you can your ad and can set this mode is underneath the task pane version overrides in your manifest you need to add this equivalent Adan's node and there's two types there's one is if it's if it's your combating you just specify the prog ID and this will say hey Excel don't show the basically don't show my web ad in UI if this comma this if this prog ID is loaded the second is the equivalent to added name so here you just say hey your type is XML instead of calm and Excel elves don't have a prog ID so you just specify that file name alright so let me jump into a quick demo and the demo I'm going to show here actually involves a partner's add-in they gave me permission to examine this of Thank You solver folks so I'm gonna go insert they're added so they actually have - edits but right now I'll start with their analytics over Adam and the solver is a Adam delivered by frontline systems they are actually scheduled to come and chat more about their integration and their scenario I believe in May in June so I'm going to save that for them and I'm just going to demo the JavaScript custom function and comm component parts so what I'm going to do first is I'm going to pick an example model and they they have some great examples here so I'm going to choose the Monte Carlo simulation because I know these have some custom functions and that's a good one so this scenario is hey I have two young kids I want to know how much money I need to save for college come on Tyler so what I'm going to do instead is I'll just use a sample function here so they have a few functions these functions will by default return pound n/a until you run a simulation but just for demo purposes I'll show here so this is a Java Script custom function actually they'll return pound value oh just one okay so we have a JavaScript function executing and let's go and open this workbook inside of Excel open an Excel okay so now what's happened is I've also basically opened this inside of Excel this is now running and you can see the formula is recalculating and here I don't have my web at and enabled I'm actually running solvers comment in OneNote the reason why you're seeing the @ sign in front of the psi normal is it's a I'm just a mismatch so you will see this it's a feature of Excel dynamic arrays so this build of office has dynamic arrays enabled Excel online does not and so if you have some functions where it looks like we're it's Excel thinks that it may spill out in terms of a dynamic array it will show that out sign and we'll have like we can share the blog post that has more information on this so so what we've done here is we've just showed essentially both in so now I have two versions of my ad in running side-by-side one as a comet in another is my web edit quick note each instance of Excel gets its own calculation attention so that's why the values your your you're seeing or different the other thing to demo is and I don't have my Mac on me as well but it would essentially be the same behavior as Excel online now let's say I have my combat and installed and I want to if a user goes and tries to install the web at in so this is one of the reasons why we ask for that prog ID so if I choose to install that Adhan what it will do is it will essentially add a pointer or create a call-out back to your combatted and this is just to help the user understand hey that added is already available now from an IT perspective hey this Bridget has been great and where we're now ready to move to the web ad and all of some how would we do that so as a end user the easiest way would be to uninstall analytic solvers combat in you can if they if the if you provide a uninstall MSI they can use that likewise they can go into here and they can choose remove added and so this will remove at that in let me close so and try to open that it again you okay so now that this may have been hard to see but now this is using solvers web adding there was another tab here that had a solver home and see what did it show okay that's interesting I'll need to check on whether that's desired or not but in a nutshell that's essentially how the condom web ad in bridge works and I didn't want to just share a few different limitations here oh one other thing so I showed how a individual user can disable or remove the commented there will be a policy setting that you can set so your IT doesn't have to tell all of their users to uninstall the combat and there should be a group policy with the value that removes that comment in as well okay practice now on the custom function behavior did just want to call out a few notes or differences that we had so so just to begin with JavaScript custom functions actually by default save in any file format then the existing model the big reason being is we needed to save it into a new format to support localization and we're Microsoft we believe in inclusion and we believe in making sure anyone across the world can access your custom functions now in the with excel UDF's the there wasn't a way to localize those functions other than to register those functions individually and they would be saved in the localized version and so that's why one of the main designs they had a new file format but however we realized for existing a solo or existing providers with UDF's we needed a compatibility mode so this table just calls out some of the notes that you would get so the column of interest is the one in the middle in terms of a few different considerations so we oh we only support this mode in the new file formats and Excel add-ins don't work in the XLS format one of the benefits like you you know you of course get the autocomplete the ability to do streaming you won't get the localization capability so in this mode you're basically going on what your name and your ID of your custom functions metadata to match and one of the things that for foot partners who have been building on custom functions is we will have this notion of requirement sets which our requirement sets are just groups of abilities based off of versions so if we one of the limitations with us in supporting this compatibility mode is it will be scoped to the one the functionality that we have in the 1.1 requirements that's so so essentially the stuff that we have been working to GA towards the other note is VBA is not supported so VBA user-defined functions or if you have UI highlighting VBA that's not supported yet and yet meaning it's not a it's not in our plans but if we here's a bunch of feedback on it we can evaluate that so yeah that was essentially it it should be rolling out on insiders so the 14 to 5 plus build should have it same with the edge webview control on the Mac if you this behavior is also in that build we just are working to turn on the feature so we expect that to be turned on by a and a week yeah and if you have issue if you have anything to report just use the the same repo as severe mentioned office Jas issues Sun thanks care so we talked today care in terms of primarily Excel that's where this feature of this came web add-in Bridge is going to initially be available presumably fair to say there are plans eventually to make it available across the other host I know somebody commented that they would love to see it in word yeah yeah we will be eventually making this capability available in other host as well we're just starting with exactly yeah awesome good stuff all right I'm gonna go ahead and request control and next Doug's gonna just say a few words about build which is less than a month away now got to go in here dog one second cool okay buildings in Seattle may 6 to 8 and if you haven't registered yet there's the link for where you can register akms slash build 2019 and this year there'll be a few things related to the excel API is as Raymond mentioned Excel 1.9 requirements that will GA then with its 500 new api's I think the way to look at build if you've never been to one is it's a very comprehensive across all of Microsoft opportunity to get up to speed on Microsoft technologies and in what's new for developers for those who build solutions one one little thing that's different this year the fine print over there on the right you can bring a person aged 14 to 21 to the conference for free so I'm just kind of an interesting new thing we're trying to do to get more young people aware of what's going on with our developer tools so if you have a you know a kid or a niece or nephew who would be interested in that that's kind of an interesting new thing we're we're doing for the first time this year so there's the link AKMs last bill 2019 there's still plenty of time to register hope some of you can make it there yeah we do have frontline systems solver who is going to be doing a community talk there as well so it's a great opportunity to hear from one of you alright so almost at the end of the call here today I encourage you if anybody's interested in sharing a demo we've had some customer demos over the last few calls we have another one scheduled for a month or two from now if you're interested in sharing what you've done with the office add-ins platform and office JavaScript API so please do reach out to us here's a forum Doug if you could paste this akms link into the chat window it's office add-ins engage just reach out to us we'll be in touch if you want to present at one of the upcoming community calls or if you're just interested in writing feedback potentially about the documentation in the office add-ins documentation we'd love to hear your ideas about maybe ways in which we could improve that for you but Doug how are we doing on the chat window with QA or we it seems like we've been kind of answering things as we go along we'd be in pretty good shape there yeah I think most have been answered Raymond Xander's a bunch of questions Lillian jumped in to answer question I think we're in good shape there but if anybody has a question that they haven't got an answer to if you want to post it right now we can see if we can help here and of course as we always do we have a blog post afterwards that summarizes answers to questions so if you don't get an answer here on the call we'll address it there right just a quick look at some developer resources for learning about the office add-ins platform and api's for engaging with us this deck will be posted to the blog post as well that Doug just mentioned it'll be published later this week so you have access to all these links there and that brings us to the end of today's call thanks everyone for joining us our next call will be on May 8th second Wednesday of May if you want to submit questions ahead of time please do so using that using the AKMs link here and if you don't know you have the invite go ahead and add it to your account or using the last link on this slide thanks for joining us and we look forward to seeing you next month