Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-475

INDEX() doesn't return #REF! when receiving a non-existed cell address

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.9.0
    • 5.7.0
    • None
    • Security Level: Jimmy
    • 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.

            DevChu DevChu
            hawk hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: