https://issues.apache.org/bugzilla/show_bug.cgi?id=52764
Bug #: 52764
Summary: Unmodified cell comments disappear after
HSSFWorkbook.write
Product: POI
Version: 3.8-dev
Platform: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Created attachment 28383
--> https://issues.apache.org/bugzilla/attachment.cgi?id=28383
Test program to reproduce bug.
Steps to reproduce bug (see attached test program):
1. load an existing .xls file that has comments on multiple cells into a
HSSFWorkbook
2. delete the comment from one of the cells and create a new comment on the
same cell. Do not touch any of the other cells containing comments.
3. write the HSSFWorkbook instance to a file.
4. the resulting file will only contain a single comment on the cell that we
modified. Any other previously existing comments disappeared into thin air.
The test program...
1. creates A1_B1_commented.xls in the current directory. In this file there is
a single sheet with comments on the A1 and B1 cells.
2. loads the created file again and creates a new comment for A1, then writes
the HSSFWorkbook to B1_comment_lost.xls
3. as the name suggests, the comment for B1 is gone (can be checked in
LibreOffice or Apache POI), though nobody ever touched it.
Tested on with the latest svn release (poi-3.8-beta6-20120225).
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
