[Bug] Divergent Error Handling in Excel vs Univer: Blank Cell Multiplication Scenarios Lead to Inconsistent Conditional Logic Results

[wang2lang]

Before you submit this issue, have you checked the following

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

0.6.6

Reproduction link

【BUG】单元格由公式计算输出结果为空 ≠ 空白单元格.xlsx
The formula in cell D4, IFERROR(B4*C4, ""), outputs an empty string when an error occurs. When cell E4 references column D for calculation, the result of B4*D4 is incorrect. Normally, multiplying a number with a blank cell should not output 0, but Univer does not distinguish between these scenarios—B4*D4 still returns 0. Consequently, when performing conditional logic judgments based on such scenarios, the results differ entirely from Excel's behavior.

Expected behavior

#VALUE!

Actual behavior

0

System information

System:
OS: macOS 15.3.2
CPU: (8) arm64 Apple M1 Pro
Memory: 72.52 MB / 16.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 20.9.0 - ~/.nvm/versions/node/v20.9.0/bin/node
Yarn: 1.22.19 - ~/.volta/bin/yarn
npm: 10.1.0 - ~/.nvm/versions/node/v20.9.0/bin/npm
pnpm: 10.5.2 - ~/.nvm/versions/node/v20.9.0/bin/pnpm
bun: 0.6.7 - ~/.bun/bin/bun
Browsers:
Chrome: 134.0.6998.118
Safari: 18.3.1

[univer-bot]

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

Origin Title: [Bug] Divergent Error Handling in Excel vs Univer: Blank Cell Multiplication Scenarios Lead to Inconsistent Conditional Logic Results

Title: [Bug] Divergent Error Handling in Excel vs Univer: Blank Cell Multiplication Scenarios Lead to Inconsistent Conditional Logic Results

---

Before you submit this issue, have you checked the following

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

0.6.6

Reproduction link

【BUG】单元格由公式计算输出结果为空 ≠ 空白单元格.xlsx
The formula in cell D4, IFERROR(B4*C4, ""), outputs an empty string when an error occurs. When cell E4 references column D for calculation, the result of B4*D4 is incorrect. Normally, multiplying a number with a blank cell should not output 0, but Univer does not distinguish between these scenarios—B4*D4 still returns 0. Consequently, when performing conditional logic judgments based on such scenarios, the results differ entirely from Excel's behavior.

Expected behavior

#VALUE!

Actual behavior

0

System information

System:
OS: macOS 15.3.2
CPU: (8) arm64 Apple M1 Pro
Memory: 72.52 MB / 16.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 20.9.0 - ~/.nvm/versions/node/v20.9.0/bin/node
Yarn: 1.22.19 - ~/.volta/bin/yarn
npm: 10.1.0 - ~/.nvm/versions/node/v20.9.0/bin/npm
pnpm: 10.5.2 - ~/.nvm/versions/node/v20.9.0/bin/pnpm
bun: 0.6.7 - ~/.bun/bin/bun
Browsers:
Chrome: 134.0.6998.118
Safari: 18.3.1