calling getEvaluatedDependents() twice for 1 cell value change

XMLWordPrintable

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: 5.10.0
    • Component/s: None
    • None

      Steps to Reproduce

      1. import dependents.xlsx
      2. select "overlapped" sheet
      3. set a breakpoint at DependencyTableEx.getEvaluatedDependents()
      4. change A1 to a different value by Range.setCellEditText()

      Current Result

      during the method calls, keikai call getEvaluatedDependents() twice for the same cell. It looks redundant.

      Expected Result

      call getEvaluatedDependents()

      Debug Information

      • print dependents in DependencyTableEx.getEvaluatedDependents() with results.stream().forEach(System.out::println)
      • it seems we can improve the performance by reusing the collected dependents. Because in some cases, getting a cell's dependents is the performance bottleneck.

      A real use case

      a cell has 10k dependents takes a long time to update

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

              Created:
              Updated: