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.