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

SUMPRODUCT() doesn't work as the previous version

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: 5.8.0.FL
    • Fix Version/s: 5.8.0
    • Component/s: None
    • Labels:
      None

      Description

      Steps to Reproduce

      1. import the attached file with 5.8.0.FL
      2. check E3

      Current Result

      #VALUE

      Expected Result

      11

      Debug Information

      1. keikai 5.7.0 and before can give the expected result. After fixing KEIKAI-479, keikai produces #VALUE
      2. keikai still doesn't support an array formula but since it works in single cell, we still need to keep this behavior for customers.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: