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] SUBTOTA function (function number is 1, 2, etc.), if you select an error code + value in the box, it will return an error code #2018

Closed
2 tasks done
oumomomo opened this issue Apr 20, 2024 · 1 comment · Fixed by #2452
Assignees
Labels
bug Something isn't working scope:formula

Comments

@oumomomo
Copy link

oumomomo commented Apr 20, 2024

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

dev

Reproduction link

操作步骤:
1、输入subtota函数,函数编号选1或者其他
2、框选一个错误码+数值

Expected behavior

会返回数值

Actual behavior

返回错误码
univer:
企业微信截图_17135958606393
企业微信截图_17135958819982

excel
企业微信截图_17135959979732
企业微信截图_17135960179269

System information

No response

@oumomomo oumomomo added bug Something isn't working scope:formula labels Apr 20, 2024
@univer-bot univer-bot bot changed the title [Bug] SUBTOTA函数(函数编号为1、2等),框选一个错误码+数值会返回为错误码 [Bug] SUBTOTA function (function number is 1, 2, etc.), if you select an error code + value in the box, it will return an error code Apr 20, 2024
@univer-bot
Copy link

univer-bot bot commented Apr 20, 2024

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

Origin Title: [Bug] SUBTOTA函数(函数编号为1、2等),框选一个错误码+数值会返回为错误码

Title: [Bug] SUBTOTA function (function number is 1, 2, etc.), if you select an error code + value in the box, it will return an error code


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

dev

Reproduction link

Steps:

  1. Enter the subtota function and select 1 or other function number.
  2. Select an error code + value in the box

Expected behavior

will return a value

Actual behavior

Return error code
universal:
Enterprise WeChat screenshot_17135958606393
Enterprise WeChat screenshot_17135958819982

excel
Enterprise WeChat screenshot_17135959979732
Enterprise WeChat screenshot_17135960179269

System information

No response

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

Successfully merging a pull request may close this issue.

3 participants