Bug 15151 - comments in source Excel causes unreadable output
Summary: comments in source Excel causes unreadable output
Status: RESOLVED FIXED
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: PC All
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2002-12-06 22:11 UTC by Xiaocun Xu
Modified: 2019-06-01 06:50 UTC (History)
0 users


Attachments
Excel with comments (21.00 KB, application/octet-stream)
2002-12-06 22:14 UTC, Xiaocun Xu 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Xiaocun Xu 2002-12-06 22:11:49 UTC 
Test with HSSF.main() using 2 arguments produced an unreadable output
Feature tested:
     * given 2 arguments where the first is an input filename and the second
     * an output filename (not write), attempts to fully read in the
     * spreadsheet and fully write it out.
My source XLS had comments, size 21KB; HSSF produces an output of 7KB and 
unreadable by Excel.  I suspected comments might be the problem.  Deleted the 
comments and try again, open output in Excel gives error information might be 
missing.  Finally removed the entire column that had the cell with comment, 
then the output open in Excel fine.
Comment 1 Xiaocun Xu 2002-12-06 22:14:11 UTC 
Created attachment 4073 [details]
Excel with comments
Comment 2 Andy Oliver 2003-07-24 14:01:53 UTC 
probably won't implement comments until 3.0
Comment 3 Jason Height 2004-10-13 03:42:48 UTC 
Whilst comments are not implemented, this bug dealt with corruption of a sheet
with comments embedded.

The current version of head will read and then write the file without error.