Uploaded image for project: 'ZK Spreadsheet'
  1. ZK Spreadsheet
  2. ZSS-1398

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

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Unresolved
    • Icon: Normal 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()

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

              Created:
              Updated: