none
Office open XML ( open XML) probelm with Mac OS

    Question

  • Hi ,

    I am working on flex and my flex application generates an xml which is using open office related schema s   and will be saved into my desktop as an open office xml file. File size will be 2MB or more than 2MB. This file is able to open success fully when i try to open in windows 7 OS and office 2010, but with Mac OS 10.7.5 and office 2011 / 2008 its not able open , word is hanging.

    Please give me some suggestions or help in this area if there are any setting in mac system into order to see that open office xml file.

    some of the open xml files are opening properly in mac os. But for a large xml it is not able to open.

    Regards

    Pradeep

    Wednesday, February 06, 2013 1:00 PM

Answers

  • Hello Pradeep,

    It sounds like there might be a problem with the underlying XML and by saving it Word for Windows fixes the problem.  I haven’t heard of this exact scenario.  But I have seen a few situations that sound similar to this:

    In one situation an Excel Open XML file was created outside of Excel could not be imported into Access.  After opening the file in Excel, saving it you could then import it into Access.

    In another situation, there was a problem printing an HTML file (which was originally saved from within Word but then modified outside of Word) from Internet Explorer.  After opening the HTML file in Word, saving it you could then print it from Internet Explorer.

    I am not sure what to tell you to look for in the document but, I would suggest you try this:

    1.  Make a copy of the document.

    2.  Rename the extension from *.docx (or whatever it happens to be) to *.zip.  (For more information on this see Office Open XML I: Exploring the Office Open XML Formats.)

    3.  Open the document in the Windows version of Word and save it out as a different name. 

    4.  Rename the extension of the new file from *.docx (or whatever it happens to be) to *.zip. 

    5.  Extract the contents of both *.zip files.

    6.  Use a program to compare the various component files.  I would start in the document.xml files from the Word folder; of course, you may need to compare other files too.

    If you identify what is being fixed by Word for Windows in one of the documents, you may be able to modify the flex application to prevent the issue going forward.


    Thank you, Matt B. Microsoft Online Community Support

    Friday, February 22, 2013 7:12 PM

