excel comment

[tom burt <to...@briefcasesystems.com>]

I am using the org.apache.poi.ss classes and version 3.8.  In my app the user 
submits excel file (xls or xlsx) to web site where it is editted with errors 
documented in cell comments and then returned to user.  When using an xlsx 
file the comments show correctly when file first returned to user.  If saved 
and then reopened, the backgound for the comment is gone but comment text 
still shows. If file is then resubmitted to web the app does a  
removecellcomment to get rid of all comment and adds new ones if any edits 
fail.  When file is returned this time, the comments have backgound of 
clockwise arrow.  The comment background works correctly in xls file and in 
xlsx file if orginal file has a comment.  This comment is removed during 
processing, but comment format continues to work.

Looking for suggestion on how to get the comment format in xlsx to be retained 
when first comment is added via poi instead of added prior to file be 
manipulated with poi.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org