[Bug] The official website's import and export demo imported a table containing the sum calculation formula, and then clicked export. The saved excel calculation formula did not take effect and displayed 0.

[huijuanhu]

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

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

受影响的包和版本

0.4.1 0.4.2

复现链接

官网的导入导出demo，导入了一个表格包含求和计算公式，然后再点击导出，保存的excel打开计算公式不生效了，显示0。本地项目也会百分百复现

default.mp4

工作簿1.xlsx

预期行为

导出的表格公式应该现实正常

实际行为

导出的表格打开后公式显示异常，都为0

运行环境

Chrome

系统信息

System:
OS: macOS 13.3
CPU: (8) arm64 Apple M2
Memory: 120.31 MB / 16.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 18.18.2 - ~/Documents/appsoft/node-v18.18.2-darwin-arm64/bin/node
Yarn: 1.22.19 - ~/node_modules/.bin/yarn
npm: 10.9.0 - ~/Documents/appsoft/node-v18.18.2-darwin-arm64/bin/npm
Browsers:
Chrome: 130.0.6723.91
Safari: 16.4

[univer-bot]

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

Origin Title: [Bug] 官网的导入导出demo导入了一个表格包含求和计算公式，然后再点击导出，保存的excel打开计算公式不生效了，显示0

Title: [Bug] The official website's import and export demo imported a table containing the sum calculation formula, and then clicked export. The saved excel calculation formula did not take effect and displayed 0.

---

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

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

Affected packages and versions

0.4.1 0.4.2

Recurrence link

Import and export demo on the official website, I imported a table containing the sum calculation formula, and then clicked export. The saved excel calculation formula did not take effect. Displays 0. Local projects will also be 100% reproducible

default.mp4

Workbook 1.xlsx

Expected behavior

The exported table formula should be realistic and normal

Actual behavior

After the exported table is opened, the formulas display abnormally and are all 0.

Running environment

Chrome

System information

System:
OS: macOS 13.3
CPU: (8) arm64 Apple M2
Memory: 120.31 MB / 16.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 18.18.2 - ~/Documents/appsoft/node-v18.18.2-darwin-arm64/bin/node
Yarn: 1.22.19 - ~/node_modules/.bin/yarn
npm: 10.9.0 - ~/Documents/appsoft/node-v18.18.2-darwin-arm64/bin/npm
Browsers:
Chrome: 130.0.6723.91
Safari: 16.4

[Dushusir]

@vanijin Please help check first

[vanijin]

wps没有自动触发公式计算，可以点击 "Formulas" -> "recalculate workbook" 手动触发一次

[univer-bot]

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

WPS does not automatically trigger formula calculation. You can click "Formulas" -> "recalculate workbook" to trigger it manually.