[ 
https://issues.apache.org/jira/browse/XMLBEANS-571?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17420819#comment-17420819
 ] 

Sateesh commented on XMLBEANS-571:
----------------------------------

The test.xlsx works with combination of POI 3.15 and xmlbeans 3.0.0. also. The 
immediate challenge is we cannot move to POI 3.15 due to our internal 
organization policies and different team dependencies. A customer is waiting 
for a fix on production down issue. 

My question - Can you please let me know the relevant source files that are 
modified for this issue in POI 3.15 so that I can appropriately generate a 
patch internally for customer. Earlier we successfully patched our software on 
POI 3.14 [*Bug 59183*|https://bz.apache.org/bugzilla/show_bug.cgi?id=59183] 

Thanks in advance.

> Excel file read failure using xmlbeans 3.0.0 whereas it works on xmlbeans 
> 2.6.0
> -------------------------------------------------------------------------------
>
>                 Key: XMLBEANS-571
>                 URL: https://issues.apache.org/jira/browse/XMLBEANS-571
>             Project: XMLBeans
>          Issue Type: Bug
>    Affects Versions: Version 3.0.0
>         Environment: linux
>            Reporter: Sateesh
>            Priority: Blocker
>             Fix For: Version 3.0.0
>
>         Attachments: XLSXReaderExample.java, test.xlsx
>
>
> 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



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to