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/04/01 14:29:17 UTC

DO NOT REPLY [Bug 28126] New: - reading files generated by SpreadCE 1.18 causes Exception.

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=28126>.
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=28126

reading files generated by SpreadCE 1.18 causes Exception.

           Summary: reading files generated by SpreadCE 1.18 causes
                    Exception.
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: julmadrid@ya.com


When I try to read excel files generated by SpreadCE 1.18 running under 
WindowsCE 2002 and WindowsCE 2003 I find two troubles:

1) org.apache.poi.hssf.record.agregate.ValueRecordsAgregate.construct(int,List) 
fail when org.apache.poi.hssf.record.LabelRecord are included in the agregate 
because the java.util.TreeMap need that the keys implement the Comparable 
interface and LabelRecord doesn't do.

2) If I try to resolve the previous trouble by implementing Comparable interface
in LabelRecord as it was implemented in other Record extended classes 
(LabelSSTRecord by example). When I do that,  
org.apache.poi.hssf.model.Sheet.convertLabelRecords(Workbook) can't replace 
LabelRecords included inside the ValueRecordsAgregate. This causes Exception in 
the org.apache.poi.hssf.usermodel.HSSFCell constructor because is unable to 
recognize the LabelRecord Type.

I resolve this by inserting code for convert from LabelRecord to LabelSSTRecord 
prior to Sheet generation in org.apache.poi.hssf.usermodel.HSSFWorkbook 
constructor instead of calling Sheet.convertLabelRecords() after Sheet 
generation.

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