-
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