Hello, I am using POI for simple CRUD operations on excel files. Once such operation is deleting and shifting of rows in a sheet. Unfortunately, both these operations don't work as expected when a row that I need to delete/shift has one or more cell comments.
I noticed the following line in this page https://poi.apache.org/changes.html : 56017 <http://issues.apache.org/bugzilla/show_bug.cgi?id=56017> - Fix shifting comments with shifted rows Since POI 3.12 beta 2 is not out yet, I used the latest stable SVN revision 1674025 to download the source code and followed the build instructions to build the 3.12 beta2 binaries. I used a simple stand alone program to shift rows with comments in an excel sheet using POI apis. When a row has only one cell comment, that row is being properly shifted. However, when a row has more than one cell with comments, only the first comment gets properly shifted along with its cell. The other remaining comments stay in that exact same cell number/row number position with only the corresponding cell's data being shifted. Are the POI developers, who took care of this bug in 3.12 beta 2 version, aware of this issue? If no one is aware of this issue, how do I bring it to their attention? Meanwhile I am going to investigate into their sources as to why this is happening. Thanks, Balaji
