Matthias,
Which version of POI are you using?
If you havent done so yet, could you:
1. Try building from the latest source and see
what results you get?
2. If that doesnt work, please attach the excel
to a bug report (if its a big file, you could
upload the smallest file that exhibits the bug)
Regards,
~ amol
> -----Original Message-----
> From: Matthias Pigulla [mailto:mp@webfactory.de]
> Sent: Wednesday, September 21, 2005 9:58 AM
> To: poi-dev@jakarta.apache.org
> Subject: HSSF breaks text in cells - known problem?
>
>
> Hi POI developers,
>
> I'm stuck with a little issue where I want to update
a few cells of an
> (admittedly not trivial) Excel workbook using the
HSSF package.
>
> Unfortunately, already the simple case of
>
> FileInputStream inFile = new
FileInputStream(args[0]);
> POIFSFileSystem fs = new POIFSFileSystem(inFile);
> HSSFWorkbook wb = new HSSFWorkbook(fs);
> FileOutputStream outFile = new
FileOutputStream(args[1]);
> wb.write(outFile);
> outFile.close();
>
> breaks the workbook: It seems as if all cells
containing text are
> corrupted; all texts will be prefixed with a 0xFF
byte and
> truncated by
> one byte on their right, that is, they all lose
their last character.
> Apart from that, everything seems to be fine.
>
> Trying to narrow possible causes, I found that
removing a
> certain set of
> worksheets stops the problem from appearing; copying
them to another
> workbook still lets them work on their own. So this
is nothing I could
> attribute to a special cell value, sheet or
whatever... :(
>
> Unfortunately, I have only little experience with
java and don't have
> the tools at hand to look into this myself - yet.
>
> If the problem sounds familiar (i. e. a common one
or a known bug),
> please let me know; maybe a workaround exists.
>
> If not, I will do my best to look into it as good as
I can and file a
> bug report.
>
> Best regards,
> Matthias
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/
|