poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Balaji Venkatamohan <bvenk...@tibco.com>
Subject Re: Apache POI 3.12 Beta2 - Shifting of rows with cell comments in excel
Date Fri, 17 Apr 2015 19:58:48 GMT
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 <dominik.stadler@gmx.at>
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
> <bvenkata@tibco.com> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message