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

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 3.9.0, 3.9.5
    • Fix Version/s: None
    • Component/s: None
    • Labels:
    • gh.sprint.customfield.default.name:
      Sprint 8

      Description

      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()

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated: