XSLX Sheet ShiftRows, RemoveRow doesn't update LastRowNum

Sep 23, 2013 at 1:44 PM
Hi All!

ISheet has ShiftRow, RemoveRow method.
HSSFSheet after each row operation recalc LastRowNum value.
XSSFSHeet recalc LastRowNum only after CreateRow operation triggers.

How manualy recalc LastRowNum in XSSFSheet?

That's needed when new RowNumber > LastRowNumber. In HSSFSheet use can compare LastRowNum with new RowNum to prevent error. In XSSFSHeet can't.

NPOI 2.0 beta 1
.Net 4.0

Oct 10, 2013 at 4:38 AM
It's a bug in XSSFSheet.ShiftRow.
Marked as answer by tonyqus on 10/9/2013 at 9:38 PM