[Solved] Is OpenOffice 100% compatible with MS Office?

Not sure where to post? Post here!
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by acknak »

As I hear it, many companies use special software for managing incoming resumes (filing, searching for keywords, etc.) and the software only accepts MS Office documents because "that's what everyone uses." Even worse, the software may reject documents not produced by MS Office itself, even though the document is "compatible" with the .doc format.

I agree that that approach is a sign that the company doesn't really know what they're doing, but not many people have the luxury of restricting their job search to companies with competent IT & HR departments.
AOO4/LO5 • Linux • Fedora 23
firmepaza
Posts: 1
Joined: Tue Apr 10, 2012 10:04 am
Location: timisoara

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by firmepaza »

In Romania there are 2 main sites for jobs and both of them offer the posibility to save/view/export the resume also in pdf format. I think that users of an job site should have the posibility to choose in what tipe of file their resume sould be exported or downloaded.
OpenOffice 3.3 on Windows 7
Paxwax
Posts: 1
Joined: Tue Jul 31, 2012 5:40 pm

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Paxwax »

Just want to say that The Ghurka's reminder 'Make sure the 'Automatic file name extension' option is checked.' when confirming a Word document, has made an enormous difference to me. I was going in circles trying to establish a Word document. So easy to forget. So important. Many thanks.
Open Office Version 3.4
Microsoft Windows
LukeFlyswatter
Posts: 1
Joined: Fri Aug 03, 2012 10:56 pm

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by LukeFlyswatter »

I am a wood restoration contractor in Jacksonville, FL. and I use an estimating software for my business which outputs in MS Word format. The program is a little dated, but it suits my purposes just fine. I would like to use open office instead of MS word, because I try to stay away from MS products as much as humanly possible, while still being able to function! I was turned on to open office by a friend about six months ago, and I really like it, but I'm just learning it.

The estimating software I use outputs the estimates and contracts in .rtf format, and it seems to open fine with open office, so comparability seems ok.

I didn't want to start a new thread for this, but once I'm done editing, what is the best format to save files in, so that my customers have an easy time opening them? I have run into problems with some (not so computer savvy) customers not being able to open my estimates when they are saved as .rtf.

The estimates have a logo .bmp and some formatting I don't want to lose. I don't want to convert them to nothing but text files, because I lose that presentation. What would you gurus recommend I do? Should I make these into pdf as mentioned above, and completely avoid compatibility with MS word, or the like? How would I go about it? I don't know everything about this software yet.
Open Office 3.4.0
Windows 7 64-bit
Deck Staining & Sealing Jacksonville, FL
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by RoryOF »

PDF is best, with secondly .DOC.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
FJCC
Moderator
Posts: 9231
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by FJCC »

A big advantage of the PDF format is that it will be much more difficult for your customers to edit the document. I assume you just want them to read the estimate, not change it. As for how to create a PDF, there is a button for that on the main tool bar, it is the 6th from the left on my system. You can also do it from the menu File -> Export as PDF
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by acknak »

LukeFlyswatter wrote:... once I'm done editing, what is the best format to save files in, so that my customers have an easy time opening them? ...
Here's how I'd handle it.

First, don't open the rtf files directly. Keep them untouched, as backups, in case something goes wrong.

Instead, do File > New > Text Document, then do Insert > File and choose your rtf file. That two-step procedure will preserve the content and formatting of the rtf but give you a document in OOo's native, best working format, ODF. You can then File > Save your edited document as ODF (.odt), without writing over the original rtf version.

For customers, as long as they don't need to change the file (right?), I would send a pdf. I can't remember ever running into someone who couldn't open a pdf, and it will preserve all your formatting, even if you use some fonts they don't have. .doc or .rtf are just asking for trouble.
AOO4/LO5 • Linux • Fedora 23
Kleptoma
Posts: 1
Joined: Fri Aug 10, 2012 7:26 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Kleptoma »

I was trying to convert my word doc from MS office to an rtf file. Is there any simple way of doing so?
OpenOffice 3.1 on Windows Vista
Visual Impact Muscle Building Review
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by RoryOF »

Try Wordpad, which comes with Windows. OpenOffice support for rtf is not good.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Bill
Volunteer
Posts: 8929
Joined: Sat Nov 24, 2007 6:48 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Bill »

