univer icon indicating copy to clipboard operation
univer copied to clipboard

[Bug] The ISERR function returns an error code when selecting an entire column or row.

Open oumomomo opened this issue 10 months ago • 1 comments

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! image

Actual behavior

excel均返回为false image

System information

No response

oumomomo avatar Apr 22 '24 03:04 oumomomo

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:

  1. Use the ISERR/ISERROR/ISNA/ISTEXT function (return #value when using the lsref parameter to select rows)
  2. Value selects the entire row

Expected behavior

Return #value when selecting entire row! image

Actual behavior

excel returns false image

System information

No response

univer-bot[bot] avatar Apr 22 '24 03:04 univer-bot[bot]

  1. 整列在最新版Excel中显示 溢出(#SPILL!),无需修复 =ISERR(J:J) @oumomomo
  2. 整行在解析=ISERR(1:1)时,_generateAstNode 对整行解析错误 @DR-Univer image

Dushusir avatar Jun 07 '24 10:06 Dushusir

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

  1. The entire column displays overflow (#SPILL!) in the latest version of Excel, no need to fix =ISERR(J:J) @oumomomo
  2. When the entire line is parsed =ISERR(1:1), _generateAstNode parses the entire line incorrectly @DR-Univer image

univer-bot[bot] avatar Jun 07 '24 10:06 univer-bot[bot]