I’m a huge advocate of free/open source software. I like to use it, and I think it makes the world of computing better. Some of it is that the open source software I’ve been using is easier to customize and more fits my particular mindset — I like the way Fluxbox and vim work, for example. Usually, it comes down to open source stuff pissing me off less than closed source.
OpenOffice.org is an exception. I’ve had to use it a lot for work lately, building spreadsheets and whatnot, because there is no Linux version of Office. I come into this as someone who has spent more time in OO.o than in Microsoft Office by about a 10:1 margin, 1000:1 when it comes to the 2007 variety.
For one, we ran into some compatibility issues between OO.o and two versions of Excel. Of course, we also ran into problems between the two versions of Excel — I had a file saved in Pre-2007 Office, opened it in 2007… and it crashed the program. This should never happen. I finally tracked it down to an issue with trendlines, deleted those graphs, and it works. So that’s actually a point in OO.o’s favor. No file saved by one Excel should ever crash a NEWER version.
But the real problem, and the real reason that OO.o is a dog, came running large spreadsheets. It is obvious that no one uses OO.o’s Calc to do any real work, because when I had four sheets filled with data — the spreadsheet is around 400kb — the thing lagged my system down to unbearable speeds. My machine is a dual-core, 3ghz processor monster with 4GB of RAM running CentOS 5 and Fluxbox. The underlying OS uses almost no memory. But a few worksheets and hundred rows of data and OO.o Calc takes sixty seconds to highligh 100 lines of data (one column, 100 rows).
Excel in a virtual machine worked 100x faster, no exaggeration. Point to Microsoft Office.
Then when actually trying to make graphs, the ability of OpenOffice.org Calc to do polynomial trendlines is crippled. I spent at least an hour on the Google trying to figure out how to do it and there was some macro I could download and use (imagine that makes it much slower…), and that is a deal breaker. When someone has to go to a conference and give a report in front of people they don’t want to rely on some wonk macro to get the R^2, they want to push a button and get it. Point to Excel.
One more point in OO.o’s favor, though this may be fixed in 2007: In Calc I could label data points with text, while Excel (pre-2007) only wanted to use their value. What the hell? So point for OO.o — tied game and all.
Excel, like Word, is just more polished. I know that OO.o is probably safer to use, but this is a big point in the favor of MS Office. It’s just prettier and easier to look at for long periods of time, it makes better looking graphs (OO.o is just above the command line graph program), and it has, in my opinion, a better interface (even the ribbon). Options are easier to find. Point for MS Office.
You may say, well, it’s a close game here, and OO.o is free! Win for OO.o!
But that’s not how this thing called reality works. That trendline thing truly is a dealbreaker, as they are a requirement for this project. So is the general sluggishness — sure, OO.o is free, and Excel crashed, but there is only so much waiting I can do on a project that is going to be do. You can’t go to a client and say “hey our project you paid for is going to take 50% longer because our software lags.”
I love Linux, and I love open source stuff. But OO.o is NOT an acceptable replacement for Microsoft Office. Open Source proponents are going to have to do better. Some applications — vim, fluxbox, the gnu tools, ImageMagick, xscreensaver (or even xlock!) — are svelte and do what I want, following a perfect sort of logic. But OO.o is not one of them. At least not when it comes to Calc or the Word clone (Writer?). Fortunately, at home, I don’t need any sort of complicated spreadsheet, and Calc is passable.
As a side note, I tried to do some of the work in Gnumeric, and it also wasn’t up to snuff, but it didn’t irritate me quite like OO.o did. I didn’t try KOffice. But Excel won hands down against the spreadsheet programs I tried. (Personally, I’m starting to think “awk and a perl script for the math that runs gnu plotutils” for my personal spreadsheets…)