[XMLBEANS-571] Excel file read failure using xmlbeans 3.0.0 whereas it works on xmlbeans 2.6.0

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Version 3.0.0
• Fix Version/s: Version 3.0.0
• Environment: linux
• Flags: Patch, Important

Docs Text

Steps to reproduce
1) export CLASSPATH pointing to the following jars ( couldnot attach due to size restrictions)
poi-3.14.jar
poi-ooxml-3.14.jar
poi-ooxml-schemas-3.14.jar
xmlbeans-3.0.0.jar
2) compile the java program
3) run the java class
You will find similar exception whereas when the xmlbeans2.6.0 is used it outputs successfully.

• Assignee: Unassigned
• Reporter: Sateesh
• Created: 24/Sep/21 15:30
• Updated: 01/Oct/21 13:11
• Resolved: 24/Sep/21 16:11

Description

I have an Excel file cell with note processing successfully with Apache POI
3.14 + xmlbeans 2.6.0.
But when we moved to xmlbeans 3.0.0 it fails with following exception. If
I delete the note in the Excel file it processes successfully with 3.0.0. Attached the testcase

Source_File,0: org.apache.poi.POIXMLException:
java.lang.reflect.InvocationTargetException
at
org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:65)
at
org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:601)
at
org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:613)
at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:174)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:249)
.......
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
at
org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
at
org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:62)
... 12 more
Caused by: org.apache.xmlbeans.XmlException: error: Content is not allowed
in trailing section.
at
org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
at
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1271)
at
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1258)
at
org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
at org.apache.xmlbeans.XmlObject$Factory.parse(XmlObject.java:747)
at
org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:128)
at
org.apache.poi.xssf.usermodel.XSSFVMLDrawing.<init>(XSSFVMLDrawing.java:116)
... 18 more
Caused by: org.xml.sax.SAXParseException: Content is not allowed in
trailing section.
at
org.apache.xerces.util.ErrorHandlerWrapper.createSAXParseException(Unknown
Source)
at org.apache.xerces.util.ErrorHandlerWrapper.fatalError(Unknown
Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
Source)
at org.apache.xerces.impl.XMLErrorReporter.reportError(Unknown
Source)
at org.apache.xerces.impl.XMLScanner.reportFatalError(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown
Source)
at
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.XML11Configuration.parse(Unknown
Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown
Source)
at
org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at
org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3413)
... 24 more