Thanks Dominik for your response. I have created a new bug 57828 for this issue and attached a source folder containing a runnable junit test class and a resources folder having the excel file. I also came across this issue while deleting a sheet: - Deleting a sheet with a few cells having comments, does not delete the sheet's comments.xml file. This causes unpredictable behavior when trying to create a sheet with the same name as that of the deleted sheet and afterwards while trying to add comments to this new sheet. For this defect too, I will create a bug.
Thanks, Balaji On Thu, Apr 16, 2015 at 10:52 PM, Dominik Stadler <[email protected]> wrote: > Hi, > > thanks for reporting. We are not aware of this, the best option to > ensure that we can work on this is to create a bug entry at > https://bz.apache.org/bugzilla/ together with the sample file and a > Java Unit Test, either as patch for the POI tests or as > self-sufficient java test to allow us to reproduce it. > > Thanks... .Dominik. > > On Thu, Apr 16, 2015 at 10:44 PM, Balaji Venkatamohan > <[email protected]> wrote: > > 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 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
