Spreadsheet crashes when using autofilter with large amount of rows

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.8.0
    • Affects Version/s: 3.6.0
    • Component/s: 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

        1. autofilter.zip
          167 kB
        2. autofilter-crash.png
          autofilter-crash.png
          31 kB

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

              Created:
              Updated:
              Resolved: