Excel Desktop - Office context document settings get didn t working

Question

The saved parameters were not retained when the Excel file was reopened. Office.context.document.settings.set('key', value) works for me. However, using Office.context.document.settings.get() to retrieve the settings didn't work.

I want the state to be saved so that we may access the saved values the next time we open the document.

I'm using the ordinary edition of Excel 2016. A version of the Build: (16.0.4266.1001) 64 bit

Answer 1

You need to call the saveAsync method of the Office.Settings interface to persist the in-memory copy of the settings property bag in the document.

Any settings previously saved by an add-in are loaded when it is initialized, so during the lifetime of the session you can just use the set and get methods to work with the in-memory copy of the settings property bag. When you want to persist the settings so that they are available the next time the add-in is used, use the saveAsync method.