[Bug] When the SUBTLTAL function uses a number of 4, the calculation is incorrect when there is a value that is too long in the range.

[oumomomo]

Before you submit this issue, have you checked the following

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

Affected packages and versions

dev

Reproduction link

操作步骤 1、使用power函数 2、框选范围内有超长的数值 3、使用函数编号4

Expected behavior

有超长数值时不展示最大的值

Actual behavior

有超长数值时也会展示最大的值

System information

No response

[univer-bot[bot]]

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

Origin Title: [Bug] SUBTLTAL函数使用为4的编号时，范围内有数字过长的数值时计算有误

Title: [Bug] When the SUBTLTAL function uses a number of 4, the calculation is incorrect when there is a value that is too long in the range.

---

Before you submit this issue, have you checked the following

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

Affected packages and versions

dev

Reproduction link

Steps

1. Use the power function
2. There are extremely long values ​​​​in the box selection range.
3. Use function number 4

Expected behavior

Do not display the largest value when there is an overly long value

Actual behavior

When there is an extremely long value, the largest value will also be displayed.

System information

No response

[Dushusir]

Google Sheets 认为 16 位数字及以上是字符串

所以字符串不统计在内

我们认为 17 位以上数字是字符串，不做统计

目前参考 Google Sheets 做，如用户反馈，再行商讨

[univer-bot[bot]]

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

Google Sheets considers numbers 16 digits and above to be strings

So strings are not included in the statistics

We consider numbers above 17 digits to be strings and do not make statistics.

Currently, we refer to Google Sheets. If there is feedback from users, we will discuss it further.