OpenOffice.org vs. Microsoft Office

Nobody disputes that Microsoft Office is king of the hill in office suites, but if you put marketing and market share aside, how does OpenOffice.org compare?
Spreadsheets: OOo Calc vs. MSO Excel

Calc and Excel have been in an arms race for years. Excel extends the numbers of columns and rows it can support in one release, and in the next, Calc matches it. Recent releases also have seen developers improving Calc's speed when processing complex equations. Consequently, both Calc and Excel now support spreadsheets that are so extensive, any sane user would have switched from a spreadsheet to a database long before bumping against the limitations. In much the same way, Calc always has been careful to match Excel function for function to maximize compatibility. In fact, Calc actually has several dozen more functions than Excel, not because Calc can do more, but because it often maintains two versions of the same function—one for compatibility with Excel and one with extra features that Excel lacks. Given the sheer number of functions in both spreadsheets, I cannot be completely certain that one has functions the other lacks, but if either does, those functions are specialized ones that average users are unlikely to miss.

For sorting cell entries and manipulating formulae, Calc and Excel have a roughly equivalent feature set. The main difference is in some of the names—for instance, where Excel refers to “pivot tables” and “trace precedents”, Calc refers to “datapilots” and “detective”. With the basics so close, the differences between Calc and Excel remain minor at best.

Figure 3. MS Excel

Figure 4. OpenOffice.org Calc

For example, pivot tables in Excel are easier to construct than Calc's datapilots and easier to manipulate later, although the use of cell and page styles in Calc makes formatting and printing easier. In the end, which application you prefer depends on what extras matter to you. Most users are unlikely to find any great difference in general functionality. Verdict: tie.

Slideshows: OOo Impress vs. MSO PowerPoint

OOo Impress produces slideshows that serve the needs of most users. It always has been especially strong in object animation, and because it shares much of its code with OOo's Draw, it also is ideal for drawing charts and diagrams. One particularly useful feature is the ability to save object styles so that you easily can create copies and modify them all. Yet, despite such features, Impress always has struggled to catch up with MSO PowerPoint. Over its releases, it has narrowed the gap, adding built-in support for movie and sound clips and more recently tables. However, the gap remains in several key areas. For example, although PowerPoint allows the recording of continuous narrations, Impress is limited to adding sound clips to each screen. Similarly, Impress lacks the ability to use the pointer to draw on the screen during a presentation. If you want a Presenter View—a view that includes notes that display on your machine but not on the projector—you have to install the Sun Presenter Console extension in Impress. And, although PowerPoint includes a set of collaboration features similar to those found in Word, Impress's first step to match them is scheduled to arrive in only OOo 3.2, when notes will be added.

Another weakness of Impress is that it is divided into three panes: a slide pane, the current slide pane and a task pane. This makes Impress almost impossible to use except in a full-screen window. However, although PowerPoint occasionally opens a task pane, in general, its ribbon interface means that it does not usually need one. Verdict: PowerPoint.

Figure 5. MS PowerPoint

Figure 6. OpenOffice.org Impress

Other Features

Beyond the core applications, both MSO and OOo include other programs. Both include a small database, although OOo's ability to connect easily to other database sources gives it a slight edge. In some editions, MSO includes Microsoft Outlook, a personal information manager; Visio, a charting program; Publisher, a basic desktop layout program, and a dozen more. The only other application in OOo is Draw, an SVG graphics editor, but as free software, OOo can be supplemented by dozens of other applications. Although these applications may not always interact well with each other, neither do the components of MSO. And, at least an increasing number of free software applications support OOo's Open Document Format, which means that a document written in Writer can be opened in AbiWord or KWord.

Yet another consideration is that, although MSO has an ecosystem of dozens of trainers and instructional Web pages built around it, instruction and resources for OOo are much scarcer. Conversely, OOo has developed a community of extension writers that is second only to Firefox's, while MSO's extensions are far fewer in number.

______________________

-- Bruce Byfield (nanday)

Comments

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Fear of change!

geopaxton's picture

I notice that most of the problems people put forward for why OpenOffice - particularly Calc - are no good at, are found to be non-existent. Yes Writer and Calc do a few things a bit differently, but I love not getting messages like, "It looks like you are writing a letter. Do you need help?" in Open Office. It just takes a bit of perseverance, and looking where to find things. In Openoffice, for example, all formatting is under the format tab. In MS-Word to format you page you have to go to File - Page Setup.

Well we can talk here all you want

Anonymous's picture

But in biz you have to use MS Office. Not symphony not Open Office MS.
Why because it is still so widespread everyone is used to it files are being sent with macros (talking the normal ones) and formatting gets all screwy. It is the same story again and until MS and Others don't agree to fully support one file format (which would be really MS shooting it's own foot if they did it right) people will require original ms office.

Quite simply they do not care that its Microsoft's fault that the layout is out of wack in their documents. And everyone here got the emails opened in OO and just found its not good and opened the file in word or excel.

This is especially the way how big corporate customers think. You don't have office wtf what kind of a amateur are you?

Large spreadsheets

Anonymous's picture

With small spreadsheets, Calc and Excel and pretty much equal. Start dealing with thousands of rows and thousand of calculations, though, and Excel can't touch Calc. I often use spreadsheets to 'clean' thousands of rows of data for inclusion in a DB. In that situation Excel has some serious limitations that don't exist in Calc.

Have used Excel for 20 years, Calc for about 10. I'm MS certified expert in Excel (for what little that means) so I know my way around. Neither application is perfect but I'd take Calc over Excel any day.

Oh, and BTW, OO runs beautifully on Linux, while Excel...

Microsoft Word Lawsuit

Zach Schneider's picture

I am surprised nobody mentioned about the lawsuit regarding Microsoft Word and XML
http://www.pcworld.com/article/170148/microsoft_word_lawsuit_xml_explain...

Zach Schneider is a web developer and Linux enthusiast. Find him on Twitter, @ZKM.

Unbiased? LOL!

Anonymous's picture

Seriously, is this article even supposed to be unbiased? You give Writer the advantage, Calc and Excel a tie and ignore things like Visio, OneNote, InfoPath & Outlook.

Not to mention, you ignore things within each app - SmartArt, PivotCharts, 1-click styles, cover pages, review, simultaneous editing, Excel Server, and many many more.

OOo can be used by small companies who are cheap or companies that prefer this than pirating. Of course, the producivity hit that they take with it is a hidden cost.

Outlook!?

corporatebee's picture

Seriously?

It's one of the weaker MS office suite products IMO the only reason it is so prevalent is because it came bundled with the system... just like IE.

Unbiased?? LOL - Agreed

Anonymous's picture

We are a small company downunder in the land of Oz and because the boss has it in his head that by using OO it will save him money we suffer daily with differing issues including but not limited to;

Opening Microsoft documents only to find that writer has completely thrown out the formatting of the document and usually it is a tender of which we need to respond so I have no choice but to revert back to Gatesy MS because it works. I have tried now for the last two years to NOT use MS but always seem to have to fall back to the 'old faithful' because I don't have the time when the boss is breathing down my neck for a result even though his insistent push of OO caused the delay to start with.

I say long live the "TUX" and all his offerings but it is hard to progress when MS just 'works"

Downunder Dave

Formatting

Anonymous's picture

1. I have the same problem going between Word versions - so OO.o is no worse than MSO here.

2. If you're requiring formating (specific look), you shouldn't be using the native format - PDF files are for locking down format. Which OO.o does natively (Print to PDF, or Export as PDF), while MSO needs a plugin. Advantage OO.o

Who do you blame?

Anonymous's picture

