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

reduce the time of clearing cells referenced by INDEX


    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Major Major
    • 6.0.0
    • None
    • None
    • Security Level: Jimmy

      Steps to reproduce

      1. run the zul with the file
      2. click the button to clear the content of 200 cells

      Current result

      take around 1700ms

      Expected result

      reduce the time

      Debug info

      • in "output" sheet, all cells contain =INDEX(input!$A$1:$J$200, 1, 1), keikai think its precedent is a big range A1:J200. But actually, only 1 cell change affects the cells in "output" sheet
      • In the real case, the sheet contains lots of such cases with long dependent relationships, so every clearing produces lots of unnecessary dependents.
        Check keikai-675-sampler-snapshot.nps
      • the user's real case takes 7~13s

        1. index-performance.xlsx
          20 kB
        2. keikai-675.png
          134 kB
        3. keikai-675.zul
          0.6 kB
        4. keikai-675-sampler-snapshot.nps
          4 kB

            jumperchen jumperchen
            hawk hawk
            0 Vote for this issue
            2 Start watching this issue