Bug 55924

Summary: [PATCH] xml export and minOccurs=0 issue
Product: POI Reporter: Marc <hae>
Component: XSSFAssignee: POI Developers List <dev>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: [PATCH] Patch

Description Marc 2013-12-23 12:30:17 UTC
Xml export of an excel document fails if it contains empty cells which are mapped to an xml element of type double and attribute minOccurs=0.

Poi fails to export such documents because it fills in an empty string into these xml tags. This leads to a schema validation exception in case of an element with a double datatype.

The patch I'm going to provide handles it the same way as Excel does. It removes empty elements from the output xml.
Comment 1 Marc 2013-12-23 13:55:13 UTC
Created attachment 31145 [details]
[PATCH] Patch
Comment 2 Dominik Stadler 2014-02-03 20:18:15 UTC
Thanks a lot for all these patches, this one is now applied as well via r1564045.