You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Spyros Rokopanos <s....@outlook.com> on 2017/01/05 16:42:23 UTC
shiftrows() in xls document containing hidden (zero height) rows
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
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by Javen O'Neal <ja...@gmail.com>.
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" <sp...@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" <on...@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" <ja...@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....@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
>
>
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by Javen O'Neal <ja...@gmail.com>.
To unsubscribe, send a short message to the mailer daemon:
user-unsubscribe@poi.apache.org
To manage other mailing list preferences, see
https://poi.apache.org/mailinglists.html
On Jan 8, 2017 02:53, "discreta discrecion" <ec...@hotmail.com> wrote:
unsuscribe, please?
________________________________
De: Spyros Rokopanos <sp...@gmail.com>
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows
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" <on...@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" <ja...@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....@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
RE: shiftrows() in xls document containing hidden (zero height) rows
Posted by "Murphy, Mark" <mu...@metalexmfg.com>.
Check the link at the bottom of the email?
-----Original Message-----
From: discreta discrecion [mailto:ecorreos@hotmail.com]
Sent: Sunday, January 08, 2017 5:53 AM
To: POI Users List <us...@poi.apache.org>
Subject: Re: shiftrows() in xls document containing hidden (zero height) rows
unsuscribe, please?
________________________________
De: Spyros Rokopanos <sp...@gmail.com>
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows
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" <on...@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" <ja...@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....@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
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by discreta discrecion <ec...@hotmail.com>.
unsuscribe, please?
________________________________
De: Spyros Rokopanos <sp...@gmail.com>
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows
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" <on...@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" <ja...@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....@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
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by discreta discrecion <ec...@hotmail.com>.
How can I unsuscribe?
________________________________
De: Spyros Rokopanos <sp...@gmail.com>
Enviado: sábado, 7 de enero de 2017 15:04:48
Para: user@poi.apache.org
Asunto: Re: shiftrows() in xls document containing hidden (zero height) rows
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" <on...@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" <ja...@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....@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
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by Spyros Rokopanos <sp...@gmail.com>.
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" <on...@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" <ja...@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....@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
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by Javen O'Neal <on...@apache.org>.
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" <ja...@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....@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
>
Re: shiftrows() in xls document containing hidden (zero height) rows
Posted by Javen O'Neal <ja...@gmail.com>.
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....@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
>