As a fellow "Downunder Dave" (except I'm in NZ), I simply offer this caution:

are the problems you've encountered caused by inadequacy in OOo or by anti-competitive practices by MS? Are you giving unwarranted credit to "old-faithful" rather than cursing "old-scuttle-the-competition-to-maintain-our-monopoly-by-using-ever-changing-proprietary-formats-that-non-MS-competitors-have-to-expend-vast-sums-of-money-and-time-to-reverse-engineer-and-are-forever-playing-catchup-which-is-just-how-we-like-it"?

I think the blame rests squarely on MS' shoulders here, and, under the circumstances, I'd encourage you to grit your teeth and spit if you every say "old-faithful" in regard to MS Office again, because that's what it deserves.

And push for open standard file formats that don't simply offer "theoretical" interoperability. And don't accept MS' word that OOXML (not to be confused with DOCX, XLS, and PPTX, which are *not* valid OOXML) is an open standard. It is not.

Kind regards,

Kiwi Dave

PDF and HTML

Anonymous's picture

All these comments, and nobody remembered that OOo can export to PDF or HTML without any addons or third party software!

I use MS Office at work because that's what they give me, but on my own machines at home, I use OOo, because it's got features MS Office doesn't, can handle more file types, isn't prone to macro viruses, runs on ALL my OSes (several variants of Linux, plus XP and Windows 7), and allows me greater control and compatibility with all my docs.

As a pro, I find OOo is just better all around. As the article said, Word is great for beginners, Writer is for people at intermediate to expert level.

I also use Calc for any spreadsheet needs I have, and any Excel spreadsheets I get, will always open in Calc without a hitch. Granted, I don't do a lot of highly advanced work in Excel, but my formulas, etc, work just as well, and it's faster.

The one down side is Impress. I don't use it, but my kids have in order to work on PowerPoint projects from school. Bottom line, it needs more work.

However, since PP/Impress doesn't impact my particular line of work, I'll stick with OOo for my purposes.

Calc handling 90000+ rows [Solved]

Anonymous's picture

hi, i had a nice surprise yesterday at work. i had a big 6mb xlsx (excel 2007) file and when i tried to open it in calc (in my Linux Mint Helena), it opened up like a charm, complete with the same number of rows as the original file.

then saving it to calc's native ODT format, i again had a small surprise: the file size was HALF of the XLSX file.

two thumbs up for OpenOffice Calc!

MSOffice more mature, OpenOffice is free

Anonymous's picture

I am using XP:MSOffice2007 Word and Excel at work and Ubuntu:OpenOffice3.1 Write and Calc at home/work.
My impression is that the OpenOffice suite is much less stable (i.e. crashes!), much less user friendly (e.g. bibliography in write, number to text conversion in calc and many other examples), slower (word just starts faster) and lacking many useful features of the MSOffice2007 package (e.g number of rows limit to 65000 and others).

I still like OpenOffice because it installs easily both on XP and Ubuntu, will do most of what I need, is freely available, uses open standards and is open source.

Both Calc and Excel are way better for data visualisation than bash.

Both MSWord and OOfficeWrite are major improvements over LaTex, after discovering MSWord I never went back to LaTex again.

Interface

Anonymous's picture

If you add no capabilities to a program, and just change the interface so that millions of users have to relearn their job to keep doing them - how is that Progress?

CSV and some other formats

Anonymous's picture

As someone said, importing and exporting CSV is very easy in OOCalc. One has control of everything, separators, encoding. It is very important in enterprise environment, when you need to export and import data. One of my customers has OO installed on couple of PC's for only reason of CSV manipulation. Excel had all those features in the older versions, but they were removed, leaving many users frustrated. Recently Microsoft put a web page where users could express their wishes for next MSO release. CSV was among top features.

Excel is much better when one needs to import non-spreadsheet formats, like HTML. OOCalc usually blocks and CPU load goes to 100%. One often has no patience to wait and see the outcome.

DG

OOo 3.2 startup speed *vastly* improved

Anonymous's picture

I use an Ubuntu 9.10 laptop at work with MS Office 2003 running in Wine.

On the same box, from a cold start, and no preloading (this isn't Windows), Excel starts in under a second from cold, OOo 3.1 takes seven seconds from cold. And six seconds is approximately forever.

Which is why I'm so very pleased that OOo 3.2 now starts in two seconds on the same box. PERCEIVED SPEED IS IMPORTANT!

Rich Text Format beneath OO.o

Anonymous's picture

Had my resume in RTF for 14+ years, and OO.o was ok with RTF until the 3.x series arrived. That's just plain sad, because I really have no use for tables, internet connectivity, collaboration controls, auto-correct, 1 degree text rotations, drop shadowing and all the other hooey that never seems to be used by people I can talk to. The people I talk to say that after bold, italic and bulleting, they barely use rulers and definable tabs, so I guess I'm just too rudimentary for the modern world. AFAICT OO.o = the GIMP level office suite.

Honestly, I'm not sure I've used a new feature added in the past 10 years, but I really haven't kept a list.

I keep both offices on my box

Anonymous's picture

I keep both offices on my box and I am trying to get rid of MS Office but what is holding me back is MS Excel. Calc is a way behind Excel for my tasks. I work with data and, for example, the other day I needed to import comma separated file into a spreadsheet - a seconds task for MS Excel but impossible for Calc. I do not even know if I can write programs in Calc? Can I do statistical analysis in Calc? How to turn the damn tooltips in Writer?

Statistical Analysis

Anonymous's picture

Spreadsheets are for accountants and financial types. If you need to do statistical analysis use R. It's free and runs in both Linux and Mickey$oft environments. R is designed just for statistical analysis and, therefore, vastly superior to a general purpose spreadsheet. R is also well documented and supported. Mickey$oft doesn't make a statistical analysis product because of its limited market (limited demand = limited revenue) and the lack of sophistication in Micky$oft's programmers.

~LouSam

Sorry, guys. I needed to

Anonymous's picture

Sorry, guys.

I needed to import a text file where the first few columns were tab separated and last three columns were separated by two spaces. Calc could not handle that.

VIM

Anonymous's picture

Seems an odd format but either way 10 seconds with SED or VIM could fix that. i.e, change the formatting to a consistent character. Just making the point that I don't see such items as an issue.

Try Lotus Symphony

Anonymous's picture

The recent version of Lotus Symphony has Visual Basic macro support.

http://symphony.lotus.com/software/lotus/symphony/SymphonyBetaHome.nsf/home

Import csv in seconds with calc

Anonymous's picture

Greetings,

You can import comma separated files in seconds with calc. As I do not know what operating system you use here is a general idea as to how easy it is.

- Open the file selection screen as usual.

- Select your file as usual

- click on the down arrow below the list of files box and select the relevant file format. There are many to choose from.

- to select comma separated file format when looking at the list of formats press the letter "T" 4 or 5 times. This will quickly take you to the "text csv" format option. I use 4 times for older versions of OOo and 5 t's in the newer versions. This works in windows version of OOo but not necessarily in other operating system versions.

- click on the open button.

- hay presto.

Hope this helps.

Making decisions for me.

Anonymous's picture

If I try to open a text file in Calc OOo auto-magically decides that since it's text I should open it in Writer. How lovely!

It does that for me too.

Anonymous's picture

It does that for me too.

I tried importing a CSV

Anonymous's picture

I tried importing a CSV formatted file with a TXT file name extension in Calc and it worked just fine. Be sure to choose file type = "Text CSV" not just text. That may be your problem.

bad behavior

Anonymous's picture

No, that's a broken behavior.

soft shadows

Anonymous's picture

When importing images in a document, ooo lacks some advanced but very usefull features. For example word's 2007 "soft shadows" is a kick ass feature. On the other hand writer can only apply basic shadows. With word u can create much more impressive and beautiful documents.

http://qa.openoffice.org/issues/show_bug.cgi?id=64343

OOO needs more impressive and beautiful visual effects. Both writer and impress need to improve.

oo calc for me

Anonymous's picture

I have the full blown MS office on XP at work but I use oo calc 99% of the time. I don't do spreadsheets for calculations, rather its like an artboard for me. I copy in data grids, snaps shots, add text blocks, use the drawing tools to annotate... When I share the docs I do have to save as MS... which is quite easy. Been doing this for about 2 years. I also use it for charts. Since I'm a database guy, I should explore that in oo but I haven't. Just not enough time in the day... At home I primarily use Macs and I have oo installed there too, but I don't do much at home with office software. One thing for sure, I would Never spend any of my money to buy a MS office product... :) My Macs stay away from all MS software... and I'm a proud owner of Adobe CS4 production Suite. So its not like I can't afford MS Office. I just don't like it or want it.

Cross Platform

Anonymous's picture

I own 3 version of Office (2000/XP/2007). But I still use OO most of the time. The reason is I use Windows/Mac OSX/Linux Ubuntu, OO is available on all 3 systems (and others I don't use).

File formats; OO wins hands down

Anonymous's picture

I had some fun a while back opening a doc a colleague had created at home with the base MSO wordprocessor. Work has the full office suite, but locked down PC's, so we took about 20 min to figure out where and how to download 20 MB of conversion software before she could open it. Then she was faced with the option of just looking at it, or chancing her luck on some editing and hoping it would save in a format she could open at home.

Years ago I used Lotus word pro. The easiest way to open them now: OO. MS "supported" the format for a few years, but it did a great job of butchering any formatting even then. Now it can't do even that without a fork out and download.

MS is for people and institutions with money to burn, no interest in docs more than a couple of years old, and employees who don't have any work to take home. In the real world, however, we need more flexibility.

OO Draw is misunderstood

Anonymous's picture

I do legal expert witness work and the documents are sent in pdf format. Solicitors often want an MS Word version BUT .... every diagram I do in MS Word is subject to the very high probability that some of the lines have moved and distorted the diagram when the recipient opens it.

For a legal case I CANNOT risk that. I use OO Draw to create the diagram and export as a .gif or .jpg picture. The writer document then contains diagrams that cannot be distorted when viewed in MS Word format.

So important.

Well, OOo is still safer

Anonymous's picture

With OOo, you don't have to worry about opening a document with a malicious macro that can get past your virus detector which can happen in a MS office of some type. Then again, who really uses operating systems that are prone to viruses these days? lol

how so?

Anonymous's picture

I've used both quite a bit. I don't recall being able to do anything in Calc that I couldn't do in Excel, but I commonly have problems the other way. For example if I filter a set of rows and I want to copy the filter set I can't do it. I think that a bug was filed for that issue and closed without action. What can Calc do that Excel cannot???

how so?

Anonymous's picture

In Calc you can create versions of you spreadsheet in the same file. For my work I have to produce a rapport every month. I use the version function to save every specific report in such a way that I can print every single report I did without the need of opening an external file. I can even compare them in I want. Can you do that with excel? I use to export the report in pdf format. can you do that natively with excel?

OpenOffice.org is a great product

Anonymous's picture

Just like it has already been mentioned, for FREE you can't beat OpenOffice.org. It is a mature product, and works great. The thing that I really like about OpenOffice is that I know that I'll never have to buy it. Unlike Microsoft Office which you will need to re-purchase every few years if you want the latest features and compatibility. I use OpenOffice and I also use GLabels very frequently to handle label needs. Linux itself has matured, and now includes a suite of home/office applications that are very capable.

http://members.apex-internet.com/sa/windowslinux

What do you use OO for?

Anonymous's picture

>Few users have the experience or patience to do a thorough comparison.

You are right but I use a less scientific method for my Windows friends who might not have switched to a free/libre desktop but are all using OO, FF3 and VLC on Windows.

I must know about 30-35 people in this situation and only one of them went back and bought Office2007 (which was a surprise in itself) after using OO.
Most home users want to type, bold/font/size, indent, do some footnotes and then save in .doc.

I am going to venture a guess and say that 90%+ of people are the same.

I will not comment on business integration but strictly on everyday users.
And a word processor is a word processor. Just like a browser, no one has ever been confronted with a new one and went "OMG!! What now?"
You may have to change some habits but then again my friend above was swearing nonstop at the Office ribbon because of that: having to change your habits.

You cant believe the number of parents at PTA meeting at school that I lead to OO and they come back and thank me because they saved a few hundred bucks.

And we are working on our free time with a community center around here that were are converting to GNU/Linux and OO is a very big part of this switch.
The center is staffed with (many) volunteers and so far, weve had no problems.

And Powerpoint is worse than Flash and blinking tags put together and more time is wasted on creating them than any Solitaire game ever will.

How to determine the OpenOffice market share?

Anonymous's picture

According to a German web site, OpenOffice tops 20% market share.

The guys at Webmasterpro have published a study that analyzes the install base of various office packages among German users. While Microsoft Office comes out top (72%), open source rival OpenOffice is already installed on 21.5% of all PCs and growing.

The method used in the study is quite clever as it neither depends on sales figures (quite difficult to assess for a free software product) nor on questionnaires (prone to sampling bias). Instead, they have equipped their web statistics service with the ability to detect the fonts installed on the computers visiting the monitored sites. Now, each office suite brings along a set of unique fonts (e.g., OpenSymbol comes with OpenOffice), which can be used to identify the installed office suites.

This is a pretty nifty idea.

I think we should put this little javascript tool in major independent sites and blogs, and try to figure out the real market share of OpenOffice.

More information about the study:

http://www.quantenblog.net/free-software/openoffice-market-share

Here's a script to detect installed fonts...

Anonymous's picture

The site says that it was tested on Firefox 2, 3, 3.5 IE 6, IE 7, Opera 9, Opera 10.

http://www.lalit.org/lab/javascript-css-font-detect

The next step would be to look for "OpenSymbol" (or other fonts) as an indication of OpenOffice being installed; and log that into the database.

I hope Google analytics could do that... would give us useful data.

21.5% is an impressive market share

Anonymous's picture

For OpenOffice, the number of 21.5% is already impressive. But even more telling is the trend showing that during the last year OpenOffice steadily gained 3 percentage points. But what surprised me the most is that the authors hardly found a difference between home and business users. These observations mean nothing but OpenOffice is rapidly making inroads into Microsoft's #1 cash cow!

Calc just makes them angry

Anonymous's picture

Too many people with ADHD using Excel or Calc

I don't know what you mean

Anonymous's picture

If you are an engineer you probably use a spreadsheet. It's a powerful general purpose tool.

Use Latex

Anonymous's picture

I don't know why companies or private persons don't just use Latex for documents and presentations. Latex has so many advantages, over every office suite and the only disadvantage is that you have to read 20min how you can create a document, for example in http://en.wikibooks.org/wiki/LaTeX

To name a few advantages:
* you are so much faster in Latex. You just write down the text and create a beautiful pdf file in seconds. You don't have to care about anything, because Latex will do all formating for you.
* Latex files are simple text files, so you can read them in 100 years and Latex itself is open source and is very solid. With word documents you are very lucky if you can open a document that is 5 years old.
* With Latex you can create dvi files for printing or pdf files for sending. You can create html files for a web browser or plain text files.
* With Latex it's very easy to work in a group, because tex files are normal text files, so you can put them in a VCS, like Subversion or git.

Maybe Latex is a litle bit confusing and maybe difficult, too, for the WYSIWYG generation. But why are coperations not adopting Latex for all documents and leave that war between X doc file formats to itself? At least with Latex you don't need to train your people every 2 years because the interface has changed.

I for myself use Latex for my documents and presentations and live is so much easier now. I don't need 45min because MS Office 2007 won't import an image for some reason (happen with a colleague of me last month) and I don't have to fight the office suite to have my paragraphs formated like I wanted.

For all what is wrong with WYSIWYG here is a good blog about Latex. http://www.terminally-incoherent.com/blog/2010/02/04/lyx-easy-latex-with...

argument against LaTeX

Anonymous's picture

I used LaTeX when I was a graduate student, but had to give it up eventually because I work on articles collaboratively, and none of my colleagues use it. That said, there are some arguments against LaTeX in principle. TeX and especially LaTeX are built around the idea that the software knows what looks good, and you should just tell it what goes in which section. While this is often true, people don't really want to be told that. You can usually customize things in (La)TeX, but the more control you want the more difficult it gets. Back when I used it, it was difficult even to select your font beyond a handful of Roman fonts (this would make it completely useless for some of my applications). Modern word processors have a very nice system for hierarchical styling that I believe is much easier to use than LaTeX if you like to fiddle with the look of your documents. Modern word processors also make it very easy to distribute forms.

I think a few of your arguments are incorrect. You can create a beautiful pdf file in seconds in both word processors and LaTeX, but only if you happen to like the default formatting in both. Customization is a pain in both, less of a pain in word processors in my opinion. It's quite easy in word processors to create pdf files or html files, less than ten seconds of effort. You can script it in openoffice if you prefer the command line. Virtually no one outside fields like math and computer science cares about dvi files. Finally, using word processor formats does not impede working in a group. In my experience, using (La)TeX does.

I like TeX quite a bit, and wish the word processors I use today were as facile with equations as it is. I wish OpenOffice were as handy with kerning as TeX is. I think your argument about the perpetual readability of the files is very important, a very big issue that word processors need to address more thoroughly. That said, they're getting better. The only documents I have that I can't open were created with proprietary software about 20 years ago. Everything created since then I can open with its original intended formatting. In any case, I still can't see LaTeX (even using something like LyX) as a practical solution for most people who make extensive use of word processors.

OO.o and interoperability

Anonymous's picture

I've used OO.o since its original inception as a All-In-One package carrying the StarOffice moniker, under OS/2. I haven't installed or used MS Office (except under protest to fix some of its problems here in the office, I manage the IT), since about '93.

No one, customers, clients, vendors, or co-workers have any idea I don't use MS Office. Actually, I'm the one special projects are sent to simply because my set of functional, intuitive tools allow me to get work done. I don't spend 30 minutes trying to find a command that MS has now instituted as an "anti-feature". A feature to benefit the software vendor and force the user to upgrade to obtain the functionality they need.

For fun, I eradicated MS Office on the receptionists machine, and replaced it with OO.o, telling here it was the new, "Pro" version of MS Office... we now can actually get work out of her.. amazing......

Exel != Calc

Anonymous's picture

For anyone who uses Calc on a regular basis, Excel just makes them angry. Little things count.

Excel != Calc

Anonymous's picture

You are right about one thing, Excel 2007 is not equal to Calc - its far superior.

I am a big fan of all things open source (my personal laptop is linux and i use open office as well). But I installed one thing there through Wine that open source applications just couldn't quite catch up to: excel 2007.

When it comes to detail reporting and visualization (and add-ons for business intelligence applications), excel 2007 is the far superior product. Calc still feels like exel 2003 - it even looks like it.

OO.o and interoperability

Anonymous's picture

I find that OO.o will accept many different file types (examples: .doc, .docx, .wps, .ppt, and others). I doubt that MSO can do that.

I have taken many .ppt files and used OO.o to display them without a single problem. I have also converted .doc and .docx files, as well as .xls and .xlsx. The problem most experienced was when my computer did not have one of the fonts that the original document had in it. I expect that Visual Basic would cause problems with OO.o, but someday that will be worked out.

I left MSO 97 behind and starting using OO.o and I have not been disappointed yet. Unless someone is a power user I believe that OO.o will be entirely satsifactory.

Most people who think they're power users...

lightweight's picture

aren't.

They just don't realise how much they don't know.

For anyone that knows

Anonymous's picture

For anyone that knows programming, using spreadsheats just seems stupid.

Please...

Anonymous's picture

What an inane comment. I may not be an uber-programmer, but I am familiar with one or two languages and the basics of programming architecture.

Your comment reflects the stereotypical IT-centric ignorance that plagues so many of my technical peers. Just because you don't have a use for some features you deem them useless.

As someone who frequently works with tables that have thousands of rows, data from multiple systems, and works too much with finance reports... there are quite a few functions and uses of spreadsheets that are not just timesavers or quickfixes, but imperatives.

Vlookups and HLookups are far better uses of time than taking the time to write and debug a script to do the same thing when both tables have thousands of rows.

Another example is charts. In a spreadsheet I can link to an ODBC source, query, group and filter the results, and create a chart in less than five minutes. How long would it take to write a program or script to do the same?

White Paper
Linux Management with Red Hat Satellite: Measuring Business Impact and ROI

Linux has become a key foundation for supporting today's rapidly growing IT environments. Linux is being used to deploy business applications and databases, trading on its reputation as a low-cost operating environment. For many IT organizations, Linux is a mainstay for deploying Web servers and has evolved from handling basic file, print, and utility workloads to running mission-critical applications and databases, physically, virtually, and in the cloud. As Linux grows in importance in terms of value to the business, managing Linux environments to high standards of service quality — availability, security, and performance — becomes an essential requirement for business success.

Learn More

Sponsored by Red Hat

White Paper
Private PaaS for the Agile Enterprise

If you already use virtualized infrastructure, you are well on your way to leveraging the power of the cloud. Virtualization offers the promise of limitless resources, but how do you manage that scalability when your DevOps team doesn’t scale? In today’s hypercompetitive markets, fast results can make a difference between leading the pack vs. obsolescence. Organizations need more benefits from cloud computing than just raw resources. They need agility, flexibility, convenience, ROI, and control.

Stackato private Platform-as-a-Service technology from ActiveState extends your private cloud infrastructure by creating a private PaaS to provide on-demand availability, flexibility, control, and ultimately, faster time-to-market for your enterprise.

Learn More

Sponsored by ActiveState