I have a new application using POI version 3.5-FINAL and I am seeing what
appears to be a bug in POI.
Everything is fine until I call shiftRows() on a sheet. I.e.
sheet.shiftRows(firstRow.getRowIndex(),
lastRow.getRowIndex(),
3 - firstRow.getRowIndex(),
true,
true);
The problem is that after this call some of the cells in the row(s) are
missing their data. The cells had data before the move and now some are
just plan empty!
What I am doing here is moving a set of rows up by a few rows. (And I have
previously cleared the rows I am moving into...perhaps I did not need to.)
I immediately save the workbook after this, e.g.
workbook.write(new FileOutputStream(tempFile));
Is this a known issue? How can I fix this?
Just let me know if you need to see examples of the error. In my case some
cells in columns B & C are erased.
Thanks!
