search

OfficeDev / office-js

A repo and NPM package for Office.js, corresponding to a copy of what gets published to the official "evergreen" Office.js CDN, at https://appsforoffice.microsoft.com/lib/1/hosted/office.js.
https://learn.microsoft.com/javascript/api/overview
Other
687 stars 94 forks source link

OfficeRuntime.Storage on Macs does not share storage between Excel and Word add-ins #2928

Open Andrew-AnalysisPlace opened 2 years ago

Andrew-AnalysisPlace commented 2 years ago

I want to be able to share data between an Excel add-in and a Word add-in. I have no problem doing this on Windows and Office Online, but we can't get the 2 add-ins to communicate on Macs. I need to get them to communicate on the user's device without sending customer data through a server.

Your Environment

Expected behavior

I expect OfficeRuntime.storage.getItem(key) in Word to get the value set in Excel using OfficeRuntime.storage.setItem(key, value). This works in Windows, but not Macs https://learn.microsoft.com/en-us/javascript/api/office-runtime/officeruntime.storage?view=common-js: "Storage limit is 10 MB per domain, which may be shared by multiple add-ins."

Current behavior

The Word add-in cannot communicate with the Excel add-in on Macs (locally)

Link to live example(s)

More details: https://stackoverflow.com/questions/74157366/how-can-i-get-officeruntime-storage-to-work-on-macs-so-2-open-add-ins-in-differ

Provide additional details

I have also tried localStorage, indexedDB, and BroadcastChannel. They all work on Windows. None of them work (to exchange data) on Macs I have tried all of the above with SharedRuntime, but I now understand that different add-ins don't run in the same runtime. After I'm able to upgrade to Safari 16.0, I'll also test SharedWorkers. But I believe that won't work either.

Context

My add-in customers require Excel to share data with Word without their data leaving their computers.

RuizhiSunMS commented 2 years ago

@mattgeim Suppose that you may help in this area?

RuizhiSunMS commented 1 year ago

@madhavagrawal17 or maybe you can take a look?

alexuaua commented 11 months ago

Greetings everyone, is there an update on this issue previously tagged as a bug by @RuizhiSunMS? I do understand that this may not be a high-priority concern and don't expect an ETA for resolution, but any update on its potential inclusion in an upcoming Office updates would be appreciated: the issue, although not critical, poses a significant limitation compared to the VSTO API.

I'm also experiencing a similar issue with an add-in that should operate in multiple office apps. The existing documentation, code, comments mainly focus on Windows, where Office applications share the same browser data storage per add-in. This means loading the same add-in across different host applications results in using the same data storage, including options like OfficeRuntime.Storage, localStorage, indexedDB, etc. However, as mentioned by the issue author, this doesn't apply to Office for Mac applications. These versions (including those from the AppStore) use shared storage (keyword: group containers) for other data (like templates, legacy add-ins, etc) but not for Office.js add-ins. This situation suggests it is either a different design approach (vs Windows) or a flaw for WKWebsiteDataStore storage location, or possibly a bug where the add-in ID isn't correctly identified, leading to new storage being created for the same add-in when loaded into different host applications.

Thank you for your attention to this issue.