[Bug] Formula calculation refers to a selection area. After deleting any column in the reference area and undoing it, the formula result is not restored.

[zhaolixin7]

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

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

受影响的包和版本

dev

复现链接

1、单元格P1=公式SUM(A23:d28)，选中P1向右、向下填充 2、删除B列后undo undo

预期行为

P1单元格向右、向下填充的公式正常显示为公式

实际行为

undo后公式只显示值未显示结果 2024_4_17 20_12_41 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] 公式计算引用选区，删除引用区任意列后undo，公式结果未恢复

Title: [Bug] Formula calculation refers to a selection area. After deleting any column in the reference area and undoing it, the formula result is not restored.

---

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 P1 = formula SUM(A23:d28), select P1 and fill it to the right and downwards
2. Undo undo after deleting column B

Expected behavior

Formulas filled to the right and downwards in cell P1 are normally displayed as formulas

Actual behavior

After undo, the formula only displays the value but not the result. 2024_4_17 20_12_41 video.webm

Running environment

No response

system message

No response