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.

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

[Bug]公式只输入符号无参数时预期报错,控制台有报错 #1415

Closed
2 tasks done
zhaolixin7 opened this issue Feb 22, 2024 · 5 comments · Fixed by #1444
Closed
2 tasks done

[Bug]公式只输入符号无参数时预期报错,控制台有报错 #1415

zhaolixin7 opened this issue Feb 22, 2024 · 5 comments · Fixed by #1444
Assignees
Labels
bug Something isn't working

Comments

@zhaolixin7
Copy link

zhaolixin7 commented Feb 22, 2024

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

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

受影响的包和版本

dev

###复现链接

case1、单元中直接输入=()
case2、单元格中输入=-或(<>等),然后选择单元格A1(A1单元格有内容如:数字2)

预期行为

case1、对齐google报错?
case2、可以计算出结果,等于-2

实际行为

1、显示为空且控制台有报错
2、单元格显示=A1-
image
2024_2_22 16_55_17 commands.json
2024_2_22 16_55_17 video.webm

运行环境

No response

系统信息

No response

@zhaolixin7 zhaolixin7 added the bug Something isn't working label Feb 22, 2024
@Issues-translate-bot
Copy link

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


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

dev

Recurrence link

case1, directly input =() in the unit
case2, enter =- in the cell, and then select cell A1 (cell A1 has content such as: number 2)

Expected behavior

Case 1. Align Google to report an error?
case2, the result can be calculated, which is equal to -2

Actual behavior

  1. The display is empty and there is an error in the console.
  2. Cell display =A1-
    image
    2024_2_22 16_55_17 commands.json
    2024_2_22 16_55_17 video.webm

Running environment

No response

system message

No response

@Dushusir
Copy link
Member

Dushusir commented Feb 22, 2024

公式输入:=INDEX((A6:B6,C6:D7),1,1,2),解析错误,一组范围用()包围起来
17086021514382

Excel 也支持 =SUM((A6:B6,C6:D7),1,1,2)

@Issues-translate-bot
Copy link

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


Formula input: =INDEX((A6:B6,C6:D7),1,1,2), parsing error, a range is surrounded by ()

Excel also supports =SUM((A6:B6,C6:D7),1,1,2)

@zhaolixin7
Copy link
Author

@DR-Univer 1、公式括号和计算符号组合计算错误
image
2、评论这个也未修复
image

@Issues-translate-bot
Copy link

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


@DR-Univer 1. The combination of formula brackets and calculation symbols is wrong in calculation
image
2. This comment has not been repaired.
image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants