On Tue, 8 Feb 2011, hartford123 wrote:
Here is the code I am using.Suppose when shiftRows() is done for 2 rows to shift down,ie from 47 to 49, then current row is showing 49 and if I want to start writing the content from 47, I am not able to read the row at 47 and it coming out as null. thus happened to create a row at 47 again.
Could you create a junit test that uses the SS usermodel, which tries the shift + read trick on both HSSF and XSSF? From what you say, it should work with hssf, and fail for xssf. That unit test can then be used to help track down the problem, and also as a check in future to ensure it doesn't get broken again
Thanks Nick --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