Kleptoma wrote:I was trying to convert my word doc from MS office to an rtf file. Is there any simple way of doing so?
Have you tried opening the file with Writer and saving as an RTF file? Were the results inadequate?
RoryOF wrote:Try Wordpad, which comes with Windows. OpenOffice support for rtf is not good.
That might work for Wordpad in XP or older versions of Windows. Support for opening DOC files was dropped for Wordpad in Vista.
User avatar
kingfisher
Volunteer
Posts: 2123
Joined: Tue Nov 20, 2007 10:53 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by kingfisher »

In my version, there is an option to save a document in RTF format.
Apache OpenOffice 4.1.9 on Linux
kimdep
Posts: 1
Joined: Sun Oct 07, 2012 7:01 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by kimdep »

[/quote]
TheGurkha wrote:
cindy5522 wrote:Could you dumb it down a little please? I am not very computer literate. When I email my resume, created in Open Office, it opens as jibberish on the other end. I sent it to a friend with a Mac, and she could open it. What do I need to do so that potential employers can open my resume, if I don't know what system they are using? Thank you
Send it as a PDF. Anyone can open it then, on any machine. There is a PDF button right next to the print icon on the toolbar.

If they want to open it and edit it, then you need toknow what they are going to open it with. If it is OOo then you don't need to do anything. If is is Word then you need to have saved it in Word format, so that Word can understand it.

File > Save As and select 'Microsoft Word 97/2000/XP' from the 'Save as type' dropdown menu. Make sure the 'Automatic file name extension' option is checked.

It is always safer to work in the native OOo formats (.odt and .ods etc) and then use Save As to save a copy in .doc or .xls format if you need to distribute it in MS Office formats. But always then go back to the native OOo version to continue working. If the people you are sending to do not need to edit the files then it is best to send them a PDF as then no matter what office suite they use it will be possible for them to read and print the files.
When I save my OO and try to convert to MS Office, it won't let me. It makes me save it in Odf (odt). But then when I send it to someone, it will not open on the other end in MS Office. What is the problem? I am frustrated!
Open Office 3.4
on Windows 7
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by RoryOF »

