Posts tagged openoffice

Review LibreOffice 3.6 Vs OpenOffice 3.4 Vs MsOffice Vs iWorks (on Win/Mac/Linux)

So there was a lot of confusion and some complaints about my previous faceoff OpenOffice vs LibreOffice, some stuff was deserved (not providing the test files was silly, but i did use office documents so i couldn’t without messing with them), making a strange graph with strange values, not including the other operating systems even though the results were close, so I’m fixing all of this on this review, it will be simple and similar in point (comparison of performance for a small business office), because im doing this review as much for me as anyone else, in an office setting, were performance is the most important thing followed by a responsive layout and good formatting (stuff like compatibility or features are not as important since all of the software here has the features we want and used for years!).

This is the setup i will be using (and yes i wont be using my ssd powered hardware, because i dont have any at the office):

  • Windows 7 – Intel T3200 2Ghz (2 Cores) – 3GB – HD 7200RPM.
  • Ubuntu 12.04 – (with gnome classic of course, unity?… please…) Same specs as Win7, its dual boot.
  • Mac OSX 10.6.8 – Intel Core 2 Duo 2.4Ghz (2 Cores) – 4GB – HD 7200RPM.

The files i will be using are (you can get them here):

  • Small Excel File – 44KB
  • Large Excel File – 3.3MB
  • Small Doc File – 80KB
  • Large Doc File – 22MB

Why no OpenDocument (.odf or .od) or Office Open XML (.docx or .xlsx)? Well cause 90% of our files are .xls or .doc and normally when we receive in any other format, we convert it to .xls or .doc (Office 2003 format), as well as LibreOffice 3.5 (what we are using now) can pretty much open any file-type, so i’m aiming to what we normally use.


For the software, all operating systems are up to date, i’ve disabled as much software as i can from all of them prior to the tests (that means, anti-virus, dropbox, etc), also on windows 7 im using Ms Office 2003 and on Mac im using Office 2008 and iWork 09, the reason being these are the only ones i own and its mostly for comparison purposes, all installations were on the typical settings and on Mac i did close the software every-time, so hot start was with the program fully closed.

Libreoffice and Openoffice need to do some tweaks on first run, so i did first runs with no files just to finish that, also for each cold start, the measurement is the time of the first run of the file (this time around, no averages!), time is as follows 1:15:30.45 (1 hour, 15 minutes, 30 seconds and 45 centiseconds), also only added the CPU on the large .doc because that was the only one that freaked out the Office’s, on all the other files CPU dropped to 0 or very near it after loading.

Windows 7

Small .xls Large .xls Small .doc Large .doc
cold hot mem cold hot mem cold hot mem cold hot mem CPU%
LibreOffice 3.6 21.0 5.12 46.3MB 7.38 6.30 50.7MB 6.67 3.85 44.6MB 1:18.88 1:18.71 124.7MB 50
OpenOffice 3.4 9.64 4.60 36.7MB 5.57 4.89 39.2MB 5.99 3.53 32.5MB 2:13.42 2:14.91 114.3MB 20/30
MsOffice 2003 1.83 0.72 3MB 1.71 1.05 8.6MB 2.40 0.79 9.9MB 6.36 5.45 25.2MB 15

Clear winner here is MsOffice 2003 blazes past LibreOffice 3.6 and OpenOffice 3.4, still its kinda weird that altough nitpicking, its OpenOffice that still nudges past LibreOffice and takes second place, and even on the large .doc where it took almost 1 more minute to load than LibreOffice it still was way more responsive after loading, while LibreOffice was hanging and lagging hard (using a full core) and it also crashed on shutting down.

Mac OSX 10.6.8

Small .xls Large .xls Small .doc Large .doc
cold hot mem cold hot mem cold hot mem cold hot mem CPU%
LibreOffice 3.6 14.11 10.94 124 11.94 11.58 133 12.71 10.83 131 39.71 39.44 222 100
OpenOffice 3.4 15.40 11.96 125 12.81 12.55 133 12.81 11.56 125 3:03.75 3:04.01 204 2
MsOffice 2008 40.60 15.38 151 19.55 18.80 171 19.90 17.31 177 18.57 17.76 183 6
iWork 09 1:55.53 10.1 199 15.61 15.63 188 8.66 6.21 171 4:31.28 3:28.0 479 45

First things first, the winner here is pretty much LibreOffice 3.6, still it seems to struggle hard on the large .doc, it hangs hard and has a hard time with it (although it opened the file surprisingly fast) the biggest loser here is iWork, since not only does it struggle to open files but between all the Office’s it was the only one that had bad formatting, MsOffice 2008 was good enough on everything.

Ubuntu 12.04

Small .xls Large .xls Small .doc Large .doc
cold hot mem cold hot mem cold hot mem cold hot mem CPU%
LibreOffice 3.5.6.2 5.16 2.82 36 5.03 4.04 42 5.06 3.11 30 1:13.32 1:14.02 46 6
LibreOffice 3.6 6.86 4.13 38 6.47 5.43 43 5.28 4.06 34 41.89 41.73 90 108
OpenOffice
3.4
10.19 4.37 35 6.11 5.82 44 5.16 4.29 27 2:58.73 2:53.53 80 110

WTF! All 3 Offices performed really great, the winner here is LibreOffice 3.5, but not by a wide margin, and on the large .doc all of them suffered on one thing or another, LibreOffice 3.5 had bad formatting on the large .doc, but was pretty responsive after loading, LibreOffice 3.6 and OpenOffice 3.4 were both lagging hard and made it almost impossible to view or edit the large .doc.

Conclusion

Here is a quick chart of best performance (with whatever operating system works best) for the small .xls and .doc, what we get here is that if you want best performance it depends a lot on the operating system, for Windows 7, MsOffice 2003 blows past the competition, its by far the best, i actually even enjoy the “lazy loading” that it does with the large .doc where it doesn’t load it all at once but opens pretty fast, besides that OpenOffice 3.4 kinda still works best than LibreOffice 3.6.
For Mac your choice is LibreOffice 3.6, it works like a charm, next up would probably be MSOffice 2008 just cause it has good compatibility and kinda treats all files equaly, but overall Mac OSX 10.6 is pretty disappointing for Office Performance with nothing loading faster than 10 seconds.
For Linux (Ubuntu 12.04), apparently LibreOffice 3.5 is freaking king, still OpenOffice 3.4 and LibreOffice 3.6 run pretty good too, they feel native and run almost like MSOffice 2003 on Windows 7, super fast and slick i barely see the annoying splash screen (ie any application that has a splash screen just means its going to be slow)!!!, i also like to point out that I’m using the same computer for Windows 7 and Ubuntu 12.04, so yeah great performance for all.
As a side note, in my office its all Win7 machines, mostly cause some of the software, like accounting software is windows only and there are no alternatives, so using another operating system would be troublesome even if doable (virtual machines and such), but this performance on Linux does give me pause, especially with how Linux nowadays does play fairly well with windows networks and windows computers, and with LibreOffice and OpenOffice seem to fairly stagnated in performance on Windows, going for Linux might just do the trick.

Apache OpenOffice 3.4 Vs LibreOffice 3.5.3

So I’ve been using LibreOffice on multiple computers on the office, as an obvious alternative to Microsoft’s Office, now the reason for moving from OpenOffice to LibreOffice was purely because Oracle is probably the most untrustworthy company in the world (i joke, i joke, but they surely seem a very anti-opensource company), so with the spin-off LibreOffice and especially because they were joining with Go-oo, i thought the move to LibreOffice was the right one!

See my main concerns (and probably like most other users) with Office software are:

  • I need basic Office Functions (Writer/Calc/Presentation);
  • I need compatibility with Microsoft Office documents;
  • I need Performance (Opening fast, closing fast, editing fast, if possible low memory and low cpu)!

