Excel cell with note failing on xmlbeans 3.0.0

"Sateesh K Kolusu" <[email protected]>
Newsgroups gmane.comp.jakarta.poi.user
Message-ID <OF1073DCBC.F262415A-ON65258759.003A288E-65258759.003A9F5C@ibm.com>
Hi - I have an Excel file cell with note processing successfully with 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.

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

---
Thanks
Sateesh
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.