[Bug] Related issues after calling API insertRowAfter(afterPosition)

[18860852449]

在您提交此问题之前，您是否检查了以下内容？

• 这真的是个问题吗？
• 我已经在 Github Issues 中搜索过了，但没有找到类似的问题。

受影响的包和版本

0.6.1

复现链接

问题描述：页面上存在 9 至 13 行的数据，其中 第 14 行的 F 列 对 9-13 行的 F 列进行了统计，公式为：=SUM($F$9:$F$13)
以前版本：调用 insertRowAfter(13) 后，在 13 行后插入了新行，原先的第 14 行成为 第 15行，公式会自动更新为 =SUM($F$9:$F$14)
现在版本：调用 insertRowAfter(13) 后，在 13 行后插入了新行，原先的第 14 行成为 第 15行，公式仍然为 =SUM($F$9:$F$13)

预期行为

期望：调用 insertRowAfter(13) 后 和 以前的版本一样，在 13 行后插入了新行，原先的第 14 行成为 第 15行，公式会自动更新为 =SUM($F$9:$F$14)

实际行为

实际：调用 insertRowAfter(13) 后，在 13 行后插入了新行，原先的第 14 行成为 第 15行，公式仍然为 =SUM($F$9:$F$13)

运行环境

Chrome

系统信息

System:
OS: Windows 10 10.0.17763
CPU: (5) x64 Intel(R) Xeon(R) CPU E5-2687W v3 @ 3.10GHz
Memory: 3.71 GB / 16.00 GB
Binaries:
Node: 16.20.2 - D:\develop\env\nodejs\node.EXE
npm: 8.19.4 - D:\develop\env\nodejs\npm.CMD
Browsers:
Chrome: 133.0.6943.127
Internet Explorer: 11.0.17763.2989

[univer-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Origin Title: [Bug] 调用 API insertRowAfter(afterPosition) 后的相关问题

Title: [Bug] Related issues after calling API insertRowAfter(afterPosition)

---

Have you checked the following before you submitted this question?

• Is this really a problem?
• I've searched in Github Issues but found no similar questions.

Affected packages and versions

0.6.1

Reproduce link

Problem description: There are data from rows 9 to 13 on the page, where column F of rows 14 counts columns F of rows 9-13, and the formula is: =SUM($F$9:$F$13)
Previous version: After calling insertRowAfter(13), a new line is inserted after line 13, and the original line 14 becomes line 15, and the formula will be automatically updated to =SUM($F$9:$F$14)
Now version: After calling insertRowAfter(13), a new line is inserted after line 13, and the original line 14 becomes line 15, and the formula is still =SUM($F$9:$F$13)

Expected behavior

Expected: After calling insertRowAfter(13) and as in the previous version, a new line is inserted after line 13. The original line 14 becomes line 15, and the formula will be automatically updated to =SUM($F$9:$F$14)

Actual behavior

Actually: After calling insertRowAfter(13), a new line is inserted after line 13, and the original line 14 becomes line 15, and the formula is still =SUM($F$9:$F$13)

Running environment

Chrome

System Information

System:
OS: Windows 10 10.0.17763
CPU: (5) x64 Intel(R) Xeon(R) CPU E5-2687W v3 @ 3.10GHz
Memory: 3.71 GB / 16.00 GB
Binaries:
Node: 16.20.2 - D:\develop\env\nodejs\node.EXE
npm: 8.19.4 - D:\develop\env\nodejs\npm.CMD
Browsers:
Chrome: 133.0.6943.127
Internet Explorer: 11.0.17763.2989