[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    =?iso-8859-1?B?UmU6IFJlOiB1bmFibGUgdG8gb3BlbiBIU1NGIChnZW5lcmF0ZWQpIGV4Y2VsIGZpbGU=?=
From:       "=?iso-8859-1?B?QXZpayBTZW5ndXB0YQ==?=" <avik.sengupta () itellix ! com>
Date:       2003-10-31 7:25:39
[Download RAW message or body]

[Attachment #2 (text/plain)]


When you say latest CVS, are you sure you got the REL_2_BRANCH rather than HEAD. If \
not, please do. It looks very much like our old &quot;too many strings&quot; bug, \
which has been fixed. If that doesnt work, add in the txt and java files to bugzilla \
as a new bug. 

Regards
-
Avik


   -------Original Message-------
   &gt; From: Tom &lt;dist_mec@hotmail.com&gt;
   &gt; Subject: Re: unable to open HSSF (generated) excel file
   &gt; Sent: 31 Oct 2003 04:53:19
   &gt;
   &gt;  using  poi-bin-2.0-pre3-20030728
   &gt;  platforms- win2k and solaris.
   &gt;  
   &gt;  our application queries a DB user-log table  and generates a workbook sheet \
that contains 3 columns (plus some header columns). the 3 columns are \
&quot;username&quot; &quot;login-time&quot; and &quot;logout-time&quot; all cell \
values are writted out as strings. in some cases the workbook generated will not open \
in MS-Excel 2000. i wrote a test pgm that can recreate the problem consistently, \
using the the data from the DB exported into a flat file. the test pgm simply reads \
the file and writes to a workbook.  &gt;  
   &gt;  i have noticed that this seems to depend on size. if i run this for records \
for the current month only, the report is generated correctly. if i run it for the \
whole year, i am unable to open the file.  &gt;  
   &gt;  i noticed a similar thread in the list and as per the resolution note, i \
checked out the latest code from CVS today morning and tried re-running the test pgm \
with the latest jars but i get the following exception  &gt;  \
java.lang.ArrayIndexOutOfBoundsException  &gt;  at \
org.apache.poi.util.LittleEndian.putNumber(LittleEndian.java:549)  &gt;  at \
org.apache.poi.util.LittleEndian.putShort(LittleEndian.java:282)  &gt;  at \
org.apache.poi.hssf.record.RowRecord.serialize(RowRecord.java:465)  &gt;  at \
org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serializeRowBlock(RowRecordsAggregate.java:244)
  &gt;  at org.apache.poi.hssf.record.aggregates.RowRecordsAggregate.serialize(RowRecordsAggregate.java:275)
  &gt;  at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java:734)
   &gt;  at org.apache.poi.hssf.usermodel.HSSFWorkbook.getBytes(HSSFWorkbook.java:787)
  &gt;  at org.apache.poi.hssf.usermodel.HSSFWorkbook.write(HSSFWorkbook.java:731)
   &gt;  at src.ReadWriteWorkbook.main(ReadWriteWorkbook.java:61)
   &gt;  Exception in thread &quot;main&quot;
   &gt;  
   &gt;  i can send out the test pgm (which is fairly straight forward) and the input \
test file (cannot attach it as the zipped file size is abt 150k). can someone please \
help me with the problem?  &gt;  
   &gt;  note - if i try ms-excel 2002, i am able to open the file but i  get an \
error dialog saying &quot;errors detected in workbook, but ms excel was able to open \
it by making repairs listed below&quot; the repair log says that the repairs were not \
possible.  &gt;  
   &gt;  please let me know if i should open this as a bug or i should pose this to \
some other mailing list.  &gt;  
   &gt;  
   &gt;  thanks,
   -------Original Message-------



[prev in list] [next in list] [prev in thread] [next in thread]