https://issues.apache.org/bugzilla/show_bug.cgi?id=45431
Matthew <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |NEW
--- Comment #3 from Matthew <[EMAIL PROTECTED]> 2008-07-20 18:48:36 PST ---
I compared the pre-poi and post-poi files, I have following findings:
(1) In [Content_Types].xml:
Excel expected output:
<Override PartName="/xl/workbook.xml"
ContentType="application/vnd.ms-excel.sheet.macroEnabled.main+xml"/>
POI actual output:
<Override PartName="/xl/workbook.xml"
ContentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet.main+xml"/>
(2) In [Content_Types].xml:
Excel expected output:
<Default Extension="vml"
ContentType="application/vnd.openxmlformats-officedocument.vmlDrawing"/>
<Override PartName="/xl/vbaProject0.bin"
ContentType="application/vnd.ms-office.vbaProject"/>
POI actual output (the case difference):
<Default Extension="vml"
ContentType="application/vnd.openxmlformats-officedocument.vmldrawing"/>
<Override PartName="/xl/vbaProject0.bin"
ContentType="application/vnd.ms-office.vbaproject"/>
I found that this problem is caused by OpenXml4J
(http://people.apache.org/~nick/openxml4j-bin-alpha-080407.jar), I tried to use
the library with a newer version, it fix this issue but I encountered another
problem which doesn't happen in older version.
(3) Package contents:
Some .xlsm file contains not only vbaProject.bin, it also includes ActiveX
controls and some .emf image files linked. If only copy the vbaProject.bin
without the linked ActiveX controls and image, Excel will prompt error also.
Please check my attached image.
Patch
=====
I have created a patch which solve above problems (assume OpenXML4J (2) issue
is fixed), but I know the patch just only solve my problem temporary (I hard
code the output is macro-enabled workbook, image is .emf etc...) and it is not
a generic solution for the POI project. I hope it helps the POI team to figure
out the perfect solution some ways.
--
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]
