Office.context.document.settings.saveAsync() disables undo

[SharonCKC]

Your Environment

• Host [Excel, Word, PowerPoint, etc.]: Excel

Provide additional details

The user makes some change to their data on a worksheet.
In the worksheet.onChanged event, first call Office.context.document.settings.set(key, value);
Then call Office.context.document.settings.saveAsync(). This makes sure that the setting is saved in the document for the next time that the user opens the doc. But saveAsync() disables the undo button.

Context

The add-in needs to update a setting whenever the user changes data (e.g. deletes a column). However, if the user accidentally deleted some data, they cannot recover it using undo.

Expected behavior

Two possible solutions. Either

1. the undo button should not be disabled when Office.context.document.settings.saveAsync() is called
2. Or please provide a workbook.onSave event. We need a better place to call Office.context.document.settings.saveAsync(). Then, we can continue to call settings.set() in the onChanged event, and only call settings.saveAsync() when the user saves the workbook.

[ghost]

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

[SiruiSun-MSFT]

Hi @SharonCKC ,
Thanks for reporting this issue. And the issue has been confirmed and tracked as ADO#7609487 in our backlog. Will share updates here if we have any progress!

[SharonCKC]

@SiruiSun-MSFT any update? Undo is very important for data editing in Excel.

[SiruiSun-MSFT]

@SharonCKC, I'm sorry to tell you that this bug is still in the backlog. We will start the investigation ASAP when we have bandwidth. Or you can provide the scale of affected users, it will help us re-prioritize this bug. Thanks for your patience!

[Isaac96SM]

same issue here, please fix it ASAP

[ValentinShtankoAimtraction]

I have same issue here

[digambar2002]

is this issue solved? Can anybody found the solution

[SiruiSun-MSFT]

Thanks for your reporting here. We are tracking the progress of API Undo Support through Feature ASK. We recommend you to upvote or submit a new Tech Community New Ideas item, this will give us visibility of the commonality of it and will help with our prioritization. Once the timeline is lock down, will update here. Thanks again!