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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Normal
    • 5.9.0
    • 5.7.0
    • None
    • Security Level: Jimmy
    • None

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: