https://issues.apache.org/bugzilla/show_bug.cgi?id=49020
Summary: "org.xml.sax.SAXParseException: </b> does not close
tag <br>." when opening some Excel 2007 files
Product: POI
Version: 3.6
Platform: All
OS/Version: All
Status: NEW
Severity: regression
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I am get the exception below thrown when reading in some .xlsm files
into POI v3.6 WorkbookFactory.create(fileInputStream). The files open without
error in Excel 2007 and OpenOffice 2.3. I have other .xlsm files that
work as expected in POI v3.6.
The source of the error is in xi/drawings/vmlDrawing1.vml. A user created
button has a 2 line title. The lines are separated by a <BR>, thus the reason
for the exception. Below is an excerpt from vmlDrawing1.vml
<v:shape id="_x0000_s2060" type="#_x0000_t201" style='position:absolute;
margin-left:554.25pt;margin-top:78.75pt;width:205.5pt;height:50.25pt;
z-index:1;mso-wrap-style:tight' o:button="t" fillcolor="buttonFace [67]"
strokecolor="windowText [64]" o:insetmode="auto">
<v:fill color2="buttonFace [67]" o:detectmouseclick="t"/>
<o:lock v:ext="edit" rotation="t"/>
<v:textbox o:singleclick="f">
<div style='text-align:center'><font face="Arial" size="280"
color="10"><b>Print
Entire <br>
Data Set</b></font></div>
</v:textbox>
<x:ClientData ObjectType="Button">
<x:Anchor>
10, 8, 5, 1, 13, 66, 7, 36</x:Anchor>
<x:PrintObject>False</x:PrintObject>
<x:AutoFill>False</x:AutoFill>
<x:FmlaMacro>[0]!Module1.print_entire_data_set</x:FmlaMacro>
<x:TextHAlign>Center</x:TextHAlign>
<x:TextVAlign>Center</x:TextVAlign>
</x:ClientData>
</v:shape>
FYI: I downgrades POI to 3.5-FINAL and the workbook loaded without errors.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
