When patching rows in a site's file, if a column is being filled with an Excel formula, the value of such column for the last row will be applied to all the others
I'm trying to patch some rows in a range in an Excel file contained in a Sharepoint site. This is the URL: PATCH https://graph.microsoft.com/v1.0/sites/{site id}/drive/items/{workbook id}/workbook/worksheets/{worksheet…
How to send Azure AD SAML group claims using regular expressions, as I have multiple conditions to meet
I am looking for some help on regular expression for saml groups, I have set of groups ending with xyz and few groups starting info.test, and info.dev ...etc I have added the group claim in AzureAD enterprise apps and I have selected source attribute…
Unable to upload STREAM video links into Microsoft Forms
Hello, I am unable to upload STREAM video links into Microsoft Forms question. I am getting the below screen as "Please upload YouTube URL" When I tried with YouTube URL, it is working but not with stream video links. Is this a service…
Calling CustomFunctions.associate after await causes first invocation to fail
I'm seeing an issue where calling CustomFunctions.associate after an await is causing the first invocation of the custom function to fail with #VALUE! A value used in the formula is of the wrong data type. Subsequent invocations of the custom function…
Manually opened Word files are being closed when files are opened using Microsoft.Office.Interop.Word.dll (15.0.0.0). How can I prevent this?
I have a C# program that uses Microsoft.Office.Interop.Word.dll (15.0.0.0) to repeatedly open Word files, gather information, and close them. However, while my application is running in the background, if I try to manually open a Word file from Explorer…
ASP.Net Com-InterOp WORD issue after hosting in windows server
I have created a C#(.Net framework) API to convert Word to PDF using interop.word.dll. I have installed MS Office 2016 on the server. However, even when no one is logged on the server, I am getting the below exception. "Retrieving the COM class…
Error when Verifying Phone Number for E5 Tenant
I am trying to activate my E5 Tenant, but when I add my Swedish mobile number to receive the code for verification, I get the error message: We can't continue with the signup process for the following reason: Your phone number did not pass security…
Excel 365 when closing a window appears, The error '1004' has occurred at runtime:
Excel 365 when closing a window appears, The error '1004' has occurred at runtime: Error defined by the application or the object. I already reinstalled the office and it remains the same, any ideas????
Outlook add-in logo/icon not updating after publishing updated manifest
We've recently updated our Outlook add-in manifest, which featured updated logos/icons. There appears to be some sort of caching issue whereby any existing users of the add-in are still seeing the old logo. Whilst we do not consider this to be a…
Outlook Addin Classic layout classic ribbon shows default image for plugin
Hi, I am working on Development of Outlook Addin for new look (Web). When we are testing my outlook Addin icon comes correctly in: a) outlook.office.com (web) b) Outlook installed on Windows with new look: But when I am testing same plugin on Outlook…
Which permissions are required for Graph OneDrive pre-provision to work?
I want to pre-provision users OneDrive using the following method: https://learn.microsoft.com/en-us/graph/api/drive-get?view=graph-rest-1.0&tabs=powershell This does not however work, and the reason why is unclear. I got two test users which both…
Disable autosave via Excel office.js addin
Our Addin performs thousand of cell changes in a loop. The problem is that Excel autosave, especially in Excel 365, kicks in at every cell change and becomes the bottleneck. We could not find ways to disable autosave from office.js API. Any…
Excel Automate Changing Formula on Corresponding Tabs.
I am trying to use the Automate feature to simplify some data structuring for my team. Once properly arranged said data is dispersed across two tabs in the same file using a Filtering formula. Once I engage the Automate function the formula on the…
How to apply the column width along with word wrap
I have an excel in which data is large i.e.2000 characters for a cell.Since no wrap was there I have added the wrap handling and extra code so that I am able to scroll properly. But column width is not getting set. It is 273+ only.Tried autofitcolumn as…
Adding Gmail data to Outlook desktop app on Windows
How can I access my Gmail emails in MS Outlook on my Windows desktop? I have downloaded them in MBOX format, but I don't know how to import them into Outlook.
Custom Forms do not sync in Outlook with O365
Hello, In my company, we use the Developer Tool to create custom forms for Contacts and Tasks, which generate new pages in the contact items within Outlook. We use these custom fields to keep our contacts updated, filter them, and perform various other…
Excel - Automatic date changer
Hi I'm trying to have one date that changes once that date is reached, adding 4 weeks to it. example: starting with the cell displaying 18 Oct 24 when it actually gets to that date, the cell adding 4 weeks to it, displaying 15 Nov 24 this action…
Office Scripts : Chart Data Labels "Values From Cells
I am trying to create an Automate Script in Excel that will generate and format chart. I am getting close, but I can't figure out how to set Data Label values. I want the same functionality as the Format Data Label/Label Options/Vale From Cells as…
How to update all fields in a Word document
I'm new to Office Web Add-Ins (having come from VSTO land), so I'm probably not understanding something small and silly.. I have a document that contains 10 SEQ fields {{SEQ Test * MERGEFORMAT}} . I copied and pasted them, so they all show a result of…
Microsoft graph api while posting comments gives missing header Client-Request-Id even though its passed
When trying to post comment on a word document using the microsoft workbook comments api getting https://graph.microsoft.com/v1.0/sites/{siteid}/drive/items/{itemid}/workbook/comments Error message:…