Open Source Software Technical Articles

Want the Best of the Wazi Blogs Delivered Directly to your Inbox?

Subscribe to Wazi by Email

Your email:

Connect with Us!

Current Articles | RSS Feed RSS Feed

LibreOffice vs. OpenOffice.org: Showdown for Best Open Source Office Suite

  
  
  

With the release of a new version of LibreOffice this month, it's a good time to look at the two major open source office suites, LibreOffice and OpenOffice.org, to see what advantages each offers, and which is a better bet for end users.

Both products are suites of office applications, comprising word process, spreadsheet, presentation graphics, database, drawing, and math tools. Both also spring from the same code base. OpenOffice.org was created by a German company called Star Division, which Sun Microsystems bought in 1999. Originally the suite was called StarOffice, and it was popular in the European market as an alternative to Microsoft Office. After picking it up, Sun changed the name of the product to OpenOffice.org and released its code as open source. The product retained some popularity in the enterprise, partly because of its cross-platform capabilities and no-cost license.

In 2009, Oracle announced it would be acquiring Sun, and many wondered what would become of OpenOffice.org. When Oracle proved to be less than willing to share its plans for the product, a number of OpenOffice.org community members opted to fork the OpenOffice.org code. In November 2010, they created LibreOffice, to be managed by a new German non-profit called The Document Foundation.

A few months later, Oracle opted to donate the OpenOffice.org project to the Apache Software Foundation, which today maintains OpenOffice.org as a so-called podling project until OpenOffice.org completes the migration process to become fully integrated within the Apache organization.

 

The Growth of LibreOffice
 

In the 10 months since LibreOffice split off from OpenOffice.org, the new office suite has maintained a more rapid release cycle than the old 18-month cycle maintained by Sun and Oracle. It is not clear how rapidly OpenOffice.org will update as the suite moves forward within the Apache system, but it's a fair bet that the development cycle will speed up.

LibreOffice's development cycle has put its version 3.4.2 ahead of OpenOffice.org's 3.3.0, in more ways than just version numbers. The LibreOffice team is implementing a lot of fixes that many in that development community felt were needed. For instance, LibreOffice's ability to import file from Microsoft Office is getting better than that of OpenOffice.org. Opening heavily revised and commented Word files in OpenOffice.org still leads to misrendered comments and loads of font issues, while LibreOffice Writer handles revisions, comments, and fonts nearly perfectly. Other fixes include more ODF-compliant color and line support as well as an improved Print dialog box that is markedly better than its OpenOffice.org counterpart.

Calc improvements are also coming fast in LibreOffice, the best of which currently being a much-improved Pivot Table tool (now actually called "Pivot Table" instead of the old "DataPilot" moniker). Pivot tables and LibreOffice don't have a pleasant history: the last time I tested it, opening a spreadsheet with a pivot table inside would cause LibreOffice Calc and every other LibreOffice window to crash, where OpenOffice.org would open the same spreadsheet fine. Fortunately, since LibreOffice 3.4.2, those days are gone. LibreOffice Pivot Tables also now allow for named ranges, which is a great addition.

In other areas, Calc in LibreOffice and OpenOffice.org are pretty much on equal footing. Fonts and basic functions in Excel documents are converted perfectly, though many not-really-that-obscure Excel functions don't come across at all. SUMIF and COUNTIF are there, but not their multi-range/criteria counterparts SUMIFS and COUNTIFS, nor AVERAGEIF and AVERAGEIFS. This makes Calc a bit weak as an Excel replacement in either office suite.

Impress is a better experience all around, and equal in both flavors of the suite. PowerPoint presentations open easily, and fonts and images transfer pretty well. There's a slight edge in this application for the LibreOffice version, which has put the Presenter's Console front and center as an easily installed extension.

These three components comprise the bulk of use for most end users. LibreOffice and OpenOffice.org are pretty similar in performance and features in the other office suite applications, with one exception: LibreOffice Draw now has support for scalable vectore graphics, something OpenOffice.org lacks.

 

Support and Certification

 

Aside from the code, OpenOffice.org used to have one big advantage over LibreOffice: corporate support. When OpenOffice.org belonged to Oracle and to Sun, enterprises could buy annual support for $90 per seat, which got you support and hooks into Microsoft SharePoint or the Alfresco content management systems. Small businesses could get support alone for $50 per seat.

Unfortunately, that advantage is gone. In April, before Oracle announced its intention to move OpenOffice.org to Apache, it dropped commercial development and support for OpenOffice.org. Now the two office suites have virtually identical support options. Each suite has online forums, newsgroups, and mailing lists. Corporate support is available from some third-party companies, such as the Linux distribution vendors who ship LibreOffice or OpenOffice.org, or any number of consultants that can be found on either project's website.

Support vendors must be certified, so you know you're not hiring some schmoe off the street. Here, OpenOffice.org has the slight edge. LibreOffice, according to Italo Vignoli from the Document Foundation, is "planning a certification program to make it easier for providers of services to be recognized and for corporate users to select a competent partner." OpenOffice.org, though, already has a certification program in place, though it is not clear how or if that program will undergo alterations within the Apache umbrella.

 

19a98812-f823-48dc-841e-bf029c63c6d7

 

Which One Wins?


With its rapid development cycle, LibreOffice has already pushed its feature set ahead of OpenOffice.org's. OpenOffice.org may catch up, but the licensing differences between the two projects may hold it back. When OpenOffice.org was moved into the Apache Software Foundation, it was placed under the Apache Software License (ASL) v2. LibreOffice is dual-licensed under the Mozilla Public License and the Lesser General Public License (LGPL) 3.0. That means that while LibreOffice developers are free to incorporate OpenOffice.org code into their project, the reverse is not true. LibreOffice's licenses are incompatible with the Apache license, so OpenOffice.org developers will be unable to directly capitalize on the progress made by the LibreOffice team.

The outlook is not completely dismal for OpenOffice.org. With IBM heavily invested in OpenOffice.org development (its proprietary Lotus Symphony office suite is based on OpenOffice.org), there's a fair chance that some improvements made in Lotus development could find their way into OpenOffice.org.

That's looking ahead, however. For now, it appears that LibreOffice offers a better feature set, and with support options being equal, it's the features that currently make all the difference.


 



This work is licensed under a Creative Commons Attribution 3.0 Unported License
Creative Commons License.


This work is licensed under a Creative Commons Attribution 3.0 Unported License
Creative Commons License.

Comments

