React Excel add-in: range.insert() function moves client viewport to top of sheet

[henry4344]

Provide required information needed to triage your issue

When running the range.insert() function on an Excel range, it jumps the client viewport to the top of the sheet.

Your Environment

• Platform: Office desktop on Windows
• Host: Excel
• Office version number: V2411
• Operating System: Windows 11

Expected behavior

Previously, this function inserted the row below without moving the user’s viewport.

Current behavior

Now, whenever the range.insert() function is called, the user viewport jumps to the top of the sheet.

Steps to reproduce

1. yo office --taskpane --name "insert-row-test" --host Excel --js

2. Update the insertText() function in taskpane.js with the following code:

export async function insertText() {
  try {
    await Excel.run(async (context) => {
      const range = context.workbook.getSelectedRange();
      range.insert();

      return await context.sync();
    });
  } catch (error) {
    console.error("Error: " + error);
  }
}

5. Scroll down the sheet so the top rows are hidden.
6. Select a cell and click the Insert Text button in the taskpane.
7. You should see the viewport jump up.

Link to live example(s)

1. Insert Row Bug - Viewport Moving
2. Open Script Lab in Excel.
3. Import the YAML file from the Gist into Script Lab by pasting the content or uploading it.
4. Run the script, scroll down so top rows are hidden. Select a cell, and observe the viewport behaviour when button is clicked and a row is inserted.

Context

This issue disrupts the user workflow as they need to repeatedly scroll to return to their working position.
This issue appears to have been introduced in version V2411. Previously, the viewport remained stable, which allowed for a seamless user experience.

[RuizhiSunMS]

Hi @henry4344, thx for reaching out here.
I did a try and found that, if call range.insert, view would go up to the top. Would you please confirm this is like what you got?

[henry4344]

Hi @henry4344, thx for reaching out here. I did a try and found that, if call range.insert, view would go up to the top. Would you please confirm this is like what you got?

Hi @RuizhiSunMS yes, this is happening to me too. Previously the view did not move when calling range.insert.

[RuizhiSunMS]

@henry4344, ok. Mark it as #9641720 into our backlog. I will involve our experts to investigate. Reply would be here if any update.

[henry4344]

@RuizhiSunMS great, thank you.