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 2008/08/28 04:17:31 UTC
DO NOT REPLY [Bug 45698] New: LinkTable fails to read properly with
multiple EXTERNSHEET records
https://issues.apache.org/bugzilla/show_bug.cgi?id=45698
Summary: LinkTable fails to read properly with multiple
EXTERNSHEET records
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P4
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: josh@gildedtree.com
This bugzilla was created as a follow-on from:
http://www.nabble.com/Error-opening-a-Excel-File-tp19083161p19162369.html
The attached xls file has several EXTERNSHEET records present where single one
should have been written. POI throws an exception when attempting to read the
file:
Exception in thread "main" org.apache.poi.hssf.record.RecordFormatException:
Error reading bytes
at
org.apache.poi.hssf.record.RecordInputStream.nextRecord(RecordInputStream.java:115)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:123)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:246)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:169)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:151)
...
Excel (2007) opens the file without obvious error.
When the file is re-saved by Excel, POI read it without throwing an exception.
--
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 45698] LinkTable fails to read properly with
multiple EXTERNSHEET records
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45698
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-08-27 19:25:34 PST ---
Created an attachment (id=22488)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22488)
from http://www.nabble.com/file/p19162369/CRE_CODIFICATION.xls
--
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 45698] LinkTable fails to read properly with
multiple EXTERNSHEET records
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45698
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2008-08-27 20:11:45 PST ---
Fixed in svn r689704.
It looks like whatever application has written this sample file has written out
multiple ExternSheetRecords instead of multiple RefSubRecords within a single
ExternSheetRecord. When this unusual condition is detected, POI will now
combine the records into one (which is hopefully the right thing to do).
Junit added to make sure the observed RecordFormatException has been averted.
However, there are more problems concerning this file. Bug 45699 has been
opened to manage those.
--
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