Hello friends, I was able to overcome of this issue as well. The issue was with my code itself. In my code, I was suppose to write comments within a for loop and a condition in that for loop. I was setting anchor before that if condition. So, if IF condition fails, comment will not get set but anchor is already on that Drawing, hence the issue.
In .xlsx, you can see the erroneous comment if you open your .xlsx in 7-Zip or some other zip utility, go to xl folder and open comments1.xml. You'll find some tag without any comments like <comment ref="B2" authorId="0"/>. Rest of the comments would be fine. You just remove this, save your xml and get it zipped back, close your zip utility and open .xlsx. It'll open fine. Hope this helps someone else! Thanks, Ram -- View this message in context: http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-47188-New-setCellComment-corrupts-workbook-2007-XML-format-tp2331422p4378295.html Sent from the POI - Dev mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
