[Bug] Multiple formula results are calculated incorrectly

[zhaolixin7]

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

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

受影响的包和版本

dev

复现链接

1、单元格B1=A1 C4=SUM(C2:C11) 2、b1单元格结果中输入
3、使用快捷键恢复

预期行为

c4求和公式显示正确的结果

实际行为

显示错误的结果 2024_4_22 14_53_32 commands.json 2024_4_22 14_53_32 video.webm

运行环境

No response

系统信息

No response

[univer-bot[bot]]

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

Origin Title: [Bug] 多个公式结果计算错误

Title: [Bug] Multiple formula results are calculated incorrectly

---

Before you submitted this question, did you check the following?

• [X] Is this really a problem?
• [X] I've searched Github Issues but haven't found any similar issues.

Affected packages and versions

dev

Recurrence link

1. Cell B1=A1 C4=SUM(C2:C11)
2. Enter \ in the result of cell b1.
3. Use shortcut keys to restore

Expected behavior

c4 summation formula shows correct result

Actual behavior

Showing wrong results 2024_4_22 14_53_32 commands.json 2024_4_22 14_53_32 video.webm

Running environment

No response

system message

No response

[Dushusir]

撤销时正常触发了计算，但是循环引用导致会拿到旧值来计算 @DR-Univer

[univer-bot[bot]]

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

The calculation was triggered normally during revocation, but the circular reference resulted in the old value being obtained for calculation @DR-Univer