Document settings

[szilardd]

Is it possible to set document settings? (not custom properties)

Something similar to the office.js library?

Office.context.document.settings.set("Office.AutoShowTaskpaneWithDocument", true);

https://docs.microsoft.com/en-us/office/dev/add-ins/develop/automatically-open-a-task-pane-with-a-document#step-2-tag-the-document-to-automatically-open-the-task-pane

https://docs.microsoft.com/en-us/javascript/api/office/office.settings?view=word-js-preview

[SheetJSDev]

Are those serialized in the file? Can you export a sample file so we can take a closer look?

Some settings like the original locale or custom delimiters are not stored in the file, they are only stored in the local Excel instance :(

[zoulou00]

@SheetJSDev, yes there are serialized in the file (xl/webextensions/webextension...xml)

File structure of webExtension.xml

`
<we:webextension xmlns:we="http://schemas.microsoft.com/office/webextensions/webextension/2010/11" ..>
<we:reference id... />
...
we:properties

<we:property name="mySettings" value="mySettingsValue" />
</we:properties>

...
</we:webextension>`