All replies

  • Hi Pradeep,

    The OpenXML standard has two variants, Transitional OpenXML, and Strict OpenXML. To make the generated document compatible on Mac version Office 2011, I believe you need Strict OpenXML format.  I have to points:

    1. Office 2013 is able to save document as Strict OpenXml format. Which is compatible on Mac.
    2. OpenXml 2.5 can read Strict OpenXml document. Once the document changed, it save the document as Transitional OpenXml. Otherwise, it will keep the document as Strict OpenXml. Refer to this article.

    More reference:

    http://blogs.office.com/b/office-next/archive/2012/08/13/the-new-office-expands-file-format-options.aspx

    Forrest Guo | MSDN Community Support | Feedback to manager

    Thursday, February 07, 2013 5:11 AM
    Moderator
  • Hi Forrest,

    Thanks for the reply.

    I will check and let you know , if i need any more information.

    Regards

    Pradeep

    Monday, February 11, 2013 12:11 PM
  • Hi Forrest,

    Below is  my understanding,

    Point 1 : If we have office 2013 we can successfully open (open xml ) document in MAC os. Please correct me if am wrong. ( my question here is  , right now some of the open xml documents are able open in mac os, some or not).


    point 2 : we install open xml 2.5 sdk in mac os, we can succesfully open ( open xml) document in MAC OS . Please correct me if am wrong.


    Please give some more suggessions. Am using below open xml schemas in my xml file which is used to generate open xml in my application.

    =============

    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <?mso-application progid="Word.Document"?>
    <pkg:package xmlns:pkg="http://schemas.microsoft.com/office/2006/xmlPackage"><pkg:part pkg:name="/_rels/.rels" pkg:contentType="application/vnd.openxmlformats-package.relationships+xml" pkg:padding="512"><pkg:xmlData><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/extended-properties" Target="docProps/app.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/package/2006/relationships/metadata/core-properties" Target="docProps/core.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/officeDocument" Target="word/document.xml"/><Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/custom-properties" Target="docProps/custom.xml"/></Relationships></pkg:xmlData></pkg:part><pkg:part pkg:name="/word/_rels/document.xml.rels" pkg:contentType="application/vnd.openxmlformats-package.relationships+xml" pkg:padding="256"><pkg:xmlData><Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"><Relationship Id="rId8" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/endnotes" Target="endnotes.xml"/><Relationship Id="rId13" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/theme" Target="theme/theme1.xml"/><Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/styles" Target="styles.xml"/><Relationship Id="rId7" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/footnotes" Target="footnotes.xml"/><Relationship Id="rId12" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/fontTable" Target="fontTable.xml"/><Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/numbering" Target="numbering.xml"/><Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/customXml" Target="../customXml/item1.xml"/><Relationship Id="rId6" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/webSettings" Target="webSettings.xml"/><Relationship Id="rId11" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/image" Target="media/image1.png"/><Relationship Id="rId5" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/settings" Target="settings.xml"/><Relationship Id="rId10" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/footer" Target="footer1.xml"/><Relationship Id="rId4" Type="http://schemas.microsoft.com/office/2007/relationships/stylesWithEffects" Target="stylesWithEffects.xml"/><Relationship Id="rId9" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/header" Target="header1.xml"/></Relationships></pkg:xmlData></pkg:part><pkg:part pkg:name="/word/document.xml" pkg:contentType="application/vnd.openxmlformats-officedocument.wordprocessingml.document.main+xml"><pkg:xmlData><w:document mc:Ignorable="w14 wp14" xmlns:wpc="http://schemas.microsoft.com/office/word/2010/wordprocessingCanvas" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:m="http://schemas.openxmlformats.org/officeDocument/2006/math" xmlns:v="urn:schemas-microsoft-com:vml" xmlns:wp14="http://schemas.microsoft.com/office/word/2010/wordprocessingDrawing" xmlns:wp="http://schemas.openxmlformats.org/drawingml/2006/wordprocessingDrawing" xmlns:w10="urn:schemas-microsoft-com:office:word" xmlns:w="http://schemas.openxmlformats.org/wordprocessingml/2006/main"

    ============================

    waiting for your quick reply.

    Thanks in advance.

    Regards

    Pradeep






    Monday, February 11, 2013 12:54 PM
  • Point1, Yes, more exactly, with Office 2013 you should be able to open the doc on Mac directly. Even though you still need to find right app on Mac to work with. As to the fact that some generated document can open on Mac, others not, I'm interested which app you use on Mac to open them? Please find that app specification about file format.

    Point2, no. I mean you can use OpenXml 2.5 to programmatically open the document. Whether you can open the generated doc depends on which Office suite you use.

    Don't have insight to the schema though.


    Forrest Guo | MSDN Community Support | Feedback to manager

    Tuesday, February 12, 2013 2:03 AM
    Moderator
  • Hi Forrest,

    I agree with point 1 , but the thing is we can't ask user to upgrade his office to 2013. So we need to check for the compatibility for both Mac (office 2011 / office 2008) and windows.

    yes , some generated document can open on Mac other not.

    But when we open the document which is not opened in Mac OS using windows 7 OS its is able to open.

    if we do save as this document and pass to mac system and then we are able to open successfully.

    we are not able to figure out where exactly the problem is.

    please suggest on this.

    Regards

    Pradeep

    Tuesday, February 12, 2013 7:06 AM
  • OK. I'll ask other people to help further, please wait some time.


    Forrest Guo | MSDN Community Support | Feedback to manager

    Tuesday, February 12, 2013 9:04 AM
    Moderator
  • yes i will wait, please make it as early as possible.

    Because so many user are waiting on this resolutions.

    Regards

    Pradeep

    Wednesday, February 13, 2013 5:40 AM
  • hello guys,

    could any one answer my question please ?

    ~ Pradeep

    Friday, February 15, 2013 4:36 AM
  • Hello Pradeep,

    It sounds like there might be a problem with the underlying XML and by saving it Word for Windows fixes the problem.  I haven’t heard of this exact scenario.  But I have seen a few situations that sound similar to this:

    In one situation an Excel Open XML file was created outside of Excel could not be imported into Access.  After opening the file in Excel, saving it you could then import it into Access.

    In another situation, there was a problem printing an HTML file (which was originally saved from within Word but then modified outside of Word) from Internet Explorer.  After opening the HTML file in Word, saving it you could then print it from Internet Explorer.

    I am not sure what to tell you to look for in the document but, I would suggest you try this:

    1.  Make a copy of the document.

    2.  Rename the extension from *.docx (or whatever it happens to be) to *.zip.  (For more information on this see Office Open XML I: Exploring the Office Open XML Formats.)

    3.  Open the document in the Windows version of Word and save it out as a different name. 

    4.  Rename the extension of the new file from *.docx (or whatever it happens to be) to *.zip. 

    5.  Extract the contents of both *.zip files.

    6.  Use a program to compare the various component files.  I would start in the document.xml files from the Word folder; of course, you may need to compare other files too.

    If you identify what is being fixed by Word for Windows in one of the documents, you may be able to modify the flex application to prevent the issue going forward.


    Thank you, Matt B. Microsoft Online Community Support

    Friday, February 22, 2013 7:12 PM
  • Hi Matt,

    Thanks for the reply.

    Let me do this exercise and check the difference between open XML files generated in MAC and windows(after open and do save as).

    But still, am not clear if it is  problem with the XML generation from the application , how other documents are able to open in MAC machine. Am still clueless in this issue.

    please suggest me if you have any more information or idea.

    Regards
    Pradeep

    Monday, February 25, 2013 5:42 AM
  • I believe Forrest is correct in that you need the Transitional OpenXML format in order to open this on OS 10.7.5 and others places which do not support Strict OpenXml. 

    The question is how do you create the Transitional Open XML format with the OpenXml SDK 2.5?

    I see in the article referenced "The Open XML SDK 2.5 converts ISO Strict files to Transitional Formatted files when any changes are made to the document or when the document is saved. Unless the document is saved or modified, the document is left as an ISO Strict Format file."

    I have tried reading, changing, and saving the Strict OpenXml document and the file remains in the Strict OpenXml format.  What exactly in the OpenXml 2.5 do you need to do to get it to save in the Transitional OpenXml?

    Wednesday, March 06, 2013 3:16 PM
  • Lek me check and reply to you.

    Thanks

    Pradeep

    Thursday, March 07, 2013 5:42 AM