Excel: Desktop App correctly embeds images; web viewers like OneDrive often show them incorrectly.
Hi, I am facing issue with Image embedding using ExcelJS. When embedding images in a single Excel file from multiple source excel files, problems arise when the file is opened in online excel view like oneDrive site. While the same excel file with embedding images appear correctly In desktop view, they become overwritten across different sheets in the browser view, affecting the integrity of the data. But while exporting to PDF or using Print option on the excel browser view works fine with the exact images, issue exists only in the online web view fails. Details: Library used: ExcelJS 4.4.0 Image Format: PNG Embedding Method: addImage Method of worksheet using unique imageId Positioning: tl anchor point and extension Platform: share point online in Microsoft 365 Browser Affected: chrome, Firefox, Edge. Following things are tried from our end. Same issue persists in the incognito browser as well. Based on our business needs, our main priority is to view files in oneDrive or sharePoint site to make it shareable with teammates and clients in an ease manner. For better insights, I would like to share sample code for reference, Please feel free to test this using the shared file. https://1drv.ms/x/c/d398d8e103d503ce/EfVcgLiXM-5HnagfHF5AF98B-PTz112QtABXyRqGp8CSMQ?e=HNdsgD I have tried an approach to insert sheets of embedded images followed by set of text sheets. Then images are embedded correctly in excel online view, But if I try to order sheets, then the same embedding issue occurs. Samples files are https://1drv.ms/x/c/d398d8e103d503ce/EUVq-5QTzg9Oh3oqS5Rb0cIBUiKb0bI-3t7H_0cOKG_HYA?e=A5IryN and https://1drv.ms/x/c/d398d8e103d503ce/ER3-hNYm3btDkkkTXH2aMpgBEakvQSmJNAZ_0RZsBe7f4Q?e=of47kX. Expected behavior: The images should remain unique and correctly placed in their respective sheets while viewing from the Sharepoint or OneDrive site. The behavior should match that observed in the excel desktop application. Hope this gives better details to resolve the issue. It will be really helpful if we can get past this issue to ensure smooth data maintenance. Please let me know if there are any approaches to resolve it since our business needs require ordered sheets Thanks in advance.
Sharepoint strips off domain portion of Embedded image file path
Hello all, I have an issue whereby I am building a flow that will email the contents of a Sharepoint Online announcement list item to a group of people whenever a new item is added. The problem is that images are sometimes embedded in the Body column of the announcement list item and Sharepoint is stripping the base domain portion of the URL path to the image stored in the Images library when the announcement item is saved. Since the Body column is considered dynamic data, I have no control over the display of the contents of the Body field within a Flow email. Aren't all email Flows built as HTML? We get the "download the image" message when we open the email in Outlook but because half of the URL address to the image is missing we get a File Not Found error in the Developer Tools console. This happens whether we use the "From Sharepoint" or "From Address" Insert options in the Rich Text Body column of the Announcement list. Any suggestions?