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

multiple SUMIF() with the same sum range takes longer calculation time

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.11.0
    • 5.10.0
    • None
    • Security Level: Jimmy

      Steps to Reproduce

      1. enter 1 in A1
      check au request timing > waiting for server response

      Current Result

      it takes over 1s

      Expected Result

      less than 500ms

      Debug Information

      • in Sumif. sumMatchingCells, keikai evaluates the sum range ($A$1:$A$2000) first. Since there are many SUMIF() in the sum range, so it recursively evaluates SUMIF() for hundreds of times. it takes time.
      • if we put the repeated formula SUMIF($B$1:$B$2000,">0",$A$1:$A$2000) into a separate cell and reference it, it will create a circular reference and can't produce a correct result because keikai doesn't support this.

      Workaround

        1. profile snapshot.png
          profile snapshot.png
          74 kB
        2. waiting.jpg
          waiting.jpg
          12 kB
        3. keikai-614.xlsx
          16 kB

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

              Created:
              Updated:
              Resolved: