XLOOKUP formula error after import and export

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 6.0.0
    • Affects Version/s: None
    • Component/s: None
    • None
    • None

      Steps to Reproduce

      import and export attached file.

      Current Result

      D1 show "#NAME?"

      Expected Result

      D1 show "1"

      Debug Information

      missing "_xlfn." in "_xlfn.XLOOKUP"

        1. keikai-734.xlsx
          9 kB

            Assignee:
            DevChu
            Reporter:
            DevChu
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: