Bug 21278 - Unable to Add to Pre-Existing XLS
Summary: Unable to Add to Pre-Existing XLS
Status: RESOLVED DUPLICATE of bug 14824
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: Sun Solaris
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2003-07-02 15:00 UTC by Dennis Trask
Modified: 2004-11-16 19:05 UTC (History)
0 users

Input XLS File (Just an empty workbook) (13.50 KB, application/vnd.ms-excel)
2003-07-02 15:10 UTC, Dennis Trask
Code to open file and add data. (1.07 KB, text/plain)
2003-07-02 15:11 UTC, Dennis Trask
Resulting corrupted XLS (13.50 KB, application/vnd.ms-excel)
2003-07-02 15:12 UTC, Dennis Trask

Note You need to log in before you can comment on or make changes to this bug.
Description Dennis Trask 2003-07-02 15:00:07 UTC
Since POI-1.8, I have not been able to use POI to open an existing XLS or XLT 
and add data. When I open the resulting document, all cells are blank. However, 
if I view the file in a Hex viewer, such as Textpad, I see the new data in the 
file. Therefore, the resulting document must be corrupt.

I have example input, output, and code that I can forward, if interested.
Comment 1 Dennis Trask 2003-07-02 15:10:52 UTC
Created attachment 7058 [details]
Input XLS File (Just an empty workbook)
Comment 2 Dennis Trask 2003-07-02 15:11:50 UTC
Created attachment 7059 [details]
Code to open file and add data.
Comment 3 Dennis Trask 2003-07-02 15:12:21 UTC
Created attachment 7060 [details]
Resulting corrupted XLS
Comment 4 Dennis Trask 2003-07-02 15:14:28 UTC
Please note that I have attached said input, output, and code.
Comment 5 Dennis Trask 2003-07-14 17:18:00 UTC
This appears to be related (if not same) bug as reported by 14824. Marcin Nowak 
makes an interesting observation, which is, "There is simple workaround for 
this problem. Modify sheet in Excel putting (for example) one space into cell

I tried this workaround with success.

I suggest closing this bug in deference to 14824.
Comment 6 Andy Oliver 2003-07-24 17:01:11 UTC

*** This bug has been marked as a duplicate of 14824 ***