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

color filter causes null pointer exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Normal
    • 3.9.6
    • 3.9.5
    • None

    Description

      Steps to Reproduce

      1. load the file
      2. select color filter on the 3rd column

      Current Result

      null pointer exception

      SEVERE:
      java.lang.NullPointerException
      at org.zkoss.zss.range.impl.AutoFilterHelper._match(AutoFilterHelper.java:629)
      at org.zkoss.zss.range.impl.AutoFilterHelper._filterByColor(AutoFilterHelper.java:655)
      at org.zkoss.zss.range.impl.AutoFilterHelper.enableAutoFilter0(AutoFilterHelper.java:799)
      at org.zkoss.zss.range.impl.AutoFilterHelper.enableAutoFilter(AutoFilterHelper.java:165)
      at org.zkoss.zss.range.impl.RangeImpl$45.invoke(RangeImpl.java:1649)
      at org.zkoss.zss.model.util.ReadWriteTask.doInWriteLock(ReadWriteTask.java:43)
      at org.zkoss.zss.range.impl.RangeImpl.enableAutoFilter(RangeImpl.java:1654)
      at org.zkoss.zss.ui.au.in.AutoFilterDefaultHandler.applyFilter(AutoFilterDefaultHandler.java:712)
      at org.zkoss.zss.ui.au.in.FilterCommand.process(FilterCommand.java:49)
      at org.zkoss.zss.ui.Spreadsheet.service(Spreadsheet.java:6161)

      Expected Result

      color filter is disabled (in Excel), since those cells are all blank

      Attachments

        1. disabledColorFilter.png
          30 kB
          hawk
        2. filter.xlsx
          11 kB
          hawk

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: