LibreOffice/OpenOffice vs. MS-Office

3

What is the difference between them? ...I mean like if I create a document under MS-Office, what problems could occur if I want to edit it later with ooo.org?

LanceBaynes

Posted 2011-05-12T17:52:25.890

Reputation: 3 510

Answers

2

Usually there are only minor formatting errors, if at all. There are some edge cases where using a specific Brand New Feature in Office won't work with OOO/LO and vice-versa, but those are the exception.

The biggest difference is the interface. Someone that is used to Office 2007 will take a while to find their comfort zone with anything beyond the very basic features in OOO/LO.

Hyppy

Posted 2011-05-12T17:52:25.890

Reputation: 3 636

what about macros? are there any problems regarding with those? – LanceBaynes – 2011-05-12T18:06:58.693

Pricing and licensing restrictions are also a very important difference: For pricing, while fully featured versions of LibreOffice and OpenOffice is free, MS-Office has price tags that range from less than $200 to over $600 here in Canada depending on how many features you're willing to pay for (and not everyone qualifies for the lower priced bundles). For licensing, LibreOffice and OpenOffice are open source though MS-Office is not (which may also be an important factor with regards to data security). – Randolf Richardson – 2011-05-12T18:49:26.513

I believe OOO/LO have support for macros, but they may not be fully compatible with MS Office. The best way to decide is to just try it on your own macros and see if they work. – Ryan C. Thompson – 2011-05-12T19:45:53.657

@LanceBaynes: For the most part, the Basic on both MS and OOO are surprisingly similar. – surfasb – 2011-08-06T09:42:37.937

@Randolf Richardson: Open-Source != exploit free. http://www.cert.org/blogs/certcc/2011/04/office_shootout_microsoft_offi.html http://dankaminsky.com/2011/03/11/fuzzmark/

– surfasb – 2011-08-06T09:43:31.773

@surfasb: I never made any claim that open-source equates to being exploit-free. The advantage of open source software is, however, that those who are concerned about security always have the option of immediately reviewing the code themselves (or hiring someone with the needed expertise to review the code for them) -- with closed-source products, this option typically isn't available. So, although being open source can be an important factor with regards to data security (which could be about privacy, data reliability, etc.), it certainly is not the only factor. – Randolf Richardson – 2011-08-07T20:33:40.780

If only security reviews and testing was as easy as looking at the code. . . – surfasb – 2011-08-08T00:03:00.117

It's not easy, no. Security never is. – Hyppy – 2011-08-11T12:41:40.933

2

It has to be added here - that Word 2007+ - supports .odt (it's a OO/LO file format) - while Word 2003 doesn't.

In my experience - you can interact with both - Word and OO/LO - if and only if - you don't use any fancy formatting features.

Adobe

Posted 2011-05-12T17:52:25.890

Reputation: 1 883

It's the PowerPoint slides that don't like to convert well . . . – surfasb – 2011-08-06T09:44:12.100