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 2010/04/23 12:02:10 UTC
DO NOT REPLY [Bug 49175] New: POI is reading the data incorrectly in
case the sheets were shifted
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
Summary: POI is reading the data incorrectly in case the sheets
were shifted
Product: POI
Version: 3.6
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: blocker
Priority: P2
Component: POI Overall
AssignedTo: dev@poi.apache.org
ReportedBy: amitkalemail@gmail.com
CC: amitkalemail@gmail.com
Hi , I am having workbook which has sheet1, sheet2 and sheet3 viz. If i add a
range01 inside sheet3 and shifts the sheet3 before sheet2 and try to read the
data from range01 it doesnt work correctly.
I am using AbortableHSSFListener to read the data from the range.
Please find the attached code for reference. Urgent help will be highly helpful
for us as its blocking issue for us.
--
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
amitkale <am...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
amitkale <am...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |INVALID
Severity|blocker |normal
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2011-06-24 10:22:50 UTC ---
Use high-level usermodel API and you will be good.
By using a low-level HSSFListener you are taking the burden of processing BIFF
records, it requires a good knowledge of the Excel BIFF8 format and in cases
like your it is not trivial. Spreadsheet usermodel API already does it for you,
just try.
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2010-04-24 13:00:51 EDT ---
Please attach the workbook and sample code to reproduce the problem.
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
amitkale <am...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--
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 49175] POI is reading the data incorrectly in case
the sheets were shifted
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49175
--- Comment #2 from amitkale <am...@gmail.com> 2010-04-26 03:01:02 EDT ---
Created an attachment (id=25351)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=25351)
The attached file contains the code snippet and input excel file
We are trying to read the header row from the range "Range_01" which is part of
"sheet2" . The expected output is header row of Range_01 while actual output is
the same row from different sheet (i.e. sheet1).
On debugging what we have obesrved is the sheetIndex associated with Range_01
is coming invalid. Please let us know how we can resolve this.
Thanks,
Amit
--
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