Bug 7779 - Excel file created is not opening sometimes in Unix
Summary: Excel file created is not opening sometimes in Unix
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.0.2
Hardware: HP HP-UX
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-04-05 21:15 UTC by Naren
Modified: 2004-11-16 19:05 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Naren 2002-04-05 21:15:26 UTC
I am trying to create a Excel file .I pull some records from the data and put 
these records into a cell and create an excel file. The excel gets created 
properly and shows some 400kb .(approximatley i will be pulling 1000 records).
and this file is being mailed toa group of people and when we try to open the 
file, it doesnt open but there is data in the file. 
if we change the class file by deleting/adding some junk code and compile it 
and then run it. the excel file is created and is opened properly. if i try to 
run again with the same data..it doesnt open...can neone help me in solving 
thsi problem..
i dont think there is any problem with the code or with the data?
is there nething that is related to the jar files?
is there ne new set of jar files that are used to create an excel file.
Please help me in solving this?
Comment 1 Andy Oliver 2002-04-06 01:37:33 UTC
Send samples of invalid worksheets to acoliver at apache dot org. 
Confidentiality is assured.  Secure methods of transmitting the data can be
arranged.  It would probably be most useful to see examples of ones you slightly
modified as well as their original unmodified (corrupt) version.

Also are you adding/modifying strings or numeric values?  (This could be a
problem with the static string record).

It would be far more helpful to know if this occurs with a build from CVS.  At
the very least with 1.4583.  (see downloads)  -- If you can help us trace this
down I'm confident we can fix it before the 1.5 release.
Comment 2 Naren 2002-04-08 14:05:16 UTC
Hi Andy,
I have sent you some sample along with valid and invalid worksheets.
I am trying to run the program continously...
Sometimes it workd fine and sometimes it doesnt .My name of the file is :


Has it got to do nething with the data or the no of records...

Please let me know.
Comment 3 Naren 2002-04-10 13:17:28 UTC
Hi Andy,
Thanks for the prompt reply.Actually i was using the old jar files and this is 
a known bug in the old jar files of poi. I have started using latest jakarta-
poi-1.1-dev.jar (ver 1.4583) jar files and log4j.jar.
This solved my problem.