reduce the time to evaluate a formula that references a whole column

XMLWordPrintable

    • Type: New Feature
    • Resolution: Unresolved
    • Priority: Normal
    • None
    • Affects Version/s: 3.9.0, 3.9.5
    • Component/s: 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()

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

              Created:
              Updated: