[Bug 57423] shiftRows() produces a corrupted xlsx file

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[Bug 57423] shiftRows() produces a corrupted xlsx file

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=57423

--- Comment #17 from David Gauntt <[hidden email]> ---
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: [hidden email]
For additional commands, e-mail: [hidden email]