-
New Feature
-
Resolution: Unresolved
-
Normal
-
None
-
3.9.0, 3.9.5
-
None
-
Sprint 8
Steps to Reproduce
1. start zss test
http://localhost:8080/zss.test/issue.zul?file=/book/zss-1398.xlsx
2. select the 7th sheet
Current Result
Check developer tool/Network tab/Timing/request waiting time:
onSheetSelect takes 8.45s
onZSSFetchActiveRange takes 13.25s
Expected Result
shorter than 3s
Debug Information
- since =SUMIF(dataSource!A:A,">160000",dataSource!B:B) references a whole column, ZSS will evaluate 65565 cells for the column
Test Case
org.zkoss.zss.api.impl.formula.FormulaPerformanceTest.wholeColumnRange()