Evaluate a named range as a single value

XMLWordPrintable

    • Type: New Feature
    • Resolution: Fixed
    • Priority: Normal
    • 5.7.0
    • Affects Version/s: None
    • Component/s: None
    • Security Level: Jimmy
    • None
    • None

      Steps to Reproduce

      1. load formulaNamedRange.xlsx file
      2. check B7

      Current Result

      #VALUE

      Expected Result

      it's A

      Debug Information

      • The named range condition_result, contains a 2 cells reference B2:C2
      • Excel can evaluate a named range as a single value
      • keikai-376.xlsx is a user case

      Workaround

      • change B2:C2 to 1 cell, B2

        1. formulaNamedRange.xlsx
          9 kB
        2. keikai-376.xlsx
          12 kB

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

              Created:
              Updated:
              Resolved: