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.

Not always.

Anonymous's picture

I've been writing code on various platforms for 30 years, but I still find spreadsheets to be useful for quick and dirty solutions.

I certainly wouldn't use one to create an application as such, but they can be very good for doing things like generating ad hoc graphs, or doing personal finance stuff.

If I want to generate graphs on a regular basis, I usually do it with a mix of bash scripts, gnuplot, and image magick. But not one-offs.

Calc != Excel

Anonymous's picture

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

The contrary is also true.

Anonymous's picture

The contrary is also true.

contrary

Anonymous's picture

Count things little? Big things count? ;-)

Try large spreadsheets with

Anonymous's picture

Try large spreadsheets with multi thousand formulas and autocalc switched on in excel and calc...
Till Calc uses more than one cpu, it will be something for the netbook users to create their household accounts. Calc is just not ready for the technical world yet - those who rely on the power of spreadsheets.

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