Document settings #1952

New Issue

2020-05-18T05:48:23Z

szilardd commented

2020-05-18 05:48:23 +00:00

(Migrated from github.com)

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

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

👍 1

SheetJSDev commented

2020-06-03 20:10:00 +00:00

(Migrated from github.com)

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 :(

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 commented

2021-05-19 15:47:02 +00:00

(Migrated from github.com)

@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>`

@SheetJSDev, yes there are serialized in the file (xl/webextensions/webextension...xml) File structure of webExtension.xml `<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <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>`

Sign in to join this conversation.