Bug 15151 - comments in source Excel causes unreadable output
Summary: comments in source Excel causes unreadable output
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
Depends on:
Reported: 2002-12-06 22:11 UTC by Xiaocun Xu
Modified: 2019-06-01 06:50 UTC (History)
0 users

Excel with comments (21.00 KB, application/octet-stream)
2002-12-06 22:14 UTC, Xiaocun Xu

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.