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/04/02 11:12:50 UTC

DO NOT REPLY [Bug 44739] New: Unable to construct record instance. java. lang.IllegalArgumentException: invalid cell range (9, -1, 1, 1

https://issues.apache.org/bugzilla/show_bug.cgi?id=44739

           Summary: Unable to construct record instance.
                    java.lang.IllegalArgumentException: invalid cell range
                    (9, -1, 1, 1
           Product: POI
           Version: 3.0-dev
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: blocker
          Priority: P1
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: mrlal_tvm@yahoo.com


This file doest open in release 'poi-3.0.3-alpha1-20080401.jar' and latest..

Following is the error thrown.


org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance
        at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:206)
        at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:124)
        at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:204)
        at TestUserHome.main(TestUserHome.java:37)
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:194)
        ... 3 more
Caused by: java.lang.IllegalArgumentException: invalid cell range (9, -1, 1, 1)
        at org.apache.poi.hssf.record.cf.CellRange.<init>(CellRange.java:56)
        at
org.apache.poi.hssf.record.CFHeaderRecord.fillFields(CFHeaderRecord.java:66)
        at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
        at
org.apache.poi.hssf.record.CFHeaderRecord.<init>(CFHeaderRecord.java:54)
        ... 8 more


-- 
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 44739] Unable to construct record instance. java.lang. IllegalArgumentException: invalid cell range (9, -1, 1, 1

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44739


Lal M.R <mr...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |ASSIGNED




--- Comment #3 from Lal M.R <mr...@yahoo.com>  2008-04-02 22:04:11 PST ---
I have attached the excel file


-- 
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 44739] Unable to construct record instance. java.lang. IllegalArgumentException: invalid cell range (9, -1, 1, 1

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44739





--- Comment #2 from Lal M.R <mr...@yahoo.com>  2008-04-02 22:02:51 PST ---
Created an attachment (id=21773)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=21773)
Invalid Range Excel File

Invalid Range Excel File


-- 
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 44739] Unable to construct record instance. java.lang. IllegalArgumentException: invalid cell range (9, -1, 1, 1

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44739


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|ASSIGNED                    |RESOLVED
         Resolution|                            |FIXED




--- Comment #4 from Josh Micich <jo...@gildedtree.com>  2008-04-03 13:55:05 PST ---
Fixed in svn r644473.

CellRange used to assume that ranges like "C:C" were possible, but C10:C65536
were not.  Actually, firstRow and lastRow can have any value between 0 and
65535 so ranges like C40000:C50000 should also be supported.

Both these problems were fixed.

The supplied test XLS file seems to read OK in Excel after being re-serialised
by POI.   (This is not to be taken for granted. See ongoing work for bug 30311)


-- 
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 44739] Unable to construct record instance. java.lang. IllegalArgumentException: invalid cell range (9, -1, 1, 1

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44739


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2008-04-02 08:22:23 PST ---
Please upload an example spreadsheet that shows this bug


-- 
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