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

Spreadsheet crashes when using autofilter with large amount of rows

XMLWordPrintable

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

      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

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

              Created:
              Updated:
              Resolved: