Excel Undo feature is not working after saving data in customXmlParts about office-js

[microsoft-github-policy-service]

Thank you for letting us know about this issue. We will take a look shortly. Thanks.

[shanshanzheng-dev]

Hi @NiteshParmarCoh Thanks for reporting this issue. But when I copy your provided code using script lab, and click run button, nothing is happened. Could you please help to provide more details about code in order for us to better repro or investigation?

[NiteshParmarCoh]

Please import the below code in the script lab.

description: ''
host: EXCEL
api_set: {}
script:
  content: >
    $("#create-custom-xml-part").on("click", () =>
    tryCatch(createCustomXmlPart));


    async function createCustomXmlPart() {
      await Excel.run(async (context) => {
        const originalXml = "<Reviewers><Reviewer>test</Reviewer></Reviewers>";
        const customXmlPart = context.workbook.customXmlParts.add(originalXml);
        const xmlBlob = customXmlPart.getXml();
        await context.sync();
        console.log("xmlBlob.value:", xmlBlob.value);
      });
    }


    async function tryCatch(callback) {
      try {
        await callback();
      } catch (error) {
        console.error(error);
      }
    }
  language: typescript
template:
  content: "<section class=\"samples ms-font-m\">\n\t<button id=\"create-custom-xml-part\" class=\"ms-Button\">\n        <span class=\"ms-Button-label\">Create XML part</span>\n    </button>\n</section>"
  language: html
style:
  content: |
    section.samples {
        margin-top: 20px;
    }

    section.samples .ms-Button, section.setup .ms-Button {
        display: block;
        margin-bottom: 5px;
        margin-left: 20px;
        min-width: 80px;
    }
  language: css
libraries: |
  https://appsforoffice.microsoft.com/lib/1/hosted/office.js
  @types/office-js

  [email protected]/dist/css/fabric.min.css
  [email protected]/dist/css/fabric.components.min.css

  [email protected]/client/core.min.js
  @types/core-js

  [email protected]
  @types/[email protected]

[shanshanzheng-dev]

Hi @NiteshParmarCoh, Thanks for this details. I can repro this, the excel Api set operation can't redo/undo. It's a by-design behavior. Also please go to community to vote on undo support: Undo to help accelerate it! We value your feedback and will consider it in our future feature reviews.‌

[microsoft-github-policy-service]

This issue has been automatically marked as stale because it is marked as needing author feedback but has not had any activity for 4 days. It will be closed if no further activity occurs within 3 days of this comment. Thank you for your interest in Office Add-ins!

[microsoft-github-policy-service]

This issue has been closed due to inactivity. Please comment if you still need assistance and we'll re-open the issue.