kimdep wrote:[When I save my OO and try to convert to MS Office, it won't let me. It makes me save it in Odf (odt). But then when I send it to someone, it will not open on the other end in MS Office. What is the problem? I am frustrated!
How does it make you save in .odt format? If you drop down the type selector on the Save As screen and select MS Office 07/2000/XP format, with "automatic file name extension" checked, it will give you a warning that some forating may be lost. This is only a warning - you can accept its advice or not, as you choose.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Villeroy »

kimdep wrote:But then when I send it to someone, it will not open on the other end in MS Office. What is the problem? I am frustrated!
File>Send>Send as PDF
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Harshit
Posts: 3
Joined: Thu Oct 11, 2012 11:32 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Harshit »

I am using MS Office for making documents which includes headers and footers and size of the document goes upto 200 pages. Now when i open the same document in Open Office the page borders goes up and surrounds all header and footer. Is there any solution that if i open the document in Open Office the page border could be set below the headers??

Same way is there any provision in Open Office to go in next section of header with a click ?
OpenOffice 3.1 on Windows 7 Home Premium
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Villeroy »

Export from WinWord to .doc and try that format. The new .docx format is too complex and too new.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Bill
Volunteer
Posts: 8929
Joined: Sat Nov 24, 2007 6:48 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Bill »

Your version of OOo is obsolete. If the problem is due to a bug, it may have been fixed in a newer version.
Harshit
Posts: 3
Joined: Thu Oct 11, 2012 11:32 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Harshit »

Dear Villeroy i am using .doc formats only for my documents in one of the PC and open office in other PC. Then also i am facing problems with formatting in Open office.
OpenOffice 3.1 on Windows 7 Home Premium
User avatar
RoryOF
Moderator
Posts: 34571
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by RoryOF »

As the filters for .doc formats have been reverse engineered it is likely that OpenOffice will open such files with formatting differences to MS Office. Such differences show up usually with more complex formatting, including headers/footers/ comments and tables. If formatting is required to be invariant at editing level between computers it is best to use only the same program and the same font selection, working in that program's native format.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Harshit
Posts: 3
Joined: Thu Oct 11, 2012 11:32 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Harshit »

Thanks a lot RoryOF.
OpenOffice 3.1 on Windows 7 Home Premium
MurrayScott
Posts: 2
Joined: Wed Aug 01, 2012 8:29 am

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by MurrayScott »

I have no trouble with OpenOffice compatibility with Microsoft files but I frequently get email attachments carrying the".doc" extension that OpenOffice assumes are MS Word 97 format, then raises an error message saying "the file is corrupt and cannot be opened". Picking through such files with Notepad I found the characters "XML" and thus tried renaming with a ".docx" extension, following which OpenOffice opened them correctly.

We cannot complain about Microsoft having adopted an XML standard, but recent versions of MS Word do not appear to (always) label these as .docx files. To access these email attachments I have to find the file in the "attach" folder, rename it with a .docx extension (thus confusing its association with the incoming email) after which OpenOffice happily opens it. This is a tedious process and having to do it several times a day gets my goat. I use an old version of the Eudora email program but that does not seem to be the problem as files which do arrive with the .docx extension appear as such and are opened by OpenOffice correctly.

Since MS Word seems to use the .doc extension ambiguously, could future revsions of OpenOffice help us out by recognising that ambiguity, trying to interpret ".doc" files in either Word 97 or later XML formats?
Openoffice 3.2.1 OOO320m18 (Build:9502)
Win XP Version 5.1 (Build 2600.xpsp_sp3_gdr.120504-1619:Service Pack 3)
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Hagar Delest »

Rather strange. Have not tried on Windows but I think that the extension doesn't matter if AOO is launched, it should open the file.
If even MS Office doesn't know when applying the correct extension, that's rather difficult to correct AOO POV.
Have you tried with AOO 3.4.1?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Villeroy »

MurrayScott wrote: Picking through such files with Notepad I found the characters "XML" and thus tried renaming with a ".docx" extension, following which OpenOffice opened them correctly.
After 20 years of wide spread personal computing, far too many users still have no clue about files. I'm 90% sure that somebody renamed a docx file to doc and attached it to the email.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by acknak »

Hagar Delest wrote:Rather strange. Have not tried on Windows but I think that the extension doesn't matter if AOO is launched, it should open the file.
If even MS Office doesn't know when applying the correct extension, that's rather difficult to correct AOO POV.
Have you tried with AOO 3.4.1?
No, the poster's report is accurate. I just renamed a docx file and tried to open it from AOO 3.4.1: all you get is the "document corrupted" window, and then a "nope can't do it" window if you ask to have it repaired.

If I select the correct file type, then the document opens properly.

My guess is that this is because the OOXML support is still new and somewhat in flux.
AOO4/LO5 • Linux • Fedora 23
Tauiliili
Posts: 1
Joined: Fri Jul 05, 2013 6:42 pm

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Tauiliili »

I have emailed myself a document saved in Openoffice and I cannot open it at work. There is only MS 2003 at my work, how can I convert the document?? I do not have access to download openoffice on my work computer. PLEASE HELP!
Openoffice 2.4 to windows vista
User avatar
Hagar Delest
Moderator
Posts: 32594
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Hagar Delest »

You can try an online converter like zamzar.com.
Next time, export as .doc (but remember that the import/export filters were reverse engineered).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
camel
Posts: 1
Joined: Sun Jul 07, 2013 6:33 pm

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by camel »

Hagar Delest wrote:Next time, export as .doc (but remember that the import/export filters were reverse engineered).
Is that bad that they are reverse engineered (not recommended)?
So far I have always exported/imported, but more than once I got a strange error message.
I always thought exporting/importing was more reliable than online converters but I am no authority in the matter...

________________________________________________________
Free hosting
Last edited by camel on Tue Oct 08, 2013 5:52 pm, edited 2 times in total.
OpenOffice 3.1 on Windows 7
User avatar
floris v
Volunteer
Posts: 4408
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by floris v »

camel wrote:Is that bad that they are reverse engineered (not recommended)?
So far I have always exported/imported, but more than once I got a strange error message.
I always thought exporting/importing was more reliable than online converters but I am no authority in the matter
Reverse engineering means that the filters were written based on analyses of existing documents, not on the documentation of the file structure. It's not the best way of doing things, but if the documentation of the file structure is not available or so unreadable that it might just as well not be available, it's the next best thing.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
Villeroy
Volunteer
Posts: 31265
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Is OpenOffice.org 100% compatible with MS Office?

Post by Villeroy »

Why are the Microsoft Office file formats so complicated? (And some workarounds)
In short: For technical/economical reasons there can not be any application doing the same as MS Office without being MS Office or a very close clone of it. So install and use MS Office if you really need to work with MS Office file formats.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Locked