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.rokopa...@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" <one...@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" <javenon...@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.rokopa...@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-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >