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: [email protected] For additional commands, e-mail: [email protected]
