https://bz.apache.org/bugzilla/show_bug.cgi?id=35125
--- Comment #4 from Sangeetha <[email protected]> --- Hi Yegor Kozlov, I need to custom filter the value of a column(based on one of the value of the column) after applying the auto-filter. The below method helps me to apply autofilter for the columns A3 through E3 sheet.setAutoFilter(CellRangeAddress.valueOf("A3:E3")); But if I use the same method for custom filtering, like below. It doesn't work. In this case, I want to filter the rows for the value of column E3 as "Near End" sheet.setAutoFilter(CellRangeAddress.valueOf("E3:Near End")); It did not work and throws - java.lang.IllegalArgumentException error. I tried to use the HSSFAutoFilter class like below, with method 'equals'. It also did not work. HSSFAutoFilter autofilter; autofilter = sheet.setAutoFilter(CellRangeAddress.valueOf("E3")); autofilter.equals("Near End"); Is the custom filtering supported in HSSFAutoFilter for HSSFSheet? If not supported now, when it will be available. I am using the poi 3.15 JAR files. Is there any other way for this. Please provide information on this. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
