poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 35125] implementing autofilter support
Date Tue, 03 May 2016 10:33:54 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=35125

--- Comment #4 from Sangeetha <sangeetha.chandran@nokia.com> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message