I would recommend filing a bug report in bugzilla and attach the xls that is causing the error. In the bug report, could you mention how you generated the file (MS Excel/ OpenOffice / POI etc.)?
Here's the link to filing the bug report: http://issues.apache.org/bugzilla/enter_bug.cgi?product=POI Regards, ~ amol > -----Original Message----- > From: Philip Mailinglist [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 31, 2005 2:05 AM > To: POI Users List > Subject: Re: Compatibility issue reading excel file? > > > Hi Amol > I tried the alpha, but alas, same result: > > java.lang.IllegalArgumentException: Start and end index not in range. > at > org.apache.poi.hssf.usermodel.HSSFRichTextString.applyFont(HSS > FRichTextString.java:61) > at > org.apache.poi.hssf.record.TextObjectRecord.processFontRuns(Te > xtObjectRecord.java:148) > at > org.apache.poi.hssf.record.TextObjectRecord.processContinueRec > ord(TextObjectRecord.java:131) > at > org.apache.poi.hssf.record.RecordFactory.createRecords(RecordF > actory.java:199) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook > .java:183) > at > org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook > .java:152) > at org.apache.poi.hssf.dev.HSSF.<init>(HSSF.java:67) > at > net.instadia.datamining.ResultFormatterXLS.main(ResultFormatte > rXLS.java:546) > > And my code is REALLY simple: > > public static void main(String args[]) { > try { > String a[]=new String[2]; > a[0]="/tmp/Custom Report example.xls"; > a[1]="/tmp/res2.xls"; > HSSF.main(a); > } catch (IllegalArgumentException e) { > e.printStackTrace(); > } > } > > This file is a valid Excel file, that opens just fine in oocalc, > gnumeric and excel 2003. > > /Philip > > > Amol Deshmukh wrote: > > >Philip, > > > >Can you try building the latest version from the source? > >As I understand, the RichTextString functionality has > >undergone some major changes in the latest source. > > > >Else you could try the 3.0alpha build in the path on a mirror > >site. The relative path on a mirror site is: > > > >/apache/jakarta/poi/dev/bin/poi-bin-3.0-alpha1-20050704.tar.gz > > > > > >HTH, > >~ amol > > > > > > > >>-----Original Message----- > >>From: Philip Mailinglist [mailto:[EMAIL PROTECTED] > >>Sent: Tuesday, August 30, 2005 9:39 AM > >>To: [email protected] > >>Subject: Compatibility issue reading excel file? > >> > >> > >>Hi, > >> > >>I've been using poi for writing hssf with great success. Now I'm > >>starting to read and modify spreadsheets and I get into trouble. On > >>debian package POI version 1.1 it complains but works, but > >>entire rows > >>disappear from the dataset. > >>Then I downloaded 2.51-FINAL from the web site but it refuses > >>entirely > >>to load my document. > >> > >>java.lang.IllegalArgumentException: Start and end index not > in range. > >> at > >>org.apache.poi.hssf.usermodel.HSSFRichTextString.applyFont(HSS > >>FRichTextString.java:61) > >> at > >>org.apache.poi.hssf.record.TextObjectRecord.processFontRuns(Te > >>xtObjectRecord.java:148) > >> at > >>org.apache.poi.hssf.record.TextObjectRecord.processContinueRec > >>ord(TextObjectRecord.java:131) > >> at > >>org.apache.poi.hssf.record.RecordFactory.createRecords(RecordF > >>actory.java:188) > >> at > >>org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook > >>.java:163) > >> at > >>org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook > >>.java:130) > >> at org.apache.poi.hssf.dev.HSSF.<init>(HSSF.java:67) > >> at > >>net.instadia.datamining.ResultFormatterXLS.main(ResultFormatte > >>rXLS.java:546) > >> > >>I do not know what to do next. Any suggestions? > >> > >>/Philip > >> > >>------------------------------------------------------------ > --------- > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>Mailing List: http://jakarta.apache.org/site/mail2.html#poi > >>The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > >> > >> > >> > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >Mailing List: http://jakarta.apache.org/site/mail2.html#poi > >The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > Mailing List: http://jakarta.apache.org/site/mail2.html#poi > The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
