TechSpot

Open Office compatibility with MS Office ?

By macx
Mar 10, 2008
Topic Status:
Not open for further replies.
  1. Just took possession of a new/used laptop w/XP Pro sp2 and the OpenOffice
    apps.

    Transferred some Excel files onto it from my desktop and the OpenOffice
    equivalent worked fine to open and modify those Excel files.

    When I tried moving them back to the desktop, the MS Office files would not read the OpenOffice Excel equivalent.

    AFAIK, both the MS Office and OpenOffice versions are the latest.

    Any info on this? Would be nice if they'd work "both ways"

    Thx!
  2. kimsland

    kimsland Ex-TechSpotter Posts: 18,353

  3. Rick

    Rick TechSpot Staff Posts: 6,304   +52 Staff Member

    For the most part, MS Office documents open in Open Office just fine; however, Open Office documents are not supported by MS Office.

    So when you save your documents in Open Office, make sure you save them as .doc and NOT .odt. Same goes for .xls and .ppt as well.
  4. Didou

    Didou Bowtie extraordinair! Posts: 5,899

  5. macx

    macx TS Maniac Topic Starter Posts: 743

    Do I put that on the computer with OOffice, or on the computer with MS Office? The one I tried to transfer the OO excel file back to is a co machine and I'm not allowed to install anything on it.

    I will for sure do that on my own desktop tho - if it has to go
    on the receiving machine rather than on the machine with OO.

    (Edit - I see the add on has to go on the machine that has MS Office on it as an addition to it.
    Well, I can do it on my personal machine anyway.)

    Thanks!!
  6. Rick

    Rick TechSpot Staff Posts: 6,304   +52 Staff Member

    Using a plug-in is fine, but in OO, it is very easy to pick .doc instead of .odt during the "Save As" box dialogue and save your document in a format that Office understands. That would solve your issue and no installation needs to be done. :)

    The plug-in, much like saving your document as .doc can suffer from formatting issues though. It works pretty well for the most part, but be aware that documents may not be pixel-perfect between the two.
  7. macx

    macx TS Maniac Topic Starter Posts: 743

    Well, well!

    Of COURSE I missed that little tidbit!

    Will have to give it a try.

    Stands to reason there'd be a way to make it compatible
    going back to MS Office.

    Thanks!!
  8. Tedster

    Tedster Techspot old timer..... Posts: 10,074   +13

    In openoffice, you need to save the files in MS office format. Otherwise it defaults to openoffice format.

    Also in the next release of OO, it will allow import/ export of DOCX .

    For the most part OO is 100% compatible. You just need to pay attention to the file formatting.
Topic Status:
Not open for further replies.


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.