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