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

Spreadsheet crashes when using autofilter with large amount of rows

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Normal
    • 3.8.0
    • 3.6.0
    • None
    • Security Level: Jean

    Description

      Problem Description

      Users try to use auto filter on a column with 25000 rows in an Excel file and encounter performance issue.

      Steps to Reproduce

      1. import and run attached maven project autofilter.zip
      2. click filter button to enable autofilter
      3. click dropdown list of a autofilter, uncheck all, only check "Daniel"

      Actual Result

      Browser crashes with no response.

      Related Information

      examples of implementing advanced filters in Apache POI that may be helpful:
      http://thinktibits.blogspot.com/2014/09/apache-poi-custom-filters-java-example.html
      http://thinktibits.blogspot.com/2014/09/Excel-auto-filter-criteria-Apache-POI-Example.html
      http://thinktibits.blogspot.com/2014/09/excel-auto-filter-cell-color-poi-java-example.html

      Attachments

        Issue Links

          Activity

            People

              Jenkins Jenkins
              hawk hawk
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: