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 2004/01/13 16:31:49 UTC

DO NOT REPLY [Bug 26100] New: - 128-character message in IF statement cell causes HSSFWorkbook open failure

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

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=26100

128-character message in IF statement cell causes HSSFWorkbook open failure

           Summary: 128-character message in IF statement cell causes
                    HSSFWorkbook open failure
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Blocker
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: jun.zuo@mscsoftware.com


In version 2.0 (2.0-RC2) but not 1.5.1, if a cell contains an IF statement that 
has a message longer than 127 characters, the following error occurs:

java.lang.reflect.InvocationTargetException: 
java.lang.IllegalArgumentException: Illegal length
	at org.apache.poi.util.StringUtil.getFromUnicode(StringUtil.java:170)
	at org.apache.poi.hssf.record.formula.StringPtg.<init>
(StringPtg.java:92)
	at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:272)
	at org.apache.poi.hssf.record.FormulaRecord.getParsedExpressionTokens
(FormulaRecord.java:181)
	at org.apache.poi.hssf.record.FormulaRecord.fillFields
(FormulaRecord.java:157)
	at org.apache.poi.hssf.record.Record.fillFields(Record.java:127)
	at org.apache.poi.hssf.record.Record.<init>(Record.java:92)
	at org.apache.poi.hssf.record.FormulaRecord.<init>
(FormulaRecord.java:122)
	at java.lang.reflect.Constructor.newInstance(Native Method)
	at org.apache.poi.hssf.record.RecordFactory.createRecord
(RecordFactory.java:257)
	at org.apache.poi.hssf.record.RecordFactory.createRecords
(RecordFactory.java:193)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:207)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:254)
	at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>
(HSSFWorkbook.java:235)

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