Hello, Using XssfSheet.removeRow(row0), only deletes cell values. If any cell in row0 contained comments, they are not deleted and are retained in the same cell address. This causes unpredictable behavior in the saved / modified excel file and opening this saved workbook may or may not open properly.
The POI and OOXML libs used for my sample project were built from revision r1674975 of POI source. I have created a bug in POI for this and I have attached the src folder of my test project in the bugzilla ticket with URL below: https://bz.apache.org/bugzilla/show_bug.cgi?id=57838 This seems to be an obvious use case and was wondering if any users observed this bug. I could not locate a bug in bugzilla exactly matching the issue I have explained here. Thanks, Balaji
