https://bz.apache.org/bugzilla/show_bug.cgi?id=57610
Bug ID: 57610
Summary: Excel Messages on xl/tables XMLs
Product: POI
Version: 3.10-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Hello,
after upgrading from POI 3.8 to POI 3.10.1 my application is generating XLSX
files, which are not accepted completely by Excel 2010 or later.
Excel is reporting inconsistencies in the file and offering, to repair those.
Reparing creates messages like "Repaired Records: Table from
/xl/tables/table1.xml part (Table)". Functionally the XLSX seems to be fine
after repair and my application can still consume it with POI library.
Anyway, I am concerned about my users complaining about my application creating
inconsistent XLSX file so that I would like to have you providing me guidance
on how to get that fixed (either by a patch for POI 3.10.1 or instructions on
how to adjust my Java Coding).
Kindly note, that POI 3.11 or later is no viable option, because my application
has to be build with Java 1.5.
Please find attached a sample program to reproduce the behavior without all my
additional application logic. POI_Sample simply reads by raw XLSX template file
into a POI Workbook and writes that Workbook back to a ByteArray and a File. I
would expect the XLSX not being changed at all in course of that. Instead
POI_Sample aborts with following stacktrace when writing the Workbook to the
file:
org.apache.xmlbeans.impl.values.XmlValueDisconnectedException
at
org.apache.xmlbeans.impl.values.XmlObjectBase.check_orphaned(XmlObjectBase.java:1258)
at
org.apache.xmlbeans.impl.values.XmlObjectBase.newCursor(XmlObjectBase.java:286)
at
org.apache.xmlbeans.impl.values.XmlComplexContentImpl.arraySetterHelper(XmlComplexContentImpl.java:1124)
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTDefinedNamesImpl.setDefinedNameArray(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.saveNamedRanges(XSSFWorkbook.java:1288)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.commit(XSSFWorkbook.java:1309)
at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:322)
at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:179)
at POI_Sample.main(POI_Sample.java:43)
Any help is highly appreciated.
Thank You,
Stefan
--
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]
