Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[Bug] When the formula result is equal to "0", no error message is expected #2194

Closed
2 tasks done
zhaolixin7 opened this issue May 8, 2024 · 1 comment · Fixed by #2206
Closed
2 tasks done

[Bug] When the formula result is equal to "0", no error message is expected #2194

zhaolixin7 opened this issue May 8, 2024 · 1 comment · Fixed by #2206
Assignees
@Dushusir
Labels
bug Something isn't working scope:formula

Comments

@zhaolixin7
Copy link

zhaolixin7 commented May 8, 2024 •
edited
Loading

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

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

受影响的包和版本

staging

复现链接

https://staging.univer.plus/?unit=CLN4Y8sWSNmHWOCrn96AxA&type=2&subunit=uni1
1、公式计算结果等于0，如截图
image
2、无公式只显示#REF!、 #N/A时查看单元格
image

预期行为

1、结果只显示0，无公式提示
2、只显示#REF!、 #N/A，无公式提示

实际行为

都有绿标提示
image

运行环境

No response

系统信息

No response
@zhaolixin7 zhaolixin7 added bug Something isn't working scope:formula labels May 8, 2024
@univer-bot
Copy link

univer-bot bot commented May 8, 2024 •
edited
Loading

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

Origin Title: [Bug] 公式结果等于“0"时，预期无错误提示

Title: [Bug] When the formula result is equal to "0", no error message is expected

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

staging

Recurrence link

https://staging.univer.plus/?unit=CLN4Y8sWSNmHWOCrn96AxA&type=2&subunit=uni1

  1. The formula calculation result is equal to 0, as shown in the screenshot
    image
  2. When there is no formula, only #REF! and #N/A are displayed when viewing the cell.
    image

Expected behavior

  1. The result only displays 0, and there is no formula prompt.
  2. Only #REF!, #N/A are displayed, and there is no formula prompt.

Actual behavior

There are green labels
image

Running environment

No response

system message

No response

@univer-bot univer-bot bot changed the title [Bug] 公式结果等于“0"时，预期无错误提示 [Bug] When the formula result is equal to "0", no error message is expected May 8, 2024
@Dushusir Dushusir mentioned this issue May 10, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Dushusir Dushusir

Labels
bug Something isn't working scope:formula
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

fix(formula): formula string results are displayed as regular strings dream-num/univer
3 participants
@Dushusir @DR-Univer @zhaolixin7