Worksheet OnChanged event does not return details when multiple cells are edited

[harsh-borad]

Environment

• Platform : PC desktop
• Host : Excel
• Office version number: Microsoft® Excel® for Microsoft 365 MSO (Version 2412 Build 16.0.18324.20092) 64-bit
• Operating System: Windows 11

Description

I am using the Worksheet.OnChanged event in office.js to capture valueBefore and valueAfter for cell changes. When I change a single cell, the event provides the details object with changeType: "RangeEdited" along with valueBefore and valueAfter.

However, when I edit multiple cells at once (e.g., deleting values into a range), the details object is undefined. This makes it impossible to track value changes for multiple-cell edits.

So below I attached the Screenshot of both the differences.

Expected behavior

The details object should provide valueBefore and valueAfter for all modified cells, similar to how it works for a single cell.

Current behavior

For multiple-cell edits, details is undefined, making it impossible to track the changes.

Steps to reproduce

1. Register Worksheet.OnChanged event to capture valueBefore and valueAfter.
2. Modify a single cell → details contains valueBefore, and valueAfter with its other objects.
3. Modify multiple cells at once (e.g., delete a range of values) → details is undefined.

Useful logs

1. When "RangeEdited" in single Cell

2. When "RangeEdited" in mutiple Cells or Range

Point to be noted

This concern is raised because when we are checking Excel's in built Review -> Show Changes ,we got the its tracked before and after values for the same Range "CD:C4".

[ElizabethSamuel-MSFT]

@harsh-borad Thanks for raising this issue.

@XuanZhouMSFT Can you take a look and reassign if needed?

Thanks.

[harsh-borad]

@ElizabethSamuel-MSFT @XuanZhouMSFT any update on this?

Please suggest me any temporary alternative for this !!!

[XuanZhouMSFT]

Hi @harsh-borad, Thanks for reporting this issue. For Worksheet.onChanged event details, we only support for single cell change. You can also reference the document for this API here: Excel.WorksheetChangedEventArgs.

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. If we end up working on this issue, we will re-activate as needed.  Microsoft 365 Developer Platform - Microsoft Community Hub

[harsh-borad]

@XuanZhouMSFT
Thank you for your response. I appreciate the guidance on submitting a new idea or upvoting existing ones on the Microsoft Tech Community. I understand that this helps with visibility and prioritization. I will proceed accordingly and look forward to any future updates if this issue is considered for development.

[guoms1]

Close this issue since there is no more action needed.