univer
univer copied to clipboard
[Bug] The ISERR function returns an error code when selecting an entire column or row.
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、使用ISERR/ISERROR/ISNA/ISTEXT函数(使用lsref参数选择行的时候返回#value) 2、value选择整行
Expected behavior
选择整行时返回#value!
Actual behavior
excel均返回为false
System information
No response
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Origin Title: [Bug] ISERR函数选择整列或者整行时会返回错误码
Title: [Bug] The ISERR function returns an error code when selecting an entire column or row.
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:
- Use the ISERR/ISERROR/ISNA/ISTEXT function (return #value when using the lsref parameter to select rows)
- Value selects the entire row
Expected behavior
Return #value when selecting entire row!
Actual behavior
excel returns false
System information
No response
- 整列在最新版Excel中显示 溢出(#SPILL!),无需修复 =ISERR(J:J) @oumomomo
- 整行在解析=ISERR(1:1)时,_generateAstNode 对整行解析错误 @DR-Univer
Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
- The entire column displays overflow (#SPILL!) in the latest version of Excel, no need to fix =ISERR(J:J) @oumomomo
- When the entire line is parsed =ISERR(1:1), _generateAstNode parses the entire line incorrectly @DR-Univer