-
Improvement
-
Resolution: Fixed
-
Major
-
None
-
None
-
Security Level: Jimmy
-
None
Steps to reproduce
- run the zul with the file
- 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
- relates to
-
KEIKAI-735 when specifying a cell address in the 2nd parameter of INDEX(), it doesn't get cell value update
- Closed