-
Bug
-
Resolution: Fixed
-
Normal
-
5.7.0
-
None
-
Security Level: Jimmy
-
None
-
None
Steps to Reproduce
1. enter =INDEX(NoSuchSheet!A1:A2, 1) at A1
2. check the result
Current Result
#ERROR!
Expected Result
#REF! like Excel
Debug Information
- Current behavior throw runtime exception instead of return an ErrorEval, the exception will break formula evaluation. If there is another function enclosing INDEX() or referencing the result of INDEX(). It looks like returning an ErrorEval is the same behavior like Excel.
- if we pass this index() result to IFERROR(A1, "error"), Excel will return "error" but keikai will get #ERROR!
- According to Error.xlsx, it looks like Excel returns an error code when any argument is error.