Bug 531554

Summary: oowriter cannot open formulas from Microsoft Office 2007 SP2 ODT files
Product: [Fedora] Fedora Reporter: Josh Cogliati <jrincayc>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED ERRATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: low    
Version: 11CC: caolanm
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 3.1.1-19.8.fc11 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-11-18 14:10:05 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
ODT file with formula from Microsoft Word 2007 SP2 none

Description Josh Cogliati 2009-10-28 18:10:03 UTC
Created attachment 366477 [details]
ODT file with formula from Microsoft Word 2007 SP2

Description of problem:
If a file with formulas (equations) is created in Microsoft Office 2007 SP2 and saved as an ODT file, the formulas are not read in Open Office Writer

Version-Release number of selected component (if applicable):
openoffice.org-writer-3.1.1-19.2.fc11.x86_64

How reproducible:
Every time.

Steps to Reproduce:
1. Create a document in MS office 2007 with a formula
2. Save the file as an open document file
3. Open in Open Office Writer
  
Actual results:
All formulas are stripped out.

Expected results:
All formulas should be read in.

Additional info:
The attached file was created in Microsoft Office 2007 SP2.  If you unzip the file, you can find the formula as "Object 1/content.xml" 

If you open the from_msword.odt file with oowriter, there is no formula.

If in the "content.xml" the following is changed:
<draw:object xlink:href="Object 1/" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"/>
to:
<draw:object xlink:href="Object 1" xlink:type="simple" xlink:show="embed" xlink:actuate="onLoad"/>

That is, change the xlink:href="Object 1/" to xlink:href="Object 1" 

and rezip the .odt file, this works fine and the formula shows up in oowriter. 

Arguably this might be a bug in Microsoft Office, but I was unable to find any requirement in the ODF 1.1 specification on whether or not a / is permitted at the end of a subobject xlink:href, so I think that Open Office should be able to load a formula when there is the extra /.

Comment 1 Caolan McNamara 2009-10-28 20:37:19 UTC
known upstream and fixed for 3.2, backported fix. Will be available >= 3.1.1-19.5 for F-11

Comment 2 Fedora Update System 2009-10-29 08:46:53 UTC
openoffice.org-3.1.1-19.5.fc11 has been submitted as an update for Fedora 11.
http://admin.fedoraproject.org/updates/openoffice.org-3.1.1-19.5.fc11

Comment 3 Fedora Update System 2009-11-04 12:20:26 UTC
openoffice.org-3.1.1-19.5.fc11 has been pushed to the Fedora 11 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing update openoffice.org'.  You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F11/FEDORA-2009-10957

Comment 4 Fedora Update System 2009-11-07 12:59:13 UTC
openoffice.org-3.1.1-19.7.fc11 has been submitted as an update for Fedora 11.
http://admin.fedoraproject.org/updates/openoffice.org-3.1.1-19.7.fc11

Comment 5 Fedora Update System 2009-11-10 17:57:27 UTC
openoffice.org-3.1.1-19.7.fc11 has been pushed to the Fedora 11 testing repository.  If problems still persist, please make note of it in this bug report.
 If you want to test the update, you can install it with 
 su -c 'yum --enablerepo=updates-testing update openoffice.org'.  You can provide feedback for this update here: http://admin.fedoraproject.org/updates/F11/FEDORA-2009-11295

Comment 6 Fedora Update System 2009-11-17 11:10:51 UTC
openoffice.org-3.1.1-19.8.fc11 has been submitted as an update for Fedora 11.
http://admin.fedoraproject.org/updates/openoffice.org-3.1.1-19.8.fc11

Comment 7 Fedora Update System 2009-11-18 14:09:36 UTC
openoffice.org-3.1.1-19.8.fc11 has been pushed to the Fedora 11 stable repository.  If problems still persist, please make note of it in this bug report.