Created attachment 24462 [details] Test case taken from Busy Developers Guide and Output XLSX The simple test case from the "Busy Developers Guide" to create Cell Comments in an XSSF workbook does not work. The comments are not visible in the resulting XLSX file. A comments1.xml file is created but the comments triangle and message box is not visible when the spreadsheet is opened in Microsoft Excel.
Can POI see the comments? Try writing the file out, opening it again fresh in poi and see if you can see the comments. That'll help us figure out how far along things go before they break
Created attachment 24470 [details] Simple main() that writes/reads a cell comment to/from workbook A very simple test case that writes an XSSFWorkbook with one cell. Comments are added to the one cell and POI can read and cell comments after writing the file to disk. However, comments are not visible using MS Excel.
Yes, POI can see the comments after writing the XSSFWorkbook to disk.
Any chance you could create a similar one cell file in excel, and attach that? That'll make it much quicker for us to spot what we're doing differently!
Created attachment 24473 [details] Workbook made using Poi with Cell Comments (not visible)
Created attachment 24474 [details] Workbook made using Excel with Cell Comments (visible)
There are two big differences between the files I just uploaded. The POI generated xlsx file does not contain the Drawing\vmDrawing1.vml or the Themes\theme1.xml files.
fixed in r884918 Missing vmDrawing1.vml was important - this part stores visual properties of cell comments (background color, position in the sheet, whether the comment is visible, etc.) I added support for cell comments to common SS interfaces so that it is possible to use the same code to generate .xlsx or .xls output, see the updated Busy Developers Guide. Yegor
I got 884918 from SVN and jarred it up and the comments are working. Nice job on making the comment creation more consistent as part of the usermodel interface. Thanks Yegor!