What i noticed first with my change to Libreoffice is that it was slightly slower than OpenOffice, i thought it was a bit strange since Go-oo was a bit faster than OpenOffice, still the difference dint seem much at the time and i put if off as the excuse from the LibreOffice camp that the focus right then was on code clean up.

So now that OpenOffice practically died off at the hands of Oracle and was handed down to the Apache foundation to try and become a more open source project again, i kinda would like to give it a go, at least to see how the performance is, so with OpenOffice 3.4 just coming out, lets make a comparison!

Basic Office Functions between OpenOffice 3.4 and LibreOffice 3.5.3

Well there are already a lot, especially on the LibreOffice side of things, but not all are for the better, sure LibreOffice has more tricks and features, but most are to my view (the view of someone that wants a basic office software for a business) mostly irrelevant, also Libreoffice color change is kinda obnoxious, who wants fluorescent green/blue/yellow documents icons? Besides that, i would say in basic office functions OpenOffice and LibreOffice are on par.

Office Compatibility between OpenOffice 3.4 and LibreOffice 3.5.3

Well almost the same, even tough here i kinda have to give a nudge to LibreOffice, since it has way less warnings and quiz options while opening Microsoft Office Documents, the OpenOffice “oh jesus christ i see a macro” warnings are a bit of a overkill and annoying, but yeah they both work pretty good with Microsoft Office documents.

Performance between OpenOffice 3.4 and LibreOffice 3.5.3


I’m using pretty modern computers (multiple core cpus, 4GB ram, fast 7200rpm hard drives), one with Windows XP the other with Windows 7, yes 
I’m  not going to compare on the Mac or Linux cause 
I’m  not using them on the business side, also although this isn’t all that scientific, 
I’m  going to take some precautions, my scheme will be installing/rebooting, running cold/running hot, also 
I’m  not tweaking any of them for performance, this is out of the box performance, on both 
I’m  only installing the writer/spreadsheet/presentation programs, on both 
I’m  disabling quick start.



The small.doc is 40KB, the large.doc is 25MB with plenty of formatting and embedded images and graphs, the small.xls is 45KB and the large.xls is 4MB with 20 sheets lots of calculations and graphs.

Note: I’ve removed the cold start, since they both acted pretty much the same, if starting cold, it adds around 16 seconds whatever the document and whatever the software (that sucks on both software’s). I also removed the Windows XP graphic cause it was kinda the same, although all a bit slower than on Windows 7, but that computer is also a bit slower than the Windows 7.

So as we can see, OpenOffice has better performance once warmed up, especially on the large.doc, the difference in opening is huge! Almost half the time to open, and with smaller files it also consistently outperformed LibreOffice, also OpenOffice was very responsive on the Large.doc, while LibreOffice kept hanging while i was scrolling or editing, also for the same document Libreoffice used 43MB of RAM, while OpenOffice used 35MB of RAM.

So now i’m not sure if i should move all my computers back to OpenOffice or if i should wait for LibreOffice 3.6 in a month’s time, but i do hope that both distributions start focusing on performance, i think if OpenOffice keeps improving its performance like this, that it really doesn’t matter the clean code and all the nice bells and whistles of LibreOffice, most business will make the decision on performance (literally the biggest reason to buy Microsoft Office is performance) to stay with OpenOffice or go back to it, just like me.

Note 1: Seems i should have published the documents i used in this comparison, sorry about that, my fault! but like i said in the comments they were random office documents, i promisse ill make a better comparison when LibreOffice 3.6 comes out!

Note 2: Also the Windows XP computer has Microsoft Office 2003 (the only office i have ever bought) and all of the files i tested open INSTANTLY! and in COLD START! even the huge 25MB file, although it seems in that one it only loads the first 6 pages, but scrolling down it keeps showing the rest pretty quickly and smoothly, soo i would add that in the performance department LibreOffice and OpenOffice have still a long Long LONG way to go, even in 2012 they are no comparison in performance to a 2003 software.