Read with Formatting | Join TechSpot! (it's free) | Bookmark / Share this



Open Office compatibility with MS Office ?

macx
03-10-2008, 09:30 PM
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!

kimsland
03-10-2008, 09:48 PM
Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats
http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en

Ad
03-10-2008, 09:48 PM

Rick
03-10-2008, 10:25 PM
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.

Didou
03-11-2008, 03:50 AM
Get the OpenXML/ODF Translator Add-ins (http://odf-converter.sourceforge.net/).

macx
03-11-2008, 04:46 AM
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!!

Rick
03-11-2008, 02:39 PM
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.

macx
03-11-2008, 08:06 PM
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!!

Tedster
03-12-2008, 02:46 AM
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.

 Top Technology News

 Software Downloads

Copyright © 1998-2008 TechSpot.com. TechSpot is a registered trademark. All Rights Reserved.