problem with shiftRows for XSSF

Hi, I am using poi v 3.14. My program reads a spreadsheet (which has just two cells filled for the sake of this simple test) , fills rows and then needs to swap rows. It works fine when template is in "xls" format and so is the output. However, when template is saved as "xlsx", then resulting x

Re: problem with shiftRows for XSSF

Hi, Unfortunately there are a number of "known" bugs around shifting data, you likely hit one of those, especially https://bz.apache.org/bugzilla/show_bug.cgi?id=57423 sounds related. A list of related issues around shifting is: https://bz.apache.org/bugzilla/buglist.cgi?bug_id=59306%2C59239%2C58