Is OpenOffice.org 100% compatible with MS Office?

Not sure where to post? Post here!

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

Postby Sunshine » Sun Oct 13, 2013 1:30 am

No, it certainly is not! I spent countless hours writing two books in OO. I then had to Paste them into a Word template. Blam! The format went all over the place. I spent hours and hours reformatting. It looked fine. I close the file and reopen it. Blam! It's a mess. I'm talking about having to go over 400 pages at a time. I'm way behind deadline, will have to purchase Word, and spend countless hours reformatting all over again.

I guess I should have done my research before using OO. It has cost me in time and lost income so much more than if I'd just purchased Word in the first place. It should definitely not be promoted as "compatible." It may be so for writing a simple one page letter. Certainly not for other purposes.
OOo 2.0.X on Ms Windows XP
Sunshine
 
Posts: 19
Joined: Mon Sep 15, 2008 9:26 am

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

Postby Villeroy » Sun Oct 13, 2013 11:29 am

No, it certainly is not! I spent countless hours writing two books in OO. I then had to Paste them into a Word template. Blam! The format went all over the place.

I'm surprised that MS Word is able to paste anything from a non-Microsoft application. Normally they should simply refuse anything from AOO and find a way to make AOO crash when you try to pullute their divine software with foreign content.
Why is MS Office unable to handle the ODF standard? Because they simply have to do nothing to make Sunshine believe that compatibility is a one-way road.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby Zizi64 » Sun Oct 13, 2013 11:53 am

I then had to Paste them into a Word template.


Why did you do that?


For example: Few people buy Adobe Acrobat editing software, but they all are used a free PDF reader software.
The MS Office have freeware Viewer softwares to display/print the "secret code like" binary doc, xls fileformats...

The AOO/LO have not standalone "READER" application, because it is cost free the 'editing software' too.

If you want to work efficiently with Apache OpenOffice or LibreOffice, then you need use the native, STANDARDIZED ODF document formats.
Everybody can download and install (one of) theese opensource office suites (for free), and they can open/read/print/edit your shared documents...
Tibor Kovacs, Hungary; LO4.4.7, LO5.4.7 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.0 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7000
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

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

Postby floris v » Sun Oct 13, 2013 12:08 pm

I just tried pasting a document made with OO in Word 2003, while Word does paste some of the formatting correctly, it messes up a lot. I suggest that if you have to exchange between OO and Word, you save in doc format instead of pasting. Still better is to bypass OO entirely if you share files with users of MS Office professionally.
MS Windows 10 - AOO 4.1.3 - LibreOffice 5.2.3.3
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
floris v
Moderator
 
Posts: 3999
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

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

Postby jrkrideau » Sat Oct 19, 2013 12:49 pm

Sunshine wrote:No, it certainly is not! I spent countless hours writing two books in OO. I then had to Paste them into a Word template.
....
I guess I should have done my research before using OO.


Yes you should have. OO has never claimed to be 100% compatible.

Why are you pasting something into a Word template? Cannot you duplicate the template in AOO and just save the document in .doc format?

Alternateively save everything as text and paste into the template?
LibreOffice Version: 6.0.3.2 Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3511
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

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

Postby Haribol0 » Mon Dec 09, 2013 3:49 am

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.
OpenOffice 4.0.1 on opensuse 13.1 with kernel 3.11.6-4-desktop
User avatar
Haribol0
Banned
 
Posts: 3
Joined: Mon Dec 09, 2013 3:44 am

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

Postby thomasjk » Mon Dec 09, 2013 6:16 am

If you don't want your clients to edit the files then PDF is a good choice. Otherwise .doc for compatibility with folks who have MS Office. Always save the original in native AOO format .odt etc.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4357
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

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

Postby Villeroy » Mon Dec 09, 2013 3:38 pm

Haribol0 wrote: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.


You don't need OpenOffice for this. Download and install the MS Word Viewer (free as in "free beer") from MS and a virtual PDF printer. Let the viewer print out PDFs.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby Pannetart » Mon Jun 02, 2014 12:21 am

I did an Open Office search (as suggested) and did not get any responses to my inquiry so I thought I'd ask here. I just downloaded OO 4.1.0 as it was suggested I use it to replace MS Office.
I noticed it is compatible with MS Word, Excel, & PowerPoint....but is it not compatible with MS Publisher?
I would like to open several Publisher files but didn't understand the window that opened asking me to choose a "filter selection". I use a Windows based OS.
Open Office 4.1.0 on a Toshiba laptop intel core i3=3120M
Pannetart
 
Posts: 1
Joined: Sun Jun 01, 2014 11:55 pm

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

Postby RoryOF » Mon Jun 02, 2014 2:44 am

Publisher is not supported in OpenOffice
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby keme » Mon Jun 02, 2014 3:08 pm

Not even MS Publisher is always compatible with MS Publisher... (I remember some years ago, failing to open older publisher files after upgrading. Had to roll back to the older version of the software.) Anyway, that does not help you much...

Some free file conversion services (such as zamzar) have publisher support, so you can convert your files to a format your software can handle. You will not always the layout preserved, but you get the content extracted (the few times I tried it I got all the content, but layout was "linear").
Apache OO 3.4.1/4.1.2/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice 4.3.3.2 on Mepis Antix MX 14
User avatar
keme
Volunteer
 
Posts: 2905
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

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

Postby JanetHudgins » Fri Mar 30, 2018 9:52 pm

