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 2007/02/06 01:19:02 UTC

DO NOT REPLY [Bug 41546] New: - because of "Unable to construct record instance" can not load a xls file

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546

           Summary: because of "Unable to construct record instance" can not
                    load a xls file
           Product: POI
           Version: 3.0-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: critical
          Priority: P5
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: gjx1108@yahoo.co.jp


HI, dear POI dev team.

I'v got a VERY VERY SIMPLE AND EMPTY Excel file, ONLY ONE sheet and NOTHING in 
the sheet.(I do not known how the excel file was be created,It just come from 
my customer),
And when I use new HSSFWorkbook(fs) , it will threw a exception:
(but poi2.5 will WORK FINE with my poor excel files.)
----------------------------------------
org.apache.poi.hssf.record.RecordFactory.createRecord() RecordFactory.java:189
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents() 
HSSFEventFactory.java:174
org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents() 
HSSFEventFactory.java:101

org.apache.poi.hssf.record.RecordFormatException: Unable to construct record 
instance 
----------------------------------------

And when I ues the newest poi-source-3.0-alpha3-20070205.zip try to finding the 
error point,I got the following infomation:

---------------------------------------
In method of Pta.createPtg(RecordInputStream in) 
   when switch (id), the id was -59 ,so it goto default :
   and 
   throw new java.lang.UnsupportedOperationException(" Unknown Ptg in Formula: 
0x"+Integer.toHexString(( int ) id) + " (" + ( int ) id + ")");

how can i upload my poor excel file?

your laoguo

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41546] - because of "Unable to construct record instance" can not load a xls file

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546





------- Additional Comments From gjx1108@yahoo.co.jp  2007-02-05 16:22 -------
Created an attachment (id=19523)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=19523&action=view)
only one sheet ,and nothing in the sheet.of cause no any macro.


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41546] - because of "Unable to construct record instance" can not load a xls file

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546





------- Additional Comments From benelux@email.plala.or.jp  2007-06-15 07:55 -------
the name definition (named range) causes this problem. 

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


DO NOT REPLY [Bug 41546] - because of "Unable to construct record instance" can not load a xls file

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546





------- Additional Comments From ajaygautam@yahoo.com  2007-02-21 16:32 -------
Created an attachment (id=19623)
 --> (http://issues.apache.org/bugzilla/attachment.cgi?id=19623&action=view)
Stacktrace of the issue


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41546] - because of "Unable to construct record instance" can not load a xls file

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546





------- Additional Comments From gjx1108@yahoo.co.jp  2007-02-05 16:22 -------
HI, I HAVE UPLOAD MY POOL EXCEL FILE NAMED  1.xls.
thanks first.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


DO NOT REPLY [Bug 41546] - because of "Unable to construct record instance" can not load a xls file

Posted by bu...@apache.org.
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=41546>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=41546


ajaygautam@yahoo.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ajaygautam@yahoo.com




------- Additional Comments From ajaygautam@yahoo.com  2007-02-21 16:30 -------
Same issue here!
MY xls file is not as simple as 1.xls. Its a real world xls file. (Let me know
if you would like me to attach it).

Just upgraded my java app to poi-3.0-alpha3-20061212
This file used to work in poi-final-2.5.1

I will attach the stacktrace.


-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/