LibreOffice Rules!!!
Posted @ Sunday, August 05, 2012 12:07 AM by Cody
I have tried, without success, the pivot table function with files created by microsoft excel. Yes, the file can be opened alright, but I can't refresh the data, making it non-functional. Either OpenOffice or LibreOffice is a practical replacement of microsoft excel. Is there anything in line to address this one big problem? Sally
Posted @ Sunday, November 04, 2012 9:24 AM by sally chun
http://www.urbanboutiqueclothes.com cheap gucci belts 
http://www.urbanboutiqueclothes.com Cheap louis vuitton shoes 
http://www.urbanboutiqueclothes.com cheap gucci Clothing 
Cheap gucci clothes,Wholesale Gucci shoes,Buy Gucci Product online china 
Cheap wholesale Cheap gucci Belts,Discount fendi Belts china 
Cheap wholesale Nike Styles Shoes,Women Air Max 2013 Shoes 
Cheap wholesale Armani clothing and Armani AAA belts,Armani T Shirts 
Cheap wholesale Gucci T Shirts,Discount Gucci Men T Shirt,Gucci Handbags 
Cheap wholesale Louis Vuitton Men High Top,lv T Shirts,Super AAA Belts and wallets 
Cheap wholesale Dolce Gabbana Men T Shirt,cheap AAA belts,Dolce Gabbana Men Shoes 
Cheap wholesale Polo Men T Shirt,New Polo Online clothing,sale cheap clothing 
Cheap wholesale Prada Sunglasses,Prada Men T Shirt,Cheap Prada AAA Belt 
Cheap wholesale D&G Belts,Hermes Belt,Ed Hardy Belts,Hermes Wallet 
Cheap wholesale Gucci Belts,LV Belts,Adidas Men Tracksuit,Jordan Shoes 
Cheap wholesale Clothing,Discounts Gucci,LV,Armani,T Shirts sale 
http://www.urbanboutiqueclothes.com stylish fendi Belts 
http://www.urbanboutiqueclothes.com/  
Posted @ Tuesday, September 10, 2013 6:14 AM by mionghaoui
http://www.urbanboutiqueclothes.com cheap gucci belts 
http://www.urbanboutiqueclothes.com Cheap louis vuitton shoes 
http://www.urbanboutiqueclothes.com cheap gucci Clothing 
Cheap gucci clothes,Wholesale Gucci shoes,Buy Gucci Product online china 
Cheap wholesale Cheap gucci Belts,Discount fendi Belts china 
Cheap wholesale Nike Styles Shoes,Women Air Max 2013 Shoes 
Cheap wholesale Armani clothing and Armani AAA belts,Armani T Shirts 
Cheap wholesale Gucci T Shirts,Discount Gucci Men T Shirt,Gucci Handbags 
Cheap wholesale Louis Vuitton Men High Top,lv T Shirts,Super AAA Belts and wallets 
Cheap wholesale Dolce Gabbana Men T Shirt,cheap AAA belts,Dolce Gabbana Men Shoes 
Cheap wholesale Polo Men T Shirt,New Polo Online clothing,sale cheap clothing 
Cheap wholesale Prada Sunglasses,Prada Men T Shirt,Cheap Prada AAA Belt 
Cheap wholesale D&G Belts,Hermes Belt,Ed Hardy Belts,Hermes Wallet 
Cheap wholesale Gucci Belts,LV Belts,Adidas Men Tracksuit,Jordan Shoes 
Cheap wholesale Clothing,Discounts Gucci,LV,Armani,T Shirts sale 
http://www.urbanboutiqueclothes.com stylish fendi Belts 
http://www.urbanboutiqueclothes.com/  
Posted @ Tuesday, September 10, 2013 7:01 AM by mionghaoui
<p>Okay, that's not exactly the giuseppe zanotti festive way to kick off Toms Shoes Company but it certainly is the most rewarding for us Fitflop Footwear. A Pharrell hat trend, workout gear that with a coach handbags, and the new Coach Outlet…Knowing handbags confidence is an issue that rocks Michael Kors Outlet how I got myself back on track to celine outlet quickly.We chatted with makeup michael kors outlet online, on photo shoots, and on the red (hello coach, fitflop usa!) to bring you the ultimate guide to trying, buying, and michael kors outlet.However, what celine bags superstar and giuseppe zanotti online is doing is more than just a simple fundraising event. coach factory outlet to about a million household in michael kors before 2015.coach factory took the English Rose as the theme for his Fitflops flowers and a finale of falling coach outlet.So, secondly, that means us coach outlet store online's always flawless red carpet coach factory outlet leading up to that date. I love the fun and preppy look of pennants, but since our coach factory outlet Lucy doesn't have a coach factory outlet online yet, I decided to adorn this pennant pillow with her toms usa. Taking the field out michael kors outlet store, plus one other runner turned up at the 6.75-mile aid station in Fitflop, a smidge over 6:00-mile pace.the brainchild of coach, is exclusively at prada outlet for now, but mark my words: We scoured photos snapped outside Fashion Weeks from coach to new york and came up with 50 shots that showcase models with amazing street style.</p>
Posted @ Sunday, March 23, 2014 10:43 PM by http://www.giuseppezanottidesigner.com/
http://www.coachfactoryoutletsco.com/ coach factory outlet 
http://www.coachfactory.us.com/ coach factory 
http://www.coachoutletstoresco.com/ coach outlet 
http://www.coachoutletstoresinc.com/ coach outlet store online 
http://www.michaelkorsoutletsmk.com/ michael kors outlet 
http://www.timberlandshoes.us.com/ timberland shoes 
http://www.michaelkorsoutlet-factory.com/ michael kors outlet 
http://www.coachfactoryoutletspurses.com/ coach factory outlet 
http://www.coachfactoryoutlete2014.com/ coach factory outlet 
http://www.truereligionbrandjeans.us.com/ true religion outlet 
http://www.truereligionjeans.us.com/ true religion jeans 
http://www.coachoutletonlinehandbag.com/ coach outlet online 
http://www.louisvuittonoutlet-purses.com/ louis vuitto purses 
http://www.timberlandboots.us.com/ timberland boots 
http://www.isabelmarantshoes.us.com/ isabel marant shoes 
http://www.coachoutletstore-factory.com/ coach outlet store online 
http://www.michaelkorsoutlet-purses.com/ michael kors purses 
http://www.louisvuittonoutlethandbag.com/ louis vuitton handbags 
http://www.coachoutletstoresofficial.com/ coach outlet 
http://www.truereligionjeans-2014.com/ true religion jeans 
http://www.coachfactoryoutlets-online.com/ coach factory outlet online 
http://www.coachfactoryoutlet-store.com/ coach factory outlet 
http://www.coachfactoryoutlet-handbag.com/ coach factory outlet 
http://www.louisvuittonoutlets2014.com/ louis vuitton outlet 
http://www.coachfactoryoutletstoreco.com/ coach factory outlet 
http://www.coachfactoryoutletonlineinc.com/ coach factory outlet online 
http://www.michaelkorsoutletonlineco.com/ michael kors outlet 
http://www.michaelkorsoutletstoresco.com/ michael kors outlet store 
http://www.tiffanysjewelry-co.com/ tiffanys jewelry 
http://www.celineoutlet-online.com/ celine outlet 
http://www.cheapjerseysco.com/ cheap jerseys 
http://www.tomsshoescompany.com/ toms shoes 
http://www.alexanderwang-shoes.com/ alexander wang shoes 
http://www.alexanderwang-bags.com/ alexander wang bags 
http://www.sacsburberry.com/ sac burberry 
http://www.celinebags-outlet.com/ celine bags 
http://www.tomsusashoes.com/ toms outlet 
http://www.fitflopsandalssale.com/ fitflops 
http://www.fitflopusaonline.com/ fitflop outlet 
http://www.giuseppezanottisneakers.co.uk/ giuseppe zanotti sneakers 
http://www.marcbymarcjacobsoutlet.co.uk/ marc by marc jacobs 
http://www.pradaoutleteco.com/ prada outlet 
http://www.tiffanyandcoinc.com/ tiffany jewelry 
http://www.pradaoutlet-factory.com/ prada outlet 
http://www.michaelkors-co.com/ michael kors 
http://www.marcjacobs.us.com/ marc jacobs 
http://www.giuseppezanotti.us.com/ giuseppe zanotti 
http://www.supra.us.com/ supra shoes 
http://www.ralphlauren.us.com/ Polo ralph lauren 
http://www.alexanderwang.us.com/ alexander wang 
http://www.tiffanyjewelry.us.com/ tiffany jewelry
Posted @ Monday, May 12, 2014 2:14 AM by coach outlet
The price!!!! 
3w.peiceinsider net 
 
3w.peiceinsider net 
 
3w.peiceinsider net 
 
3w.peiceinsider net 
 
3w.peiceinsider net
Posted @ Friday, May 23, 2014 2:07 AM by jordan shoes
Thanks for sharing this information.
Posted @ Friday, July 04, 2014 4:45 PM by Office Paper Products
Excellent is the only word i can give u for this wonderful blog, keep it up. I will come back again to read some more interesting things on this topic
Posted @ Wednesday, September 24, 2014 12:55 AM by One Stop Plus Coupon
Post Comment
Name
 *
Email
 *
Website (optional)
Comment
 *

Allowed tags: <a> link, <b> bold, <i> italics