poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Javen O'Neal" <javenon...@gmail.com>
Subject Re: shiftrows() in xls document containing hidden (zero height) rows
Date Sun, 08 Jan 2017 12:43:45 GMT
The attachment didn't make it through.

Would you be willing to open a bug on bz.apache.org/bugzilla and submit all
the information needed to reproduce the problem there?

Also include a link to this discussion,
https://lists.apache.org/thread.html/7a2c9215bbc77549c5cf038dac820312f633468ab4f1a5112136c095@
<user.poi.apache.org>

On Jan 7, 2017 18:31, "Spyros Rokopanos" <spiros.rokopanos@gmail.com> wrote:

> I don't know if its universal. I have faced the issue in one workbook in
> which one sheet has hidden rows... I have not tried with other
> workbooks/sheets..
> Also from stackoverflow  I found this which sounds the same problem:
> "Somehow I manage to create new rows between two rows in an existing excel
> file. The problem is, some of the formatting were not include along the
> shifting of the rows.
>
> One of this, is the row that are hide are not relatively go along during
> the shift. What I mean is(ex.), rows from 20 to 30 is hidden, but when a
> create new rows the formating still there. The hidden rows must also move
> during the insertion/creation of new rows, it should be 21 to 31.
>
> Another thing is, the other object in the sheet that are not in the cell.
> Like the text box are not move along after the new row is created. Its like
> the position of these object are fixed. But I want it to move, the same
> thing as I insert a new row or paste row in excel. If there is a function
> of inserting a new row, please let me know."
>
> Although there are many answers, it seems that problem is unresolved...
> The link is here:
> http://stackoverflow.com/questions/5785724/how-to-
> insert-a-row-between-two-rows-in-an-existing-excel-with-hssf-apache-poi
>
> I will also attach my workbook to have a look...
> On 2017-01-06 06:50 (+0200), "Javen O'Neal" <onealj@apache.org> wrote:
> > Does this happen on all XLS workbooks or just a few?
> >
> > If it isn't universal, could you also attach a small workbook to go along
> > with your code sample so that we can reproduce the problem?
> >
> > On Jan 5, 2017 20:47, "Javen O'Neal" <javenoneal@gmail.com> wrote:
> >
> > Sounds like a bug in the shiftRows code.
> >
> > Could you post a self-contained example of what you're doing that's
> causing
> > the error, including a stack trace of the error if you're getting an
> > exception instead of a mangled workbook?
> >
> > On Jan 5, 2017 15:40, "Spyros Rokopanos" <s.rokopanos@outlook.com>
> wrote:
> >
> > > Hello all,
> > >
> > >
> > > I would like to ask if behavior of shiftrows() changes if a documents
> > > contains hidden (zero height) rows. I just ask because I am trying to
> > > insert some new rows (using shiftrows()) and if I have hidden rows in
> the
> > > document I face issues. If I unhide them, shiftrows() works as
> expected.
> > >
> > >
> > > Has anyone faced a similar issue?
> > >
> > >
> > > Thanks in advance for any hint/help!
> > >
> > >
> > > Kind regards,
> > >
> > > Spyros
> > >
> >
>
> ---------------------------------------------------------------------
> 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