I have been fighting with Office 2016's Word and just want to get rid of it. I'm happy to find a legitimate competitor as monopolies tend to make products less than perfect. But, I'm a writer, concerned that journals and publishers will not be able to accept OpenOffice and I won't be able to convert it to MS Word to accommodate them. Is there a solution already and what is the experience of other writers?

Appreciate your help.

Janet
NeoOffice 2.2.3 with MacOS 10.4
JanetHudgins
 
Posts: 1
Joined: Fri Mar 30, 2018 9:42 pm

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

Postby Villeroy » Fri Mar 30, 2018 10:05 pm

Non-US publishers?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby RoryOF » Fri Mar 30, 2018 10:07 pm

There will be differences; it is best to work in .odt (Writer's native format) and Save as in .doc format only when finished, but there will be differences. You could try using an external conversion facility, such at that offered by
http://www.zamzar.com
to convert the odt to .doc - this may be more accurate. Perhaps your publisher can work from a PDF file, and you can generate that by /File /Export as PDF.

Sometimes publishers run a doc file through filters to extract only the text without formatting, then reformat to suit their equipment.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby John_Ha » Sat Mar 31, 2018 12:24 pm

See [Tutorial] Differences between Writer and MS Word files for an extensive discussion, and for the reasons why you should always work in and save files as .odt. It includes this diagram which answers the question.

Remember that all versions of MS Word later than 2007 can both read and write .odt files.

MS files.png
Different capabilities in Writer and its .odt files compared with MS Word and its .doc, .docx (and .rtf) files.
Note that MS Word, while capable of supporting some of the function stored in a .odt file chooses not to implement that function.
MS Word 6.0/95 files cannot store Draw objects.
AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5689
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby esperantisto » Wed Apr 04, 2018 8:29 am

JanetHudgins wrote:…journals and publishers will not be able to accept OpenOffice…


In fact, publishers don’t need office suit files anyway because they use special dedicated formats in their processes. Office suit files are regarded as an inevitable evil and policies in their regard may vary. You have to ask particular publishers, not this forum.
AOO 4.2.0 / LibO 5.0.2.1 / Win 7 / openSUSE Linux 11.3 (32-bit) / 13.2 (64-bit)
esperantisto
Volunteer
 
Posts: 469
Joined: Mon Oct 08, 2007 1:31 am

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

Postby esperantisto » Wed Apr 04, 2018 8:32 am

John_Ha wrote:Remember that all versions of MS Word later than 2007 can both read and write .odt files.


In my practice, MS Word 2010 always reports errors and always presents a certain extend of formatting loss/distortion. It is much better to export files to DOC from AOO.
AOO 4.2.0 / LibO 5.0.2.1 / Win 7 / openSUSE Linux 11.3 (32-bit) / 13.2 (64-bit)
esperantisto
Volunteer
 
Posts: 469
Joined: Mon Oct 08, 2007 1:31 am

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

Postby John_Ha » Wed Apr 04, 2018 7:50 pm

esperantisto wrote:In my practice, MS Word 2010 always reports errors and always presents a certain extend of formatting loss/distortion. It is much better to export files to DOC from AOO.

The problem does not lie with the .odt files so complain vigorously to Microsoft.

See Microsoft's claim at Use Word to open or save a document in the OpenDocument Text (.odt) format where Microsoft lists what MS Word supports.

Read the Tutorial for other factors like different or missing fonts, headers and footers methodology etc.
AOO 4.1.5, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 5689
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

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

Postby bobbypergs » Tue May 08, 2018 9:43 pm

I think that Microsoft tends to sabotage ODT files somewhat, due to the free nature of open office.

It would make sense, at least, in the strictest sense that this would be the case. (I have never been able to get a 1:1 conversion back to either program. I was coming here hoping that there might be some insight, but most of the tips in here I've already tried.)
Open Office 3.1 on Windows 10
bobbypergs
 
Posts: 2
Joined: Mon May 07, 2018 9:38 pm

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

Postby Villeroy » Tue May 08, 2018 10:28 pm

Have you ever tested how far MS Office supports foreign file formats? If you have to edit MS documents, you need MS software. Simple as that.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 16.04, OpenOffice 4.x & LibreOffice 5.x
User avatar
Villeroy
Volunteer
 
Posts: 25570
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby ankit3302 » Fri Jun 08, 2018 11:18 am

OpenOffice.org is compatible with MS office but only upto some extent not 100%. If you want to full access to MS Office, you have to buy it. But generally people are not able to afford it , so they use openoffice which is very good to use.
OpenOffice 3.1 on Windows 10
ankit3302
 
Posts: 5
Joined: Fri Jun 01, 2018 8:34 am

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

Postby RoryOF » Fri Jun 08, 2018 11:22 am

Another reason to use Open- or Libre-Office is that MS Office does not run (without considerable trickery) on platforms other than Windows.
Apache OpenOffice 4.1.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
14 October 2016 was Pooh's 90th birthday
User avatar
RoryOF
Moderator
 
Posts: 26942
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby esperantisto » Fri Jun 08, 2018 3:09 pm

MS Office does not run (without considerable trickery) on platforms other than Windows.


Well, there is a native version of MS Office for Mac OS actually. And running under Linux is no big problem (although no piece of cake either).
AOO 4.2.0 / LibO 5.0.2.1 / Win 7 / openSUSE Linux 11.3 (32-bit) / 13.2 (64-bit)
esperantisto
Volunteer
 
Posts: 469
Joined: Mon Oct 08, 2007 1:31 am

Previous

Return to Beginners

Who is online

Users browsing this forum: No registered users and 5 guests