Excel: TableChanged's details property is undefined when paste multiple cells

[hamzamaimi]

TableChanged's details property is undefined when paste multiple cells

• Platform : PC Desktop
• Host : Excel
• Office version number: Version 2412
• Operating System: Windows 11

Expected behavior

When you copy two or more cells and then paste them inside a table it has to trigger the TableChangedEvent with the 'details' property that has to contain the previous values and the current values of the cells.

Current behavior

When you copy a single cell and paste it inside a table it does trigger a TableChangedEvent that contains the property 'details' that has the valueBefore and the valueAfter of the cell.
When you try to copy more than a single cell and paste it inside a table it does trigger the TableChangedEvent but the property 'details' it's always undefined.

Steps to reproduce

1. Open Script Lab on Excel
2. Go to samples and select (Data changed event)
3. In the code replace the function registerDataChangedHandler with this

async function registerDataChangedHandler() {
  await Excel.run(async (context) => {
    const sheet = context.workbook.worksheets.getItem("Sample");
    const salesTable = sheet.tables.getItem("SalesTable");
    const salesByQuarterBinding = context.workbook.bindings.add(salesTable.getRange(), "Table", "SalesByQuarter");
    salesByQuarterBinding.onDataChanged.add(onSalesDataChanged);

    salesTable.onChanged.add(async (excelEvent) => {
      console.log("excelEvent with data->", excelEvent);
    });

    await context.sync();
  });
}

4. write 2 random values in 2 cell's outside of the table's context
5. copy the new 2 cells and paste them in 2 random cells inside the table context. This is going to trigger the event that is going to be printed in the console. You can notice the property details is undefined.

Recording.2025-01-24.153849.mp4

[microsoft-github-policy-service]

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