https://bz.apache.org/bugzilla/show_bug.cgi?id=57423
--- Comment #17 from David Gauntt <[email protected]> --- Created attachment 36712 --> https://bz.apache.org/bugzilla/attachment.cgi?id=36712&action=edit Partial bug fix for bug 57423 In this patch to XSSFSheet.rebuildRows, if bRebuildCTSheetData==false, then the XSSFRow map (_rows) is sorted by row number, but the CTRow list (getCTWorksheet().getSheetData().getRowList()) is not. This is the current behavior in trunk (as of 6 Aug 2019). If bRebuildCTSheetData==true then both the list and the map are sorted by row number. However, the test case in attachment 36711 still fails because of the following error: Testcase: testShiftUpGapped took 0.027 sec Caused an ERROR null org.apache.xmlbeans.impl.values.XmlValueDisconnectedException at org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1258) at org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTCellImpl.isSetF(Unknown Source) at org.apache.poi.xssf.usermodel.helpers.XSSFRowColShifter.updateRowFormulas(XSSFRowColShifter.java:104) at org.apache.poi.xssf.usermodel.helpers.XSSFRowColShifter.updateSheetFormulas(XSSFRowColShifter.java:88) at org.apache.poi.xssf.usermodel.helpers.XSSFRowColShifter.updateFormulas(XSSFRowColShifter.java:74) at org.apache.poi.xssf.usermodel.helpers.XSSFRowShifter.updateFormulas(XSSFRowShifter.java:46) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:3032) at org.apache.poi.xssf.usermodel.XSSFSheet.shiftRows(XSSFSheet.java:2999) at org.apache.poi.ss.unfixedBugs.TestXSSFSheetShiftRowsAndColumns.runTest(TestXSSFSheetShiftRowsAndColumns.java:272) at org.apache.poi.ss.unfixedBugs.TestXSSFSheetShiftRowsAndColumns.testShiftUpGapped(TestXSSFSheetShiftRowsAndColumns.java:112) -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
