You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/02/14 07:27:25 UTC
DO NOT REPLY [Bug 52660] New: Unable to detect auto filter applied
on excel sheet.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
Bug #: 52660
Summary: Unable to detect auto filter applied on excel sheet.
Product: POI
Version: 3.7
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: sushil.is.online@gmail.com
Classification: Unclassified
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52660] Unable to detect auto filter applied on
excel sheet.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
--- Comment #5 from Sushil Kumar <su...@gmail.com> 2012-02-14 08:32:36 UTC ---
Created attachment 28328
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28328
Java sample code
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52660] Unable to detect auto filter applied on
excel sheet.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
OS/Version| |All
--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> 2012-02-14 06:56:11 UTC ---
Please explain what is wrong with POI: post sample code you are using, what you
expect and what is the actual result.
Also, please try with the latest POI 3.8-beta5. Many bugs have been fixed
since POI-3.7, involving support for auto-filters.
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52660] Unable to detect auto filter applied on
excel sheet.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
--- Comment #1 from Sushil Kumar <su...@gmail.com> 2012-02-14 06:30:58 UTC ---
Created attachment 28326
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28326
test excel sheet with auto filter.
I have filtered some rows.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52660] Unable to detect auto filter applied on
excel sheet.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
--- Comment #4 from Sushil Kumar <su...@gmail.com> 2012-02-14 08:31:38 UTC ---
I am trying to read an excel file (attached) with filter. This excel contains
only one workbook. Without implementing any filter, following records will be
visible -
Age Name Class
1 qq fgh
2 qq fgh
3 as a
4 fr a
5 gf a
When we apply filter on workbook on Name column, and select "qq" as filter,
then following records will be visible-
Age Name Class
1 qq fgh
2 qq fgh
Now, when I am trying to read filtered excel sheet using Apache POI (version
3.7), then my code is able to read all 6 rows (including header). While my
understading was because sheet is filtered, only 3 recodrs should be read by
POI.
The sample code, I am usinf to read attached excel sheet is also attached.
Thanks
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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
DO NOT REPLY [Bug 52660] Unable to detect auto filter applied on
excel sheet.
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=52660
--- Comment #3 from Sushil Kumar <su...@gmail.com> 2012-02-14 08:30:42 UTC ---
Created attachment 28327
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28327
Testing excel sheet
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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